Save new article (create a new ID) very slow in category with many articles

[pici65]

Steps to reproduce the issue

Hello
in category with many articles
is very slow to save another one.
Seems the problem concern to create a new ID.
For example sub-category "World" in category "News"
Category "News" is empty
"World" has 8000 articles.
Save a new one in "World" with few text = 150 seconds.
Save again here with other text, more long (for example 3000 characters) = 5 seconds.
If I save in the category father "News" I save in 3 seconds.
After I save in "World" 3 seconds.
So the problem is to save directly in the category with 8000 articles and to create a new ID.
Assets tables do no has too much content.
The server is dedicated.
I can't find the problem and the way to solve.

Expected result

Actual result

System information (as much as possible)

php 5.6.21
database version 5.5.5-10.0.25-MariaDB

Additional comments

[ggppdk]

That is a good guess, but in most cases we can avoid guessing

• You can avoid redirection after the article finishes saving and get the needed information out of the Joomla Debug Console

(If anyone knows a better way, please reply here)
[EDIT] Maybe there should be a tutorial or something for such this, or some option in Global configuration ?

---

It would be better to do this in a duplicate website, but it should not be a problem to do in a live website if you are careful

---

1 . Edit file: /libraries/legacy/controller/form.php

Goto to the bottom and find last lines:

// Invoke the postSave method to allow for the child class to access the model.
$this->postSaveHook($model, $validData);

return true;

add before return true; (copy paste carefully, not to make syntax error)

if ( $context == 'com_content.edit.article' && JFactory::getUser()->username=='admin' && $app->isAdmin() )
{
    $this->setRedirect(null);
}

---

2 . Login as "admin" or as the username that you have used above, if you want a different user then change 'admin' above

---

3 . Open a new browser TAB and Enable Joomla Debug in Global configuration

---

4 . Open a new browser TAB and Create a new article in the category with the many articles and click save (and you will get a screen with the Joomla Debug console)

---

5 . In the other browser TAB, disable the System Debug in Global configuration, so that your website stops displaying it

---

The step 4 should have given you the info that is needed (like the picture you see below), e.g. click the "Database Query" slider to find slow queries, and provide them here

[pici65]

