Tiempo de la consulta: 0.73 ms
SELECT `data`
FROM `vdj20_session`
WHERE `session_id` = '39qd1mv3bscemp22vgjnt69ca3'
| 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.78 ms Después de la última consulta: 2.64 ms
SELECT `session_id`
FROM `vdj20_session`
WHERE `session_id` = '39qd1mv3bscemp22vgjnt69ca3'
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: 1.02 ms Después de la última consulta: 0.24 ms
INSERT INTO `vdj20_session`
(`session_id`, `client_id`, `time`)
VALUES
('39qd1mv3bscemp22vgjnt69ca3', 0, '1539785090')
'Explicar' no es posible en la consulta: INSERT INTO `vdj20_session`
(`session_id`, `client_id`, `time`) VALUES
('39qd1mv3bscemp22vgjnt69ca3', 0, '1539785090')
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: 1.12 ms Después de la última consulta: 5.49 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: 1.31 ms Después de la última consulta: 0.62 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.87 ms Después de la última consulta: 15.12 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.28 ms Después de la última consulta: 30.36 ms
SELECT `network`
FROM `vdj20_sfw_networks`
WHERE `network` = 920713002& 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 | 13 | 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: 1.06 ms Después de la última consulta: 0.17 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.24 ms Después de la última consulta: 0.12 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: 1.37 ms Después de la última consulta: 0.58 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: 1.12 ms Después de la última consulta: 0.98 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: 1.06 ms Después de la última consulta: 2.16 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\":1539738566,\"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\":1539727413,\"ip_license\":\"\",\"moderate_ip\":\"\",\"groups\":[\"1\"],\"sfw_min_mask\":4294967295,\"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: 5.50 ms Después de la última consulta: 8.29 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: 3.46 ms Después de la última consulta: 35.25 ms
SELECT a.rules
FROM vdj20_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| 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 | |
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:1541 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:246 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:384 |
| 15 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:544 |
| 14 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:517 |
| 13 | VmConfig->__construct() | JROOT/administrator/components/com_virtuemart/helpers/config.php:806 |
| 12 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:779 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:339 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 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.25 ms Después de la última consulta: 0.77 ms
SELECT b.rules
FROM vdj20_assets AS a
LEFT JOIN vdj20_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 152 | const | 1 | 100.00 | Using temporary; Usando 'filesort' |
| 1 | SIMPLE | b | ALL | idx_lft_rgt | No pudo usarse una clave de índice | NULL | NULL | 2293 | 49.98 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 19 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 18 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:246 |
| 17 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:107 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 15 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:544 |
| 14 | VmConfig::echoAdmin() | JROOT/administrator/components/com_virtuemart/helpers/config.php:517 |
| 13 | VmConfig->__construct() | JROOT/administrator/components/com_virtuemart/helpers/config.php:806 |
| 12 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:779 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:339 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 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: 1.18 ms Después de la última consulta: 1.35 ms
SHOW TABLES LIKE "vdj20_virtuemart_configs"
'Explicar' no es posible en la consulta: SHOW TABLES LIKE "vdj20_virtuemart_configs"
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/administrator/components/com_virtuemart/models/config.php:507 |
| 13 | VirtueMartModelConfig::checkConfigTableExists() | JROOT/administrator/components/com_virtuemart/helpers/config.php:809 |
| 12 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:779 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:339 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 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.19 ms Después de la última consulta: 0.12 ms
SELECT `config`
FROM `vdj20_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_configs | system | PRIMARY | No pudo usarse una clave de índice | NULL | NULL | 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:1731 |
| 13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_virtuemart/helpers/config.php:861 |
| 12 | VmConfig::loadConfig() | JROOT/components/com_virtuemart/router.php:779 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:339 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 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.37 ms Después de la última consulta: 1.61 ms
SELECT *
FROM `vdj20_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "es-ES" )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_menu | ALL | idx_client_id_parent_id_alias_language,idx_language | No pudo usarse una clave de índice | NULL | NULL | 620 | 84.52 | Using where |
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:1692 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_virtuemart/router.php:1094 |
| 13 | vmrouterHelper->setMenuItemId() | JROOT/components/com_virtuemart/router.php:757 |
| 12 | vmrouterHelper->__construct() | JROOT/components/com_virtuemart/router.php:781 |
| 11 | vmrouterHelper::getInstance() | JROOT/components/com_virtuemart/router.php:339 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 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: 2.46 ms Después de la última consulta: 3.84 ms
SELECT p.`virtuemart_product_id`
FROM `vdj20_virtuemart_products_es_es` AS `p`
WHERE `slug` = "papel-tapiz-wooden-planks-by-destefano"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | p | const | slug | slug | 578 | 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/components/com_virtuemart/router.php:1018 |
| 11 | vmrouterHelper->getProductId() | JROOT/components/com_virtuemart/router.php:640 |
| 10 | virtuemartParseRoute() | JROOT/libraries/cms/component/router/legacy.php:104 |
| 9 | JComponentRouterLegacy->parse() | JROOT/libraries/cms/router/site.php:395 |
| 8 | JRouterSite->parseSefRoute() | JROOT/libraries/cms/router/router.php:479 |
| 7 | JRouter->_parseSefRoute() | JROOT/libraries/cms/router/router.php:234 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:118 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 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.95 ms Después de la última consulta: 1.38 ms
UPDATE `vdj20_extensions`
SET `params` = '{\"mediaversion\":\"8b0e85e42d3ae75cfe61df4f74438c9e\"}'
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.33 ms Después de la última consulta: 32.35 ms
SELECT *
FROM `vdj20_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_shoppergroups | ref | virtuemart_vendor_id,shared,published | published | 1 | const | 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 | | 17 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 16 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102 |
| 15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
| 14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
| 13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
| 12 | VirtueMartModelUser->getCurrentUser() | JROOT/administrator/components/com_virtuemart/models/product.php:1166 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.28 ms
SELECT `vdj20_virtuemart_shoppergroups`.*
FROM `vdj20_virtuemart_shoppergroups`
WHERE `vdj20_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_shoppergroups | 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 | | 20 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997 |
| 18 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:906 |
| 17 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52 |
| 16 | VirtueMartModelShopperGroup->getShopperGroup() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107 |
| 15 | VirtueMartModelShopperGroup->getDefault() | JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136 |
| 14 | VirtueMartModelShopperGroup->appendShopperGroups() | JROOT/administrator/components/com_virtuemart/models/user.php:163 |
| 13 | VirtueMartModelUser->getUser() | JROOT/administrator/components/com_virtuemart/models/user.php:114 |
| 12 | VirtueMartModelUser->getCurrentUser() | JROOT/administrator/components/com_virtuemart/models/product.php:1166 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.12 ms Después de la última consulta: 1.81 ms
SELECT `vdj20_virtuemart_products`.* ,`vdj20_virtuemart_products_es_es`.*
FROM `vdj20_virtuemart_products`
INNER JOIN `vdj20_virtuemart_products_es_es` using (`virtuemart_product_id`)
WHERE `vdj20_virtuemart_products`.`virtuemart_product_id` = "6269"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_products | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | vdj20_virtuemart_products_es_es | 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 | | 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 13 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997 |
| 12 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1191 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.91 ms Después de la última consulta: 1.22 ms
SELECT `virtuemart_media_id`
FROM `vdj20_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6269"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_product_medias | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 2 | 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 | | 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 12 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1196 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.51 ms Después de la última consulta: 0.51 ms
SELECT `virtuemart_shoppergroup_id`
FROM `vdj20_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6269"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | No pudo usarse una clave de índice | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
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:1541 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 12 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1199 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.79 ms Después de la última consulta: 0.24 ms
SELECT *
FROM `vdj20_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6269"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2018-10-17 14:04:50" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2018-10-17 14:04:50" ) )
ORDER BY `product_price` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_product_prices | ref | virtuemart_product_id,product_price,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down | virtuemart_product_id | 4 | const | 1 | 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 | | 15 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 14 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1043 |
| 13 | VirtueMartModelProduct->loadProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1062 |
| 12 | VirtueMartModelProduct->getRawProductPrices() | JROOT/administrator/components/com_virtuemart/models/product.php:1211 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.53 ms Después de la última consulta: 0.56 ms
SELECT `virtuemart_manufacturer_id`
FROM `vdj20_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "6269"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_product_manufacturers | ref | virtuemart_product_id | virtuemart_product_id | 5 | 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 | | 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 13 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126 |
| 12 | VmTableXarray->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1214 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.66 ms Después de la última consulta: 0.47 ms
SELECT `vdj20_virtuemart_manufacturers`.* ,`vdj20_virtuemart_manufacturers_es_es`.*
FROM `vdj20_virtuemart_manufacturers`
INNER JOIN `vdj20_virtuemart_manufacturers_es_es` using (`virtuemart_manufacturer_id`)
WHERE `vdj20_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "99"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_manufacturers | const | PRIMARY,virtuemart_manufacturercategories_id | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | vdj20_virtuemart_manufacturers_es_es | 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 | | 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 13 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997 |
| 12 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1219 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.66 ms Después de la última consulta: 0.26 ms
SELECT *
FROM `vdj20_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6269
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_product_categories | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 3 | 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:1497 |
| 13 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/models/product.php:1420 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1230 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.75 ms Después de la última consulta: 0.74 ms
SELECT `vdj20_virtuemart_categories`.* ,`vdj20_virtuemart_categories_es_es`.*
FROM `vdj20_virtuemart_categories`
INNER JOIN `vdj20_virtuemart_categories_es_es` using (`virtuemart_category_id`)
WHERE `vdj20_virtuemart_categories`.`virtuemart_category_id` = "156"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | vdj20_virtuemart_categories_es_es | 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:1456 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1425 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1230 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.76 ms Después de la última consulta: 0.25 ms
SELECT `vdj20_virtuemart_categories`.* ,`vdj20_virtuemart_categories_es_es`.*
FROM `vdj20_virtuemart_categories`
INNER JOIN `vdj20_virtuemart_categories_es_es` using (`virtuemart_category_id`)
WHERE `vdj20_virtuemart_categories`.`virtuemart_category_id` = "438"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | vdj20_virtuemart_categories_es_es | 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:1456 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1425 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1230 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.78 ms Después de la última consulta: 0.24 ms
SELECT `vdj20_virtuemart_categories`.* ,`vdj20_virtuemart_categories_es_es`.*
FROM `vdj20_virtuemart_categories`
INNER JOIN `vdj20_virtuemart_categories_es_es` using (`virtuemart_category_id`)
WHERE `vdj20_virtuemart_categories`.`virtuemart_category_id` = "455"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| 1 | SIMPLE | vdj20_virtuemart_categories_es_es | 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:1456 |
| 14 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997 |
| 13 | VmTable->load() | JROOT/administrator/components/com_virtuemart/models/product.php:1425 |
| 12 | VirtueMartModelProduct->getProductCategories() | JROOT/administrator/components/com_virtuemart/models/product.php:1230 |
| 11 | VirtueMartModelProduct->getProductSingle() | JROOT/administrator/components/com_virtuemart/models/product.php:873 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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: 2.01 ms Después de la última consulta: 3.46 ms
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `vdj20_virtuemart_customs` AS c
LEFT JOIN `vdj20_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (6269)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | field | ref | virtuemart_product_id,virtuemart_custom_id | virtuemart_product_id | 4 | const | 4 | 100.00 | Using temporary; Usando 'filesort' |
| 1 | SIMPLE | c | eq_ref | PRIMARY,published | PRIMARY | 4 | decohunt_deco_restore.field.virtuemart_custom_id | 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 | | 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/models/customfields.php:146 |
| 12 | VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields() | JROOT/administrator/components/com_virtuemart/models/product.php:2283 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:943 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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: 9.19 ms
SELECT *
FROM `vdj20_virtuemart_currencies` AS c
, `vdj20_virtuemart_vendors` AS v
WHERE v.virtuemart_vendor_id = 1
AND v.vendor_currency = c.virtuemart_currency_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | v | system | PRIMARY,vendor_currency | No pudo usarse una clave de índice | NULL | NULL | 1 | 100.00 | |
| 1 | SIMPLE | c | 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 | | 18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1653 |
| 17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_virtuemart/models/vendor.php:265 |
| 16 | VirtueMartModelVendor::getVendorCurrency() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:49 |
| 15 | CurrencyDisplay->__construct() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:98 |
| 14 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2290 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:943 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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: 1.59 ms
SELECT `vdj20_virtuemart_currencies`.*
FROM `vdj20_virtuemart_currencies`
WHERE `vdj20_virtuemart_currencies`.`virtuemart_currency_id` = "31"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_currencies | 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 | | 18 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1456 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997 |
| 16 | VmTable->load() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:906 |
| 15 | VmModel->getData() | JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:114 |
| 14 | CurrencyDisplay::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2290 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:943 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.15 ms Después de la última consulta: 5.69 ms
SHOW FULL COLUMNS
FROM `vdj20_virtuemart_userfields`
'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `vdj20_virtuemart_userfields`
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 25 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1497 |
| 24 | JDatabaseDriver->loadAssocList() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:647 |
| 23 | VmTable->showFullColumns() | JROOT/administrator/components/com_virtuemart/tables/userfields.php:43 |
| 22 | TableUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:204 |
| 21 | VmTable::getInstance() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425 |
| 20 | VmModel->_createTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387 |
| 19 | VmModel->getTable() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593 |
| 18 | VmModel->setMainTable() | JROOT/administrator/components/com_virtuemart/models/userfields.php:51 |
| 17 | VirtueMartModelUserfields->__construct() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545 |
| 16 | VmModel::getModel() | JROOT/components/com_virtuemart/helpers/cart.php:248 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2290 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:943 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.23 ms Después de la última consulta: 0.49 ms
SELECT *
FROM `vdj20_virtuemart_userfields`
WHERE 1 = 1
AND `account`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_virtuemart_userfields | ref | published,account | published | 1 | const | 22 | 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 | | 20 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490 |
| 18 | VmModel->_getList() | JROOT/administrator/components/com_virtuemart/models/userfields.php:593 |
| 17 | VirtueMartModelUserfields->getUserFields() | JROOT/administrator/components/com_virtuemart/models/userfields.php:487 |
| 16 | VirtueMartModelUserfields->getUserFieldsFor() | JROOT/components/com_virtuemart/helpers/cart.php:259 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2290 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:943 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.31 ms Después de la última consulta: 2.90 ms
SHOW FULL COLUMNS
FROM `vdj20_assets`
'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `vdj20_assets`
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | Comunicador | Archivo y número de línea | | 26 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 23 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 22 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:61 |
| 21 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:305 |
| 20 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:100 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 18 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1281 |
| 17 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/models/userfields.php:758 |
| 16 | VirtueMartModelUserfields->getUserFieldsFilled() | JROOT/components/com_virtuemart/helpers/cart.php:264 |
| 15 | VirtueMartCart->prepareAddressFieldsInCart() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252 |
| 14 | calculationHelper->setCountryState() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89 |
| 13 | calculationHelper->__construct() | JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104 |
| 12 | calculationHelper::getInstance() | JROOT/administrator/components/com_virtuemart/models/product.php:2290 |
| 11 | VirtueMartModelProduct->getPrice() | JROOT/administrator/components/com_virtuemart/models/product.php:943 |
| 10 | VirtueMartModelProduct->getProduct() | JROOT/components/com_virtuemart/views/productdetails/view.html.php:83 |
| 9 | VirtueMartViewProductdetails->display() | JROOT/components/com_virtuemart/controllers/productdetails.php:55 |
| 8 | VirtueMartControllerProductdetails->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_virtuemart/virtuemart.php:125 |
| 6 | require_once JROOT/components/com_virtuemart/virtuemart.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.26 ms Después de la última consulta: 0.25 ms
SELECT id
FROM vdj20_assets
WHERE parent_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | vdj20_assets | ref | idx_parent_id | idx_parent_id | 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 | | 22 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1541 |
| 21 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/table/nested.php:1216 |
| 20 | JTableNested->getRootId() | JROOT/libraries/joomla/access/access.php:101 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 18 | JUser->authorise() | JROOT/administrator/components/com_virtuemart/helpers/config.php:1281 |
| 17 | vmAccess::manager() | JROOT/administrator/components/com_virtuemart/models/userfields.php:758 |
| 16 | VirtueMartModelUserfields->getUserFieldsFilled() | JROOT/components/com_virtuemart/helpers/cart.php:264 |
| 15 | VirtueMartCart-> |
Papel Tapiz Brick Wall (Rollo Estándar 5mt2) by Destefano
Papel Tapiz Tressage (Rollo XTraGrande 7mt2) by Destefano
Papel Tapiz Luggage (Rollo XTraGrande 7mt2) by Destefano
Papel Tapiz Isambard (Rollo XTraGrande 7mt2) by Destefano
