Posts @IPDRS
Paraguay
SOMOS PARTE DE:
CONTACTO:
Av. 20 de octubre # 2396, casi esq. Belisario Salinas
Edif. María Haydee. Piso 12
Edif. María Haydee. Piso 12
Telf. 591-2-2115952
Casilla Nº 9052
Casilla Nº 9052
La Paz – Bolivia
NIT: 169994029
NIT: 169994029
INTRANET
CONÉCTATE CON NOSOTROS
Síguenos y mantente en contacto a travéz de las redes sociales
2012 - 2026 Sudamérica Rural | Todos los derechos reservados
Diseñado y administrado por: Bolivia Rural S.R.L.
Diseñado y administrado por: Bolivia Rural S.R.L.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1788142375,
"last": 1788142375,
"now": 1788142375
},
"token": "WoJwQCXyDxr0zkkvLu9CE3DWCVSR97LO"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 2.15 ms / 2.15 ms Memory: 0.742 MB / 0.95 MB Application: afterLoad
Time: 31.65 ms / 33.80 ms Memory: 1.410 MB / 2.36 MB Application: afterInitialise
Time: 8.70 ms / 42.50 ms Memory: 0.617 MB / 2.98 MB Application: afterRoute
Time: 7.73 ms / 50.22 ms Memory: 0.146 MB / 3.13 MB Application: beforeRenderComponent com_tags
Time: 90.91 ms / 141.13 ms Memory: 1.133 MB / 4.26 MB Application: Before Access::preloadComponents (all components)
Time: 2.28 ms / 143.42 ms Memory: 0.127 MB / 4.39 MB Application: After Access::preloadComponents (all components)
Time: 0.08 ms / 143.50 ms Memory: 0.000 MB / 4.38 MB Application: Before Access::getAssetRules (id:35 name:com_tags)
Time: 0.24 ms / 143.74 ms Memory: 0.019 MB / 4.40 MB Application: After Access::getAssetRules (id:35 name:com_tags)
Time: 11.16 ms / 154.90 ms Memory: 0.461 MB / 4.86 MB Application: afterRenderComponent com_tags
Time: 0.34 ms / 155.23 ms Memory: 0.007 MB / 4.87 MB Application: afterDispatch
Time: 3.57 ms / 158.80 ms Memory: 0.197 MB / 5.06 MB Application: beforeRenderModule mod_custom (m2017 - Sidebar)
Time: 0.37 ms / 159.17 ms Memory: 0.011 MB / 5.07 MB Application: afterRenderModule mod_custom (m2017 - Sidebar)
Time: 0.05 ms / 159.22 ms Memory: 0.000 MB / 5.07 MB Application: beforeRenderModule mod_flexi_customcode (m2017 - FB)
Time: 1.50 ms / 160.72 ms Memory: 0.021 MB / 5.09 MB Application: afterRenderModule mod_flexi_customcode (m2017 - FB)
Time: 0.09 ms / 160.81 ms Memory: 0.000 MB / 5.09 MB Application: beforeRenderModule mod_search (m2017 - Buscador)
Time: 0.53 ms / 161.34 ms Memory: 0.023 MB / 5.11 MB Application: afterRenderModule mod_search (m2017 - Buscador)
Time: 0.07 ms / 161.42 ms Memory: 0.000 MB / 5.10 MB Application: beforeRenderModule mod_menu (m2017 - Menu)
Time: 5.88 ms / 167.30 ms Memory: 0.490 MB / 5.59 MB Application: afterRenderModule mod_menu (m2017 - Menu)
Time: 7.19 ms / 174.49 ms Memory: 0.671 MB / 6.26 MB Application: afterRender
Database queries total: 109.36 ms
6.89 MB (7,220,344 Bytes)
27 Queries Logged 109.36 ms
- Query Time: 1.32 ms Query memory: 0.008 MB Memory before query: 1.468 MB
DELETE
FROM `jo362_session`
WHERE `time` < '1788141475'EXPLAIN not possible on query: DELETE FROM `jo362_session` WHERE `time` < '1788141475'Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.02 ms init for update 0.07 ms Updating 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Application/CMSApplication.php:824 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:49 - Query Time: 1.31 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 1.491 MB Rows returned: 1
SELECT `data`
FROM `jo362_session`
WHERE `session_id` = 's1u6rp0tnv8oso02k89bjluvr7'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_session const PRIMARY PRIMARY 766 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:831 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:133 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:415 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:49 - Query Time: 1.62 ms After last query: 0.70 ms Query memory: 0.022 MB Memory before query: 1.613 MB Rows returned: 102
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 300 Using where Status Duration Starting 0.05 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 init 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.23 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:422 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:430 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:496 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:596 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.27 ms After last query: 0.67 ms Query memory: 0.015 MB Memory before query: 1.713 MB Rows returned: 5
SELECT id, rules
FROM `jo362_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.33 ms After last query: 0.14 ms Query memory: 0.015 MB Memory before query: 1.737 MB Rows returned: 1
SELECT b.id
FROM jo362_usergroups AS a
LEFT JOIN jo362_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:310 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.72 ms After last query: 0.20 ms Query memory: 0.021 MB Memory before query: 1.775 MB Rows returned: 74
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jo362_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 300 Using where; Using filesort Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.30 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:348 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 3.22 ms After last query: 9.31 ms Query memory: 0.036 MB Memory before query: 2.439 MB Rows returned: 51
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jo362_menu AS m
LEFT JOIN jo362_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 62 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.m.component_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.47 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:446 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:551 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1146 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.44 ms After last query: 3.47 ms Query memory: 0.017 MB Memory before query: 2.960 MB Rows returned: 1
SELECT id
FROM `jo362_tags`
WHERE `alias` = 'paraguay'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_tags ref idx_alias idx_alias 402 const 1 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 11 JDatabaseDriver->loadResult() JROOT/components/com_tags/router.php:179 10 TagsRouter->fixSegment() JROOT/components/com_tags/router.php:147 9 TagsRouter->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1147 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.51 ms After last query: 0.43 ms Query memory: 0.020 MB Memory before query: 3.009 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.46 ms After last query: 0.29 ms Query memory: 0.013 MB Memory before query: 3.011 MB
UPDATE `jo362_extensions`
SET `params` = '{\"mediaversion\":\"ec4a30d92c6ca7832ebdd68f4100d3b2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `jo362_extensions` SET `params` = '{\"mediaversion\":\"ec4a30d92c6ca7832ebdd68f4100d3b2\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init for update 0.09 ms Updating 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1116 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.40 ms After last query: 0.51 ms Query memory: 0.014 MB Memory before query: 3.089 MB Rows returned: 3
SELECT *
FROM jo362_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.00 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.70 ms After last query: 0.39 ms Query memory: 0.010 MB Memory before query: 3.114 MB Rows returned: 5
SELECT id, home, template, s.params
FROM jo362_template_styles as s
LEFT JOIN jo362_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 7 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 sudmerik_samerik.s.template,const 1 Using index condition; Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.08 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.60 ms After last query: 1.94 ms Query memory: 0.029 MB Memory before query: 3.356 MB Rows returned: 30
SELECT *
FROM `jo362_content_types`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_content_types ALL NULL NO INDEX KEY COULD BE USED NULL NULL 30 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.19 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 18 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Helper/TagsHelper.php:794 17 Joomla\CMS\Helper\TagsHelper::getTypes() JROOT/libraries/src/Helper/TagsHelper.php:628 16 Joomla\CMS\Helper\TagsHelper->getTagItemsQuery() JROOT/components/com_tags/models/tag.php:148 15 TagsModelTag->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 14 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:51 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 58.67 ms After last query: 0.30 ms Query memory: 0.028 MB Memory before query: 3.383 MB Rows returned: 10
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM jo362_contentitem_tag_map AS m
INNER JOIN jo362_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2026-08-31 02:12:55')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2026-08-31 02:12:55')
INNER JOIN jo362_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN jo362_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN jo362_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (343)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_ruralistas.ruralista','com_dialogues.dilogo','com_explorations.exploracin','com_links_pages.enlace','com_countries.pas','com_iso_languages.idiomaiso6391','com_activities.actividad','com_on_paper.enpapel','com_interv1ews.entrevista','com_gallery_ipdrs.concursante','com_opinion_articles.artculodeopinin','com_printed.impreso','com_multimedia.multimedia','com_landvoc.landvoc','com_license.licencia','com_publication_type.tipodepublicacin','com_memorias.memorias')
AND c.core_access IN (0,1)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASC
LIMIT 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 95 Using where; Using temporary; Using filesort 1 SIMPLE c eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 sudmerik_samerik.m.core_content_id 1 Using where 1 SIMPLE tc eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.c.core_catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.c.core_created_user_id 1 Using where 1 SIMPLE ct ref idx_alias idx_alias 402 sudmerik_samerik.m.type_alias 1 Using where Status Duration Starting 0.21 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.13 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.04 ms Creating tmp table 0.08 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 56.32 ms Creating sort index 0.29 ms Removing tmp table 0.12 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_tags/models/tag.php:86 12 TagsModelTag->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:51 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.75 ms After last query: 0.64 ms Query memory: 0.030 MB Memory before query: 3.543 MB Rows returned: 34
SHOW FULL COLUMNS
FROM `jo362_tags`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jo362_tags`Status Duration Starting 0.06 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.21 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.09 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.06 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_tags/tables/tag.php:29 14 TagsTableTag->__construct() JROOT/libraries/src/Table/Table.php:312 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_tags/models/tag.php:271 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:52 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.47 ms After last query: 1.13 ms Query memory: 0.028 MB Memory before query: 3.676 MB Rows returned: 1Duplicate queries: #19
SELECT *
FROM jo362_tags
WHERE `id` = '343'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_tags const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.08 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 13 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:280 12 TagsModelTag->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:52 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 7.51 ms After last query: 0.50 ms Query memory: 0.053 MB Memory before query: 3.731 MB Rows returned: 94
SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM jo362_contentitem_tag_map AS m
INNER JOIN jo362_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2026-08-31 02:12:55')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2026-08-31 02:12:55')
INNER JOIN jo362_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN jo362_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN jo362_users AS ua
ON ua.id = c.core_created_user_id
WHERE m.tag_id IN (343)
AND (c.core_catid = 0 OR tc.published = 1)
AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_ruralistas.ruralista','com_dialogues.dilogo','com_explorations.exploracin','com_links_pages.enlace','com_countries.pas','com_iso_languages.idiomaiso6391','com_activities.actividad','com_on_paper.enpapel','com_interv1ews.entrevista','com_gallery_ipdrs.concursante','com_opinion_articles.artculodeopinin','com_printed.impreso','com_multimedia.multimedia','com_landvoc.landvoc','com_license.licencia','com_publication_type.tipodepublicacin','com_memorias.memorias')
AND c.core_access IN (0,1)
GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
ORDER BY MAX(`c`.`core_title`) ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_tag_type,idx_core_content_id idx_tag_type 4 const 95 Using where; Using temporary; Using filesort 1 SIMPLE c eq_ref PRIMARY,tag_idx,idx_access,idx_content_type PRIMARY 4 sudmerik_samerik.m.core_content_id 1 Using where 1 SIMPLE tc eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.c.core_catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.c.core_created_user_id 1 Using where 1 SIMPLE ct ref idx_alias idx_alias 402 sudmerik_samerik.m.type_alias 1 Using where Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.12 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.04 ms Creating tmp table 0.07 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 3.03 ms Creating sort index 1.74 ms Removing tmp table 0.12 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.03 ms Updating status 0.01 ms Reset for next command 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:348 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_tags/views/tag/view.html.php:55 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.78 ms After last query: 1.50 ms Query memory: 0.032 MB Memory before query: 3.953 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_tags.tag'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sudmerik_samerik.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.a.group_id 1 Using where Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.05 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_tags/views/tag/view.html.php:99 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.53 ms After last query: 2.94 ms Query memory: 0.027 MB Memory before query: 4.029 MB Rows returned: 1Duplicate queries: #16
SELECT *
FROM jo362_tags
WHERE `id` = '343'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_tags const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 13 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:730 12 Joomla\CMS\Table\Table->load() JROOT/components/com_tags/models/tag.php:335 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:197 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 2.32 ms After last query: 0.28 ms Query memory: 0.016 MB Memory before query: 4.044 MB
UPDATE jo362_tags
SET `hits` = (`hits` + 1)
WHERE `id` = '343'EXPLAIN not possible on query: UPDATE jo362_tags SET `hits` = (`hits` + 1) WHERE `id` = '343'Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init for update 0.06 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.97 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1241 12 Joomla\CMS\Table\Table->hit() JROOT/components/com_tags/models/tag.php:336 11 TagsModelTag->hit() JROOT/components/com_tags/views/tag/view.html.php:197 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 2.25 ms After last query: 1.07 ms Query memory: 0.040 MB Memory before query: 4.109 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_tag.tag'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 sudmerik_samerik.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sudmerik_samerik.a.group_id 1 Using where Status Duration Starting 0.46 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 26 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 25 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 24 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 23 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 22 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 21 PlgSystemFields->onContentPrepare() Same as call in the line below. 20 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 19 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 18 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41 17 JHtmlContent::prepare() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/components/com_tags/views/tag/tmpl/default.php:24 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.88 ms After last query: 2.15 ms Query memory: 0.032 MB Memory before query: 4.271 MB Rows returned: 53
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jo362_assets`
WHERE `name` IN ('root.1','com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_search','com_templates','com_content','com_config','com_redirect','com_users','com_finder','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_fields','com_activities','com_jcomments','com_ruralistas','com_dialogues','com_explorations','com_acymailing','com_links_pages','com_countries','com_iso_languages','com_on_paper','com_interv1ews','com_gallery_ipdrs','com_opinion_articles','com_chronoforms','com_printed','com_multimedia','com_landvoc','com_license','com_publication_type','com_memorias','com_associations','com_calendar')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_assets range idx_asset_name idx_asset_name 202 NULL 54 Using index condition Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.32 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 20 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 19 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 18 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 17 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 16 Joomla\CMS\User\User->authorise() JROOT/components/com_tags/views/tag/tmpl/default_items.php:22 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:51 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.91 ms After last query: 1.16 ms Query memory: 0.045 MB Memory before query: 4.437 MB Rows returned: 16
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=4
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 98 Using where; Using filesort Status Duration Starting 0.15 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.16 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 16 Joomla\CMS\Router\Route::_() JROOT/components/com_tags/views/tag/tmpl/default_items.php:87 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:51 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.84 ms After last query: 1.19 ms Query memory: 0.043 MB Memory before query: 4.619 MB Rows returned: 6
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=19
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 98 Using where; Using filesort Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.13 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.11 ms Reset for next command 0.01 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 16 Joomla\CMS\Router\Route::_() JROOT/components/com_tags/views/tag/tmpl/default_items.php:87 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:51 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.85 ms After last query: 1.36 ms Query memory: 0.046 MB Memory before query: 4.699 MB Rows returned: 18
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=36
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 98 Using where; Using filesort Status Duration Starting 0.14 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 27 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:305 26 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:186 25 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 24 ContentRouter->getCategorySegment() Same as call in the line below. 23 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 22 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 21 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 20 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:669 19 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 18 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 17 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 16 Joomla\CMS\Router\Route::_() JROOT/components/com_tags/views/tag/tmpl/default_items.php:87 15 include JROOT/components/com_tags/views/tag/tmpl/default_items.php JROOT/libraries/src/MVC/View/HtmlView.php:695 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_tags/views/tag/tmpl/default.php:51 13 include JROOT/components/com_tags/views/tag/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:695 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_tags/views/tag/view.html.php:201 10 TagsViewTag->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_tags/controller.php:52 8 TagsController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_tags/tags.php:15 6 require_once JROOT/components/com_tags/tags.php JROOT/libraries/src/Component/ComponentHelper.php:381 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 2.07 ms After last query: 3.26 ms Query memory: 0.023 MB Memory before query: 4.923 MB Rows returned: 19
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jo362_modules AS m
LEFT JOIN jo362_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jo362_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 <= '2026-08-31 02:12:55')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-31 02:12:55')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 64 Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 sudmerik_samerik.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 sudmerik_samerik.m.module,const 1 Using index condition; Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.08 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.37 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 14 JDatabaseDriver->loadObjectList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 12 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 11 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 10 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 9 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 8 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/ipdrs21/index.php:181 7 require JROOT/templates/ipdrs21/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1103 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52 - Query Time: 1.65 ms After last query: 11.56 ms Query memory: 0.021 MB Memory before query: 6.102 MB Rows returned: 134
SELECT *
FROM jo362_acymailing_configid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE jo362_acymailing_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 134 Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.12 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.03 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 11 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:461 10 acymailing_config() JROOT/administrator/components/com_acymailing/helpers/helper.php:1183 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:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1123 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:273 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:52
21 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jo362_categories as c
LEFT JOIN jo362_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jo362_extensions`2 × SELECT *
FROM jo362_tags2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM jo362_contentitem_tag_map AS m
INNER JOIN jo362_ucm_content AS c
ON m.type_alias = c.core_type_alias
AND m.core_content_id = c.core_content_id
AND c.core_state IN (1)
AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2026-08-31 02:12:55')
AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2026-08-31 02:12:55')
INNER JOIN jo362_content_types AS ct
ON ct.type_alias = m.type_alias
LEFT JOIN jo362_categories AS tc
ON tc.id = c.core_catid
LEFT JOIN jo362_users AS ua
ON ua.id = c.core_created_user_id2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM jo362_fields AS a
LEFT JOIN `jo362_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jo362_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jo362_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jo362_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jo362_fields_groups AS g
ON g.id = a.group_id1 × SELECT *
FROM `jo362_content_types1 × SELECT *
FROM jo362_acymailing_confi1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jo362_modules AS m
LEFT JOIN jo362_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jo362_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jo362_assets`1 × SELECT id, home, template, s.params
FROM jo362_template_styles as s
LEFT JOIN jo362_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT b.id
FROM jo362_usergroups AS a
LEFT JOIN jo362_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `jo362_viewlevels1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jo362_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jo362_menu AS m
LEFT JOIN jo362_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM jo362_languages1 × SELECT id
FROM `jo362_tags`1 × SELECT `data`
FROM `jo362_session`
OTHER Tables:
1 × UPDATE jo362_tags
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `jo362_tags1 × UPDATE `jo362_extensions`
SET `params` = '{\"mediaversion\":\"ec4a30d92c6ca7832ebdd68f4100d3b2\"}'1 × DELETE
FROM `jo362_session`