Thanks for answer.
I have follow the exact steps.
`Database Queries
28 Queries Logged 91.13 ms

2 duplicate found!
2 duplicates: #13 #18

Query Time: 0.31 ms Query memory: 0.027 MB Memory before query: 2.752 MB Rows returned: 1

SELECT `data`

  FROM `sDg_session`

  WHERE `session_id` = 'a36cbceec4c0a330778ad39eba3cde8c'

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_session const   PRIMARY PRIMARY 766 const   1   
Profile
Status  Duration
starting    0.03 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.02 ms
checking permissions    0.01 ms
Opening tables  0.02 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.02 ms
init    0.01 ms
optimizing  0.01 ms
statistics  0.03 ms
preparing   0.01 ms
executing   0.01 ms
Sending data    0.01 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.00 ms
storing result in query cache   0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
14  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1731
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:258
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:748
5   JApplicationCms->loadSession()  JROOT/libraries/cms/application/cms.php:131
4   JApplicationCms->__construct()  JROOT/libraries/cms/application/administrator.php:45
3   JApplicationAdministrator->__construct()    JROOT/libraries/cms/application/cms.php:404
2   JApplicationCms::getInstance()  JROOT/libraries/joomla/factory.php:125
1   JFactory::getApplication()  JROOT/administrator/index.php:48
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.38 ms After last query: 3.87 ms Query memory: 0.025 MB Memory before query: 3.315 MB Rows returned: 44

SELECT extension_id AS id, element AS "option", params, enabled

  FROM sDg_extensions

  WHERE `type` = 'component'

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_extensions  ref extension   extension   82  const   44  Using index condition
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.03 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.00 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.01 ms
init    0.01 ms
optimizing  0.01 ms
statistics  0.03 ms
preparing   0.01 ms
executing   0.00 ms
Sending data    0.10 ms
Waiting for query cache lock    0.01 ms
Sending data    0.04 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.00 ms
storing result in query cache   0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
10  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
9   JDatabaseDriver->loadObjectList()   Same as call in the line below.
8   call_user_func_array()  JROOT/libraries/joomla/cache/controller/callback.php:157
7   JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448
6   JComponentHelper::load()    JROOT/libraries/cms/component/helper.php:43
5   JComponentHelper::getComponent()    JROOT/libraries/cms/component/helper.php:120
4   JComponentHelper::getParams()   JROOT/libraries/cms/application/administrator.php:272
3   JApplicationAdministrator->initialiseApp()  JROOT/libraries/cms/application/administrator.php:116
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.64 ms After last query: 2.98 ms Query memory: 0.017 MB Memory before query: 3.770 MB Rows returned: 106

SELECT folder AS type, element AS name, params

  FROM sDg_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2,3,6)

  ORDER BY ordering

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_extensions  ref extension   extension   82  const   128 Using index condition; Using where; Using filesort
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.04 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.00 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.01 ms
init    0.01 ms
optimizing  0.01 ms
statistics  0.02 ms
preparing   0.02 ms
executing   0.00 ms
Sorting result  0.25 ms
Sending data    0.10 ms
Waiting for query cache lock    0.01 ms
Sending data    0.03 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.00 ms
storing result in query cache   0.07 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
9   JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
8   JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/plugin/helper.php:310
7   JPluginHelper::load()   JROOT/libraries/cms/plugin/helper.php:86
6   JPluginHelper::getPlugin()  JROOT/libraries/cms/plugin/helper.php:128
5   JPluginHelper::isEnabled()  JROOT/libraries/cms/application/cms.php:649
4   JApplicationCms->initialiseApp()    JROOT/libraries/cms/application/administrator.php:294
3   JApplicationAdministrator->initialiseApp()  JROOT/libraries/cms/application/administrator.php:116
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.16 ms After last query: 29.83 ms Query memory: 0.022 MB Memory before query: 8.496 MB Rows returned: 2

SELECT *

  FROM sDg_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_languages   ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    2   Using where; Using filesort
Profile
Status  Duration
starting    0.04 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.01 ms
checking privileges on cached   0.01 ms
checking permissions    0.01 ms
sending cached result to clien  0.01 ms
updating status 0.02 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
15  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
14  JDatabaseDriver->loadObjectList()   JROOT/libraries/joomla/language/helper.php:164
13  JLanguageHelper::getLanguages() JROOT/administrator/components/com_sh404sef/helpers/language.php:164
12  Sh404sefHelperLanguage::getUrlCodeFromTag() JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
11  Sh404sefClassPageinfo->setCurrentLanguage() JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
10  Sh404sefClassPageinfo->init()   JROOT/plugins/system/sh404sef/sh404sef.php:60
9   plgSystemSh404sef->onAfterInitialise()  Same as call in the line below.
8   call_user_func_array()  JROOT/libraries/joomla/event/event.php:69
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:663
4   JApplicationCms->initialiseApp()    JROOT/libraries/cms/application/administrator.php:294
3   JApplicationAdministrator->initialiseApp()  JROOT/libraries/cms/application/administrator.php:116
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.12 ms After last query: 6.10 ms Query memory: 0.022 MB Memory before query: 9.623 MB Rows returned: 1

SELECT `params` 
  FROM sDg_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_extensions  ref element_clientid,element_folder_clientid,extension  element_clientid    402 const   1   Using index condition; Using where
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.02 ms
init    0.00 ms
checking query cache for query  0.02 ms
checking privileges on cached   0.00 ms
checking permissions    0.01 ms
sending cached result to clien  0.01 ms
updating status 0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
17  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1731
16  JDatabaseDriver->loadResult()   JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
15  ShlDbClass->loadResult()    JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
14  ShlDbClass->shlLoadResult() JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
13  ShlDbHelper::selectResult() JROOT/administrator/components/com_sh404sef/helpers/general.php:132
12  Sh404sefHelperGeneral::getComponentParams() JROOT/administrator/components/com_sh404sef/classes/config.php:612
11  Sh404sefClassConfig->__construct()  JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
10  Sh404sefFactory::getConfig()    JROOT/plugins/system/sh404sef/sh404sef.php:83
9   plgSystemSh404sef->onAfterInitialise()  Same as call in the line below.
8   call_user_func_array()  JROOT/libraries/joomla/event/event.php:69
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:663
4   JApplicationCms->initialiseApp()    JROOT/libraries/cms/application/administrator.php:294
3   JApplicationAdministrator->initialiseApp()  JROOT/libraries/cms/application/administrator.php:116
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.39 ms After last query: 6.32 ms Query memory: 0.024 MB Memory before query: 10.503 MB Rows returned: 1

SELECT extension_id AS id, element AS "option", params, enabled

  FROM sDg_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_extensions  ref element_clientid,element_folder_clientid,extension  extension   484 const,const 1   Using index condition
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.05 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.01 ms
After opening tables    0.02 ms
init    0.02 ms
optimizing  0.01 ms
statistics  0.05 ms
preparing   0.02 ms
executing   0.01 ms
Sending data    0.03 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.05 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
19  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1653
18  JDatabaseDriver->loadObject()   Same as call in the line below.
17  call_user_func_array()  JROOT/libraries/joomla/cache/controller/callback.php:157
16  JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156
15  JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47
14  JLibraryHelper::getLibrary()    JROOT/libraries/cms/library/helper.php:90
13  JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274
12  JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737
11  JFactory::createDocument()  JROOT/libraries/joomla/factory.php:216
10  JFactory::getDocument() JROOT/plugins/system/cachecleaner/cachecleaner.php:58
9   PlgSystemCacheCleaner->getHelper()  JROOT/plugins/system/cachecleaner/cachecleaner.php:28
8   PlgSystemCacheCleaner->onAfterRoute()   Same as call in the line below.
7   call_user_func_array()  JROOT/libraries/joomla/event/event.php:69
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/administrator.php:461
3   JApplicationAdministrator->route()  JROOT/libraries/cms/application/administrator.php:137
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 15.07 ms After last query: 0.30 ms Query memory: 0.018 MB Memory before query: 10.511 MB

UPDATE `sDg_extensions`

  SET `params` = '{\"mediaversion\":\"5cda5b1cb5ea7e089ef5b75c4acb18fc\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain
EXPLAIN not possible on query: UPDATE `sDg_extensions` SET `params` = '{\"mediaversion\":\"5cda5b1cb5ea7e089ef5b75c4acb18fc\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
Status  Duration
starting    0.02 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.00 ms
After opening tables    0.00 ms
init    0.04 ms
updating    0.03 ms
end 0.01 ms
Waiting for query cache lock    0.01 ms
end 0.06 ms
query end   14.80 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
15  JDatabaseDriverMysqli->execute()    JROOT/libraries/cms/library/helper.php:119
14  JLibraryHelper::saveParams()    JROOT/libraries/cms/version/version.php:325
13  JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284
12  JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737
11  JFactory::createDocument()  JROOT/libraries/joomla/factory.php:216
10  JFactory::getDocument() JROOT/plugins/system/cachecleaner/cachecleaner.php:58
9   PlgSystemCacheCleaner->getHelper()  JROOT/plugins/system/cachecleaner/cachecleaner.php:28
8   PlgSystemCacheCleaner->onAfterRoute()   Same as call in the line below.
7   call_user_func_array()  JROOT/libraries/joomla/event/event.php:69
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/administrator.php:461
3   JApplicationAdministrator->route()  JROOT/libraries/cms/application/administrator.php:137
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.12 ms After last query: 4.84 ms Query memory: 0.015 MB Memory before query: 11.174 MB Rows returned: 6

SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type` 
  FROM `sDg_obrss` 
  WHERE `published` = 1 
  AND `feeded` = 1 
  ORDER BY `ordering`

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_obrss   ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    6   Using where; Using filesort
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.01 ms
checking privileges on cached   0.01 ms
checking permissions    0.01 ms
sending cached result to clien  0.01 ms
updating status 0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
10  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
9   JDatabaseDriver->loadObjectList()   JROOT/plugins/system/obrss/obrss.php:40
8   plgSystemobrss->onAfterRoute()  Same as call in the line below.
7   call_user_func_array()  JROOT/libraries/joomla/event/event.php:69
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/administrator.php:461
3   JApplicationAdministrator->route()  JROOT/libraries/cms/application/administrator.php:137
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.39 ms After last query: 0.41 ms Query memory: 0.010 MB Memory before query: 11.220 MB Rows returned: 1

