Tiempo de la consulta: 0.32 ms
SELECT `data`
FROM `vdj20_session`
WHERE `session_id` = 'u86eqng7rnphleoj436brmulh0'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_session | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 12 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:44 |
| 11 | JSessionStorageDatabase->read() | Lo mismo que llamada de la línea de abajo. |
| 10 | session_start() | JROOT/libraries/joomla/session/handler/native.php:79 |
| 9 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:81 |
| 8 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:628 |
| 7 | JSession->_start() | JROOT/libraries/joomla/session/session.php:596 |
| 6 | JSession->start() | JROOT/libraries/cms/application/cms.php:748 |
| 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:404 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:51 |
Tiempo de la consulta: 0.18 ms Después de la última consulta: 2.36 ms
SELECT `session_id`
FROM `vdj20_session`
WHERE `session_id` = 'u86eqng7rnphleoj436brmulh0'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_session | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 8 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:774 |
| 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:404 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:51 |
Tiempo de la consulta: 0.53 ms Después de la última consulta: 0.18 ms
INSERT INTO `vdj20_session`
(`session_id`, `client_id`, `time`)
VALUES
('u86eqng7rnphleoj436brmulh0', 0, '1534673416')
'Explicar' no es posible en la consulta: INSERT INTO `vdj20_session`
(`session_id`, `client_id`, `time`) VALUES
('u86eqng7rnphleoj436brmulh0', 0, '1534673416')
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 7 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/application/cms.php:208 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:774 |
| 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:404 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:51 |
Tiempo de la consulta: 0.29 ms Después de la última consulta: 5.35 ms
SELECT b.id
FROM vdj20_usergroups AS a
LEFT JOIN vdj20_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 5 | 100.00 | Using where; Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 10 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 9 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:354 |
| 8 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:423 |
| 7 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 6 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 5 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:163 |
| 4 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/site.php:589 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.58 ms
SELECT id, rules
FROM `vdj20_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_viewlevels | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 8 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 9 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 8 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:440 |
| 7 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 6 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 5 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:163 |
| 4 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/site.php:589 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.26 ms Después de la última consulta: 13.99 ms
SELECT `enabled`
FROM `vdj20_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 100.00 | Using index condition; Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 9 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:50 |
| 7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/cms/plugin/helper.php:230 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:662 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:663 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.39 ms Después de la última consulta: 25.96 ms
SELECT `network`
FROM `vdj20_sfw_networks`
WHERE `network` = 920677614& mask
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sfw_networks | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 2844 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1764 |
| 11 | JDatabaseDriver->loadRow() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2329 |
| 10 | plgSystemAntispambycleantalk->swf_init() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:504 |
| 9 | plgSystemAntispambycleantalk->onAfterInitialise() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:663 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:663 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.24 ms Después de la última consulta: 0.18 ms
SELECT `a`.`extension_id`
FROM `vdj20_extensions` AS `a`
WHERE `a`.`element` = 'antispambycleantalk'
AND `a`.`folder` = 'system'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ref | element_clientid,element_folder_clientid | element_folder_clientid | 604 | const,const | 1 | 100.00 | Using where; Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:217 |
| 11 | plgSystemAntispambycleantalk->getId() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2333 |
| 10 | plgSystemAntispambycleantalk->swf_init() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:504 |
| 9 | plgSystemAntispambycleantalk->onAfterInitialise() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:663 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:663 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.10 ms
SELECT `a`.`extension_id`
FROM `vdj20_extensions` AS `a`
WHERE `a`.`element` = 'antispambycleantalk'
AND `a`.`folder` = 'system'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ref | element_clientid,element_folder_clientid | element_folder_clientid | 604 | const,const | 1 | 100.00 | Using where; Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 12 | JDatabaseDriver->loadObject() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:219 |
| 11 | plgSystemAntispambycleantalk->getId() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2333 |
| 10 | plgSystemAntispambycleantalk->swf_init() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:504 |
| 9 | plgSystemAntispambycleantalk->onAfterInitialise() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:663 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:663 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.76 ms Después de la última consulta: 0.55 ms
SHOW FULL COLUMNS
FROM `vdj20_extensions`
'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `vdj20_extensions`
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 15 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 14 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 13 | JTable->__construct() | JROOT/libraries/joomla/table/extension.php:30 |
| 12 | JTableExtension->__construct() | JROOT/libraries/joomla/table/table.php:305 |
| 11 | JTable::getInstance() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2336 |
| 10 | plgSystemAntispambycleantalk->swf_init() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:504 |
| 9 | plgSystemAntispambycleantalk->onAfterInitialise() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:663 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:663 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.88 ms
SELECT *
FROM vdj20_extensions
WHERE `extension_id` = '10385'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 12 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:728 |
| 11 | JTable->load() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2337 |
| 10 | plgSystemAntispambycleantalk->swf_init() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:504 |
| 9 | plgSystemAntispambycleantalk->onAfterInitialise() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:663 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:663 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.61 ms Después de la última consulta: 1.71 ms
UPDATE `vdj20_extensions`
SET `name`='Antispam by CleanTalk',`type`='plugin',`element`='antispambycleantalk',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"Antispam by CleanTalk\",\"type\":\"plugin\",\"creationDate\":\"26.04.2016\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"welcome@cleantalk.org\",\"authorUrl\":\"cleantalk.org\",\"version\":\"4.0.1\",\"description\":\"PLG_CLEANTALK_DESCRIPTION\",\"
group\":\"\",\"filename\":\"antispambycleantalk\"}',`params`='{\"apikey\":\"uvanyzevy6uv\",\"general_contact_forms_test\":\"1\",\"sfw_enable\":\"1\",\"sfw_last_check\":1534658447,\"sfw_check_interval\":\"86400\",\"sfw_reload_timeout\":\"3\",\"sfw_last_send_log\":1533670785,\"server\":\"http:\\/\\/moderate.cleantalk.org\",\"user_token\":\"\",\"last_status\":0,\"show_notice\":\"0\",\"last_checked\":1534521164,\"ip_license\":\"\",\"moderate_ip\":\"\",\"groups\":[\"1\"],\"sfw_min_mask\":4294966784,\"sfw_max_mask\":4294967295,\"sfw_log\":[]}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='0',`state`='0'
WHERE `extension_id`='10385'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_extensions | range | PRIMARY | PRIMARY | 4 | NULL | 1 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:2279 |
| 12 | JDatabaseDriver->updateObject() | JROOT/libraries/joomla/table/table.php:802 |
| 11 | JTable->store() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2396 |
| 10 | plgSystemAntispambycleantalk->swf_init() | JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:504 |
| 9 | plgSystemAntispambycleantalk->onAfterInitialise() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:663 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:663 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 2.64 ms Después de la última consulta: 5.50 ms
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 vdj20_menu AS m
LEFT JOIN vdj20_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.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | No pudo usarse una clave de índice | NULL | NULL | 620 | 84.35 | Using where; Usando 'filesort' |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | decohunt_deco_restore.m.component_id | 1 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
| 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:133 |
| 11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:435 |
| 10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:57 |
| 8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:196 |
| 7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:531 |
| 6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:407 |
| 5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1097 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.69 ms Después de la última consulta: 23.59 ms
UPDATE `vdj20_extensions`
SET `params` = '{\"mediaversion\":\"d5984e47b59f5272b6ee523c15abc911\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_extensions | range | element_clientid,element_folder_clientid,extension | extension | 364 | NULL | 1 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/cms/library/helper.php:119 |
| 15 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:325 |
| 14 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:284 |
| 13 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:737 |
| 12 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 11 | JFactory::getDocument() | JROOT/plugins/system/cdnforjoomla/cdnforjoomla.php:63 |
| 10 | PlgSystemCDNforJoomla->getHelper() | JROOT/plugins/system/cdnforjoomla/cdnforjoomla.php:28 |
| 9 | PlgSystemCDNforJoomla->onAfterRoute() | Lo mismo que llamada de la línea de abajo. |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1107 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:763 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.27 ms Después de la última consulta: 26.95 ms
SELECT *
FROM vdj20_sobipro_object
WHERE ( id ='167' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_object | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:855 |
| 10 | SPJoomlaDb->loadObject() | JROOT/components/com_sobipro/lib/base/factory.php:197 |
| 9 | SPFactory::object() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:190 |
| 8 | SobiProCtrl->getSection() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:103 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.19 ms
SELECT pid
FROM vdj20_sobipro_relations
WHERE ( id ='167' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_relations | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 10 | JDatabaseDriver->loadResult() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:803 |
| 9 | SPJoomlaDb->loadResult() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:201 |
| 8 | SobiProCtrl->getSection() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:103 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.16 ms Después de la última consulta: 0.13 ms
SELECT pid
FROM vdj20_sobipro_relations
WHERE ( id ='84' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_relations | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 10 | JDatabaseDriver->loadResult() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:803 |
| 9 | SPJoomlaDb->loadResult() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:201 |
| 8 | SobiProCtrl->getSection() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:103 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.16 ms
SELECT *
FROM vdj20_sobipro_object
WHERE ( id ='84' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_object | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 11 | JDatabaseDriver->loadObject() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:855 |
| 10 | SPJoomlaDb->loadObject() | JROOT/components/com_sobipro/lib/base/factory.php:197 |
| 9 | SPFactory::object() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:212 |
| 8 | SobiProCtrl->getSection() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:103 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.69 ms Después de la última consulta: 3.03 ms
SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue
FROM vdj20_sobipro_config
WHERE ( section IN ( '0','84' ) )
ORDER BY section, configsection
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_config | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 216 | 100.00 | Using where; Usando 'filesort' |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:881 |
| 10 | SPJoomlaDb->loadObjectList() | JROOT/components/com_sobipro/lib/base/config.php:190 |
| 9 | SPConfig->addTable() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:173 |
| 8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.24 ms Después de la última consulta: 2.87 ms
SELECT *
FROM vdj20_sobipro_field
WHERE ( fid ='41' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_field | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 12 | JDatabaseDriver->loadObject() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:855 |
| 11 | SPJoomlaDb->loadObject() | JROOT/components/com_sobipro/lib/models/field.php:365 |
| 10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
| 9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:177 |
| 8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.19 ms Después de la última consulta: 1.01 ms
Consultas duplicadas:
#38SELECT pid
FROM vdj20_sobipro_plugins
WHERE ( enabled ='1' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_plugins | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 26 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 14 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:51 |
| 13 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:154 |
| 12 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:227 |
| 11 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/models/field.php:366 |
| 10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
| 9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:177 |
| 8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.24 ms
SELECT pid
FROM vdj20_sobipro_plugin_task
WHERE ( onAction IN ( '*','*' ) )
AND ( pid IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','es-ES','mod_sobipro_geomap','notifications','collection','stgallery','geomap_field','info','contact_field','review_rating','router','promotedentries','promotedentries_field','promovalidation_field','promogeomap_field' ) )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_plugin_task | index | pid | pid | 757 | NULL | 24 | 100.00 | Using where; Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 14 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:61 |
| 13 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:154 |
| 12 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:227 |
| 11 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/models/field.php:366 |
| 10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
| 9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:177 |
| 8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.16 ms
SELECT pid
FROM vdj20_sobipro_plugin_section
WHERE ( section ='84' )
AND ( enabled ='1' )
AND ( pid IN ( 'notifications','promotedentries' ) )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_plugin_section | range | PRIMARY | PRIMARY | 156 | NULL | 2 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 14 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:71 |
| 13 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:154 |
| 12 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:227 |
| 11 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/models/field.php:366 |
| 10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
| 9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:177 |
| 8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 1.10 ms Después de la última consulta: 5.52 ms
SELECT sValue,sKey
FROM vdj20_sobipro_language
WHERE ( fid ='41' )
AND ( sKey IN ( 'name','description','suffix' ) )
AND ( oType ='field' )
ORDER BY FIELD( language, 'es-ES', '%' ) ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_language | ALL | PRIMARY,sKey | No pudo usarse una clave de índice | NULL | NULL | 2085 | 25.66 | Using where; Usando 'filesort' |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84 |
| 13 | SPDb->loadAssocList() | JROOT/components/com_sobipro/lib/models/field.php:490 |
| 12 | SPField->loadTables() | JROOT/components/com_sobipro/lib/models/field.php:386 |
| 11 | SPField->extend() | JROOT/components/com_sobipro/lib/models/field.php:370 |
| 10 | SPField->init() | JROOT/components/com_sobipro/lib/base/config.php:76 |
| 9 | SPConfig->init() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:177 |
| 8 | SobiProCtrl->createConfig() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.87 ms Después de la última consulta: 1.67 ms
SELECT id AS id, sKey AS label, sValue AS value, language
FROM vdj20_sobipro_language
WHERE ( id ='84' )
AND ( oType ='section' )
AND ( sKey IN ( 'name' ) )
ORDER BY FIELD( language, 'es-ES', 'es-ES' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_language | ref | PRIMARY,sKey | sKey | 452 | const | 121 | 100.00 | Using index condition; Using where; Usando 'filesort' |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 11 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 10 | JDatabaseDriver->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84 |
| 9 | SPDb->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:702 |
| 8 | SPJoomlaLang::translateObject() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:139 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.28 ms Después de la última consulta: 0.34 ms
SELECT rel.gid
FROM vdj20_sobipro_user_group AS grp
LEFT JOIN vdj20_sobipro_users_relation AS rel
ON grp.gid = rel.gid
WHERE ( ( rel.validUntil > '2018-08-19 10:10:16' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1969-12-31 19:00:00' ) )
AND ( rel.validSince < '2018-08-19 10:10:16' OR rel.validSince IN( '0000-00-00 00:00:00', '1969-12-31 19:00:00' ) )
AND grp.enabled = 1 )
AND ( uid ='0' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | grp | ALL | PRIMARY | No pudo usarse una clave de índice | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | rel | ref | PRIMARY | PRIMARY | 8 | const,decohunt_deco_restore.grp.gid | 1 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 14 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:101 |
| 13 | SPJoomlaUser->spGroups() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:43 |
| 12 | SPUser->__construct() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:387 |
| 11 | SPJoomlaUser::getCurrent() | JROOT/components/com_sobipro/lib/base/factory.php:111 |
| 10 | SPFactory::user() | JROOT/components/com_sobipro/lib/sobi.php:439 |
| 9 | Sobi::My() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:264 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.18 ms Después de la última consulta: 0.15 ms
SELECT parent.id, parent.lft, parent.rgt
FROM vdj20_usergroups AS parent
ORDER BY parent.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | parent | index | NULL | idx_usergroup_nested_set_lookup | 8 | NULL | 12 | 100.00 | Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:176 |
| 15 | JAccess::getGroupPath() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:220 |
| 14 | SAccess::parentGroups() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:78 |
| 13 | SPUser->parentGids() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:45 |
| 12 | SPUser->__construct() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:387 |
| 11 | SPJoomlaUser::getCurrent() | JROOT/components/com_sobipro/lib/base/factory.php:111 |
| 10 | SPFactory::user() | JROOT/components/com_sobipro/lib/sobi.php:439 |
| 9 | Sobi::My() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:264 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.47 ms Después de la última consulta: 0.83 ms
SELECT fileName,template,configFile,cid
FROM vdj20_sobipro_view_cache
WHERE ( section ='84' )
AND ( sid ='167' )
AND ( task ='entry.details' )
AND ( site ='1' )
AND ( request ='{Itemid:1427}' )
AND ( language ='es-ES' )
AND ( userGroups ='[]' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_view_cache | ref | sid,section,language,task,request,site,userGroups | task | 102 | const | 1 | 100.00 | Using index condition; Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1764 |
| 11 | JDatabaseDriver->loadRow() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:898 |
| 10 | SPJoomlaDb->loadRow() | JROOT/components/com_sobipro/lib/base/cache.php:724 |
| 9 | SPCache->view() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:271 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 30.19 ms Después de la última consulta: 0.22 ms
SELECT fileName,template,configFile,cid
FROM vdj20_sobipro_view_cache
WHERE ( section ='84' )
AND ( sid ='167' )
AND ( task ='' )
AND ( site ='1' )
AND ( request ='[]' )
AND ( language ='es-ES' )
AND ( userGroups ='[]' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_view_cache | index_merge | sid,section,language,task,request,site,userGroups | sid,section,site,language,request | 4,4,4,17,257 | NULL | 10 | 80.00 | Using intersect(sid,section,site,language,request); Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1764 |
| 11 | JDatabaseDriver->loadRow() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:898 |
| 10 | SPJoomlaDb->loadRow() | JROOT/components/com_sobipro/lib/base/cache.php:730 |
| 9 | SPCache->view() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:271 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.25 ms Después de la última consulta: 12.34 ms
SELECT *
FROM vdj20_sobipro_category
WHERE ( id ='167' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_category | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:855 |
| 13 | SPJoomlaDb->loadObject() | JROOT/components/com_sobipro/lib/models/dbobject.php:714 |
| 12 | SPDBObject->loadTable() | JROOT/components/com_sobipro/lib/models/category.php:154 |
| 11 | SPCategory->loadTable() | JROOT/components/com_sobipro/lib/models/dbobject.php:660 |
| 10 | SPDBObject->extend() | JROOT/components/com_sobipro/lib/ctrl/controller.php:70 |
| 9 | SPController->extend() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:302 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.19 ms Después de la última consulta: 0.17 ms
SELECT counter
FROM vdj20_sobipro_counter
WHERE ( sid ='167' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_counter | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 14 | JDatabaseDriver->loadResult() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:803 |
| 13 | SPJoomlaDb->loadResult() | JROOT/components/com_sobipro/lib/models/dbobject.php:716 |
| 12 | SPDBObject->loadTable() | JROOT/components/com_sobipro/lib/models/category.php:154 |
| 11 | SPCategory->loadTable() | JROOT/components/com_sobipro/lib/models/dbobject.php:660 |
| 10 | SPDBObject->extend() | JROOT/components/com_sobipro/lib/ctrl/controller.php:70 |
| 9 | SPController->extend() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:302 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 1.36 ms Después de la última consulta: 0.33 ms
SELECT id AS id, sKey AS label, sValue AS value, language
FROM vdj20_sobipro_language
WHERE ( id ='167' )
AND ( sKey IN ( 'description','introtext','name','metaKeys','metaDesc','nid','metaDesc','metaKeys' ) )
ORDER BY FIELD( language, 'es-ES', 'es-ES' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_language | ALL | PRIMARY,sKey | No pudo usarse una clave de índice | NULL | NULL | 2085 | 58.23 | Using where; Usando 'filesort' |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 16 | JDatabaseDriver->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84 |
| 15 | SPDb->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:702 |
| 14 | SPJoomlaLang::translateObject() | JROOT/components/com_sobipro/lib/models/dbobject.php:742 |
| 13 | SPDBObject->translate() | JROOT/components/com_sobipro/lib/models/dbobject.php:733 |
| 12 | SPDBObject->loadTable() | JROOT/components/com_sobipro/lib/models/category.php:154 |
| 11 | SPCategory->loadTable() | JROOT/components/com_sobipro/lib/models/dbobject.php:660 |
| 10 | SPDBObject->extend() | JROOT/components/com_sobipro/lib/ctrl/controller.php:70 |
| 9 | SPController->extend() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:302 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.33 ms
SELECT position,pid
FROM vdj20_sobipro_relations
WHERE ( id ='167' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_relations | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:855 |
| 12 | SPJoomlaDb->loadObject() | JROOT/components/com_sobipro/lib/models/category.php:160 |
| 11 | SPCategory->loadTable() | JROOT/components/com_sobipro/lib/models/dbobject.php:660 |
| 10 | SPDBObject->extend() | JROOT/components/com_sobipro/lib/ctrl/controller.php:70 |
| 9 | SPController->extend() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:302 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.56 ms Después de la última consulta: 0.35 ms
INSERT INTO vdj20_sobipro_counter (`sid`,`counter`,`lastUpdate`)
VALUES ('167','42054','2018-08-19 10:10:17')
ON DUPLICATE KEY UPDATE sid = '167',counter = '42054',lastUpdate = '2018-08-19 10:10:17'
'Explicar' no es posible en la consulta: INSERT INTO vdj20_sobipro_counter (`sid`,`counter`,`lastUpdate`) VALUES ('167','42054','2018-08-19 10:10:17') ON DUPLICATE KEY UPDATE sid = '167',counter = '42054',lastUpdate = '2018-08-19 10:10:17'
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 14 | JDatabaseDriverMysql->execute() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:791 |
| 13 | SPJoomlaDb->query() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:955 |
| 12 | SPJoomlaDb->exec() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:756 |
| 11 | SPJoomlaDb->insertUpdate() | JROOT/components/com_sobipro/lib/models/dbobject.php:513 |
| 10 | SPDBObject->countVisit() | JROOT/components/com_sobipro/lib/ctrl/controller.php:72 |
| 9 | SPController->extend() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:302 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.29 ms
SELECT DISTINCT sprl.rid
FROM vdj20_sobipro_permissions_groups AS spgr
LEFT JOIN vdj20_sobipro_permissions_rules AS sprl
ON spgr.rid = sprl.rid
WHERE ( ( sprl.validUntil > '2018-08-19 10:10:17' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1969-12-31 19:00:00' ) )
AND ( sprl.validSince < '2018-08-19 10:10:17' OR sprl.validSince IN( '0000-00-00 00:00:00', '1969-12-31 19:00:00' ) )
AND state = 1 )
AND spgr.gid in( 0 )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | sprl | ALL | PRIMARY | No pudo usarse una clave de índice | NULL | NULL | 8 | 100.00 | Using where; Using temporary |
| 1 | SIMPLE | spgr | eq_ref | PRIMARY | PRIMARY | 8 | decohunt_deco_restore.sprl.rid,const | 1 | 100.00 | Using index; Distinct |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 14 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:181 |
| 13 | SPUser->getPermissions() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240 |
| 12 | SPJoomlaUser->authorisePermission() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180 |
| 11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:248 |
| 10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:343 |
| 9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:339 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.19 ms
SELECT pid
FROM vdj20_sobipro_permissions_map
WHERE ( sid ='84' )
AND ( rid IN ( '1','3','5','6','8','9' ) )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_permissions_map | index | PRIMARY | PRIMARY | 12 | NULL | 35 | 51.43 | Using where; Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 14 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:189 |
| 13 | SPUser->getPermissions() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240 |
| 12 | SPJoomlaUser->authorisePermission() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180 |
| 11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:248 |
| 10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:343 |
| 9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:339 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.21 ms
SELECT *
FROM vdj20_sobipro_permissions
WHERE ( site ='front' )
AND ( published ='1' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_permissions | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 44 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 15 | JDatabaseDriver->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84 |
| 14 | SPDb->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:197 |
| 13 | SPUser->getPermissions() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:240 |
| 12 | SPJoomlaUser->authorisePermission() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180 |
| 11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:248 |
| 10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:343 |
| 9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:339 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.34 ms
Consultas duplicadas:
#21SELECT pid
FROM vdj20_sobipro_plugins
WHERE ( enabled ='1' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_plugins | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 26 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 15 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:51 |
| 14 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:154 |
| 13 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:227 |
| 12 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182 |
| 11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:248 |
| 10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:343 |
| 9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:339 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.28 ms
SELECT pid
FROM vdj20_sobipro_plugin_task
WHERE ( onAction IN ( '*','category.view','category.*' ) )
AND ( pid IN ( 'bank_transfer','paypal','chbxgroup','email','image','inbox','multiselect','radio','select','textarea','url','category','es-ES','mod_sobipro_geomap','notifications','collection','stgallery','geomap_field','info','contact_field','review_rating','router','promotedentries','promotedentries_field','promovalidation_field','promogeomap_field' ) )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_plugin_task | index | pid | pid | 757 | NULL | 24 | 100.00 | Using where; Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 15 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:61 |
| 14 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:154 |
| 13 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:227 |
| 12 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182 |
| 11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:248 |
| 10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:343 |
| 9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:339 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.21 ms
SELECT pid
FROM vdj20_sobipro_plugin_section
WHERE ( section ='84' )
AND ( enabled ='1' )
AND ( pid IN ( 'collection','notifications','promotedentries','review_rating' ) )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_plugin_section | range | PRIMARY | PRIMARY | 156 | NULL | 4 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 16 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 15 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/plugins/interface.php:71 |
| 14 | SPPlugins->load() | JROOT/components/com_sobipro/lib/plugins/interface.php:154 |
| 13 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:227 |
| 12 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182 |
| 11 | SPJoomlaUser->can() | JROOT/components/com_sobipro/lib/sobi.php:248 |
| 10 | Sobi::Can() | JROOT/components/com_sobipro/lib/ctrl/controller.php:343 |
| 9 | SPController->visible() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:339 |
| 8 | SobiProCtrl->route() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:151 |
| 7 | SobiProCtrl->__construct() | JROOT/components/com_sobipro/sobipro.php:48 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.28 ms Después de la última consulta: 13.49 ms
SELECT *
FROM vdj20_sobipro_registry
WHERE ( section ='messages' )
ORDER BY value
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_registry | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 67 | 100.00 | Using where; Usando 'filesort' |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:881 |
| 14 | SPJoomlaDb->loadObjectList() | JROOT/components/com_sobipro/lib/base/registry.php:137 |
| 13 | SPRegistry->loadDBSection() | JROOT/components/com_sobipro/lib/base/message.php:42 |
| 12 | SPMessage->__construct() | JROOT/components/com_sobipro/lib/base/message.php:179 |
| 11 | SPMessage::getInstance() | JROOT/components/com_sobipro/lib/base/factory.php:162 |
| 10 | SPFactory::message() | JROOT/components/com_sobipro/lib/views/cache.php:145 |
| 9 | SPCachedView->parseXml() | JROOT/components/com_sobipro/lib/views/cache.php:71 |
| 8 | SPCachedView->cachedView() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:546 |
| 7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:49 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.32 ms
SELECT *
FROM vdj20_sobipro_registry
WHERE ( section ='reports' )
ORDER BY value
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_registry | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 67 | 100.00 | Using where; Usando 'filesort' |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:881 |
| 14 | SPJoomlaDb->loadObjectList() | JROOT/components/com_sobipro/lib/base/registry.php:137 |
| 13 | SPRegistry->loadDBSection() | JROOT/components/com_sobipro/lib/base/message.php:48 |
| 12 | SPMessage->__construct() | JROOT/components/com_sobipro/lib/base/message.php:179 |
| 11 | SPMessage::getInstance() | JROOT/components/com_sobipro/lib/base/factory.php:162 |
| 10 | SPFactory::message() | JROOT/components/com_sobipro/lib/views/cache.php:145 |
| 9 | SPCachedView->parseXml() | JROOT/components/com_sobipro/lib/views/cache.php:71 |
| 8 | SPCachedView->cachedView() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:546 |
| 7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:49 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.81 ms
SELECT sid
FROM vdj20_sobipro_view_cache_relation
WHERE ( cid ='4204' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_view_cache_relation | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 12 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66 |
| 10 | SPDb->loadResultArray() | JROOT/components/com_sobipro/lib/views/cache.php:80 |
| 9 | SPCachedView->validateData() | JROOT/components/com_sobipro/lib/views/cache.php:72 |
| 8 | SPCachedView->cachedView() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:546 |
| 7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:49 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.46 ms Después de la última consulta: 8.30 ms
SELECT sValue,language
FROM vdj20_sobipro_language
WHERE ( sKey ='collection.link-label' )
AND ( oType ='application' )
AND ( language IN ( 'es-ES','en-GB' ) )
AND ( section ='84' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_sobipro_language | ref | PRIMARY,sKey,section,language | sKey | 452 | const | 1 | 100.00 | Using index condition; Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 17 | JDatabaseDriver->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84 |
| 16 | SPDb->loadAssocList() | JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:414 |
| 15 | SPJoomlaLang::getValue() | JROOT/components/com_sobipro/opt/plugins/collection/init.php:299 |
| 14 | SPCollectionApp->getOutput() | JROOT/components/com_sobipro/opt/plugins/collection/init.php:112 |
| 13 | SPCollectionApp->TemplateEngineSetData() | Lo mismo que llamada de la línea de abajo. |
| 12 | call_user_func_array() | JROOT/components/com_sobipro/lib/plugins/interface.php:166 |
| 11 | SPPlugins->trigger() | JROOT/components/com_sobipro/lib/sobi.php:227 |
| 10 | Sobi::Trigger() | JROOT/components/com_sobipro/lib/mlo/template_xslt.php:378 |
| 9 | SPTemplateXSLT->setData() | JROOT/components/com_sobipro/lib/views/view.php:290 |
| 8 | SPFrontView->display() | JROOT/components/com_sobipro/lib/ctrl/sobipro.php:547 |
| 7 | SobiProCtrl->execute() | JROOT/components/com_sobipro/sobipro.php:49 |
| 6 | require_once JROOT/components/com_sobipro/sobipro.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 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:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 4.04 ms Después de la última consulta: 38.17 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vdj20_modules AS m
LEFT JOIN vdj20_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vdj20_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 <= '2018-08-19 10:10:17')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-08-19 10:10:17')
AND m.access IN (1,1,4)
AND m.client_id = 0
AND (mm.menuid = 1427 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 206 | 100.00 | Using index condition; Using where; Usando 'filesort' |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | decohunt_deco_restore.m.module,const | 1 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | decohunt_deco_restore.m.id | 6 | 100.00 | Using where; Using index |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 13 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/module/helper.php:409 |
| 11 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:352 |
| 10 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 9 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:501 |
| 8 | JDocumentHtml->countModules() | JROOT/templates/decohunter/index.php:250 |
| 7 | require JROOT/templates/decohunter/index.php | JROOT/libraries/joomla/document/html.php:578 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:635 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:455 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1054 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.21 ms Después de la última consulta: 24.83 ms
SELECT `params`
FROM `vdj20_comprofiler_plugin`
WHERE `id` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_comprofiler_plugin | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 29 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 28 | JDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 |
| 27 | CBLib\Database\Driver\CmsDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CB/Application/CBConfig.php:43 |
| 26 | CB\Application\CBConfig::getConfig() | JROOT/libraries/CBLib/CB/Application/CBApplication.php:44 |
| 25 | CB\Application\CBApplication::CB\Application\{closure}() | Lo mismo que llamada de la línea de abajo. |
| 24 | call_user_func_array() | JROOT/libraries/CBLib/CBLib/Application/Config.php:38 |
| 23 | CBLib\Application\Config::setMainConfig() | JROOT/libraries/CBLib/CBLib/Core/CBLib.php:69 |
| 22 | CBLib\Core\CBLib::CBLib\Core\{closure}() | JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605 |
| 21 | CBLib\DependencyInjection\Container->build() | JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496 |
| 20 | CBLib\DependencyInjection\Container->make() | JROOT/libraries/CBLib/CBLib/Application/Application.php:179 |
| 19 | CBLib\Application\Application::__callStatic() | JROOT/libraries/CBLib/CB/Application/CBConfig.php:77 |
| 18 | CBLib\Application\Application::Config() | JROOT/libraries/CBLib/CB/Application/CBConfig.php:77 |
| 17 | CB\Application\CBConfig::loadLegacyCBueConfig() | JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109 |
| 16 | CB\Legacy\LegacyFoundationFunctions->__construct() | Lo mismo que llamada de la línea de abajo. |
| 15 | ReflectionClass->newInstanceArgs() | JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643 |
| 14 | CBLib\DependencyInjection\Container->build() | JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496 |
| 13 | CBLib\DependencyInjection\Container->make() | JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132 |
| 12 | CBLib\DependencyInjection\Container->get() | JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33 |
| 11 | include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php | JROOT/modules/mod_cblogin/mod_cblogin.php:17 |
| 10 | include JROOT/modules/mod_cblogin/mod_cblogin.php | JROOT/libraries/cms/module/helper.php:190 |
| 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:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.37 ms Después de la última consulta: 14.64 ms
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `vdj20_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1,4)
AND `type` = 'user'
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_comprofiler_plugin | ALL | idx_folder,type_pub_order | No pudo usarse una clave de índice | NULL | NULL | 15 | 73.33 | Using where; Usando 'filesort' |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394 |
| 13 | CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446 |
| 12 | CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList() | JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:180 |
| 11 | cbPluginHandler->loadPluginGroup() | JROOT/modules/mod_cblogin/mod_cblogin.php:29 |
| 10 | include JROOT/modules/mod_cblogin/mod_cblogin.php | JROOT/libraries/cms/module/helper.php:190 |
| 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:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.99 ms Después de la última consulta: 40.75 ms
SHOW FULL COLUMNS
FROM `vdj20_users`
'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `vdj20_users`
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 23 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 20 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 19 | JTable->__construct() | JROOT/libraries/joomla/table/user.php:38 |
| 18 | JTableUser->__construct() | JROOT/libraries/joomla/table/table.php:305 |
| 17 | JTable::getInstance() | JROOT/libraries/joomla/user/user.php:582 |
| 16 | JUser::getTable() | JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:152 |
| 15 | CB\Database\Table\UserTable->_reinitNonComprofileVars() | JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:112 |
| 14 | CB\Database\Table\UserTable->__construct() | JROOT/libraries/CBLib/CB/Legacy/CBuser.php:198 |
| 13 | CBuser::_getOrSetInstance() | JROOT/libraries/CBLib/CB/Legacy/CBuser.php:86 |
| 12 | CBuser::getInstance() | JROOT/libraries/CBLib/CB/Legacy/CBuser.php:70 |
| 11 | CBuser::getMyInstance() | JROOT/modules/mod_cblogin/mod_cblogin.php:33 |
| 10 | include JROOT/modules/mod_cblogin/mod_cblogin.php | JROOT/libraries/cms/module/helper.php:190 |
| 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:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 1.00 ms Después de la última consulta: 3.30 ms
SELECT f.*
FROM vdj20_comprofiler_fields f
INNER JOIN vdj20_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
ORDER BY t.position, t.ordering, f.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | f | ALL | tabid_pub_prof_order | No pudo usarse una clave de índice | NULL | NULL | 39 | 76.92 | Using where; Using temporary; Usando 'filesort' |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | decohunt_deco_restore.f.tabid | 1 | 100.00 | |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 20 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 19 | JDatabaseDriver->loadAssocList() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394 |
| 18 | CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446 |
| 17 | CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList() | JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:921 |
| 16 | cbTabs->_getTabFieldsDb() | JROOT/libraries/CBLib/CB/Legacy/CBuser.php:338 |
| 15 | CBuser->getField() | JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1013 |
| 14 | CBuser->_evaluateCbFields() | Lo mismo que llamada de la línea de abajo. |
| 13 | preg_replace_callback() | JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1063 |
| 12 | CBuser->_evaluateCbFields() | JROOT/libraries/CBLib/CB/Legacy/CBuser.php:621 |
| 11 | CBuser->replaceUserVars() | JROOT/modules/mod_cblogin/mod_cblogin.php:82 |
| 10 | include JROOT/modules/mod_cblogin/mod_cblogin.php | JROOT/libraries/cms/module/helper.php:190 |
| 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:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 1.25 ms Después de la última consulta: 2.22 ms
SELECT `id`
FROM `vdj20_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler' OR `link` LIKE 'index.php?option=com_comprofiler&task=userprofile' OR `link` LIKE 'index.php?option=com_comprofiler&view=userprofile' )
AND `published` = 1
AND `access` IN ( 1,4 )
AND `language` IN ( 'es-ES', '*', '' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_menu | ALL | idx_language | No pudo usarse una clave de índice | NULL | NULL | 620 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 |
| 14 | CBLib\Database\Driver\CmsDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:262 |
| 13 | getCBprofileItemid() | JROOT/libraries/CBLib/CB/Legacy/CBframework.php:922 |
| 12 | CBframework->viewUrl() | JROOT/libraries/CBLib/CB/Legacy/CBframework.php:826 |
| 11 | CBframework->userProfileUrl() | JROOT/modules/mod_cblogin/mod_cblogin.php:146 |
| 10 | include JROOT/modules/mod_cblogin/mod_cblogin.php | JROOT/libraries/cms/module/helper.php:190 |
| 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:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.19 ms
SELECT `id`
FROM `vdj20_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&task=userslist' OR `link` LIKE 'index.php?option=com_comprofiler&view=userslist' )
AND `published` = 1
AND `access` IN ( 1,4 )
AND `language` IN ( 'es-ES', '*', '' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_menu | ALL | idx_language | No pudo usarse una clave de índice | NULL | NULL | 620 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 |
| 14 | CBLib\Database\Driver\CmsDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:281 |
| 13 | getCBprofileItemid() | JROOT/libraries/CBLib/CB/Legacy/CBframework.php:922 |
| 12 | CBframework->viewUrl() | JROOT/libraries/CBLib/CB/Legacy/CBframework.php:826 |
| 11 | CBframework->userProfileUrl() | JROOT/modules/mod_cblogin/mod_cblogin.php:146 |
| 10 | include JROOT/modules/mod_cblogin/mod_cblogin.php | JROOT/libraries/cms/module/helper.php:190 |
| 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:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.99 ms Después de la última consulta: 5.83 ms
SELECT `id`
FROM `vdj20_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&task=login%' OR `link` LIKE 'index.php?option=com_comprofiler&view=login%' )
AND `published` = 1
AND `access` IN ( 1,4 )
AND `language` IN ( 'es-ES', '*', '' )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_menu | ALL | idx_language | No pudo usarse una clave de índice | NULL | NULL | 620 | 100.00 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 16 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1731 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345 |
| 14 | CBLib\Database\Driver\CmsDatabaseDriver->loadResult() | JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222 |
| 13 | getCBprofileItemid() | JROOT/libraries/CBLib/CB/Legacy/CBframework.php:922 |
| 12 | CBframework->viewUrl() | JROOT/templates/decohunter/html/mod_cblogin/default.php:21 |
| 11 | require JROOT/templates/decohunter/html/mod_cblogin/default.php | JROOT/modules/mod_cblogin/mod_cblogin.php:167 |
| 10 | include JROOT/modules/mod_cblogin/mod_cblogin.php | JROOT/libraries/cms/module/helper.php:190 |
| 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:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:697 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1068 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:745 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:263 |
| 1 | JApplicationCms->execute() | JROOT/index.php:54 |
Tiempo de la consulta: 0.98 ms Después de la última consulta: 0.70 ms
.jpg){kind=logo}
_field_imagen_interna.jpg)
-
