En un trabajo en conjunto entre el Centro de Comercio Propiedad e Industria, el Programa Local de Asociativismo Productivo (PLAP), INTI, FLACSO, ARPA, CUA.
CAPACITACIÓN
Acceda a toda la información sobre cursos on line y presenciales
FINANCIACIÓN
Acceda a toda la información sobre recursos financieros.
Centro del Comercio Prop. e Ind.
+54 2326 456667/452396
Arellano 286
San Antonio de Areco - (2760)
Provincia de Buenos Aires - Argentina
Ubicación
Desarrollo Puntovista.
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713938006,
"last": 1713938006,
"now": 1713938006
}
},
"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
}
}
}
Fecha y hora
Memoria
Fecha y hora: 4.61 ms / 4.61 ms Memoria: 0.849 MB / 1.06 MB Application: afterLoad
Fecha y hora: 183.67 ms / 188.28 ms Memoria: 4.179 MB / 5.24 MB Application: afterInitialise
Fecha y hora: 7.69 ms / 195.98 ms Memoria: 1.385 MB / 6.63 MB Application: afterRoute
Fecha y hora: 236.32 ms / 432.30 ms Memoria: 0.437 MB / 7.06 MB Application: beforeRenderComponent com_content
Fecha y hora: 3.34 ms / 435.64 ms Memoria: 0.673 MB / 7.74 MB Application: Before JAccess::preloadComponents (all components)
Fecha y hora: 0.81 ms / 436.45 ms Memoria: 0.080 MB / 7.82 MB Application: After JAccess::preloadComponents (all components)
Fecha y hora: 0.02 ms / 436.47 ms Memoria: 0.000 MB / 7.81 MB Application: Before JAccess::preloadPermissions (com_content)
Fecha y hora: 0.78 ms / 437.25 ms Memoria: 0.182 MB / 8.00 MB Application: After JAccess::preloadPermissions (com_content)
Fecha y hora: 0.03 ms / 437.28 ms Memoria: 0.000 MB / 7.99 MB Application: Before JAccess::getAssetRules (id:58 name:com_content.category.9)
Fecha y hora: 0.33 ms / 437.61 ms Memoria: 0.041 MB / 8.03 MB Application: After JAccess::getAssetRules (id:58 name:com_content.category.9)
Fecha y hora: 5.31 ms / 442.92 ms Memoria: 0.405 MB / 8.43 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Fecha y hora: 0.02 ms / 442.94 ms Memoria: 0.003 MB / 8.44 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Fecha y hora: 8.48 ms / 451.41 ms Memoria: 1.015 MB / 9.45 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 0.06 ms / 451.47 ms Memoria: 0.009 MB / 9.46 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 11.40 ms / 462.87 ms Memoria: 1.349 MB / 10.81 MB Application: afterRenderComponent com_content
Fecha y hora: 0.25 ms / 463.12 ms Memoria: 0.008 MB / 10.82 MB Application: afterDispatch
Fecha y hora: 2.69 ms / 465.81 ms Memoria: 0.377 MB / 11.20 MB Application: beforeRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.62 ms / 466.43 ms Memoria: 0.054 MB / 11.25 MB Application: afterRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.01 ms / 466.45 ms Memoria: 0.000 MB / 11.25 MB Application: beforeRenderModule mod_custom (Ubicación)
Fecha y hora: 0.15 ms / 466.60 ms Memoria: 0.007 MB / 11.25 MB Application: afterRenderModule mod_custom (Ubicación)
Fecha y hora: 0.74 ms / 467.34 ms Memoria: 0.000 MB / 11.25 MB Application: beforeRenderModule mod_custom (Capacitación)
Fecha y hora: 0.15 ms / 467.49 ms Memoria: 0.007 MB / 11.26 MB Application: afterRenderModule mod_custom (Capacitación)
Fecha y hora: 0.03 ms / 467.52 ms Memoria: 0.000 MB / 11.25 MB Application: beforeRenderModule mod_custom (Financiación)
Fecha y hora: 0.13 ms / 467.65 ms Memoria: 0.007 MB / 11.26 MB Application: afterRenderModule mod_custom (Financiación)
Fecha y hora: 0.05 ms / 467.71 ms Memoria: 0.000 MB / 11.26 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.67 ms / 468.37 ms Memoria: 0.032 MB / 11.29 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.06 ms / 468.43 ms Memoria: 0.000 MB / 11.28 MB Application: beforeRenderModule mod_menu (Main Menu)
Fecha y hora: 2.20 ms / 470.62 ms Memoria: 0.183 MB / 11.47 MB Application: afterRenderModule mod_menu (Main Menu)
Fecha y hora: 1.27 ms / 471.89 ms Memoria: 0.077 MB / 11.54 MB Application: afterRender
Total de consultas a la base de datos: 404.90 ms
12.19 MB (12,777,952 Bytes)
24 consultas registradas 404.90 ms
- Tiempo de la consulta: 0.20 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.161 MB Filas devueltas: 0
SELECT `data`
FROM `oja8d_session`
WHERE `session_id` = '26ncb7tj2afn1fd73jq2cikmi7'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_session const PRIMARY PRIMARY 766 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.00 ms optimizing 0.00 ms statistics 0.11 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Lo mismo que llamada de la línea de abajo. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:82 10 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:648 9 JSession->_start() JROOT/libraries/joomla/session/session.php:608 8 JSession->start() JROOT/libraries/joomla/session/session.php:486 7 JSession->get() JROOT/libraries/joomla/session/session.php:443 6 JSession->isNew() JROOT/libraries/cms/application/cms.php:825 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.13 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.304 MB Filas devueltas: 0
SELECT `session_id`
FROM `oja8d_session`
WHERE `session_id` = '26ncb7tj2afn1fd73jq2cikmi7'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:827 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 160.40 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.320 MB
INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('26ncb7tj2afn1fd73jq2cikmi7', 1, '1713938006', 0, '', 0)'Explicar' no es posible en la consulta: INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('26ncb7tj2afn1fd73jq2cikmi7', 1, '1713938006', 0, '', 0)Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.01 ms update 0.30 ms Waiting for query cache lock 0.00 ms update 0.01 ms end 0.00 ms query end 159.95 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:216 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:827 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.66 ms Después de la última consulta: 1.67 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.571 MB Filas devueltas: 35
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_extensions ref extension extension 82 const 35 Using index condition Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.01 ms executing 0.00 ms Sending data 0.28 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:452 9 JComponentHelper::{closure}() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:460 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:111 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:593 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.34 ms Después de la última consulta: 1.39 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.859 MB Filas devueltas: 2
SELECT b.id
FROM oja8d_usergroups AS a
LEFT JOIN oja8d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 3 Using where; Using index Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.03 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:978 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:1047 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:293 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.936 MB Filas devueltas: 5
SELECT id, rules
FROM `oja8d_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_viewlevels ALL NULL No pudo usarse una clave de índice NULL NULL 5 Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.00 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1486 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:1064 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:293 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.65 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 3.975 MB Filas devueltas: 63
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM oja8d_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_extensions ref extension extension 82 const 112 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.36 ms Sending data 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:311 9 JPluginHelper::{closure}() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/plugin/helper.php:316 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.55 ms Después de la última consulta: 8.32 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 5.504 MB Filas devueltas: 7
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 oja8d_menu AS m
LEFT JOIN oja8d_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 range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 8 Using index condition; Using where; Usando 'filesort' 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.m.component_id 1 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.11 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.04 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:88 17 JMenuSite->{closure}() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 15 JCacheControllerCallback->get() JROOT/libraries/cms/menu/site.php:96 14 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 13 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 12 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:129 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:443 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:59 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:198 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:548 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:402 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1141 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:795 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.35 ms Después de la última consulta: 6.22 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.676 MB Filas devueltas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 14 JDatabaseDriver->loadObject() JROOT/libraries/cms/library/helper.php:166 13 JLibraryHelper::{closure}() Lo mismo que llamada de la línea de abajo. 12 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:174 10 JLibraryHelper::loadLibrary() JROOT/libraries/cms/library/helper.php:42 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:89 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:270 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 231.95 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 6.678 MB
UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"47b33e0e92077bd4531068fe3df29792\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `oja8d_extensions` SET `params` = '{\"mediaversion\":\"47b33e0e92077bd4531068fe3df29792\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.03 ms Updating 48.48 ms end 0.01 ms Waiting for query cache lock 0.18 ms end 0.03 ms query end 183.05 ms closing tables 0.01 ms freeing items 0.02 ms updating status 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:116 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:321 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:280 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.33 ms Después de la última consulta: 1.69 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 6.943 MB Filas devueltas: 1
SELECT *
FROM oja8d_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_languages ALL NULL No pudo usarse una clave de índice NULL NULL 2 Using where; Usando 'filesort' Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.12 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.03 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:148 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:327 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 6.974 MB Filas devueltas: 3
SELECT id, home, template, s.params
FROM oja8d_template_styles as s
LEFT JOIN oja8d_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 e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template No pudo usarse una clave de índice NULL NULL 5 Using where; Using join buffer (flat, BNL join) Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 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.11 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.02 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:485 4 JApplicationSite->getTemplate() JROOT/libraries/cms/application/site.php:165 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.57 ms Después de la última consulta: 4.35 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 7.742 MB Filas devueltas: 30
SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`
WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_assets index_merge idx_asset_name,idx_parent_id idx_asset_name,idx_parent_id 202,4 NULL 33 Using sort_union(idx_asset_name,idx_parent_id); Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.04 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.01 ms executing 0.00 ms Sending data 0.25 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:427 18 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:211 17 JAccess::preload() JROOT/libraries/joomla/access/access.php:529 16 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 15 JAccess::check() JROOT/libraries/joomla/user/user.php:393 14 JUser->authorise() JROOT/plugins/system/contentmulticategories/classes/category35.php:137 13 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:434 12 JModelLegacy->getState() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.43 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 7.815 MB Filas devueltas: 102
SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_assets ALL idx_asset_name,idx_parent_id No pudo usarse una clave de índice NULL NULL 212 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.02 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.22 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:357 18 JAccess::preloadPermissions() JROOT/libraries/joomla/access/access.php:224 17 JAccess::preload() JROOT/libraries/joomla/access/access.php:538 16 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 15 JAccess::check() JROOT/libraries/joomla/user/user.php:393 14 JUser->authorise() JROOT/plugins/system/contentmulticategories/classes/category35.php:137 13 ContentModelCategory->populateState() JROOT/libraries/legacy/model/legacy.php:434 12 JModelLegacy->getState() JROOT/libraries/legacy/view/category.php:115 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 2.31 ms Después de la última consulta: 1.49 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 8.148 MB Filas devueltas: 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,COUNT(i.`id`) AS numitems
FROM oja8d_categories as c
LEFT JOIN oja8d_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `oja8d_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=9
GROUP BY 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
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 Using temporary; Usando 'filesort' 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right No pudo usarse una clave de índice NULL NULL 17 Using where 1 SIMPLE i ref idx_state,idx_catid idx_catid 4 centrodecomerciosada_org_ar.c.id 11 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.04 ms optimizing 0.02 ms statistics 0.27 ms preparing 0.02 ms executing 0.00 ms Creating tmp table 0.17 ms Copying to tmp table 1.46 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 16 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 15 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 14 JCategories->get() JROOT/plugins/system/contentmulticategories/classes/category35.php:354 13 ContentModelCategory->getCategory() JROOT/libraries/legacy/view/legacy.php:422 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:121 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.25 ms Después de la última consulta: 1.17 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 8.358 MB Filas devueltas: 53
SELECT `article_id`
FROM `oja8d_contentmulticategories_categories`
WHERE `category_id` = '9'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_contentmulticategories_categories ref category_id category_id 4 const 58 Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 19 JDatabaseDriver->loadColumn() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:380 18 plgSystemContentmulticategories->getMultiCatsArticles() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:280 17 plgSystemContentmulticategories->onGetContentItems() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/plugins/system/contentmulticategories/classes/category35.php:248 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:422 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:143 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.23 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 8.394 MB Filas devueltas: 71
SELECT `id`
FROM `oja8d_content`
WHERE `catid` = '9'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_content ref idx_catid idx_catid 4 const 71 Using index Status Duration starting 0.02 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 19 JDatabaseDriver->loadColumn() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:391 18 plgSystemContentmulticategories->getMultiCatsArticles() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:280 17 plgSystemContentmulticategories->onGetContentItems() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/plugins/system/contentmulticategories/classes/category35.php:248 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:422 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:143 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.55 ms Después de la última consulta: 0.43 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 8.437 MB Filas devueltas: 1
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM oja8d_content AS a
LEFT JOIN oja8d_categories AS c
ON c.id = a.catid
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_by
LEFT JOIN oja8d_users AS uam
ON uam.id = a.modified_by
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oja8d_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.id IN (17,18,20,21,22,23,24,25,26,27,28,29,30,31,33,35,36,37,38,39,40,41,42,43,44,45,46,48,51,53,55,56,57,58,59,60,61,62,64,65,67,68,71,72,73,74,75,76,77,78,79,80,81,2,6,7,8,12,13,14,16,19,34,50,63,66,84,85,86,87,89)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-24 05:53:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 05:53:26')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 64, 14id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref PRIMARY,idx_access,idx_state,idx_catid idx_state 1 const 80 Using index condition; Using where; Using temporary; Usando 'filesort' 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 centrodecomerciosada_org_ar.a.catid 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.id 1 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.04 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.00 ms Creating tmp table 0.13 ms Copying to tmp table 0.76 ms Sorting result 0.06 ms Sending data 0.07 ms end 0.00 ms removing tmp table 0.03 ms end 0.00 ms query end 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 16 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 15 JModelList->getItems() JROOT/components/com_content/models/articles.php:536 14 ContentModelArticles->getItems() JROOT/plugins/system/contentmulticategories/classes/category35.php:253 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:422 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:143 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.54 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 8.622 MB Filas devueltas: 1
SELECT COUNT(*)
FROM oja8d_content AS a
LEFT JOIN oja8d_categories AS c
ON c.id = a.catid
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_by
LEFT JOIN oja8d_users AS uam
ON uam.id = a.modified_by
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oja8d_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.id IN (17,18,20,21,22,23,24,25,26,27,28,29,30,31,33,35,36,37,38,39,40,41,42,43,44,45,46,48,51,53,55,56,57,58,59,60,61,62,64,65,67,68,71,72,73,74,75,76,77,78,79,80,81,2,6,7,8,12,13,14,16,19,34,50,63,66,84,85,86,87,89)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-24 05:53:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-24 05:53:26')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref PRIMARY,idx_access,idx_state,idx_catid idx_state 1 const 80 Using index condition; Using where 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 centrodecomerciosada_org_ar.a.catid 1 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.20 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.02 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.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 17 JDatabaseDriver->loadResult() JROOT/libraries/legacy/model/legacy.php:334 16 JModelLegacy->_getListCount() JROOT/libraries/legacy/model/list.php:281 15 JModelList->getTotal() JROOT/libraries/legacy/model/list.php:231 14 JModelList->getPagination() JROOT/plugins/system/contentmulticategories/classes/category35.php:265 13 ContentModelCategory->getItems() JROOT/libraries/legacy/view/legacy.php:422 12 JViewLegacy->get() JROOT/libraries/legacy/view/category.php:143 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.40 ms Después de la última consulta: 1.07 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 8.790 MB Filas devueltas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `oja8d_contentitem_tag_map` AS m
INNER JOIN `oja8d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type No pudo usarse una clave de índice NULL NULL 22 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 centrodecomerciosada_org_ar.m.tag_id 1 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 13 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:450 12 JHelperTags->getItemTags() JROOT/libraries/legacy/view/category.php:225 11 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.35 ms Después de la última consulta: 3.23 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 9.402 MB Filas devueltas: 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 oja8d_categories as c
LEFT JOIN oja8d_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,5)
AND c.published = 1
AND s.id=9
GROUP BY 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
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 Usando 'filesort' 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right No pudo usarse una clave de índice NULL NULL 17 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 21 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 20 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 19 JCategories->get() JROOT/administrator/components/com_fields/models/fields.php:197 18 FieldsModelFields->getListQuery() JROOT/libraries/legacy/model/list.php:132 17 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:186 16 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Lo mismo que llamada de la línea de abajo. 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_content/views/category/view.html.php:108 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.67 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 9.459 MB Filas devueltas: 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 oja8d_fields AS a
LEFT JOIN `oja8d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN oja8d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN oja8d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN oja8d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `oja8d_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.orderingid 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 temporary; Usando 'filesort' 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 centrodecomerciosada_org_ar.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.id 1 Using where; Using index Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.02 ms executing 0.00 ms Creating tmp table 0.12 ms Copying to tmp table 0.01 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 18 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 16 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Lo mismo que llamada de la línea de abajo. 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_content/views/category/view.html.php:108 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.60 ms Después de la última consulta: 6.06 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 10.521 MB Filas devueltas: 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 oja8d_fields AS a
LEFT JOIN `oja8d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN oja8d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN oja8d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN oja8d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `oja8d_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.orderingid 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 temporary; Usando 'filesort' 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 centrodecomerciosada_org_ar.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.id 1 Using where; Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms executing 0.00 ms Creating tmp table 0.15 ms Copying to tmp table 0.02 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.03 ms end 0.00 ms query end 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 22 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 20 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 18 PlgSystemFields->onContentPrepare() Lo mismo que llamada de la línea de abajo. 17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/legacy/view/legacy.php:694 13 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229 12 JViewLegacy->display() JROOT/libraries/legacy/view/category.php:241 11 JViewCategory->display() JROOT/components/com_content/views/category/view.html.php:260 10 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.86 ms Después de la última consulta: 5.78 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.171 MB Filas devueltas: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM oja8d_modules AS m
LEFT JOIN oja8d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN oja8d_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 <= '2024-04-24 05:53:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-24 05:53:26')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 103 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 range PRIMARY,published,newsfeeds published 5 NULL 12 Using index condition; Using where; Usando 'filesort' 1 SIMPLE mm ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 centrodecomerciosada_org_ar.m.module,const 1 Using index condition; Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.25 ms Sending data 0.20 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 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.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() Lo mismo que llamada de la línea de abajo. 14 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 13 JCacheControllerCallback->get() JROOT/libraries/cms/module/helper.php:424 12 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:360 11 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 10 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:576 9 JDocumentHtml->countModules() JROOT/templates/ja_simpli/helper.php:96 8 SimpliHelper->init() JROOT/templates/ja_simpli/index.php:10 7 require JROOT/templates/ja_simpli/index.php JROOT/libraries/joomla/document/html.php:653 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:715 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:530 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1098 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49
21 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
2 × 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 oja8d_fields AS a
LEFT JOIN `oja8d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN oja8d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN oja8d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN oja8d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `oja8d_fields_categories` AS fc
ON fc.field_id = a.id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`1 × SELECT COUNT(*)
FROM oja8d_content AS a
LEFT JOIN oja8d_categories AS c
ON c.id = a.catid
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_by
LEFT JOIN oja8d_users AS uam
ON uam.id = a.modified_by
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oja8d_content_rating AS v
ON a.id = v.content_id1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM oja8d_content AS a
LEFT JOIN oja8d_categories AS c
ON c.id = a.catid
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_by
LEFT JOIN oja8d_users AS uam
ON uam.id = a.modified_by
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oja8d_content_rating AS v
ON a.id = v.content_id1 × SELECT `id`
FROM `oja8d_content`1 × SELECT `m`.`tag_id`,`t`.*
FROM `oja8d_contentitem_tag_map` AS m
INNER JOIN `oja8d_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × 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 oja8d_categories as c
LEFT JOIN oja8d_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM oja8d_modules AS m
LEFT JOIN oja8d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN oja8d_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `session_id`
FROM `oja8d_session`1 × SELECT `article_id`
FROM `oja8d_contentmulticategories_categories`1 × 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,COUNT(i.`id`) AS numitems
FROM oja8d_categories as c
LEFT JOIN oja8d_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `oja8d_content` AS i
ON i.`catid` = c.id
AND i.state = 11 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM oja8d_extensions1 × SELECT id, rules
FROM `oja8d_viewlevels1 × 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 oja8d_menu AS m
LEFT JOIN oja8d_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM oja8d_languages1 × SELECT `data`
FROM `oja8d_session`1 × SELECT id, home, template, s.params
FROM oja8d_template_styles as s
LEFT JOIN oja8d_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT b.id
FROM oja8d_usergroups AS a
LEFT JOIN oja8d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
OTRAS tablas:
1 × UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"47b33e0e92077bd4531068fe3df29792\"}'1 × INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('26ncb7tj2afn1fd73jq2cikmi7', 1, '1713938006', 0, '', 0