SELECT template, s.params

  FROM sDg_template_styles as s

  LEFT JOIN sDg_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id

  WHERE s.client_id = 1 
  AND home = '1'

  ORDER BY home

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  s   ref idx_home    idx_home    28  const   2   Using index condition; Using where; Using filesort
1   SIMPLE  e   ref element_clientid,element_folder_clientid,extension  extension   484 const,cristian_newnewj3.s.template  1   Using where; Using index
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.04 ms
checking permissions    0.01 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.02 ms
init    0.02 ms
optimizing  0.01 ms
statistics  0.04 ms
preparing   0.02 ms
executing   0.01 ms
Sorting result  0.04 ms
Sending data    0.02 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.08 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
6   JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1653
5   JDatabaseDriver->loadObject()   JROOT/libraries/cms/application/administrator.php:212
4   JApplicationAdministrator->getTemplate()    JROOT/libraries/cms/application/administrator.php:82
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.29 ms After last query: 6.31 ms Query memory: 0.023 MB Memory before query: 12.303 MB Rows returned: 1

SELECT enabled

  FROM `sDg_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'languagefilter'

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_extensions  ref element_clientid,element_folder_clientid,extension  element_clientid    402 const   1   Using index condition; Using where
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.02 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.00 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.02 ms
init    0.01 ms
optimizing  0.01 ms
statistics  0.04 ms
preparing   0.01 ms
executing   0.00 ms
Sending data    0.02 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.00 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.06 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
17  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1731
16  JDatabaseDriver->loadResult()   JROOT/libraries/cms/language/multilang.php:59
15  JLanguageMultilang::isEnabled() JROOT/libraries/cms/language/associations.php:140
14  JLanguageAssociations::isEnabled()  JROOT/administrator/components/com_content/models/articles.php:56
13  ContentModelArticles->__construct() JROOT/libraries/legacy/model/legacy.php:207
12  JModelLegacy::getInstance() JROOT/libraries/legacy/controller/legacy.php:568
11  JControllerLegacy->createModel()    JROOT/libraries/legacy/controller/legacy.php:754
10  JControllerLegacy->getModel()   JROOT/libraries/legacy/controller/legacy.php:648
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 66.27 ms After last query: 2.26 ms Query memory: 0.024 MB Memory before query: 12.668 MB Rows returned: 1

SELECT COUNT(*)

  FROM sDg_content AS a

  LEFT JOIN `sDg_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN sDg_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN sDg_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN sDg_categories AS c 
  ON c.id = a.catid

  LEFT JOIN sDg_users AS ua 
  ON ua.id = a.created_by

  WHERE (a.state = 0 OR a.state = 1)

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   range   idx_state   idx_state   1   NULL    9454    Using index condition; Using where
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.04 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.01 ms
Opening tables  0.26 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.02 ms
init    0.02 ms
optimizing  0.01 ms
statistics  0.06 ms
preparing   0.02 ms
executing   0.01 ms
Sending data    65.59 ms
end 0.02 ms
query end   0.01 ms
closing tables  0.02 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.02 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
18  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1731
17  JDatabaseDriver->loadResult()   JROOT/libraries/legacy/model/legacy.php:341
16  JModelLegacy->_getListCount()   JROOT/libraries/legacy/model/list.php:290
15  JModelList->getTotal()  JROOT/libraries/legacy/model/list.php:324
14  JModelList->getStart()  JROOT/libraries/legacy/model/list.php:185
13  JModelList->getItems()  JROOT/administrator/components/com_content/models/articles.php:368
12  ContentModelArticles->getItems()    JROOT/libraries/legacy/view/legacy.php:401
11  JViewLegacy->get()  JROOT/administrator/components/com_content/views/articles/view.html.php:39
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.69 ms After last query: 0.20 ms Query memory: 0.032 MB Memory before query: 12.680 MB Rows returned: 30

