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": 1738770686, "last": 1738770686, "now": 1738770686 }, "token": "5Q2acN6szez6zYaNsYO2YZAXkG5nlgl6" }, "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: 13.21 ms / 13.21 ms Memoria: 0.057 MB / 0.40 MB Application: afterLoad
Fecha y hora: 29.25 ms / 42.46 ms Memoria: 0.830 MB / 1.23 MB Application: afterInitialise
Fecha y hora: 5.76 ms / 48.23 ms Memoria: 0.221 MB / 1.45 MB Application: afterRoute
Fecha y hora: 7.28 ms / 55.51 ms Memoria: 0.183 MB / 1.63 MB Application: beforeRenderComponent com_contact
Fecha y hora: 5.83 ms / 61.34 ms Memoria: 0.248 MB / 1.88 MB Application: Before JAccess::preloadComponents (all components)
Fecha y hora: 1.80 ms / 63.15 ms Memoria: 0.051 MB / 1.93 MB Application: After JAccess::preloadComponents (all components)
Fecha y hora: 0.06 ms / 63.21 ms Memoria: 0.000 MB / 1.93 MB Application: Before JAccess::getAssetRules (id:7 name:com_contact)
Fecha y hora: 0.33 ms / 63.54 ms Memoria: 0.071 MB / 2.00 MB Application: After JAccess::getAssetRules (id:7 name:com_contact)
Fecha y hora: 22.37 ms / 85.91 ms Memoria: 0.635 MB / 2.64 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 0.11 ms / 86.02 ms Memoria: 0.007 MB / 2.65 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 186.84 ms / 272.86 ms Memoria: 0.774 MB / 3.42 MB Application: afterRenderComponent com_contact
Fecha y hora: 0.70 ms / 273.56 ms Memoria: 0.005 MB / 3.43 MB Application: afterDispatch
Fecha y hora: 3.74 ms / 277.30 ms Memoria: 0.112 MB / 3.54 MB Application: beforeRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.89 ms / 278.18 ms Memoria: 0.006 MB / 3.54 MB Application: afterRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.04 ms / 278.22 ms Memoria: 0.000 MB / 3.54 MB Application: beforeRenderModule mod_custom (Ubicación)
Fecha y hora: 0.16 ms / 278.38 ms Memoria: 0.003 MB / 3.55 MB Application: afterRenderModule mod_custom (Ubicación)
Fecha y hora: 1.31 ms / 279.69 ms Memoria: 0.000 MB / 3.55 MB Application: beforeRenderModule mod_custom (Capacitación)
Fecha y hora: 0.16 ms / 279.85 ms Memoria: 0.005 MB / 3.55 MB Application: afterRenderModule mod_custom (Capacitación)
Fecha y hora: 0.05 ms / 279.90 ms Memoria: 0.000 MB / 3.55 MB Application: beforeRenderModule mod_custom (Financiación)
Fecha y hora: 0.13 ms / 280.04 ms Memoria: 0.003 MB / 3.55 MB Application: afterRenderModule mod_custom (Financiación)
Fecha y hora: 0.08 ms / 280.12 ms Memoria: 0.000 MB / 3.55 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 3.83 ms / 283.95 ms Memoria: 0.042 MB / 3.60 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.11 ms / 284.06 ms Memoria: 0.000 MB / 3.59 MB Application: beforeRenderModule mod_menu (Main Menu)
Fecha y hora: 2.66 ms / 286.73 ms Memoria: 0.047 MB / 3.64 MB Application: afterRenderModule mod_menu (Main Menu)
Fecha y hora: 4.70 ms / 291.42 ms Memoria: 0.040 MB / 3.68 MB Application: afterRender
Total de consultas a la base de datos: 35.73 ms
4.19 MB (4,393,064 Bytes)
29 consultas registradas 35.73 ms
- Tiempo de la consulta: 0.75 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 0.728 MB Filas devueltas: 0
SELECT `data`
FROM `oja8d_session`
WHERE `session_id` = 'v5tggc9m7miv74jle95fbc94h6'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.10 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.02 ms Executing 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.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.08 ms Updating status 0.03 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.56 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 0.747 MB Filas devueltas: 0
SELECT `session_id`
FROM `oja8d_session`
WHERE `session_id` = 'v5tggc9m7miv74jle95fbc94h6'
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.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.02 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.03 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: 1.14 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 0.753 MB
INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('v5tggc9m7miv74jle95fbc94h6', 1, '1738770686', 0, '', 0)'Explicar' no es posible en la consulta: INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('v5tggc9m7miv74jle95fbc94h6', 1, '1738770686', 0, '', 0)Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.03 ms Update 0.18 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.51 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 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: 1.40 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 0.781 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.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.46 ms End of update loop 0.02 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.06 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.80 ms Después de la última consulta: 1.37 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 0.830 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.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.06 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.02 ms Updating status 0.03 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.61 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 0.837 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.05 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.06 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.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: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: 1.86 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 0.866 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.11 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.03 ms End of update loop 0.02 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.02 ms Updating status 0.04 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: 1.24 ms Después de la última consulta: 10.84 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 1.323 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.16 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.28 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.04 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.71 ms Después de la última consulta: 4.28 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 1.472 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.07 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.11 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.06 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.03 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: 1.00 ms Después de la última consulta: 0.45 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 1.465 MB
UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"747971824165f35d9d622628f7a17b71\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `oja8d_extensions` SET `params` = '{\"mediaversion\":\"747971824165f35d9d622628f7a17b71\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.12 ms Updating 0.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.38 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.03 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.64 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 1.567 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.06 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.02 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.03 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.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.03 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.85 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 1.583 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.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.04 ms Statistics 0.09 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.12 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.03 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: 1.30 ms Después de la última consulta: 7.97 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 1.887 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.12 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.03 ms Statistics 0.21 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.42 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.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: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/components/com_contact/models/contact.php:67 13 ContactModelContact->populateState() JROOT/libraries/legacy/model/legacy.php:434 12 JModelLegacy->getState() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_contact/views/contact/view.html.php:71 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.36 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.042 MB memoria antes de la consulta: 2.009 MB Filas devueltas: 1
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM oja8d_contact_details AS a
LEFT JOIN oja8d_categories AS c
on c.id = a.catid
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id
WHERE a.id = 1
AND (a.published = 1 OR a.published =2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-02-05 15:51:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-02-05 15:51:26')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init 0.13 ms Optimizing 0.07 ms Statistics 1.24 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.12 ms End of update loop 0.02 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.02 ms Updating status 0.04 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/components/com_contact/models/contact.php:199 12 ContactModelContact->getItem() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.82 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 2.053 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_contact.contact'
AND `m`.`content_item_id` = 1
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.09 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.07 ms Optimizing 0.05 ms Statistics 0.11 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.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.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/cms/helper/tags.php:450 13 JHelperTags->getItemTags() JROOT/components/com_contact/models/contact.php:221 12 ContactModelContact->getItem() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.14 ms Después de la última consulta: 5.81 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 2.296 MB Filas devueltas: 16
SHOW FULL COLUMNS
FROM `oja8d_users`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `oja8d_users`Status Duration Starting 0.05 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.93 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.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.19 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.35 ms closing tables 0.01 ms Unlocking tables 0.02 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 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:244 20 JTable->getFields() JROOT/libraries/joomla/table/table.php:163 19 JTable->__construct() JROOT/libraries/joomla/table/user.php:39 18 JTableUser->__construct() JROOT/libraries/joomla/table/table.php:311 17 JTable::getInstance() JROOT/administrator/components/com_users/models/user.php:64 16 UsersModelUser->getTable() JROOT/libraries/legacy/model/admin.php:899 15 JModelAdmin->getItem() JROOT/administrator/components/com_users/models/user.php:89 14 UsersModelUser->getItem() JROOT/components/com_contact/models/contact.php:361 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:257 12 ContactModelContact->getItem() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.42 ms Después de la última consulta: 10.47 ms Consulta a la memoria: 0.044 MB memoria antes de la consulta: 2.652 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
WHERE a.context = 'com_users.user'
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)
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; 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 Status Duration Starting 0.33 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.12 ms Optimizing 0.08 ms Statistics 0.17 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.04 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.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.02 ms Updating status 0.03 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/administrator/components/com_fields/helpers/fields.php:281 17 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:236 16 PlgSystemFields->onContentPrepareForm() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_contact/models/contact.php:370 13 ContactModelContact->buildContactExtendedData() JROOT/components/com_contact/models/contact.php:257 12 ContactModelContact->getItem() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_contact/views/contact/view.html.php:72 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.40 ms Después de la última consulta: 111.50 ms Consulta a la memoria: 0.044 MB memoria antes de la consulta: 2.794 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
WHERE a.context = 'com_contact.mail'
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)
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; 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 Status Duration Starting 0.31 ms checking permissions 0.02 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.12 ms Optimizing 0.08 ms Statistics 0.17 ms Preparing 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.04 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.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.02 ms Updating status 0.03 ms Reset for next command 0.01 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/administrator/components/com_fields/helpers/fields.php:281 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:236 17 PlgSystemFields->onContentPrepareForm() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/libraries/legacy/model/form.php:313 14 JModelForm->preprocessForm() JROOT/libraries/legacy/model/form.php:234 13 JModelForm->loadForm() JROOT/components/com_contact/models/contact.php:88 12 ContactModelContact->getForm() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_contact/views/contact/view.html.php:73 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.35 ms Después de la última consulta: 2.19 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 2.874 MB Filas devueltas: 1
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `oja8d_contact_details` 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
WHERE a.access IN (1,1,5)
AND a.catid = 13
AND c.access IN (1,1,5)
AND a.published = 1
ORDER BY a.name ascid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_state 1 const 1 Using where; Usando 'filesort' 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.created_by 1 Using where Status Duration Starting 0.19 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.12 ms Optimizing 0.06 ms Statistics 0.31 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.05 ms Creating sort index 0.13 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.02 ms Updating status 0.04 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/legacy/model/legacy.php:307 13 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:186 12 JModelList->getItems() JROOT/components/com_contact/models/category.php:91 11 ContactModelCategory->getItems() JROOT/components/com_contact/views/contact/view.html.php:90 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.79 ms Después de la última consulta: 0.44 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 2.905 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_contact.contact'
AND `m`.`content_item_id` = 1
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.11 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.11 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.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.03 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/components/com_contact/models/category.php:102 11 ContactModelCategory->getItems() JROOT/components/com_contact/views/contact/view.html.php:90 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.23 ms Después de la última consulta: 2.27 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 2.939 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_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=13
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.23 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.13 ms Optimizing 0.06 ms Statistics 0.17 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.12 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.02 ms Updating status 0.03 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_contact/views/contact/view.html.php:248 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.63 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 2.954 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_contact.contact'
AND (fc.category_id IS NULL OR fc.category_id IN (13,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.25 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.12 ms Optimizing 0.08 ms Statistics 0.14 ms Preparing 0.09 ms Creating tmp table 0.11 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 1.05 ms Creating sort index 0.05 ms Removing tmp table 0.26 ms Creating sort index 0.02 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 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_contact/views/contact/view.html.php:248 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.81 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 2.980 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_contact.contact'
AND `m`.`content_item_id` = 1
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.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.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.10 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.03 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/helper/tags.php:450 11 JHelperTags->getItemTags() JROOT/components/com_contact/views/contact/view.html.php:291 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.18 ms Después de la última consulta: 1.18 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 3.014 MB Filas devueltas: 43
SHOW FULL COLUMNS
FROM `oja8d_contact_details`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `oja8d_contact_details`Status Duration Starting 0.05 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.78 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.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.34 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.34 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:244 15 JTable->getFields() JROOT/libraries/joomla/table/table.php:163 14 JTable->__construct() JROOT/administrator/components/com_contact/tables/contact.php:39 13 ContactTableContact->__construct() JROOT/libraries/joomla/table/table.php:311 12 JTable::getInstance() JROOT/components/com_contact/models/contact.php:587 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:311 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.66 ms Después de la última consulta: 1.06 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 3.109 MB Filas devueltas: 1
SELECT *
FROM oja8d_contact_details
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_contact_details const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 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.03 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:1445 13 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:729 12 JTable->load() JROOT/components/com_contact/models/contact.php:588 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:311 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.87 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.118 MB
UPDATE oja8d_contact_details
SET `hits` = (`hits` + 1)
WHERE `id` = '1''Explicar' no es posible en la consulta: UPDATE oja8d_contact_details SET `hits` = (`hits` + 1) WHERE `id` = '1'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 for update 0.09 ms Updating 0.14 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.30 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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/table/table.php:1240 12 JTable->hit() JROOT/components/com_contact/models/contact.php:589 11 ContactModelContact->hit() JROOT/components/com_contact/views/contact/view.html.php:311 10 ContactViewContact->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_contact/controller.php:65 8 ContactController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_contact/contact.php:28 6 require_once JROOT/components/com_contact/contact.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.06 ms Después de la última consulta: 54.34 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 3.532 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 <= '2025-02-05 15:51:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-02-05 15:51:26')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 107 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.30 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.15 ms Optimizing 0.12 ms Statistics 0.23 ms Preparing 0.14 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.57 ms End of update loop 0.02 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.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.04 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 - Tiempo de la consulta: 0.60 ms Después de la última consulta: 4.28 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 3.576 MB Filas devueltas: 1
SELECT `alias`
FROM `oja8d_contact_details`
WHERE id = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_contact_details const PRIMARY PRIMARY 4 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 Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 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.03 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:1720 20 JDatabaseDriver->loadResult() JROOT/components/com_contact/router.php:121 19 ContactRouter->getContactSegment() JROOT/libraries/cms/component/router/view.php:117 18 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 17 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 16 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 15 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_breadcrumbs/helper.php:56 11 ModBreadCrumbsHelper::getList() JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16 10 include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php JROOT/libraries/cms/module/helper.php:198 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1112 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 - Tiempo de la consulta: 1.58 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.045 MB memoria antes de la consulta: 3.593 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_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=1
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.32 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.21 ms Optimizing 0.08 ms Statistics 0.24 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.20 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.02 ms Updating status 0.03 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/categories/categories.php:301 21 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 20 JCategories->get() JROOT/components/com_contact/router.php:68 19 ContactRouter->getCategorySegment() JROOT/libraries/cms/component/router/view.php:121 18 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 17 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 16 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 15 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 14 JRouter->build() JROOT/libraries/cms/router/site.php:149 13 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 12 JRoute::_() JROOT/modules/mod_breadcrumbs/helper.php:56 11 ModBreadCrumbsHelper::getList() JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16 10 include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php JROOT/libraries/cms/module/helper.php:198 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:486 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:777 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:552 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1112 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
24 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
3 × SELECT `m`.`tag_id`,`t`.*
FROM `oja8d_contentitem_tag_map` AS m
INNER JOIN `oja8d_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`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)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_id1 × SELECT `data`
FROM `oja8d_session`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 *
FROM oja8d_contact_details1 × 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 a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `oja8d_contact_details` 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_by1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`1 × SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM oja8d_contact_details AS a
LEFT JOIN oja8d_categories AS c
on c.id = a.catid
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id1 × 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 `alias`
FROM `oja8d_contact_details`
OTRAS tablas:
1 × INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('v5tggc9m7miv74jle95fbc94h6', 1, '1738770686', 0, '', 01 × UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"747971824165f35d9d622628f7a17b71\"}'1 × SHOW FULL COLUMNS
FROM `oja8d_users1 × SHOW FULL COLUMNS
FROM `oja8d_contact_details1 × UPDATE oja8d_contact_details
SET `hits` = (`hits` + 1)