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.
Cursos On line
Academia PyME
Es un programa de capacitación virtual abierto y gratuito, orientado a todas las personas que trabajan en Micro, Pequeñas y Medianas Empresas.
Academia Argentina Emprende
Es una plataforma con capacitaciones online brindadas por especialistas en ventas, finanzas, marketing, redes sociales y comunicación.
CAME Educativa
Más de 60 cursos, seminarios y capacitaciones online con certificados otorgados por la Cámara Argentina de la Mediana Empresa.
Capacitación continua CAC
Ofrece herramientas para desempeñarse en el ámbito laboral. Brindar a profesionales de empresas asociadas y a la comunidad en general, alternativas de formación en temáticas comerciales y de servicios
Campus Virtual del Ministerio de Turismo
Para potenciar tus conocimientos, especializarte, seguir creciendo y generar nuevas oportunidades, continúa tu formación a través de las propuestas formativas del Campus Mintur.
Cursos Presenciales
CAME Educativa
PROGRAMA DE CAPACITACIÓN PROFESIONAL DE CAME, para fortalecer la competitividad del recurso humano empleado en PYMES de todo el país.
Cursos Presenciales CAC
Acciones de formación de calidad que permiten a quienes participen estar permanentemente actualizados. Cursos presenciales en CABA
Cámara Argentina de Comercio Electrónico
Cursos, desayunos de trabajo, talleres, conferencias y charlas en todo el país
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": 1738781768,
"last": 1738781768,
"now": 1738781768
}
},
"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: 2.58 ms / 2.58 ms Memoria: 0.057 MB / 0.40 MB Application: afterLoad
Fecha y hora: 23.62 ms / 26.20 ms Memoria: 0.830 MB / 1.23 MB Application: afterInitialise
Fecha y hora: 6.29 ms / 32.50 ms Memoria: 0.230 MB / 1.46 MB Application: afterRoute
Fecha y hora: 6.33 ms / 38.82 ms Memoria: 0.183 MB / 1.65 MB Application: beforeRenderComponent com_content
Fecha y hora: 4.73 ms / 43.55 ms Memoria: 0.166 MB / 1.81 MB Application: Before JAccess::preloadComponents (all components)
Fecha y hora: 1.67 ms / 45.22 ms Memoria: 0.051 MB / 1.86 MB Application: After JAccess::preloadComponents (all components)
Fecha y hora: 0.05 ms / 45.27 ms Memoria: 0.000 MB / 1.86 MB Application: Before JAccess::preloadPermissions (com_content)
Fecha y hora: 1.73 ms / 46.99 ms Memoria: 0.120 MB / 1.98 MB Application: After JAccess::preloadPermissions (com_content)
Fecha y hora: 0.08 ms / 47.07 ms Memoria: 0.000 MB / 1.97 MB Application: Before JAccess::getAssetRules (id:62 name:com_content.category.11)
Fecha y hora: 0.35 ms / 47.42 ms Memoria: 0.072 MB / 2.05 MB Application: After JAccess::getAssetRules (id:62 name:com_content.category.11)
Fecha y hora: 8.56 ms / 55.98 ms Memoria: 0.190 MB / 2.24 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Fecha y hora: 0.05 ms / 56.02 ms Memoria: 0.002 MB / 2.24 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Fecha y hora: 10.86 ms / 66.89 ms Memoria: 0.226 MB / 2.47 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 0.17 ms / 67.06 ms Memoria: 0.007 MB / 2.47 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 18.14 ms / 85.21 ms Memoria: 0.207 MB / 2.68 MB Application: afterRenderComponent com_content
Fecha y hora: 0.90 ms / 86.11 ms Memoria: 0.005 MB / 2.68 MB Application: afterDispatch
Fecha y hora: 2.89 ms / 89.00 ms Memoria: 0.060 MB / 2.74 MB Application: beforeRenderModule mod_custom (Cursos On line)
Fecha y hora: 0.97 ms / 89.96 ms Memoria: 0.007 MB / 2.75 MB Application: afterRenderModule mod_custom (Cursos On line)
Fecha y hora: 0.76 ms / 90.73 ms Memoria: 0.000 MB / 2.75 MB Application: beforeRenderModule mod_custom (Cursos Presenciales)
Fecha y hora: 0.27 ms / 91.00 ms Memoria: 0.003 MB / 2.75 MB Application: afterRenderModule mod_custom (Cursos Presenciales)
Fecha y hora: 0.67 ms / 91.67 ms Memoria: 0.000 MB / 2.75 MB Application: beforeRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.25 ms / 91.92 ms Memoria: 0.003 MB / 2.75 MB Application: afterRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.04 ms / 91.96 ms Memoria: 0.000 MB / 2.75 MB Application: beforeRenderModule mod_custom (Ubicación)
Fecha y hora: 0.23 ms / 92.18 ms Memoria: 0.003 MB / 2.76 MB Application: afterRenderModule mod_custom (Ubicación)
Fecha y hora: 1.50 ms / 93.68 ms Memoria: 0.002 MB / 2.76 MB Application: beforeRenderModule mod_custom (Capacitación)
Fecha y hora: 0.24 ms / 93.92 ms Memoria: 0.004 MB / 2.76 MB Application: afterRenderModule mod_custom (Capacitación)
Fecha y hora: 0.07 ms / 94.00 ms Memoria: 0.000 MB / 2.76 MB Application: beforeRenderModule mod_custom (Financiación)
Fecha y hora: 0.21 ms / 94.21 ms Memoria: 0.003 MB / 2.77 MB Application: afterRenderModule mod_custom (Financiación)
Fecha y hora: 0.13 ms / 94.33 ms Memoria: 0.000 MB / 2.77 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 1.54 ms / 95.88 ms Memoria: 0.009 MB / 2.78 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.12 ms / 96.00 ms Memoria: 0.000 MB / 2.77 MB Application: beforeRenderModule mod_menu (Main Menu)
Fecha y hora: 3.16 ms / 99.16 ms Memoria: 0.047 MB / 2.82 MB Application: afterRenderModule mod_menu (Main Menu)
Fecha y hora: 5.27 ms / 104.43 ms Memoria: 0.039 MB / 2.86 MB Application: afterRender
Total de consultas a la base de datos: 19.39 ms
3.30 MB (3,457,680 Bytes)
24 consultas registradas 19.39 ms
- Tiempo de la consulta: 0.42 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 0.730 MB Filas devueltas: 0
SELECT `data`
FROM `oja8d_session`
WHERE `session_id` = 'kfa1qpr7733v7f9s3q4qt3k0i0'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.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.07 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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:48 - Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 0.749 MB Filas devueltas: 0
SELECT `session_id`
FROM `oja8d_session`
WHERE `session_id` = 'kfa1qpr7733v7f9s3q4qt3k0i0'
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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 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.01 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.02 ms Reset for next command 0.01 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:48 - Tiempo de la consulta: 0.77 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 0.755 MB
INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('kfa1qpr7733v7f9s3q4qt3k0i0', 1, '1738781768', 0, '', 0)'Explicar' no es posible en la consulta: INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('kfa1qpr7733v7f9s3q4qt3k0i0', 1, '1738781768', 0, '', 0)Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Update 0.12 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.36 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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:48 - Tiempo de la consulta: 0.68 ms Después de la última consulta: 0.72 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 0.783 MB Filas devueltas: 36
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 36 Using index condition Status Duration Starting 0.03 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.02 ms Optimizing 0.01 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.24 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.01 ms Unlocking tables 0.01 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.01 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:452 8 JComponentHelper::{closure}() 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:51 - Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.91 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 0.832 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 2 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.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 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.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 0.839 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.03 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.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.01 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.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.94 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 0.868 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 ALL extension No pudo usarse una clave de índice NULL NULL 230 Using where; Usando '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.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.51 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 9 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:311 8 JPluginHelper::{closure}() 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:51 - Tiempo de la consulta: 0.75 ms Después de la última consulta: 11.02 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 1.325 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.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.04 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.18 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:88 16 JMenuSite->{closure}() 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:51 - Tiempo de la consulta: 0.41 ms Después de la última consulta: 5.28 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 1.545 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.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 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.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 13 JDatabaseDriver->loadObject() JROOT/libraries/cms/library/helper.php:166 12 JLibraryHelper::{closure}() 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:51 - Tiempo de la consulta: 0.74 ms Después de la última consulta: 0.50 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 1.539 MB
UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"7c0ab55e67337a76e6206139a750e7b8\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `oja8d_extensions` SET `params` = '{\"mediaversion\":\"7c0ab55e67337a76e6206139a750e7b8\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.07 ms Updating 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.36 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 1.578 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.03 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.01 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.05 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.01 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.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.53 ms Después de la última consulta: 0.63 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 1.594 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.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.03 ms Statistics 0.06 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.08 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.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.98 ms Después de la última consulta: 7.18 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 1.815 MB Filas devueltas: 31
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_jea','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 34 Using sort_union(idx_asset_name,idx_parent_id); 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.06 ms Optimizing 0.02 ms Statistics 0.18 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.34 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.01 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.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.76 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.044 MB memoria antes de la consulta: 1.862 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 203 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.23 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.01 ms Unlocking tables 0.01 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.01 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:51 - Tiempo de la consulta: 2.16 ms Después de la última consulta: 2.14 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 2.054 MB Filas devueltas: 2
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=11
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 6 Using where Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.10 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Creating tmp table 0.09 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.96 ms Creating sort index 0.04 ms Removing tmp table 0.22 ms Creating sort index 0.01 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.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.43 ms Después de la última consulta: 3.81 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 2.199 MB Filas devueltas: 7
SELECT `article_id`
FROM `oja8d_contentmulticategories_categories`
WHERE `category_id` = '11'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 6 Status Duration Starting 0.03 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.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.09 ms End of update loop 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.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 18 JDatabaseDriver->loadColumn() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:380 17 plgSystemContentmulticategories->getMultiCatsArticles() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:280 16 plgSystemContentmulticategories->onGetContentItems() 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:51 - Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 2.214 MB Filas devueltas: 4
SELECT `id`
FROM `oja8d_content`
WHERE `catid` = '11'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_content ref idx_catid idx_catid 4 const 4 Using index Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.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.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.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 18 JDatabaseDriver->loadColumn() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:391 17 plgSystemContentmulticategories->getMultiCatsArticles() JROOT/plugins/system/contentmulticategories/contentmulticategories.php:280 16 plgSystemContentmulticategories->onGetContentItems() 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:51 - Tiempo de la consulta: 2.23 ms Después de la última consulta: 1.02 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 2.239 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 (43,45,50,64,67,71,73,4,9,11,88)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-02-05 18:56:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-02-05 18:56:08')
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 8, 6id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range PRIMARY,idx_access,idx_state,idx_catid idx_state 5 NULL 11 Using index condition; Using where; Using temporary; Usando 'filesort' 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 c eq_ref PRIMARY,idx_access PRIMARY 4 centrodecomerciosada_org_ar.a.catid 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.20 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.10 ms Optimizing 0.05 ms Statistics 0.17 ms Preparing 0.04 ms Creating tmp table 0.08 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.92 ms Creating sort index 0.08 ms Removing tmp table 0.27 ms Creating sort index 0.01 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.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.76 ms Después de la última consulta: 3.42 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 2.387 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 (43,45,50,64,67,71,73,4,9,11,88)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-02-05 18:56:08')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-02-05 18:56:08')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a range PRIMARY,idx_access,idx_state,idx_catid idx_state 5 NULL 11 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.09 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.05 ms Statistics 0.17 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.11 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.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.49 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 2.397 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` = 11
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.05 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.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 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.02 ms Reset for next command 0.01 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:51 - Tiempo de la consulta: 0.69 ms Después de la última consulta: 1.80 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 2.441 MB Filas devueltas: 2
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=11
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 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right No pudo usarse una clave de índice NULL NULL 17 Using where; Usando 'filesort' Status Duration Starting 0.12 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.07 ms Optimizing 0.03 ms Statistics 0.09 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.07 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.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 20 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 19 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 18 JCategories->get() JROOT/administrator/components/com_fields/models/fields.php:197 17 FieldsModelFields->getListQuery() JROOT/libraries/legacy/model/list.php:132 16 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:186 15 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 13 PlgSystemFields->onContentPrepare() 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:51 - Tiempo de la consulta: 1.55 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 2.470 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 (11,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.12 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.10 ms Optimizing 0.06 ms Statistics 0.09 ms Preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.57 ms Creating sort index 0.03 ms Removing tmp table 0.14 ms Creating sort index 0.01 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.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 17 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 15 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 13 PlgSystemFields->onContentPrepare() 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:51 - Tiempo de la consulta: 1.46 ms Después de la última consulta: 7.26 ms Consulta a la memoria: 0.044 MB memoria antes de la consulta: 2.647 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 (11,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.14 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.05 ms Creating tmp table 0.05 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.56 ms Creating sort index 0.03 ms Removing tmp table 0.13 ms Creating sort index 0.01 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.01 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.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 22 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 21 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 19 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 17 PlgSystemFields->onContentPrepare() 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:51 - Tiempo de la consulta: 0.98 ms Después de la última consulta: 9.62 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 2.731 MB Filas devueltas: 8
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 <= '2025-02-05 18:56:08')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-02-05 18:56:08')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 104 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.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.05 ms Optimizing 0.06 ms Statistics 0.08 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.29 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 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.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 14 JDatabaseDriver->loadObjectList() 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:51
21 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`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.id1 × 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
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`.`tag_id`,`t`.*
FROM `oja8d_contentitem_tag_map` AS m
INNER JOIN `oja8d_tags` AS t
ON `m`.`tag_id` = `t`.`id`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 `data`
FROM `oja8d_session`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 `session_id`
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 *
FROM oja8d_languages1 × 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 `folder` AS `type`,`element` AS `name`,`params`
FROM oja8d_extensions1 × SELECT id, rules
FROM `oja8d_viewlevels1 × SELECT b.id
FROM oja8d_usergroups AS a
LEFT JOIN oja8d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × 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
OTRAS tablas:
1 × INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('kfa1qpr7733v7f9s3q4qt3k0i0', 1, '1738781768', 0, '', 01 × UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"7c0ab55e67337a76e6206139a750e7b8\"}'