SELECT a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.ordering, a.featured, a.language, a.hits, a.publish_up, a.publish_down,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name

  FROM sDg_content AS a

  LEFT JOIN `sDg_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN sDg_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN sDg_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN sDg_categories AS c 
  ON c.id = a.catid

  LEFT JOIN sDg_users AS ua 
  ON ua.id = a.created_by

  WHERE (a.state = 0 OR a.state = 1)

  ORDER BY a.id desc 
  LIMIT 0, 30

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   index   idx_state   PRIMARY 4   NULL    59  Using where
1   SIMPLE  l   eq_ref  idx_langcode    idx_langcode    28  cristian_newnewj3.a.language    1   Using where
1   SIMPLE  uc  eq_ref  PRIMARY PRIMARY 4   cristian_newnewj3.a.checked_out 1   Using where
1   SIMPLE  ag  eq_ref  PRIMARY PRIMARY 4   cristian_newnewj3.a.access  1   
1   SIMPLE  c   eq_ref  PRIMARY PRIMARY 4   cristian_newnewj3.a.catid   1   Using where
1   SIMPLE  ua  eq_ref  PRIMARY PRIMARY 4   cristian_newnewj3.a.created_by  1   Using where
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.02 ms
init    0.01 ms
checking query cache for query  0.07 ms
checking permissions    0.01 ms
checking permissions    0.00 ms
checking permissions    0.00 ms
checking permissions    0.01 ms
checking permissions    0.00 ms
checking permissions    0.01 ms
Opening tables  0.02 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.02 ms
init    0.03 ms
optimizing  0.02 ms
statistics  0.05 ms
preparing   0.03 ms
executing   0.01 ms
Sorting result  0.01 ms
Sending data    0.20 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
16  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
15  JDatabaseDriver->loadObjectList()   JROOT/libraries/legacy/model/legacy.php:312
14  JModelLegacy->_getList()    JROOT/libraries/legacy/model/list.php:185
13  JModelList->getItems()  JROOT/administrator/components/com_content/models/articles.php:368
12  ContentModelArticles->getItems()    JROOT/libraries/legacy/view/legacy.php:401
11  JViewLegacy->get()  JROOT/administrator/components/com_content/views/articles/view.html.php:39
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.86 ms After last query: 1.11 ms Query memory: 0.019 MB Memory before query: 12.965 MB Rows returned: 4
Duplicate queries: #18

SELECT u.id AS value, u.name AS text

  FROM sDg_users AS u

  INNER JOIN sDg_content AS c 
  ON c.created_by = u.id

  GROUP BY u.id, u.name

  ORDER BY u.name

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  u   ALL PRIMARY NO INDEX KEY COULD BE USED  NULL    NULL    4   Using temporary; Using filesort
1   SIMPLE  c   ref idx_createdby   idx_createdby   4   cristian_newnewj3.u.id  857 Using where; Using index
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.02 ms
checking permissions    0.01 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.01 ms
init    0.01 ms
optimizing  0.01 ms
statistics  0.01 ms
preparing   0.01 ms
executing   0.01 ms
Copying to tmp table    0.02 ms
Copying to tmp table    2.50 ms
Sorting result  0.01 ms
Sending data    0.01 ms
end 0.01 ms
removing tmp table  0.06 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.03 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
14  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
13  JDatabaseDriver->loadObjectList()   JROOT/administrator/components/com_content/models/articles.php:355
12  ContentModelArticles->getAuthors()  JROOT/libraries/legacy/view/legacy.php:401
11  JViewLegacy->get()  JROOT/administrator/components/com_content/views/articles/view.html.php:42
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.18 ms After last query: 23.03 ms Query memory: 0.039 MB Memory before query: 15.837 MB Rows returned: 107

SELECT a.id, a.title, a.level

  FROM sDg_categories AS a

  WHERE a.parent_id > 0 
  AND extension = 'com_content' 
  AND a.published IN (0,1,2)

  ORDER BY a.lft

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL cat_idx NO INDEX KEY COULD BE USED  NULL    NULL    121 Using where; Using filesort
Profile
Status  Duration
starting    0.04 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.01 ms
checking privileges on cached   0.01 ms
checking permissions    0.01 ms
sending cached result to clien  0.01 ms
updating status 0.02 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
28  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
27  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/html/category.php:89
26  JHtmlCategory::options()    Same as call in the line below.
25  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
24  JHtml::call()   JROOT/libraries/cms/html/html.php:138
23  JHtml::_()  JROOT/libraries/legacy/form/field/category.php:52
22  JFormFieldCategory->getOptions()    JROOT/libraries/joomla/form/fields/list.php:58
21  JFormFieldList->getInput()  JROOT/libraries/joomla/form/field.php:402
20  JFormField->__get() JROOT/layouts/joomla/searchtools/default/filters.php:21
19  include JROOT/layouts/joomla/searchtools/default/filters.php    JROOT/libraries/cms/layout/file.php:121
18  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
17  JLayoutHelper::render() JROOT/layouts/joomla/searchtools/default.php:45
16  include JROOT/layouts/joomla/searchtools/default.php    JROOT/libraries/cms/layout/file.php:121
15  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
14  JLayoutHelper::render() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:48
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.12 ms After last query: 1.83 ms Query memory: 0.034 MB Memory before query: 16.016 MB Rows returned: 6

SELECT `a`.`id` AS `value`, `a`.`title` AS `text`

  FROM `sDg_viewlevels` AS `a`

  GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`

  ORDER BY `a`.`ordering` ASC,`title` ASC

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    6   Using filesort
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.01 ms
checking privileges on cached   0.01 ms
checking permissions    0.01 ms
sending cached result to clien  0.01 ms
updating status 0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
27  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
26  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/html/access.php:53
25  JHtmlAccess::level()    Same as call in the line below.
24  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
23  JHtml::call()   JROOT/libraries/cms/html/html.php:138
22  JHtml::_()  JROOT/libraries/joomla/form/fields/accesslevel.php:57
21  JFormFieldAccessLevel->getInput()   JROOT/libraries/joomla/form/field.php:402
20  JFormField->__get() JROOT/layouts/joomla/searchtools/default/filters.php:21
19  include JROOT/layouts/joomla/searchtools/default/filters.php    JROOT/libraries/cms/layout/file.php:121
18  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
17  JLayoutHelper::render() JROOT/layouts/joomla/searchtools/default.php:45
16  include JROOT/layouts/joomla/searchtools/default.php    JROOT/libraries/cms/layout/file.php:121
15  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
14  JLayoutHelper::render() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:48
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.12 ms After last query: 0.31 ms Query memory: 0.036 MB Memory before query: 16.057 MB Rows returned: 2

SELECT a.lang_code AS value, a.title AS text, a.title_native

  FROM sDg_languages AS a

  WHERE a.published >= 0

  ORDER BY a.title

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    2   Using where; Using filesort
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.01 ms
checking privileges on cached   0.01 ms
checking permissions    0.01 ms
sending cached result to clien  0.01 ms
updating status 0.02 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
28  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
27  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/html/contentlanguage.php:54
26  JHtmlContentLanguage::existing()    Same as call in the line below.
25  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
24  JHtml::call()   JROOT/libraries/cms/html/html.php:138
23  JHtml::_()  JROOT/libraries/cms/form/field/contentlanguage.php:40
22  JFormFieldContentlanguage->getOptions() JROOT/libraries/joomla/form/fields/list.php:58
21  JFormFieldList->getInput()  JROOT/libraries/joomla/form/field.php:402
20  JFormField->__get() JROOT/layouts/joomla/searchtools/default/filters.php:21
19  include JROOT/layouts/joomla/searchtools/default/filters.php    JROOT/libraries/cms/layout/file.php:121
18  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
17  JLayoutHelper::render() JROOT/layouts/joomla/searchtools/default.php:45
16  include JROOT/layouts/joomla/searchtools/default.php    JROOT/libraries/cms/layout/file.php:121
15  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
14  JLayoutHelper::render() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:48
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.13 ms After last query: 0.17 ms Query memory: 0.034 MB Memory before query: 16.093 MB Rows returned: 8

SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft

  FROM sDg_tags AS a

  LEFT JOIN `sDg_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE `a`.`lft` > 0 
  AND a.published IN (0,1)

  ORDER BY a.lft ASC

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL tag_idx,idx_left_right  NO INDEX KEY COULD BE USED  NULL    NULL    9   Using where; Using temporary; Using filesort
1   SIMPLE  b   ALL idx_left_right  NO INDEX KEY COULD BE USED  NULL    NULL    9   Range checked for each record (index map: 0x10); Distinct
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.02 ms
checking privileges on cached   0.00 ms
checking permissions    0.01 ms
checking permissions    0.01 ms
sending cached result to clien  0.01 ms
updating status 0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
25  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
24  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/form/field/tag.php:145
23  JFormFieldTag->getOptions() JROOT/libraries/joomla/form/fields/list.php:58
22  JFormFieldList->getInput()  JROOT/libraries/cms/form/field/tag.php:99
21  JFormFieldTag->getInput()   JROOT/libraries/joomla/form/field.php:402
20  JFormField->__get() JROOT/layouts/joomla/searchtools/default/filters.php:21
19  include JROOT/layouts/joomla/searchtools/default/filters.php    JROOT/libraries/cms/layout/file.php:121
18  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
17  JLayoutHelper::render() JROOT/layouts/joomla/searchtools/default.php:45
16  include JROOT/layouts/joomla/searchtools/default.php    JROOT/libraries/cms/layout/file.php:121
15  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
14  JLayoutHelper::render() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:48
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.08 ms After last query: 0.24 ms Query memory: 0.032 MB Memory before query: 16.128 MB Rows returned: 4
Duplicate queries: #13

SELECT u.id AS value, u.name AS text

  FROM sDg_users AS u

  INNER JOIN sDg_content AS c 
  ON c.created_by = u.id

  GROUP BY u.id, u.name

  ORDER BY u.name

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  u   ALL PRIMARY NO INDEX KEY COULD BE USED  NULL    NULL    4   Using temporary; Using filesort
1   SIMPLE  c   ref idx_createdby   idx_createdby   4   cristian_newnewj3.u.id  857 Using where; Using index
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 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.01 ms
sending cached result to clien  0.01 ms
updating status 0.01 ms
cleaning up 0.00 ms
Call Stack
#   Caller  File and line number
24  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
23  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/form/field/author.php:69
22  JFormFieldAuthor->getOptions()  JROOT/libraries/joomla/form/fields/list.php:58
21  JFormFieldList->getInput()  JROOT/libraries/joomla/form/field.php:402
20  JFormField->__get() JROOT/layouts/joomla/searchtools/default/filters.php:21
19  include JROOT/layouts/joomla/searchtools/default/filters.php    JROOT/libraries/cms/layout/file.php:121
18  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
17  JLayoutHelper::render() JROOT/layouts/joomla/searchtools/default.php:45
16  include JROOT/layouts/joomla/searchtools/default.php    JROOT/libraries/cms/layout/file.php:121
15  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
14  JLayoutHelper::render() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:48
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.08 ms After last query: 13.64 ms Query memory: 0.036 MB Memory before query: 16.519 MB Rows returned: 6

SELECT a.id AS value, a.title AS text

  FROM `sDg_viewlevels` AS a

  GROUP BY a.id, a.title, a.ordering

  ORDER BY a.ordering ASC

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    6   Using filesort
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 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
updating status 0.01 ms
cleaning up 0.00 ms
Call Stack
#   Caller  File and line number
29  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
28  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/html/access.php:255
27  JHtmlAccess::assetgroups()  JROOT/libraries/cms/html/access.php:277
26  JHtmlAccess::assetgrouplist()   Same as call in the line below.
25  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
24  JHtml::call()   JROOT/libraries/cms/html/html.php:138
23  JHtml::_()  JROOT/layouts/joomla/html/batch/access.php:32
22  include JROOT/layouts/joomla/html/batch/access.php  JROOT/libraries/cms/layout/file.php:121
21  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
20  JLayoutHelper::render() JROOT/libraries/cms/html/batch.php:34
19  JHtmlBatch::access()    Same as call in the line below.
18  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
17  JHtml::call()   JROOT/libraries/cms/html/html.php:138
16  JHtml::_()  JROOT/administrator/components/com_content/views/articles/tmpl/default_batch_body.php:21
15  include JROOT/administrator/components/com_content/views/articles/tmpl/default_batch_body.php   JROOT/libraries/legacy/view/legacy.php:670
14  JViewLegacy->loadTemplate() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:227
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.10 ms After last query: 0.47 ms Query memory: 0.038 MB Memory before query: 16.564 MB Rows returned: 107

SELECT a.id, a.title, a.level

  FROM sDg_categories AS a

  WHERE a.parent_id > 0 
  AND extension = 'com_content' 
  AND a.published IN (0,1)

  ORDER BY a.lft

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL cat_idx NO INDEX KEY COULD BE USED  NULL    NULL    121 Using where; Using filesort
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 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
updating status 0.01 ms
cleaning up 0.00 ms
Call Stack
#   Caller  File and line number
28  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
27  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/html/category.php:89
26  JHtmlCategory::options()    Same as call in the line below.
25  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
24  JHtml::call()   JROOT/libraries/cms/html/html.php:104
23  JHtml::_()  JROOT/layouts/joomla/html/batch/item.php:31
22  include JROOT/layouts/joomla/html/batch/item.php    JROOT/libraries/cms/layout/file.php:121
21  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
20  JLayoutHelper::render() JROOT/libraries/cms/html/batch.php:54
19  JHtmlBatch::item()  Same as call in the line below.
18  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
17  JHtml::call()   JROOT/libraries/cms/html/html.php:138
16  JHtml::_()  JROOT/administrator/components/com_content/views/articles/tmpl/default_batch_body.php:29
15  include JROOT/administrator/components/com_content/views/articles/tmpl/default_batch_body.php   JROOT/libraries/legacy/view/legacy.php:670
14  JViewLegacy->loadTemplate() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:227
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.09 ms After last query: 1.88 ms Query memory: 0.035 MB Memory before query: 16.713 MB Rows returned: 8

SELECT a.id, a.title, a.level, a.parent_id

  FROM sDg_tags AS a

  WHERE a.parent_id > 0 
  AND a.published IN (1)

  ORDER BY a.lft

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL tag_idx NO INDEX KEY COULD BE USED  NULL    NULL    9   Using where; Using filesort
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 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
updating status 0.01 ms
cleaning up 0.00 ms
Call Stack
#   Caller  File and line number
28  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
27  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/html/tag.php:137
26  JHtmlTag::tags()    Same as call in the line below.
25  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
24  JHtml::call()   JROOT/libraries/cms/html/html.php:138
23  JHtml::_()  JROOT/layouts/joomla/html/batch/tag.php:26
22  include JROOT/layouts/joomla/html/batch/tag.php JROOT/libraries/cms/layout/file.php:121
21  JLayoutFile->render()   JROOT/libraries/cms/layout/helper.php:72
20  JLayoutHelper::render() JROOT/libraries/cms/html/batch.php:106
19  JHtmlBatch::tag()   Same as call in the line below.
18  call_user_func_array()  JROOT/libraries/cms/html/html.php:236
17  JHtml::call()   JROOT/libraries/cms/html/html.php:138
16  JHtml::_()  JROOT/administrator/components/com_content/views/articles/tmpl/default_batch_body.php:35
15  include JROOT/administrator/components/com_content/views/articles/tmpl/default_batch_body.php   JROOT/libraries/legacy/view/legacy.php:670
14  JViewLegacy->loadTemplate() JROOT/administrator/components/com_content/views/articles/tmpl/default.php:227
13  include JROOT/administrator/components/com_content/views/articles/tmpl/default.php  JROOT/libraries/legacy/view/legacy.php:670
12  JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:209
11  JViewLegacy->display()  JROOT/administrator/components/com_content/views/articles/view.html.php:76
10  ContentViewArticles->display()  JROOT/libraries/legacy/controller/legacy.php:690
9   JControllerLegacy->display()    JROOT/administrator/components/com_content/controller.php:52
8   ContentController->display()    JROOT/libraries/legacy/controller/legacy.php:728
7   JControllerLegacy->execute()    JROOT/administrator/components/com_content/content.php:21
6   require_once JROOT/administrator/components/com_content/content.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/administrator.php:98
3   JApplicationAdministrator->dispatch()   JROOT/libraries/cms/application/administrator.php:152
2   JApplicationAdministrator->doExecute()  JROOT/libraries/cms/application/cms.php:257
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.69 ms After last query: 3.33 ms Query memory: 0.019 MB Memory before query: 16.941 MB Rows returned: 12

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM sDg_modules AS m

  LEFT JOIN sDg_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN sDg_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 <= '2016-05-23 07:19:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2016-05-23 07:19:19') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  m   ref PRIMARY,published,newsfeeds published   1   const   49  Using index condition; Using where; Using filesort
1   SIMPLE  e   ref element_clientid,element_folder_clientid    element_clientid    403 cristian_newnewj3.m.module,const    1   Using index condition; Using where
1   SIMPLE  mm  ref PRIMARY PRIMARY 4   cristian_newnewj3.m.id  4   Using where; Using index
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.06 ms
checking permissions    0.01 ms
checking permissions    0.00 ms
checking permissions    0.01 ms
Opening tables  0.02 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.02 ms
init    0.03 ms
optimizing  0.03 ms
statistics  0.06 ms
preparing   0.04 ms
executing   0.01 ms
Sorting result  0.14 ms
Sending data    0.13 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.21 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
12  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
11  JDatabaseDriver->loadObjectList()   JROOT/libraries/cms/module/helper.php:409
10  JModuleHelper::getModuleList()  JROOT/libraries/cms/module/helper.php:352
9   JModuleHelper::load()   JROOT/libraries/cms/module/helper.php:84
8   JModuleHelper::getModules() JROOT/administrator/templates/isis/index.php:56
7   require JROOT/administrator/templates/isis/index.php    JROOT/libraries/joomla/document/html.php:578
6   JDocumentHtml->_loadTemplate()  JROOT/libraries/joomla/document/html.php:635
5   JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455
4   JDocumentHtml->parse()  JROOT/libraries/cms/application/cms.php:1054
3   JApplicationCms->render()   JROOT/libraries/cms/application/administrator.php:433
2   JApplicationAdministrator->render() JROOT/libraries/cms/application/cms.php:263
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.08 ms After last query: 2.47 ms Query memory: 0.017 MB Memory before query: 17.092 MB Rows returned: 1

SELECT COUNT(*)

  FROM sDg_messages

  WHERE state = 0 
  AND user_id_to = 546

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_messages    ref useridto_state  useridto_state  5   const,const 1   Using index
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 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
updating status 0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
12  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1731
11  JDatabaseDriver->loadResult()   JROOT/administrator/modules/mod_status/mod_status.php:25
10  include JROOT/administrator/modules/mod_status/mod_status.php   JROOT/libraries/cms/module/helper.php:190
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:411
6   JDocumentHtml->getBuffer()  JROOT/libraries/joomla/document/html.php:697
5   JDocumentHtml->_renderTemplate()    JROOT/libraries/joomla/document/html.php:477
4   JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068
3   JApplicationCms->render()   JROOT/libraries/cms/application/administrator.php:433
2   JApplicationAdministrator->render() JROOT/libraries/cms/application/cms.php:263
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.47 ms After last query: 0.07 ms Query memory: 0.017 MB Memory before query: 17.109 MB Rows returned: 1

SELECT COUNT(session_id)

  FROM sDg_session

  WHERE guest = 0 
  AND client_id = 1

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_session ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    374 Using where
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.02 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.02 ms
init    0.01 ms
optimizing  0.01 ms
statistics  0.01 ms
preparing   0.01 ms
executing   0.01 ms
Sending data    0.24 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.01 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.05 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
12  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1731
11  JDatabaseDriver->loadResult()   JROOT/administrator/modules/mod_status/mod_status.php:34
10  include JROOT/administrator/modules/mod_status/mod_status.php   JROOT/libraries/cms/module/helper.php:190
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:411
6   JDocumentHtml->getBuffer()  JROOT/libraries/joomla/document/html.php:697
5   JDocumentHtml->_renderTemplate()    JROOT/libraries/joomla/document/html.php:477
4   JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068
3   JApplicationCms->render()   JROOT/libraries/cms/application/administrator.php:433
2   JApplicationAdministrator->render() JROOT/libraries/cms/application/cms.php:263
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.39 ms After last query: 0.12 ms Query memory: 0.017 MB Memory before query: 17.126 MB Rows returned: 1

SELECT COUNT(session_id)

  FROM sDg_session

  WHERE guest = 0 
  AND client_id = 0

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_session ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    374 Using where
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.00 ms
checking query cache for query  0.03 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.00 ms
Table lock  0.00 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.01 ms
init    0.01 ms
optimizing  0.01 ms
statistics  0.01 ms
preparing   0.01 ms
executing   0.01 ms
Sending data    0.15 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.00 ms
Waiting for query cache lock    0.00 ms
updating status 0.01 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.02 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
12  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1731
11  JDatabaseDriver->loadResult()   JROOT/administrator/modules/mod_status/mod_status.php:63
10  include JROOT/administrator/modules/mod_status/mod_status.php   JROOT/libraries/cms/module/helper.php:190
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:411
6   JDocumentHtml->getBuffer()  JROOT/libraries/joomla/document/html.php:697
5   JDocumentHtml->_renderTemplate()    JROOT/libraries/joomla/document/html.php:477
4   JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068
3   JApplicationCms->render()   JROOT/libraries/cms/application/administrator.php:433
2   JApplicationAdministrator->render() JROOT/libraries/cms/application/cms.php:263
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.11 ms After last query: 10.24 ms Query memory: 0.022 MB Memory before query: 17.552 MB Rows returned: 4

SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native

  FROM sDg_menu_types AS a

  LEFT JOIN sDg_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0

  LEFT JOIN sDg_languages AS l 
  ON l.lang_code = language

  WHERE (b.client_id = 0 OR b.client_id IS NULL)

  GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  a   ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    4   Using temporary; Using filesort
1   SIMPLE  b   ref idx_menutype    idx_menutype    98  cristian_newnewj3.a.menutype    11  Using where
1   SIMPLE  l   eq_ref  idx_langcode    idx_langcode    28  cristian_newnewj3.b.language    1   Using where
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.00 ms
init    0.01 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.01 ms
sending cached result to clien  0.01 ms
updating status 0.02 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
15  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
14  JDatabaseDriver->loadObjectList()   JROOT/administrator/modules/mod_menu/helper.php:47
13  ModMenuHelper::getMenus()   JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:141
12  require JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php   JROOT/administrator/modules/mod_menu/tmpl/default.php:14
11  require JROOT/administrator/modules/mod_menu/tmpl/default.php   JROOT/administrator/modules/mod_menu/mod_menu.php:30
10  include JROOT/administrator/modules/mod_menu/mod_menu.php   JROOT/libraries/cms/module/helper.php:190
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:411
6   JDocumentHtml->getBuffer()  JROOT/libraries/joomla/document/html.php:697
5   JDocumentHtml->_renderTemplate()    JROOT/libraries/joomla/document/html.php:477
4   JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068
3   JApplicationCms->render()   JROOT/libraries/cms/application/administrator.php:433
2   JApplicationAdministrator->render() JROOT/libraries/cms/application/cms.php:263
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.65 ms After last query: 0.57 ms Query memory: 0.026 MB Memory before query: 17.624 MB Rows returned: 68

SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element

  FROM sDg_menu AS m

  LEFT JOIN sDg_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1

  ORDER BY m.lft

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  m   ref PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid  idx_client_id_parent_id_alias_language  1   const   68  Using index condition; Using where; Using filesort
1   SIMPLE  e   eq_ref  PRIMARY PRIMARY 4   cristian_newnewj3.m.component_id    1   Using where
Profile
Status  Duration
starting    0.01 ms
Waiting for query cache lock    0.01 ms
init    0.01 ms
checking query cache for query  0.03 ms
checking permissions    0.01 ms
checking permissions    0.01 ms
Opening tables  0.01 ms
After opening tables    0.01 ms
System lock 0.01 ms
Table lock  0.01 ms
After opening tables    0.01 ms
Waiting for query cache lock    0.00 ms
After opening tables    0.01 ms
init    0.02 ms
optimizing  0.01 ms
statistics  0.04 ms
preparing   0.02 ms
executing   0.01 ms
Sorting result  0.14 ms
Sending data    0.12 ms
end 0.01 ms
query end   0.01 ms
closing tables  0.01 ms
freeing items   0.01 ms
updating status 0.00 ms
Waiting for query cache lock    0.00 ms
updating status 0.09 ms
Waiting for query cache lock    0.01 ms
updating status 0.00 ms
storing result in query cache   0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
15  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
14  JDatabaseDriver->loadObjectList()   JROOT/administrator/modules/mod_menu/helper.php:93
13  ModMenuHelper::getComponents()  JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php:246
12  require JROOT/administrator/modules/mod_menu/tmpl/default_enabled.php   JROOT/administrator/modules/mod_menu/tmpl/default.php:14
11  require JROOT/administrator/modules/mod_menu/tmpl/default.php   JROOT/administrator/modules/mod_menu/mod_menu.php:30
10  include JROOT/administrator/modules/mod_menu/mod_menu.php   JROOT/libraries/cms/module/helper.php:190
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:411
6   JDocumentHtml->getBuffer()  JROOT/libraries/joomla/document/html.php:697
5   JDocumentHtml->_renderTemplate()    JROOT/libraries/joomla/document/html.php:477
4   JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068
3   JApplicationCms->render()   JROOT/libraries/cms/application/administrator.php:433
2   JApplicationAdministrator->render() JROOT/libraries/cms/application/cms.php:263
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.16 ms After last query: 19.25 ms Query memory: 0.022 MB Memory before query: 18.819 MB Rows returned: 205

SELECT * 
  FROM sDg_acymailing_config

Explain
id  select_type table   type    possible_keys   key key_len ref rows    Extra
1   SIMPLE  sDg_acymailing_config   ALL NULL    NO INDEX KEY COULD BE USED  NULL    NULL    205 
Profile
Status  Duration
starting    0.02 ms
Waiting for query cache lock    0.01 ms
init    0.01 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
updating status 0.01 ms
cleaning up 0.01 ms
Call Stack
#   Caller  File and line number
13  JDatabaseDriverMysqli->execute()    JROOT/libraries/joomla/database/driver.php:1692
12  JDatabaseDriver->loadObjectList()   JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11  cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:454
10  acymailing_config() JROOT/administrator/components/com_acymailing/helpers/helper.php:1129
9   include_once JROOT/administrator/components/com_acymailing/helpers/helper.php   JROOT/plugins/system/regacymailing/regacymailing.php:139
8   plgSystemRegacymailing->onAfterRender() Same as call in the line below.
7   call_user_func_array()  JROOT/libraries/joomla/event/event.php:69
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:1074
3   JApplicationCms->render()   JROOT/libraries/cms/application/administrator.php:433
2   JApplicationAdministrator->render() JROOT/libraries/cms/application/cms.php:263
1   JApplicationCms->execute()  JROOT/administrator/index.php:51
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

24 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

2 × SELECT COUNT(session_id) 
  FROM sDg_session

2 × SELECT u.id AS value, u.name AS text 
  FROM sDg_users AS u 
  INNER JOIN sDg_content AS c 
  ON c.created_by = u.id 
  GROUP BY u.id, u.name

2 × SELECT a.id, a.title, a.level 
  FROM sDg_categories AS a

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sDg_extensions

1 × SELECT a.id, a.title, a.level, a.parent_id 
  FROM sDg_tags AS a

1 × SELECT a.id AS value, a.title AS text 
  FROM `sDg_viewlevels` AS a 
  GROUP BY a.id, a.title, a.ordering

1 × SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft 
  FROM sDg_tags AS a 
  LEFT JOIN `sDg_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM sDg_modules AS m 
  LEFT JOIN sDg_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN sDg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT COUNT(*) 
  FROM sDg_messages

