Feeling Lucky
?
[#10567] - Save new article (create a new ID) very slow in category with many articles
- Closed
- 10 Jun 2016
- Medium
- Build: master
- # 10567
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
Votes
# of Users Experiencing Issue
1/1
Average Importance Score
5.00
pici65
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
So after "..($model, $validData);"?
ggppdk
- comment
- 23 May 2016
So after "$this->postSaveHook($model, $validData);"?
Yes exactly, that is what i said in my first message
pici65
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
- comment
- 23 May 2016
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
pici65
- comment
- 23 May 2016
Yes.
After to save article I receive
Errore HTTP 500
Microsoft Edge non riesce a trovare questa pagina
But here are Profile information
Ad here the query info in red
Anyway, about "performance issue of Joomla or of some 3rd party plugin"
I have done a fresh installation of joomla without plug, without new template, without framework and gives the same problem in subcategory with many articles. Why?
Suggest? Indications?
Thanks.
ggppdk
- comment
- 23 May 2016
I have done a fresh installation of joomla without plug, without new template, without framework and gives the same problem in subcategory with many articles. Why?
Ok i see the configuration you have
- then there is no need to test on your website
- I will test this locally
will post back in a few days
pici65
- comment
- 30 May 2016
Hello
I update you with other test.
I have done a mirror copy of one site with all the articles (30.000) in few category and unsintall step by step all the add components, modules, plugin... the result is the same.
Create new article in category with many articles is very hard. Until 300 seconds for every new article.
Have you some news?
ch2856
- comment
- 1 Jun 2016
I experience the same issue, one category with more than 5000 articles, takes about 10-15 sec to save (first time).
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/10567.
pici65
- comment
- 1 Jun 2016
Hello, I am sure I am not alone. I am a webmaster, not a php programmer or MySql programmer. I hope the developers of Joomla! fix this problem. Is this the right place to indicate the issues for them?
Could be problematic that this fantastic CMS create problem in a category after 3000 articles. I have the same problem in 3 sites with large content.
ggppdk
- comment
- 3 Jun 2016
I confirm the findings of @alikon , the issue is with checking for duplicate alias inside the given category,
- the articles DB tables does have an index for the alias column, thus you get terrible performance,
- furthermore the query is executed 3 times during article creation and 1 time during article update
The issue is fixable , just by adding the missing index to alias column, the query then runs in milliseconds ...
stevenjta
- comment
- 3 Jun 2016
please I have the same problem could you explain how I can fix th issue?? @ggppdk
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/10567.
pici65
- comment
- 3 Jun 2016
@ggppdk Please explain what I must do when you say:
"The issue is fixable , just by adding the missing index to alias column, the query then runs in milliseconds "
also..
in a test site with very fresh installation
If I use an alias very different do not change anything.. save new article in this full category mean 120 seconds almost.
Also..
I have changed in the path ../administrator/components/com_content/models/article.php
from -> if ($table->load(array('alias' => $data['alias'], 'catid' => $data['catid'])))
to -> if ($table->load(array('catid' => $data['catid'], 'alias' => $data['alias'])))
nothing change about time.
So Which is the fix that is possible to do for it?
ggppdk
- comment
- 3 Jun 2016
Do not hack the Joomla DB schema
i am guessing that this index will be in the next release of Joomla ... or similar one
ALTER TABLE `PPP_content` ADD INDEX `idx_alias` (`alias`);
In
- a testing website
- and only for the purpose of verifying the fix in your case too
Excute the above in phpmyadmin (or in the DB management tool that you are using)
1. Notice that i used a name too: idx_alias so that to follow naming used in Joomla ?
2. Replace PPP with your DB prefix
Then test to see the effect, note that there is a chance that there is 2nd performance issue,
- but in any case you should see a big performance benefit in the new article creation in category with many items
after testing you should remove the index, for your live site wait for next Joomla release
pici65
- comment
- 3 Jun 2016
Ok.
I return to original com_content/models/article.php I don't modify.
go in a test site with large content in few category
open PhpMyadmin
go to the DB and put
ALTER TABLE myprefix_content ADD INDEX JHS_alias (alias);
in
SQL query on database form
and click on "submit query"
Nothing change in time to save article.
What Am I in wrong?
alikon
- comment
- 3 Jun 2016
You should notice with the hack proposed by @ggppdk + debug enabled that
the query now use the index instead of sequential scan see #10710
On 3 Jun 2016 11:19 am, "pici65" notifications@github.com wrote:
Ok.
I return to original com_content/models/article.php I don't modify.
go in a test site with large content in few category
open PhpMyadmin
go to the DB and put ALTER TABLE myprefix_content ADD INDEX JHS_alias (alias
);
in
SQL query on database form
and click on "submit query"
Nothing change in time to save article.
What Am I in wrong?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#10567 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AALFsX6mftG2UCQ7VvYPpqHBmFLKkGsSks5qH_GigaJpZM4Ijkr-
.
ggppdk
- comment
- 3 Jun 2016
@pici65
Did you wait for the index to be created ?
it would take, 10-30 seconds or more depending on the size and load of your website
also to avoid guessing of what is happening you should apply my testing instructions above:
#10567 (comment)
- unfortunately for some reason you could not do it, thus we have no real profiling information from your case and then you posted information of the part that happens after redirection (article form loading) which is not the problematic part
thus i don't have the needed information to answer you
pici65
- comment
- 3 Jun 2016
@ggppdk
Yes after
ALTER TABLE myprefix_content ADD INDEX JHS_alias (alias);
Also I wait 120 seconds to save a new article with a very new and anomaly alias
(for example the new article is named test 45, also the alias).
I repeat If I save this article in an empty category I obtain the perfect saving in 3 seconds.
In a category with more 3000 articles, this is the problem.
I have a dedicated Intel Xeon E3-1230v2 with double SSD (one for DB MySql) and 32 gb RAM..
Here are presents only 3 sites with large content..
So I can't understand
brianteeman
- comment
- 3 Jun 2016
are you really typing
ALTER TABLE myprefix_content ADD INDEX JHS_alias (alias);
On 3 June 2016 at 10:46, pici65 notifications@github.com wrote:
@ggppdk https://github.com/ggppdk
Yes after
ALTER TABLE myprefix_content ADD INDEX JHS_alias (alias);
Also I wait 120 seconds to save a new article with a very new and anomaly
alias
(for example the new article is named test 45, also the alias).
i repeat If I save this article in an empty category I obtain the perfect
saving in 3 seconds.
I a category with more 3000 articles this is the problem.
I have a dedicated Intel Xeon E3-1230v2 with double SSD (one for DB MySql)
and 32 gb RAM..
Here are presents only 3 sites with large content..
So I can't understand—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#10567 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/ABPH8Zee5ohehXdBFJhU-tVufc5rLTGVks5qH_f6gaJpZM4Ijkr-
.
Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/
pici65
- comment
- 3 Jun 2016
@brianteeman
Hello
sorry I don not understand.
Have you some specific help for this situation?
I can give you the superadmin in the test site, if necessary.
Thanks.
brianteeman
- comment
- 3 Jun 2016
ALTER TABLE myprefix_content ADD INDEX JHS_alias (alias);
if that is what you are typing then it is wrong
you need to replace "myprefix" with the prefix of your table
pici65
- comment
- 3 Jun 2016
@brianteeman
:-)
I have write "myprefix" to not show visible "my prefix".
These are the steps that I have done:
1 - open PhpMyAdmin
2 - go in the test DB that have the same numbers of articles (30.000) with some categories. The categories with more articles have about 8000 articles.
3 - go to tab "query"
4 - go to form SQL query on database "myDB" (to not show here again)
5 - write "ALTER TABLE myprefix(to not show my prefix)_content ADD INDEX JHS_alias (alias);
6 - click "save query"
7 - create new article in a large category (is a subcategory)
8 - time to save is 120 seconds
So If I save in the category before the subcategory (that's empty) time to save = 3 seconds
If I save in the subcategory (with 8000 articles) 120 seconds
Only the question that I have is:
here
ALTER TABLE myprefix(to not show my prefix)_content ADD INDEX JHS_alias (alias);
I write JHS_alias Because I suppose I can put every kind of prefix for the alias.. Is It true?
ggppdk
- comment
- 5 Jun 2016
I could not test on large categories because Joomla Debug Console hits PHP memory limit:
- 1 Gigabyte
but i did test on smaller categories (with less articles)
and it does because for 8000 articles in a category:
you have 8000 queries like:
UPDATE #__content
SET ordering = 58
WHERE `id` = '768'
My estimation
thus about 12ms - 25 ms X 8000 = 100-110 seconds (ABOUT) of table re-ordering queries
then about 8 - 16 seconds the duplicate alias queries
then about 1.5 - 2 seconds the smart-index updates
makes the total of e.g. 120 seconds that you are seeing
ggppdk
- comment
- 5 Jun 2016
It is an old issue:
https://developer.joomla.org/joomlacode-archive/issue-32329.html
There is already a suggested fix when using MySQL DB:
- that replace the NNNN SQL queries with a single SQL query
pici65
- comment
- 5 Jun 2016
So.. we wait an answer-patch for this last version of Joomla! If I understand..
mbabker
- comment
- 5 Jun 2016
Just merge the damn patch as its obvious the project doesn't care to
properly support its claim of multi-database support.
On Sunday, June 5, 2016, Georgios Papadakis notifications@github.com
wrote:
It is an old issue:
https://developer.joomla.org/joomlacode-archive/issue-32329.htmlThere is already a suggested fix when using MySQL DB:
- that replace the NNNN SQL queries with a single SQL query
@mbabker https://github.com/mbabker
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#10567 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AAWfoT9m2l5Sr_IkONJwHadAzrB3OV0fks5qIyodgaJpZM4Ijkr-
.
brianteeman
- comment
- 5 Jun 2016
You were the one demanding that pr needed applying to non mysql databases
mbabker
- comment
- 6 Jun 2016
I still stand by that; I don't think the project should penalize people running non-MySQL engines but at the same time if nobody's going to make the effort to do it then at this point who cares.
pici65
- comment
- 6 Jun 2016
Sorry I do not understand.
I am not a developer. In order to save an article (new ID) in a category or sub-category with many articles what I must do? In one category I have 8500 articles, with a time to save about 240 seconds for a new ID.
I see here this:
1) Order article on frontpage descending by _content_frontpage.ordering (article with maximum ordering value first)? Then new article can have assigned ordering max(ordering)+1 value without reordering all other articles. Same for _content.ordering .
2) Optimalize JTable->reorder algoritm (in attached patch)
But I do not understand.
Can Someone explain, step by step what I must do to fix this problem? Where is the Patch? Is this below? In which path and in which way?
`--- table.php.orig 2015-10-28 17:44:49.199224888 +0100
+++ table.php 2015-10-28 17:46:52.161204224 +0100
@@ -1367,6 +1367,11 @@
throw new UnexpectedValueException(sprintf('%s does not support ordering.', get_class($this)));
}
- // Speedup by SQL optimalization
- if ($this->_db->name == 'mysql')
- return $this->reorderMysql($where);
-
// Default (slow) reorder $k = $this->_tbl_key; // Get the primary keys and ordering values for the selection.@@ -1408,6 +1413,47 @@
return true;
}
+
- /**
- * Method to compact the ordering values of rows in a group of rows
- * defined by an SQL WHERE clause.
- *
- * @param string $where WHERE clause to use for limiting the selection of rows to compact the ordering values.
- *
- * @return mixed Boolean True on success.
- *
- * @link http://docs.joomla.org/JTable/reorder
- * @since 11.1
- */
- protected function reorderMysql($where = '')
- {
- $k = $this->_tbl_key;
- $this->_db->setQuery('set @num = 0');
- $this->_db->execute();
- $query = $this->_db->getQuery(true)
- ->update($this->_tbl)
- ->set('ordering = @num := @num + 1')
- ->where('ordering >= 0')
- ->order('ordering');
- // Setup the extra where and ordering clause data.
- if ($where)
- {
- $query->where($where);
- }
- // Warning: Unpatched version of JDatabaseQuery->__toString ignores 'order' to update query.
- // Then query must be built from string like this:
- //$query = "update {$this->_tbl} set ordering = @num := @num + 1 where ordering >= 0 " . $where? (" and " . $where): "" . " order by ordering";
- $this->_db->setQuery($query);
- $this->_db->execute();
- return true;
- }
+
/**
- Method to move a row in the ordering sequence of a group of rows defined by an SQL WHERE clause.
- Negative numbers move the row up in the sequence and positive numbers move it down.`
@mbabker "Just merge the damn patch". Is what I posted here? Is a portion of PHP to "patch" in specific path of a specific page?
Thanks
bertmert
- comment
- 7 Jun 2016
This one is the "damn patch" ;-)
PR https://github.com/joomla/joomla-cms/pull/8563/files
Add green lines to mentioned file (and knock on wood that PR is not outdated).
Here PR concerning index but see comment of @richard67 #10739 (comment)
No answer yet if it can be solved somehow.
pici65
- comment
- 7 Jun 2016
@bertmert thanks.
The patch have two parts.
The second is not easy for me to write inside table.php
I can patch the first part 'cause the number are not ok but I see at the end " // Get the primary keys and ordering values for the selection."
For the second part I can't find exactly the point. The number are very different.
Why is not possible to have the completely table.php changed?
Thanks
bertmert
- comment
- 7 Jun 2016
There's a button "View". With it you can open a second tab with whole code and compare easier or click button "Raw". Then you can copy/paste the whole file or save it via browser.
And sorry, I don't know anything here! ;-) Just wanted to help a bit...
ggppdk
- comment
- 10 Jun 2016
About the table ordering queries,
- i tested on the particular web-site, which has J3.5.1
pici65
- comment
- 10 Jun 2016
@alikon and @ggppdk
please could you post the entire table.php page that must overwrite the actual in the last stable Joomla!
The number of the line of code posted here https://github.com/joomla/joomla-cms/pull/8563/files
are not the same.
The best thing is to post the entire code or a link where is possible to download that php page.
Thanks
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-06-10 13:20:36 |
| Closed_By | ⇒ | pici65 |
csthomas
- comment
- 7 Nov 2016
I prepared a code example at csthomas#6 to ask you whether this is the right way?
That is a good guess, but in most cases we can avoid guessing
(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:
add before return true; (copy paste carefully, not to make syntax error)
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