- Está aquí:
-
Novedades
- Día del Almacenero
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": 1713617544,
"last": 1713617544,
"now": 1713617544
}
},
"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.60 ms / 4.60 ms Memoria: 0.849 MB / 1.06 MB Application: afterLoad
Fecha y hora: 343.10 ms / 347.70 ms Memoria: 4.186 MB / 5.25 MB Application: afterInitialise
Fecha y hora: 8.83 ms / 356.53 ms Memoria: 1.543 MB / 6.79 MB Application: afterRoute
Fecha y hora: 235.46 ms / 591.99 ms Memoria: 0.438 MB / 7.23 MB Application: beforeRenderComponent com_content
Fecha y hora: 2.44 ms / 594.43 ms Memoria: 0.502 MB / 7.73 MB Application: Before JAccess::preloadComponents (all components)
Fecha y hora: 1.04 ms / 595.46 ms Memoria: 0.077 MB / 7.81 MB Application: After JAccess::preloadComponents (all components)
Fecha y hora: 0.03 ms / 595.49 ms Memoria: 0.000 MB / 7.81 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)
Fecha y hora: 0.29 ms / 595.78 ms Memoria: 0.041 MB / 7.85 MB Application: After JAccess::getAssetRules (id:8 name:com_content)
Fecha y hora: 74.96 ms / 670.74 ms Memoria: 1.457 MB / 9.30 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 0.06 ms / 670.80 ms Memoria: 0.009 MB / 9.31 MB Application: After JAccess::getAssetRules (id:1 name:root.1)
Fecha y hora: 6.80 ms / 677.60 ms Memoria: 0.980 MB / 10.29 MB Application: afterRenderComponent com_content
Fecha y hora: 0.83 ms / 678.43 ms Memoria: 0.136 MB / 10.43 MB Application: afterDispatch
Fecha y hora: 2.61 ms / 681.04 ms Memoria: 0.373 MB / 10.80 MB Application: beforeRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.60 ms / 681.64 ms Memoria: 0.054 MB / 10.86 MB Application: afterRenderModule mod_custom (Centro del Comercio Prop. e Ind.)
Fecha y hora: 0.02 ms / 681.66 ms Memoria: 0.000 MB / 10.85 MB Application: beforeRenderModule mod_custom (Ubicación)
Fecha y hora: 0.15 ms / 681.81 ms Memoria: 0.007 MB / 10.86 MB Application: afterRenderModule mod_custom (Ubicación)
Fecha y hora: 0.73 ms / 682.54 ms Memoria: 0.000 MB / 10.86 MB Application: beforeRenderModule mod_custom (Capacitación)
Fecha y hora: 0.15 ms / 682.69 ms Memoria: 0.008 MB / 10.87 MB Application: afterRenderModule mod_custom (Capacitación)
Fecha y hora: 0.03 ms / 682.72 ms Memoria: 0.000 MB / 10.86 MB Application: beforeRenderModule mod_custom (Financiación)
Fecha y hora: 0.13 ms / 682.85 ms Memoria: 0.007 MB / 10.87 MB Application: afterRenderModule mod_custom (Financiación)
Fecha y hora: 0.05 ms / 682.90 ms Memoria: 0.000 MB / 10.87 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.86 ms / 683.76 ms Memoria: 0.080 MB / 10.95 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.06 ms / 683.82 ms Memoria: 0.000 MB / 10.94 MB Application: beforeRenderModule mod_menu (Main Menu)
Fecha y hora: 2.10 ms / 685.92 ms Memoria: 0.183 MB / 11.13 MB Application: afterRenderModule mod_menu (Main Menu)
Fecha y hora: 1.13 ms / 687.06 ms Memoria: 0.073 MB / 11.20 MB Application: afterRender
Total de consultas a la base de datos: 626.03 ms
11.79 MB (12,364,992 Bytes)
24 consultas registradas 626.03 ms
- Tiempo de la consulta: 178.12 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 3.140 MB
DELETE
FROM `oja8d_session`
WHERE `time` < '1713616643''Explicar' no es posible en la consulta: DELETE FROM `oja8d_session` WHERE `time` < '1713616643'Status Duration starting 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 init 0.14 ms updating 0.14 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.00 ms query end 177.69 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:818 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.23 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 3.171 MB Filas devueltas: 0
SELECT `data`
FROM `oja8d_session`
WHERE `session_id` = 'ldmro75ou29tlkub2rbjo8qh73'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.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.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.03 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 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.20 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.314 MB Filas devueltas: 0
SELECT `session_id`
FROM `oja8d_session`
WHERE `session_id` = 'ldmro75ou29tlkub2rbjo8qh73'
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.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.01 ms After table lock 0.01 ms init 0.02 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: 142.16 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.330 MB
INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('ldmro75ou29tlkub2rbjo8qh73', 1, '1713617544', 0, '', 0)'Explicar' no es posible en la consulta: INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ldmro75ou29tlkub2rbjo8qh73', 1, '1713617544', 0, '', 0)Status Duration starting 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 init 0.01 ms update 0.09 ms Waiting for query cache lock 0.00 ms update 0.01 ms end 0.00 ms query end 141.87 ms closing tables 0.03 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.67 ms Después de la última consulta: 1.48 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.578 MB Filas devueltas: 35
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_extensions ref extension extension 82 const 35 Using index condition Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.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.02 ms init 0.02 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.01 ms executing 0.00 ms Sending data 0.28 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 10 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/component/helper.php:452 9 JComponentHelper::{closure}() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:460 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:111 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:593 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.36 ms Después de la última consulta: 1.44 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.866 MB Filas devueltas: 2
SELECT b.id
FROM oja8d_usergroups AS a
LEFT JOIN oja8d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.00 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.26 ms Después de la última consulta: 0.41 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 3.943 MB Filas devueltas: 5
SELECT id, rules
FROM `oja8d_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_viewlevels ALL NULL No pudo usarse una clave de índice NULL NULL 5 Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.00 ms optimizing 0.00 ms statistics 0.00 ms preparing 0.00 ms executing 0.00 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.04 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.67 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 3.982 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.34 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.54 ms Después de la última consulta: 7.89 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 5.511 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.12 ms preparing 0.03 ms executing 0.00 ms Sorting result 0.13 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.41 ms Después de la última consulta: 5.17 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 6.487 MB Filas devueltas: 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM oja8d_categories as c
LEFT JOIN oja8d_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=78
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 NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL Impossible WHERE noticed after reading const tables 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.04 ms optimizing 0.01 ms statistics 0.10 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.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/legacy/categories/categories.php:301 12 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 11 JCategories->get() JROOT/components/com_content/helpers/legacyrouter.php:350 10 ContentRouterRulesLegacy->parse() JROOT/libraries/cms/component/router/view.php:263 9 JComponentRouterView->parse() JROOT/libraries/cms/router/site.php:432 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:483 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:236 6 JRouter->parse() JROOT/libraries/cms/router/site.php:133 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1142 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.31 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 6.503 MB Filas devueltas: 1
SELECT `alias`,`catid`
FROM `oja8d_content`
WHERE `id` = 78id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_content 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.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.13 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 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 11 JDatabaseDriver->loadObject() JROOT/components/com_content/helpers/legacyrouter.php:366 10 ContentRouterRulesLegacy->parse() JROOT/libraries/cms/component/router/view.php:263 9 JComponentRouterView->parse() JROOT/libraries/cms/router/site.php:432 8 JRouterSite->parseSefRoute() JROOT/libraries/cms/router/router.php:483 7 JRouter->_parseSefRoute() JROOT/libraries/cms/router/router.php:236 6 JRouter->parse() JROOT/libraries/cms/router/site.php:133 5 JRouterSite->parse() JROOT/libraries/cms/application/cms.php:1142 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: 1.42 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.843 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.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.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.06 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 14 JDatabaseDriver->loadObject() JROOT/libraries/cms/library/helper.php:166 13 JLibraryHelper::{closure}() Lo mismo que llamada de la línea de abajo. 12 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:169 11 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:174 10 JLibraryHelper::loadLibrary() JROOT/libraries/cms/library/helper.php:42 9 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:89 8 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:270 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 231.54 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 6.845 MB
UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"e950107991e2d69837fd3aa440b4aef6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `oja8d_extensions` SET `params` = '{\"mediaversion\":\"e950107991e2d69837fd3aa440b4aef6\"}' 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.04 ms Updating 0.05 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.02 ms query end 231.25 ms closing tables 0.01 ms freeing items 0.02 ms updating status 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:116 9 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:321 8 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:280 7 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 6 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 5 JFactory::getDocument() JROOT/libraries/joomla/application/web.php:1022 4 JApplicationWeb->loadDocument() JROOT/libraries/cms/application/site.php:130 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.36 ms Después de la última consulta: 1.27 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 7.109 MB Filas devueltas: 1
SELECT *
FROM oja8d_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_languages ALL NULL No pudo usarse una clave de índice NULL NULL 2 Using where; Usando 'filesort' Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sorting result 0.11 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.02 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.37 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 7.141 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.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.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.78 ms Después de la última consulta: 3.38 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 7.738 MB Filas devueltas: 30
SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`
WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_assets index_merge idx_asset_name,idx_parent_id idx_asset_name,idx_parent_id 202,4 NULL 33 Using sort_union(idx_asset_name,idx_parent_id); Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.04 ms checking permissions 0.00 ms Opening tables 0.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.22 ms preparing 0.01 ms executing 0.00 ms Sending data 0.34 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/access/access.php:427 16 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:211 15 JAccess::preload() JROOT/libraries/joomla/access/access.php:529 14 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:181 13 JAccess::check() JROOT/libraries/joomla/user/user.php:393 12 JUser->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/legacy/model/legacy.php:434 10 JModelLegacy->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.47 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 7.907 MB Filas devueltas: 30
SHOW FULL COLUMNS
FROM `oja8d_content`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `oja8d_content`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.02 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 closing tables 0.00 ms executing 0.00 ms Sending data 0.03 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1681 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:244 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:163 12 JTable->__construct() JROOT/libraries/legacy/table/content.php:33 11 JTableContent->__construct() JROOT/libraries/joomla/table/table.php:311 10 JTable::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.23 ms Después de la última consulta: 1.66 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 8.262 MB Filas devueltas: 1
SELECT *
FROM oja8d_content
WHERE `id` = '78'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE oja8d_content 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.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.02 ms preparing 0.00 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.00 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1445 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:729 10 JTable->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 64.88 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 8.277 MB
UPDATE oja8d_content
SET `hits` = (`hits` + 1)
WHERE `id` = '78''Explicar' no es posible en la consulta: UPDATE oja8d_content SET `hits` = (`hits` + 1) WHERE `id` = '78'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.02 ms Updating 0.03 ms end 0.00 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 64.67 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/table/table.php:1240 10 JTable->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.60 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 8.472 MB Filas devueltas: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM oja8d_content AS a
INNER JOIN oja8d_categories AS c
on c.id = a.catid
LEFT JOIN oja8d_users AS u
on u.id = a.created_by
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oja8d_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 78
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 12:52:24')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 12:52:24')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 unique row not found Status Duration starting 0.01 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.07 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.03 ms init 0.03 ms optimizing 0.02 ms statistics 0.24 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.01 ms freeing items 0.00 ms updating status 0.00 ms Waiting for query cache lock 0.00 ms updating status 0.01 ms Waiting for query cache lock 0.00 ms updating status 0.00 ms storing result in query cache 0.01 ms cleaning up 0.00 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1642 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/legacy/view/legacy.php:422 11 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.48 ms Después de la última consulta: 1.13 ms Consulta a la memoria: 0.036 MB memoria antes de la consulta: 8.642 MB Filas devueltas: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM oja8d_categories as c
LEFT JOIN oja8d_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=9
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Usando 'filesort' 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right No pudo usarse una clave de índice NULL NULL 17 Using where Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.05 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.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.00 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/legacy/categories/categories.php:301 21 JCategories->_load() JROOT/libraries/legacy/categories/categories.php:182 20 JCategories->get() JROOT/components/com_content/router.php:70 19 ContentRouter->getCategorySegment() Lo mismo que llamada de la línea de abajo. 18 call_user_func_array() JROOT/libraries/cms/component/router/view.php:117 17 JComponentRouterView->getPath() JROOT/libraries/cms/component/router/rules/menu.php:82 16 JComponentRouterRulesMenu->preprocess() JROOT/libraries/cms/component/router/view.php:219 15 JComponentRouterView->preprocess() JROOT/libraries/cms/router/site.php:660 14 JRouterSite->processBuildRules() JROOT/libraries/cms/router/router.php:267 13 JRouter->build() JROOT/libraries/cms/router/site.php:149 12 JRouterSite->build() JROOT/libraries/joomla/application/route.php:62 11 JRoute::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.47 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 8.695 MB Filas devueltas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `oja8d_contentitem_tag_map` AS m
INNER JOIN `oja8d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 78
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.16 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.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_content/views/article/view.html.php:180 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.77 ms Después de la última consulta: 3.11 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 9.313 MB Filas devueltas: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM oja8d_fields AS a
LEFT JOIN `oja8d_languages` AS l
ON l.lang_code = a.language
LEFT JOIN oja8d_users AS uc
ON uc.id=a.checked_out
LEFT JOIN oja8d_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN oja8d_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN oja8d_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `oja8d_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state
ORDER BY a.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Usando 'filesort' 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 centrodecomerciosada_org_ar.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 centrodecomerciosada_org_ar.a.id 1 Using where; Using index Status Duration starting 0.00 ms Waiting for query cache lock 0.00 ms checking query cache for query 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms Table lock 0.00 ms After table lock 0.00 ms Waiting for query cache lock 0.00 ms After table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.24 ms preparing 0.02 ms executing 0.00 ms Creating tmp table 0.13 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_content/views/article/view.html.php:190 10 ContentViewArticle->display() JROOT/libraries/legacy/controller/legacy.php:671 9 JControllerLegacy->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709 7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39 6 require_once JROOT/components/com_content/content.php JROOT/libraries/cms/component/helper.php:394 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.82 ms Después de la última consulta: 8.26 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 10.778 MB Filas devueltas: 6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM oja8d_modules AS m
LEFT JOIN oja8d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN oja8d_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-20 12:52:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 12:52:24')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 103 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 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.04 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.14 ms preparing 0.02 ms executing 0.00 ms Sorting result 0.23 ms Sending data 0.16 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 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
22 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `oja8d_extensions`1 × SELECT *
FROM oja8d_content1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `oja8d_assets`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM oja8d_content AS a
INNER JOIN oja8d_categories AS c
on c.id = a.catid
LEFT JOIN oja8d_users AS u
on u.id = a.created_by
LEFT JOIN oja8d_categories as parent
ON parent.id = c.parent_id
LEFT JOIN oja8d_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `oja8d_contentitem_tag_map` AS m
INNER JOIN `oja8d_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT 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.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, 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 `alias`,`catid`
FROM `oja8d_content`1 × 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 id, rules
FROM `oja8d_viewlevels1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM oja8d_extensions1 × SELECT `data`
FROM `oja8d_session`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM oja8d_menu AS m
LEFT JOIN oja8d_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM oja8d_languages
OTRAS tablas:
1 × UPDATE oja8d_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `oja8d_content1 × UPDATE `oja8d_extensions`
SET `params` = '{\"mediaversion\":\"e950107991e2d69837fd3aa440b4aef6\"}'1 × INSERT INTO `oja8d_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('ldmro75ou29tlkub2rbjo8qh73', 1, '1713617544', 0, '', 01 × DELETE
FROM `oja8d_session`