1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM sDg_menu AS m 
  LEFT JOIN sDg_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
  FROM sDg_menu_types AS a 
  LEFT JOIN sDg_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN sDg_languages AS l 
  ON l.lang_code = language

1 × SELECT a.lang_code AS value, a.title AS text, a.title_native 
  FROM sDg_languages AS a

1 × SELECT * 
  FROM sDg_acymailing_confi

1 × SELECT `a`.`id` AS `value`, `a`.`title` AS `text` 
  FROM `sDg_viewlevels` AS `a` 
  GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`

1 × SELECT template, s.params 
  FROM sDg_template_styles as s 
  LEFT JOIN sDg_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id

1 × SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type` 
  FROM `sDg_obrss`

1 × SELECT `params` 
  FROM sDg_extensions

1 × SELECT enabled 
  FROM `sDg_extensions`

1 × SELECT COUNT(*) 
  FROM sDg_content AS a 
  LEFT JOIN `sDg_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN sDg_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN sDg_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN sDg_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN sDg_users AS ua 
  ON ua.id = a.created_by

1 × SELECT `data` 
  FROM `sDg_session`

1 × SELECT folder AS type, element AS name, params 
  FROM sDg_extensions

1 × SELECT a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.ordering, a.featured, a.language, a.hits, a.publish_up, a.publish_down,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name 
  FROM sDg_content AS a 
  LEFT JOIN `sDg_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN sDg_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN sDg_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN sDg_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN sDg_users AS ua 
  ON ua.id = a.created_by

