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": 1679422104,
"last": 1679422104,
"now": 1679422104
},
"token": "6KjZDzBw0PFaOJoCajt7dj9PLbswneDh"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Fecha y hora
Memoria
Fecha y hora: 4.73 ms / 4.73 ms Memoria: 0.849 MB / 1.06 MB Application: afterLoad
Fecha y hora: 41.84 ms / 46.57 ms Memoria: 4.178 MB / 5.24 MB Application: afterInitialise
Fecha y hora: 6.29 ms / 52.86 ms Memoria: 1.129 MB / 6.37 MB Application: afterRoute
Fecha y hora: 43.06 ms / 95.92 ms Memoria: 0.435 MB / 6.80 MB Application: beforeRenderComponent com_contact
Fecha y hora: 4.13 ms / 100.05 ms Memoria: 0.837 MB / 7.64 MB Application: Before JAccess::preloadComponents (all components)
Fecha y hora: 0.90 ms / 100.95 ms Memoria: 0.080 MB / 7.72 MB Application: After JAccess::preloadComponents (all components)
Fecha y hora: 0.03 ms / 100.98 ms Memoria: 0.000 MB / 7.72 MB Application: Before JAccess::getAssetRules (id:7 name:com_contact)
Fecha y hora: 0.28 ms / 101.26 ms Memoria: 0.041 MB / 7.76 MB Application: After JAccess::getAssetRules (id:7 name:com_contact)
Fecha y hora: 7.86 ms / 109.12 ms Memoria: 1.478 MB / 9.24 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 0.05 ms / 109.18 ms Memoria: 0.009 MB / 9.25 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 53.23 ms / 162.41 ms Memoria: 2.513 MB / 11.76 MB Application: afterRenderComponent com_contact
Fecha y hora: 0.25 ms / 162.66 ms Memoria: 0.008 MB / 11.77 MB Application: afterDispatch
Fecha y hora: 2.88 ms / 165.54 ms Memoria: 0.375 MB / 12.14 MB Application: beforeRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.68 ms / 166.22 ms Memoria: 0.054 MB / 12.20 MB Application: afterRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.02 ms / 166.24 ms Memoria: 0.000 MB / 12.19 MB Application: beforeRenderModule mod_custom (Ubicación)
Fecha y hora: 0.15 ms / 166.39 ms Memoria: 0.007 MB / 12.20 MB Application: afterRenderModule mod_custom (Ubicación)
Fecha y hora: 0.90 ms / 167.29 ms Memoria: 0.004 MB / 12.20 MB Application: beforeRenderModule mod_custom (Capacitación)
Fecha y hora: 0.17 ms / 167.45 ms Memoria: 0.008 MB / 12.21 MB Application: afterRenderModule mod_custom (Capacitación)
Fecha y hora: 0.03 ms / 167.48 ms Memoria: 0.000 MB / 12.21 MB Application: beforeRenderModule mod_custom (Financiación)
Fecha y hora: 0.17 ms / 167.65 ms Memoria: 0.007 MB / 12.21 MB Application: afterRenderModule mod_custom (Financiación)
Fecha y hora: 0.05 ms / 167.70 ms Memoria: 0.000 MB / 12.21 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 1.61 ms / 169.31 ms Memoria: 0.096 MB / 12.31 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.06 ms / 169.38 ms Memoria: 0.000 MB / 12.30 MB Application: beforeRenderModule mod_menu (Main Menu)
Fecha y hora: 2.29 ms / 171.67 ms Memoria: 0.185 MB / 12.49 MB Application: afterRenderModule mod_menu (Main Menu)
Fecha y hora: 1.33 ms / 173.00 ms Memoria: 0.082 MB / 12.57 MB Application: afterRender
Total de consultas a la base de datos: 99.80 ms
13.31 MB (13,959,912 Bytes)
29 consultas registradas 99.80 ms
- Tiempo de la consulta: 0.32 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.160 MB Filas devueltas: 0
SELECT `data`
FROM `oja8d_session`
WHERE `session_id` = 'do0sh5g0j3dosoblhqnn19sp45'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_session const PRIMARY PRIMARY 766 const 1 Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Lo mismo que llamada de la línea de abajo. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:82 10 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:648 9 JSession->_start() JROOT/libraries/joomla/session/session.php:608 8 JSession->start() JROOT/libraries/joomla/session/session.php:486 7 JSession->get() JROOT/libraries/joomla/session/session.php:443 6 JSession->isNew() JROOT/libraries/cms/application/cms.php:825 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.70 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.304 MB Filas devueltas: 0
SELECT `session_id`
FROM `oja8d_session`
WHERE `session_id` = 'do0sh5g0j3dosoblhqnn19sp45'
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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:827 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 19.21 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.319 MB
INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('do0sh5g0j3dosoblhqnn19sp45', 1, '1679422104', 0, '', 0)'Explicar' no es posible en la consulta: INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('do0sh5g0j3dosoblhqnn19sp45', 1, '1679422104', 0, '', 0)Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.00 ms update 0.14 ms Waiting for query cache lock 0.00 ms update 0.01 ms end 0.00 ms query end 18.95 ms closing tables 0.02 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:216 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:827 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:412 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.56 ms Después de la última consulta: 1.41 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.570 MB Filas devueltas: 35
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_extensions ref extension extension 82 const 35 Using index condition Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.25 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:452 9 JComponentHelper::{closure}() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:460 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:111 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:593 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.33 ms Después de la última consulta: 1.37 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.858 MB Filas devueltas: 2
SELECT b.id
FROM oja8d_usergroups AS a
LEFT JOIN oja8d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1530 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:978 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:1047 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:293 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.935 MB Filas devueltas: 5
SELECT id, rules
FROM `oja8d_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_viewlevels ALL NULL No pudo usarse una clave de índice NULL NULL 5 Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.02 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.02 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1486 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:1064 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:293 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.68 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 3.974 MB Filas devueltas: 63
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM oja8d_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_extensions ref extension extension 82 const 112 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.36 ms Sending data 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:311 9 JPluginHelper::{closure}() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/plugin/helper.php:316 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:603 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.47 ms Después de la última consulta: 7.83 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 5.502 MB Filas devueltas: 7
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM oja8d_menu AS m
LEFT JOIN oja8d_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 8 Using index condition; Using where; Usando 'filesort' 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.m.component_id 1 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.10 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 18 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:88 17 JMenuSite->{closure}() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 15 JCacheControllerCallback->get() JROOT/libraries/cms/menu/site.php:96 14 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 13 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 12 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:129 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:443 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:59 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:198 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:548 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:402 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1141 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:795 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.35 ms Después de la última consulta: 4.95 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.419 MB Filas devueltas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 14 JDatabaseDriver->loadObject() JROOT/libraries/cms/library/helper.php:166 13 JLibraryHelper::{closure}() Lo mismo que llamada de la línea de abajo. 12 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:174 10 JLibraryHelper::loadLibrary() JROOT/libraries/cms/library/helper.php:42 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:89 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:270 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 39.37 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 6.421 MB
UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"c3c3cb1a92f3e65edb378189b6da00dc\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `oja8d_extensions` SET `params` = '{\"mediaversion\":\"c3c3cb1a92f3e65edb378189b6da00dc\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.03 ms Updating 0.03 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.02 ms query end 39.13 ms closing tables 0.02 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:116 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:321 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:280 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.30 ms Después de la última consulta: 1.08 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 6.686 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.09 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 6 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:148 5 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:327 4 JApplicationSite->getParams() JROOT/libraries/cms/application/site.php:135 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 6.715 MB Filas devueltas: 3
SELECT id, home, template, s.params
FROM oja8d_template_styles as s
LEFT JOIN oja8d_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template No pudo usarse una clave de índice NULL NULL 5 Using where; Using join buffer (flat, BNL join) Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 5 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:485 4 JApplicationSite->getTemplate() JROOT/libraries/cms/application/site.php:165 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.65 ms Después de la última consulta: 5.15 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 7.648 MB Filas devueltas: 30
SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`
WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_assets index_merge idx_asset_name,idx_parent_id idx_asset_name,idx_parent_id 202,4 NULL 33 Using sort_union(idx_asset_name,idx_parent_id); Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.01 ms executing 0.00 ms Sending data 0.26 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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:49 - Tiempo de la consulta: 0.52 ms Después de la última consulta: 0.58 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 7.765 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 <= '2023-03-21 18:08:24')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-21 18:08:24')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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.03 ms optimizing 0.01 ms statistics 0.21 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 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:49 - Tiempo de la consulta: 0.43 ms Después de la última consulta: 1.03 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 7.985 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 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:49 - Tiempo de la consulta: 0.41 ms Después de la última consulta: 2.08 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 8.503 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.01 ms checking permissions 0.00 ms Opening tables 0.11 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.00 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms closing tables 0.00 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 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:49 - Tiempo de la consulta: 0.53 ms Después de la última consulta: 3.38 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 9.251 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.02 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.04 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 22 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 20 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 19 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:281 18 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:236 17 PlgSystemFields->onContentPrepareForm() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/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:49 - Tiempo de la consulta: 0.33 ms Después de la última consulta: 2.56 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 9.703 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.02 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 24 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 23 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 22 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 21 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 20 FieldsHelper::getFields() JROOT/administrator/components/com_fields/helpers/fields.php:281 19 FieldsHelper::prepareForm() JROOT/plugins/system/fields/fields.php:236 18 PlgSystemFields->onContentPrepareForm() Lo mismo que llamada de la línea de abajo. 17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/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:49 - Tiempo de la consulta: 0.57 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 9.819 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 Usando 'filesort' 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_state 1 const 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.created_by 1 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.01 ms statistics 0.17 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.12 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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:49 - Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 9.863 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.00 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.02 ms updating status 0.00 ms cleaning up 0.00 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:49 - Tiempo de la consulta: 0.50 ms Después de la última consulta: 2.26 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 10.291 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 Usando 'filesort' 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right No pudo usarse una clave de índice NULL NULL 17 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.03 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 21 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 20 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 19 JCategories->get() JROOT/administrator/components/com_fields/models/fields.php:197 18 FieldsModelFields->getListQuery() JROOT/libraries/legacy/model/list.php:132 17 JModelList->_getListQuery() JROOT/libraries/legacy/model/list.php:186 16 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Lo mismo que llamada de la línea de abajo. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_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:49 - Tiempo de la consulta: 0.56 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 10.322 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.02 ms executing 0.00 ms Creating tmp table 0.15 ms Copying to tmp table 0.01 ms Sorting result 0.01 ms Sending data 0.02 ms end 0.00 ms removing tmp table 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 19 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:307 18 JModelLegacy->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/legacy/model/list.php:186 16 JModelList->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:134 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:378 14 PlgSystemFields->onContentPrepare() Lo mismo que llamada de la línea de abajo. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_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:49 - Tiempo de la consulta: 0.14 ms Después de la última consulta: 1.00 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 10.525 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.00 ms checking privileges on cached 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms sending cached result to clien 0.01 ms updating status 0.00 ms cleaning up 0.00 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:49 - Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 10.588 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.01 ms checking permissions 0.00 ms Opening tables 0.13 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.00 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Filling schema table 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms closing tables 0.00 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/libraries/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:49 - Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 10.788 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.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 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:49 - Tiempo de la consulta: 30.32 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 10.803 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.03 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms init 0.02 ms Updating 0.03 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.04 ms query end 30.10 ms closing tables 0.01 ms freeing items 0.00 ms updating status 0.01 ms cleaning up 0.00 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:49 - Tiempo de la consulta: 0.95 ms Después de la última consulta: 12.87 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 12.117 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 <= '2023-03-21 18:08:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 18:08:24')
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.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.25 ms Sending data 0.18 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.05 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() Lo mismo que llamada de la línea de abajo. 14 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 13 JCacheControllerCallback->get() JROOT/libraries/cms/module/helper.php:424 12 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:360 11 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 10 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:576 9 JDocumentHtml->countModules() JROOT/templates/ja_simpli/helper.php:96 8 SimpliHelper->init() JROOT/templates/ja_simpli/index.php:10 7 require JROOT/templates/ja_simpli/index.php JROOT/libraries/joomla/document/html.php:653 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:715 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:530 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1098 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:777 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:271 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.23 ms Después de la última consulta: 2.99 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.262 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.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.00 ms executing 0.00 ms Sending data 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1720 21 JDatabaseDriver->loadResult() JROOT/components/com_contact/router.php:121 20 ContactRouter->getContactSegment() Lo mismo que llamada de la línea de abajo. 19 call_user_func_array() 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:49 - Tiempo de la consulta: 0.40 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 12.294 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 Usando 'filesort' 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right No pudo usarse una clave de índice NULL NULL 17 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.02 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.03 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 23 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:301 22 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 21 JCategories->get() JROOT/components/com_contact/router.php:68 20 ContactRouter->getCategorySegment() Lo mismo que llamada de la línea de abajo. 19 call_user_func_array() 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:49
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 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_id2 × 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)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_by1 × SELECT *
FROM oja8d_contact_details1 × SELECT `alias`
FROM `oja8d_contact_details`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 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 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 `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`1 × 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 `session_id`
FROM `oja8d_session`1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM oja8d_extensions1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM oja8d_menu AS m
LEFT JOIN oja8d_extensions AS e
ON m.component_id = e.extension_id1 × 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 `data`
FROM `oja8d_session`
OTRAS tablas:
1 × UPDATE oja8d_contact_details
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `oja8d_contact_details1 × SHOW FULL COLUMNS
FROM `oja8d_users1 × UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"c3c3cb1a92f3e65edb378189b6da00dc\"}'1 × INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('do0sh5g0j3dosoblhqnn19sp45', 1, '1679422104', 0, '', 0