1 × SELECT * 
  FROM sDg_languages

OTHER Tables:

1 × UPDATE `sDg_extensions` 
  SET `params` = '{\"mediaversion\":\"5cda5b1cb5ea7e089ef5b75c4acb18fc\"}'`

I attach two image before of the joomla debug

Thanks a lot.

[ggppdk]

Save a new one in "World" with few text = 150 seconds.

Did you get an almost empty screen

• as the picture that i posted above, which means that the code worked ?

If you did not get, then the queries above is after the form has been saved (it is the form reloading) and then it is of little use.

I say this because it seems that the above is not the "150 seconds" that you had said previously

[pici65]

Hello
thanks for answer.
150 seconds are the seconds that I have seen in my watch before to save definitely the new article. Yes I see the query gives 91.13 ms.. but I have done a test in different browsers. Usually I use Palemoon. But I have tested on Waterfox, Chrome, Edge. ecc. My PC is a quad core ssd with 16gb of RAM. I do a test now in another PC and Advise you of the time watch to save article.

[ggppdk]

With the testing code you should get an almost empty screen ,
menu bar + empty space + debug console

• did you get the above ? (see the picture at my first message)

[pici65]

First of all, thanks for answer.
Second I have tested in another PC here and another PC in other country. The same problem of time in save
Third I follow better the steps above.. probably I have not done the right steps about tabs of the browser.
I will return here in a while.

[pici65]

Hello
I follow the exact point:
1 - `
$this->postSaveHook($model, $validData);

    return true;  
if ( $context == 'com_content.edit.article' && JFactory::getUser()->username=='XXXXX' && $app->isAdmin() )

{
$this->setRedirect(null);
}
}
} `
and done the points 2/3/4/5

Below the "slow query" that I see in RED:
Query Time: 16.08 ms After last query: 0.32 ms Query memory: 0.018 MB Memory before query: 10.475 MB

UPDATE sDg_extensions

SET params = '{"mediaversion":"773f7d41cb1cedfb2b303b79971141d4"}'

WHERE type = 'library'

AND element = 'joomla'

Query Time: 69.26 ms After last query: 2.17 ms Query memory: 0.024 MB Memory before query: 12.632 MB Rows returned: 1

SELECT COUNT(*)

FROM sDg_content AS a

LEFT JOIN sDg_languages AS l
ON l.lang_code = a.language

LEFT JOIN sDg_users AS uc
ON uc.id=a.checked_out

LEFT JOIN sDg_viewlevels AS ag
ON ag.id = a.access

LEFT JOIN sDg_categories AS c
ON c.id = a.catid

LEFT JOIN sDg_users AS ua
ON ua.id = a.created_by

WHERE (a.state = 0 OR a.state = 1)

i do not understand when you say
"With the testing code you should get an almost empty screen"
I don't see empty screen.

Thanks

[ggppdk]

Hello

ok, i see now,

i had asked you, to add it before:

  return true;

• you have added it after, thus it is never used

please move the code just above:

  return true;

[pici65]

So after "..($model, $validData);"?

[ggppdk]

So after "$this->postSaveHook($model, $validData);"?

---

Yes exactly, that is what i said in my first message

[pici65]

Sorry.
I have done

as you can see here

$this->postSaveHook($model, $validData);
if ( $context == 'com_content.edit.article' && JFactory::getUser()->username=='XXXXX' && $app->isAdmin() )
{
$this->setRedirect(null);

}

I can't see an empty page
and these are the queries in red colours:

Query Time: 35.62 ms After last query: 0.30 ms Query memory: 0.018 MB Memory before query: 10.517 MB

UPDATE sDg_extensions

SET params = '{"mediaversion":"3f3c61f85a9bd256aa614c016adfa4ef"}'

WHERE type = 'library'
AND element = 'joomla'

---

Query Time: 68.07 ms After last query: 2.21 ms Query memory: 0.024 MB Memory before query: 12.674 MB Rows returned: 1

SELECT COUNT(*)

FROM sDg_content AS a

LEFT JOIN sDg_languages AS l
ON l.lang_code = a.language

LEFT JOIN sDg_users AS uc
ON uc.id=a.checked_out

LEFT JOIN sDg_viewlevels AS ag
ON ag.id = a.access

LEFT JOIN sDg_categories AS c
ON c.id = a.catid

LEFT JOIN sDg_users AS ua
ON ua.id = a.created_by

WHERE (a.state = 0 OR a.state = 1)
----------------------------

[ggppdk]

You should see this almost empty screen otherwise it means it did not work,

did you login with username ?:
XXXXX

Finally, also instead of

if ( $context == 'com_content.edit.article' && JFactory::getUser()->username=='XXXXX' && $app->isAdmin() )
...

you can also use (remember to remove it after testing to avoid effecting other users):

if ( $context == 'com_content.edit.article' )
...

[pici65]

Hello,
"You should see this almost empty screen otherwise it means it did not work,"..
No, It's not empty
After point 1 login in the backend I see the imagine below

After in general config
I put on yes as you can see

So After save an article in the "large" subcategory the query are that I post above.

did you login with username ?:
Yes, off course.

What I am in wrong?

[ggppdk]

Yes now it looks right

now post

• a picture of "Profile information" of Joomla DEBUG console
• and the check for slow SQL queries , inside "Database Queries" of Joomla DEBUG console

they should now reveal, if this is a performance issue of Joomla or of some 3rd party plugin