Product Code: CEL 043
Disponibilidad del producto: Si
Login Form
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1695430455,
"last": 1695430455,
"now": 1695430455
},
"token": "bAcyjiRvcuAoR9bbe4OAeHTOKDia04RN"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
},
"__vm": {
"manage": 0,
"vmlastvisitedItemid": 101,
"vmcartlastVendorId": 1,
"vmlastvisitedcategoryid": 113,
"vmlastvisitedproductids": [
5662
]
}
}
Fecha y hora
Memoria
Fecha y hora: 36.09 ms / 36.09 ms Memoria: 2.079 MB / 2.45 MB Application: afterLoad
Fecha y hora: 128.11 ms / 164.20 ms Memoria: 5.970 MB / 8.42 MB Application: Before Access::preloadComponents (all components)
Fecha y hora: 1.97 ms / 166.17 ms Memoria: 0.066 MB / 8.49 MB Application: After Access::preloadComponents (all components)
Fecha y hora: 0.04 ms / 166.21 ms Memoria: -0.003 MB / 8.49 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Fecha y hora: 0.82 ms / 167.03 ms Memoria: 0.028 MB / 8.51 MB Application: After Access::getAssetRules (id:1 name:root.1)
Fecha y hora: 0.04 ms / 167.07 ms Memoria: 0.001 MB / 8.52 MB Application: Before Access::getAssetRules (id:492 name:com_virtuemart)
Fecha y hora: 0.02 ms / 167.10 ms Memoria: 0.002 MB / 8.52 MB Application: After Access::getAssetRules (id:492 name:com_virtuemart)
Fecha y hora: 7.40 ms / 174.50 ms Memoria: 0.299 MB / 8.82 MB Application: afterInitialise
Fecha y hora: 55.62 ms / 230.12 ms Memoria: 2.058 MB / 10.87 MB Application: afterRoute
Fecha y hora: 6.91 ms / 237.03 ms Memoria: 0.226 MB / 11.10 MB Application: beforeRenderComponent com_virtuemart
Fecha y hora: 275.85 ms / 512.88 ms Memoria: 7.893 MB / 18.99 MB Application: afterRenderComponent com_virtuemart
Fecha y hora: 7.61 ms / 520.48 ms Memoria: 0.295 MB / 19.29 MB Application: afterDispatch
Fecha y hora: 10.62 ms / 531.10 ms Memoria: 0.349 MB / 19.64 MB Application: beforeRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Fecha y hora: 1.43 ms / 532.53 ms Memoria: 0.043 MB / 19.68 MB Application: Before Access::getAssetRules (id:23 name:com_templates)
Fecha y hora: 0.08 ms / 532.61 ms Memoria: 0.007 MB / 19.69 MB Application: After Access::getAssetRules (id:23 name:com_templates)
Fecha y hora: 1.04 ms / 533.66 ms Memoria: 0.017 MB / 19.70 MB Application: afterRenderModule mod_tm_style_switcher (TM Ajax Style Switcher)
Fecha y hora: 0.12 ms / 533.78 ms Memoria: 0.001 MB / 19.70 MB Application: beforeRenderModule mod_menu (Navigation)
Fecha y hora: 2.87 ms / 536.65 ms Memoria: 0.047 MB / 19.75 MB Application: afterRenderModule mod_menu (Navigation)
Fecha y hora: 0.06 ms / 536.70 ms Memoria: -0.004 MB / 19.75 MB Application: beforeRenderModule mod_menu (Social List)
Fecha y hora: 1.98 ms / 538.68 ms Memoria: 0.037 MB / 19.78 MB Application: afterRenderModule mod_menu (Social List)
Fecha y hora: 0.09 ms / 538.77 ms Memoria: -0.002 MB / 19.78 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 1.90 ms / 540.67 ms Memoria: 0.032 MB / 19.81 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.09 ms / 540.76 ms Memoria: -0.004 MB / 19.81 MB Application: beforeRenderModule mod_icemegamenu (Navigation menu)
Fecha y hora: 11.26 ms / 552.02 ms Memoria: 0.479 MB / 20.29 MB Application: beforeRenderModule mod_virtuemart_category (Categories Top #1)
Fecha y hora: 8.15 ms / 560.17 ms Memoria: 0.162 MB / 20.45 MB Application: afterRenderModule mod_virtuemart_category (Categories Top #1)
Fecha y hora: 0.96 ms / 561.13 ms Memoria: 0.015 MB / 20.47 MB Application: beforeRenderModule mod_virtuemart_category (Categories Top #2)
Fecha y hora: 7.28 ms / 568.41 ms Memoria: 0.176 MB / 20.64 MB Application: afterRenderModule mod_virtuemart_category (Categories Top #2)
Fecha y hora: 0.85 ms / 569.26 ms Memoria: 0.009 MB / 20.65 MB Application: beforeRenderModule mod_virtuemart_category (Categories Top #3)
Fecha y hora: 5.09 ms / 574.35 ms Memoria: 0.118 MB / 20.77 MB Application: afterRenderModule mod_virtuemart_category (Categories Top #3)
Fecha y hora: 0.87 ms / 575.22 ms Memoria: 0.011 MB / 20.78 MB Application: beforeRenderModule mod_virtuemart_category (Categories Top #4)
Fecha y hora: 4.52 ms / 579.74 ms Memoria: 0.088 MB / 20.87 MB Application: afterRenderModule mod_virtuemart_category (Categories Top #4)
Fecha y hora: 1.00 ms / 580.74 ms Memoria: 0.027 MB / 20.89 MB Application: beforeRenderModule mod_tm_slick (Mega menu Banner)
Fecha y hora: 2.14 ms / 582.89 ms Memoria: 0.045 MB / 20.94 MB Application: afterRenderModule mod_tm_slick (Mega menu Banner)
Fecha y hora: 14.98 ms / 597.86 ms Memoria: -0.006 MB / 20.93 MB Application: afterRenderModule mod_icemegamenu (Navigation menu)
Fecha y hora: 0.10 ms / 597.96 ms Memoria: -0.003 MB / 20.93 MB Application: beforeRenderModule mod_menu (Social List)
Fecha y hora: 1.12 ms / 599.08 ms Memoria: 0.005 MB / 20.94 MB Application: afterRenderModule mod_menu (Social List)
Fecha y hora: 0.09 ms / 599.16 ms Memoria: -0.003 MB / 20.93 MB Application: beforeRenderModule mod_custom (Phone Custom)
Fecha y hora: 1.00 ms / 600.16 ms Memoria: 0.008 MB / 20.94 MB Application: afterRenderModule mod_custom (Phone Custom)
Fecha y hora: 0.09 ms / 600.25 ms Memoria: -0.001 MB / 20.94 MB Application: beforeRenderModule mod_socialloginandsocialshare (Login or register)
Fecha y hora: 8.34 ms / 608.60 ms Memoria: 0.157 MB / 21.10 MB Application: afterRenderModule mod_socialloginandsocialshare (Login or register)
Fecha y hora: 0.09 ms / 608.69 ms Memoria: -0.012 MB / 21.08 MB Application: beforeRenderModule mod_virtuemart_search (Search product)
Fecha y hora: 2.18 ms / 610.87 ms Memoria: 0.016 MB / 21.10 MB Application: afterRenderModule mod_virtuemart_search (Search product)
Fecha y hora: 25.62 ms / 636.49 ms Memoria: 0.799 MB / 21.90 MB Application: afterRender
Total de consultas a la base de datos: 67.34 ms
22.96 MB (24,071,360 Bytes)
82 consultas registradas 67.34 ms
¡ 6 duplicaciones detectadas!
- Tiempo de la consulta: 0.53 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 4.120 MB Filas devueltas: 0
SELECT `data`
FROM `db_session`
WHERE `session_id` = X'3736383237343061623938636362313734326362386435343337393536653235'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Lo mismo que llamada de la línea de abajo. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.35 ms Después de la última consulta: 2.08 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.215 MB Filas devueltas: 0
SELECT `session_id`
FROM `db_session`
WHERE `session_id` = X'3736383237343061623938636362313734326362386435343337393536653235'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.03 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.96 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.221 MB
INSERT INTO `db_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3736383237343061623938636362313734326362386435343337393536653235', 1, 1695430455, 0, '', 0)'Explicar' no es posible en la consulta: INSERT INTO `db_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3736383237343061623938636362313734326362386435343337393536653235', 1, 1695430455, 0, '', 0)Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms update 0.11 ms end 0.01 ms query end 0.60 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.90 ms Después de la última consulta: 4.03 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 4.472 MB Filas devueltas: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `db_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_extensions NULL ref extension extension 82 const 43 1.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.40 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Lo mismo que llamada de la línea de abajo. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.40 ms Después de la última consulta: 4.11 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.669 MB Filas devueltas: 5
SELECT id, rules
FROM `db_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_viewlevels NULL ALL NULL No pudo usarse una clave de índice NULL NULL 5 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.681 MB Filas devueltas: 2
SELECT b.id
FROM db_usergroups AS a
LEFT JOIN db_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.86 ms Después de la última consulta: 1.11 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.749 MB Filas devueltas: 121
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM db_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_extensions NULL ref extension extension 82 const 165 0.60 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.01 ms Creating sort index 1.43 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.48 ms Después de la última consulta: 51.18 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 7.129 MB Filas devueltas: 10Consultas duplicadas: #81
SELECT *
FROM db_loginradius_settingsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_loginradius_settings NULL ALL NULL No pudo usarse una clave de índice NULL NULL 10 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare_helper.php:58 9 plgSystemSocialLoginTools::sociallogin_getsettings() JROOT/plugins/system/socialloginandsocialshare/socialloginandsocialshare.php:51 8 plgSystemSocialLoginAndSocialShare->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.95 ms Después de la última consulta: 19.24 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 8.230 MB Filas devueltas: 1
SHOW TABLES LIKE "db_virtuemart_configs"
'Explicar' no es posible en la consulta: SHOW TABLES LIKE "db_virtuemart_configs"Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms checking permissions 0.57 ms Sending data 0.02 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:727 11 VmTable::checkTableExists() JROOT/administrator/components/com_virtuemart/models/config.php:580 10 VirtueMartModelConfig::checkConfigTableExists() JROOT/administrator/components/com_virtuemart/helpers/config.php:415 9 VmConfig::loadConfig() JROOT/plugins/system/vm3_cart/vm3_cart.php:233 8 plgSystemVM3_Cart->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.92 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 8.276 MB Filas devueltas: 1
SELECT `config`
FROM `db_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_configs NULL system PRIMARY No pudo usarse una clave de índice NULL NULL 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/config.php:455 9 VmConfig::loadConfig() JROOT/plugins/system/vm3_cart/vm3_cart.php:233 8 plgSystemVM3_Cart->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.57 ms Después de la última consulta: 1.95 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 8.391 MB Filas devueltas: 1
SELECT *
FROM db_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_languages NULL ALL NULL No pudo usarse una clave de índice NULL NULL 2 50.00 Using where; Usando 'filesort' Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.13 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.09 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:98 11 vmLanguage::setLanguageByTag() JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:62 10 vmLanguage::initialise() JROOT/administrator/components/com_virtuemart/helpers/config.php:476 9 VmConfig::loadConfig() JROOT/plugins/system/vm3_cart/vm3_cart.php:233 8 plgSystemVM3_Cart->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.60 ms Después de la última consulta: 0.89 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 8.429 MB Filas devueltas: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `db_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_schuweb_sitemap','com_search','com_socialloginandsocialshare','com_tags','com_tcpdf','com_templates','com_tmbox','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_assets NULL ALL idx_asset_name No pudo usarse una clave de índice NULL NULL 211 20.85 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.09 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.27 ms preparing 0.02 ms executing 0.01 ms Sending data 0.84 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136 11 vmAccess::manager() JROOT/administrator/components/com_virtuemart/helpers/config.php:85 10 VmConfig::echoAdmin() JROOT/administrator/components/com_virtuemart/helpers/config.php:477 9 VmConfig::loadConfig() JROOT/plugins/system/vm3_cart/vm3_cart.php:233 8 plgSystemVM3_Cart->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.92 ms Después de la última consulta: 12.18 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 9.067 MB Filas devueltas: 50
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 db_menu AS m
LEFT JOIN db_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 5 NULL 65 10.00 Using index condition; Using where; Usando 'filesort' 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 promolan_dbpromolan.m.component_id 1 100.00 Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 1.27 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.73 ms Después de la última consulta: 20.34 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 10.208 MB Filas devueltas: 2
SHOW FULL COLUMNS
FROM `db_komento_configs`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `db_komento_configs`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.19 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.02 ms Opening tables 0.07 ms checking permissions 0.05 ms checking permissions 0.03 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_komento/tables/parent.php:18 14 KomentoParentTable->__construct() JROOT/administrator/components/com_komento/tables/configs.php:40 13 KomentoTableConfigs->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_komento/tables/parent.php:49 11 KomentoParentTable::getInstance() JROOT/components/com_komento/helpers/helper.php:99 10 Komento::getTable() JROOT/components/com_komento/helpers/helper.php:228 9 Komento::getKonfig() JROOT/components/com_komento/bootstrap.php:30 8 require_once JROOT/components/com_komento/bootstrap.php JROOT/components/com_komento/router.php:16 7 require_once JROOT/components/com_komento/router.php JROOT/libraries/src/Router/SiteRouter.php:779 6 Joomla\CMS\Router\SiteRouter->getComponentRouter() JROOT/libraries/src/Router/SiteRouter.php:131 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 10.239 MB Filas devueltas: 1
SELECT *
FROM db_komento_configs
WHERE `component` = 'com_komento'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_komento_configs NULL ALL NULL No pudo usarse una clave de índice NULL NULL 5 20.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 10 Joomla\CMS\Table\Table->load() JROOT/components/com_komento/helpers/helper.php:229 9 Komento::getKonfig() JROOT/components/com_komento/bootstrap.php:30 8 require_once JROOT/components/com_komento/bootstrap.php JROOT/components/com_komento/router.php:16 7 require_once JROOT/components/com_komento/router.php JROOT/libraries/src/Router/SiteRouter.php:779 6 Joomla\CMS\Router\SiteRouter->getComponentRouter() JROOT/libraries/src/Router/SiteRouter.php:131 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.90 ms Después de la última consulta: 16.29 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 10.811 MB Filas devueltas: 3
SELECT id, home, template, s.params
FROM db_template_styles as s
LEFT JOIN db_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL idx_template,idx_client_id,idx_client_id_home No pudo usarse una clave de índice NULL NULL 5 60.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 promolan_dbpromolan.s.template,const 1 4.64 Using index condition; Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.05 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms executing 0.01 ms Sending data 0.15 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 13 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/components/com_virtuemart/router.php:852 12 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:970 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:374 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.14 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 10.826 MB Filas devueltas: 8
SELECT *
FROM `db_menu`
WHERE `link` like "index.php?option=com_virtuemart%"
and (language="*" or language = "es-ES" )
AND client_id=0
AND published=1
AND ( access="1" OR access="5" )
ORDER BY `language` DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_menu NULL ref idx_client_id_parent_id_alias_language,idx_language idx_client_id_parent_id_alias_language 1 const 66 0.79 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms Creating sort index 0.60 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_virtuemart/router.php:1405 14 vmrouterHelper->setMenuItemId() JROOT/components/com_virtuemart/router.php:920 13 vmrouterHelper->setRoutingQuery() JROOT/components/com_virtuemart/router.php:898 12 vmrouterHelper->__construct() JROOT/components/com_virtuemart/router.php:970 11 vmrouterHelper::getInstance() JROOT/components/com_virtuemart/router.php:374 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 6.96 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 10.837 MB Filas devueltas: 1
SELECT l.virtuemart_product_id
FROM `db_virtuemart_products_es_es` as l
WHERE l.slug = "wolfsburg"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE l NULL const slug slug 578 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 6.51 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_virtuemart/router.php:1333 12 vmrouterHelper->getFieldOfObjectWithLangFallBack() JROOT/components/com_virtuemart/router.php:1271 11 vmrouterHelper->getProductId() JROOT/components/com_virtuemart/router.php:754 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.60 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 10.845 MB Filas devueltas: 1
SELECT l.virtuemart_category_id
FROM `db_virtuemart_categories_es_es` as l
WHERE l.slug = "acc-smartphone-y-tablet"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE l NULL const slug slug 578 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.14 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_virtuemart/router.php:1333 13 vmrouterHelper->getFieldOfObjectWithLangFallBack() JROOT/components/com_virtuemart/router.php:1129 12 vmrouterHelper->getCategoryId() JROOT/components/com_virtuemart/router.php:1275 11 vmrouterHelper->getProductId() JROOT/components/com_virtuemart/router.php:754 10 virtuemartParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.52 ms Después de la última consulta: 1.83 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 10.912 MB Filas devueltas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `db_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Lo mismo que llamada de la línea de abajo. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.10 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 10.902 MB
UPDATE `db_extensions`
SET `params` = '{\"mediaversion\":\"37f25f131409b326465d3bd9e255cd35\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE db_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.09 ms updating 0.10 ms end 0.02 ms query end 0.65 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.61 ms Después de la última consulta: 43.35 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 13.705 MB Filas devueltas: 1
SELECT *
FROM `db_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_shoppergroups NULL ref virtuemart_vendor_id,shared,published published 1 const 3 25.00 Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100 14 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 13 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:186 12 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 11 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:177 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 13.729 MB Filas devueltas: 1
SELECT `db_virtuemart_shoppergroups`.*
FROM `db_virtuemart_shoppergroups`
WHERE `db_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_shoppergroups NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 17 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024 16 VmModel->getData() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50 15 VirtueMartModelShopperGroup->getShopperGroup() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105 14 VirtueMartModelShopperGroup->getDefault() JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134 13 VirtueMartModelShopperGroup->appendShopperGroups() JROOT/administrator/components/com_virtuemart/models/user.php:186 12 VirtueMartModelUser->getUser() JROOT/administrator/components/com_virtuemart/models/user.php:114 11 VirtueMartModelUser->getCurrentUser() JROOT/components/com_virtuemart/helpers/cart.php:177 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.39 ms Después de la última consulta: 4.53 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 13.933 MB Filas devueltas: 32
SHOW FULL COLUMNS
FROM `db_virtuemart_userfields`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `db_virtuemart_userfields`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.11 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 20 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:688 19 VmTable->showFullColumns() JROOT/administrator/components/com_virtuemart/tables/userfields.php:41 18 TableUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:211 17 VmTable::getInstance() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432 16 VmModel->_createTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394 15 VmModel->getTable() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:607 14 VmModel->setMainTable() JROOT/administrator/components/com_virtuemart/models/userfields.php:49 13 VirtueMartModelUserfields->__construct() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559 12 VmModel::getModel() JROOT/components/com_virtuemart/helpers/cart.php:345 11 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:232 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.98 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 13.982 MB Filas devueltas: 18
SELECT *
FROM `db_virtuemart_userfields`
WHERE 1 = 1
AND `account`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_userfields NULL ref published,account published 1 const 21 82.14 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.45 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503 14 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:602 13 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:483 12 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:386 11 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:232 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.98 ms Después de la última consulta: 32.08 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.531 MB Filas devueltas: 12
SELECT *
FROM `db_virtuemart_userfields`
WHERE 1 = 1
AND `shipment`="1"
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_userfields NULL ref published,shipment shipment 1 const 14 75.00 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.12 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.04 ms Creating sort index 0.36 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503 14 VmModel->_getList() JROOT/administrator/components/com_virtuemart/models/userfields.php:602 13 VirtueMartModelUserfields->getUserFields() JROOT/administrator/components/com_virtuemart/models/userfields.php:489 12 VirtueMartModelUserfields->getUserFieldsFor() JROOT/components/com_virtuemart/helpers/cart.php:386 11 VirtueMartCart->setupAddressFieldsForCart() JROOT/components/com_virtuemart/helpers/cart.php:232 10 VirtueMartCart::getCart() JROOT/components/com_virtuemart/views/productdetails/view.html.php:74 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.66 ms Después de la última consulta: 2.47 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.710 MB Filas devueltas: 1
SELECT `db_virtuemart_products`.* ,`db_virtuemart_products_es_es`.*
FROM `db_virtuemart_products`
INNER JOIN `db_virtuemart_products_es_es`
ON `db_virtuemart_products`.`virtuemart_product_id` = `db_virtuemart_products_es_es`.`virtuemart_product_id`
WHERE `db_virtuemart_products`.`virtuemart_product_id` = "5662"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_products NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE db_virtuemart_products_es_es NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 12 VmTable->load() JROOT/administrator/components/com_virtuemart/models/product.php:1559 11 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1118 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.46 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.773 MB Filas devueltas: 2
SELECT `virtuemart_media_id`
FROM `db_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "5662"
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_product_medias NULL ref virtuemart_product_id,ordering ordering 4 const 2 100.00 Using index condition Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.10 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128 12 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/product.php:1582 11 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1118 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.41 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.780 MB Filas devueltas: 1
SELECT *
FROM `db_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5662id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_product_categories NULL ref virtuemart_product_id virtuemart_product_id 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 14 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/models/product.php:1929 13 VirtueMartModelProduct::getProductCategoryIds() JROOT/administrator/components/com_virtuemart/models/product.php:1906 12 VirtueMartModelProduct->getProductCategories() JROOT/administrator/components/com_virtuemart/models/product.php:1646 11 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1118 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.61 ms Después de la última consulta: 0.70 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 15.841 MB Filas devueltas: 1
SELECT `db_virtuemart_categories`.* ,`db_virtuemart_categories_es_es`.*
FROM `db_virtuemart_categories`
INNER JOIN `db_virtuemart_categories_es_es`
ON `db_virtuemart_categories`.`virtuemart_category_id` = `db_virtuemart_categories_es_es`.`virtuemart_category_id`
WHERE `db_virtuemart_categories`.`virtuemart_category_id` = "113"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE db_virtuemart_categories_es_es NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.02 ms Opening tables 0.11 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/product.php:1910 12 VirtueMartModelProduct->getProductCategories() JROOT/administrator/components/com_virtuemart/models/product.php:1646 11 VirtueMartModelProduct->getProductSingle() JROOT/administrator/components/com_virtuemart/models/product.php:1118 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.75 ms Después de la última consulta: 4.08 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 16.035 MB Filas devueltas: 0
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.`searchable`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, c.`virtuemart_shoppergroup_id`, 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.`noninheritable`, field.`ordering`
FROM `db_virtuemart_customs` AS c
LEFT JOIN `db_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE field.`virtuemart_product_id` IN (5662)
AND c.`published` = "1"
ORDER BY field.`ordering` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE field NULL ref virtuemart_custom_id,unique_cust_prd_value,virtuemart_product_id virtuemart_product_id 4 const 1 100.00 Using index condition; Using where 1 SIMPLE c NULL eq_ref PRIMARY,published PRIMARY 4 promolan_dbpromolan.field.virtuemart_custom_id 1 92.31 Using index condition; Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.18 ms init 0.05 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_virtuemart/models/customfields.php:157 11 VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields() JROOT/administrator/components/com_virtuemart/models/product.php:1213 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.62 ms Después de la última consulta: 6.96 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 16.423 MB Filas devueltas: 1
SELECT *
FROM `db_virtuemart_currencies` AS c
LEFT JOIN `db_virtuemart_vendors` AS v
ON c.virtuemart_currency_id = v.vendor_currency
WHERE v.virtuemart_vendor_id = "1"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE v NULL system PRIMARY,vendor_currency No pudo usarse una clave de índice NULL NULL 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.17 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/vendor.php:323 16 VirtueMartModelVendor::getVendorCurrency() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53 15 CurrencyDisplay->__construct() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106 14 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 13 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106 12 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2961 11 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1227 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.36 ms Después de la última consulta: 1.35 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 16.501 MB Filas devueltas: 1
SELECT `db_virtuemart_currencies`.*
FROM `db_virtuemart_currencies`
WHERE `db_virtuemart_currencies`.`virtuemart_currency_id` = "144"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_currencies NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 16 VmTable->load() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1024 15 VmModel->getData() JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122 14 CurrencyDisplay::getInstance() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79 13 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106 12 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2961 11 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1227 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.62 ms Después de la última consulta: 1.45 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 16.647 MB Filas devueltas: 0
SELECT c.*
FROM db_virtuemart_calcs as c
LEFT JOIN db_virtuemart_calc_shoppergroups as cs
ON cs.virtuemart_calc_id=c.virtuemart_calc_id
WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2023-09-23 00:54:15" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-09-23 00:54:15" )
AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL no matching row in const table Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.08 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.04 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172 14 calculationHelper->setVendorId() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91 13 calculationHelper->__construct() JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106 12 calculationHelper::getInstance() JROOT/administrator/components/com_virtuemart/models/product.php:2961 11 VirtueMartModelProduct->getPrice() JROOT/administrator/components/com_virtuemart/models/product.php:1227 10 VirtueMartModelProduct->getProduct() JROOT/components/com_virtuemart/views/productdetails/view.html.php:78 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.48 ms Después de la última consulta: 2.22 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 16.763 MB Filas devueltas: 1
SELECT `db_virtuemart_medias`.*
FROM `db_virtuemart_medias`
WHERE `db_virtuemart_medias`.`virtuemart_media_id` = "11025"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_medias NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/media.php:92 12 VirtueMartModelMedia->createMediaByIds() JROOT/administrator/components/com_virtuemart/models/media.php:484 11 VirtueMartModelMedia->attachImages() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188 10 VmModel->addImages() JROOT/components/com_virtuemart/views/productdetails/view.html.php:157 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.38 ms Después de la última consulta: 18.88 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 16.979 MB Filas devueltas: 1
SELECT `db_virtuemart_medias`.*
FROM `db_virtuemart_medias`
WHERE `db_virtuemart_medias`.`virtuemart_media_id` = "11026"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_medias NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/media.php:92 12 VirtueMartModelMedia->createMediaByIds() JROOT/administrator/components/com_virtuemart/models/media.php:484 11 VirtueMartModelMedia->attachImages() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188 10 VmModel->addImages() JROOT/components/com_virtuemart/views/productdetails/view.html.php:157 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 4.46 ms Después de la última consulta: 36.72 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 16.992 MB Filas devueltas: 1
SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering
FROM `db_virtuemart_products` as p
LEFT JOIN `db_virtuemart_products_es_es` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `db_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `db_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `db_virtuemart_categories` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( `pc`.`virtuemart_category_id` IN (113)
AND `c`.`published` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`="1" )
AND p.`virtuemart_product_id`!="5662"
AND `pc`.ordering <= "0"
ORDER BY `pc`.`ordering` DESC, `product_name` DESC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ps NULL system virtuemart_product_id No pudo usarse una clave de índice NULL NULL 0 0.00 const row not found 1 SIMPLE c NULL const PRIMARY,published PRIMARY 4 const 1 100.00 Using temporary; Usando 'filesort' 1 SIMPLE pc NULL ALL virtuemart_product_id,ordering No pudo usarse una clave de índice NULL NULL 5797 3.48 Using where 1 SIMPLE p NULL eq_ref PRIMARY,published PRIMARY 4 promolan_dbpromolan.pc.virtuemart_product_id 1 92.83 Using where 1 SIMPLE l NULL eq_ref PRIMARY PRIMARY 4 promolan_dbpromolan.pc.virtuemart_product_id 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.12 ms init 0.06 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.05 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 3.55 ms Creating sort index 0.08 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/models/product.php:2217 10 VirtueMartModelProduct->getNeighborProducts() JROOT/components/com_virtuemart/views/productdetails/view.html.php:178 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 6.15 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 17.000 MB Filas devueltas: 1
SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering
FROM `db_virtuemart_products` as p
LEFT JOIN `db_virtuemart_products_es_es` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `db_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `db_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `db_virtuemart_categories` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
WHERE ( `pc`.`virtuemart_category_id` IN (113)
AND `c`.`published` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`="1" )
AND p.`virtuemart_product_id`!="5662"
AND p.`virtuemart_product_id`!="5672"
AND `pc`.ordering >= "0"
ORDER BY `pc`.`ordering` ASC, `product_name` ASC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ps NULL system virtuemart_product_id No pudo usarse una clave de índice NULL NULL 0 0.00 const row not found 1 SIMPLE c NULL const PRIMARY,published PRIMARY 4 const 1 100.00 Using temporary; Usando 'filesort' 1 SIMPLE pc NULL ALL virtuemart_product_id,ordering No pudo usarse una clave de índice NULL NULL 5797 10.00 Using where 1 SIMPLE p NULL eq_ref PRIMARY,published PRIMARY 4 promolan_dbpromolan.pc.virtuemart_product_id 1 92.83 Using where 1 SIMPLE l NULL eq_ref PRIMARY PRIMARY 4 promolan_dbpromolan.pc.virtuemart_product_id 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 5.33 ms Creating sort index 0.11 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_virtuemart/models/product.php:2217 10 VirtueMartModelProduct->getNeighborProducts() JROOT/components/com_virtuemart/views/productdetails/view.html.php:178 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.51 ms Después de la última consulta: 3.53 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 17.171 MB Filas devueltas: 1
SELECT `virtuemart_media_id`
FROM `db_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "113"
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_category_medias NULL ref virtuemart_category_id,ordering ordering 4 const 1 100.00 Using index condition Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 12 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128 11 VmTableXarray->load() JROOT/administrator/components/com_virtuemart/models/category.php:95 10 VirtueMartModelCategory->getCategory() JROOT/components/com_virtuemart/views/productdetails/view.html.php:215 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 17.174 MB Filas devueltas: 1Consultas duplicadas: #57
SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM db_virtuemart_categories
WHERE `virtuemart_category_id`= 113id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/category.php:1044 11 VirtueMartModelCategory->getCategoryRecurse() JROOT/administrator/components/com_virtuemart/models/category.php:977 10 VirtueMartModelCategory->getParentsList() JROOT/components/com_virtuemart/views/productdetails/view.html.php:216 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.30 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 17.181 MB Filas devueltas: 1Consultas duplicadas: #58
SELECT `virtuemart_category_id` AS `child`, `category_parent_id` AS `parent`
FROM db_virtuemart_categories
WHERE `virtuemart_category_id`= 82id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/category.php:1044 12 VirtueMartModelCategory->getCategoryRecurse() JROOT/administrator/components/com_virtuemart/models/category.php:1051 11 VirtueMartModelCategory->getCategoryRecurse() JROOT/administrator/components/com_virtuemart/models/category.php:977 10 VirtueMartModelCategory->getParentsList() JROOT/components/com_virtuemart/views/productdetails/view.html.php:216 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 17.189 MB Filas devueltas: 1
SELECT l.virtuemart_category_id, l.category_name, published
FROM `db_virtuemart_categories` as c
LEFT JOIN `db_virtuemart_categories_es_es` as l
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
WHERE l.virtuemart_category_id = 82id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE l NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/category.php:998 10 VirtueMartModelCategory->getParentsList() JROOT/components/com_virtuemart/views/productdetails/view.html.php:216 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 17.196 MB Filas devueltas: 1
SELECT l.virtuemart_category_id, l.category_name, published
FROM `db_virtuemart_categories` as c
LEFT JOIN `db_virtuemart_categories_es_es` as l
ON l.`virtuemart_category_id` = c.`virtuemart_category_id`
WHERE l.virtuemart_category_id = 113id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE l NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/administrator/components/com_virtuemart/models/category.php:998 10 VirtueMartModelCategory->getParentsList() JROOT/components/com_virtuemart/views/productdetails/view.html.php:216 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.37 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 17.206 MB Filas devueltas: 1
SELECT `db_virtuemart_medias`.*
FROM `db_virtuemart_medias`
WHERE `db_virtuemart_medias`.`virtuemart_media_id` = "7313"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_medias NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 13 VmTable->load() JROOT/administrator/components/com_virtuemart/models/media.php:92 12 VirtueMartModelMedia->createMediaByIds() JROOT/administrator/components/com_virtuemart/models/media.php:484 11 VirtueMartModelMedia->attachImages() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1188 10 VmModel->addImages() JROOT/components/com_virtuemart/views/productdetails/view.html.php:219 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.61 ms Después de la última consulta: 14.85 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 17.866 MB Filas devueltas: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM db_fields AS a
LEFT JOIN `db_languages` AS l
ON l.lang_code = a.language
LEFT JOIN db_users AS uc
ON uc.id=a.checked_out
LEFT JOIN db_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN db_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN db_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_virtuemart.productdetails'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; Usando 'filesort' 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 promolan_dbpromolan.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 promolan_dbpromolan.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 promolan_dbpromolan.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 promolan_dbpromolan.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 promolan_dbpromolan.a.group_id 1 100.00 Using where Status Duration starting 0.22 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.09 ms System lock 0.02 ms optimizing 0.05 ms statistics 0.21 ms preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.02 ms executing 0.01 ms Sending data 0.28 ms Creating sort index 0.06 ms end 0.01 ms query end 0.01 ms removing tmp table 0.06 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:1085 10 shopFunctionsF::triggerContentPlugin() JROOT/components/com_virtuemart/views/productdetails/view.html.php:353 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.41 ms Después de la última consulta: 15.74 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 18.685 MB Filas devueltas: 0
SELECT *
FROM db_komento_configs
WHERE `component` = 'com_virtuemart'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_komento_configs NULL ALL NULL No pudo usarse una clave de índice NULL NULL 5 20.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 17 Joomla\CMS\Table\Table->load() JROOT/components/com_komento/helpers/helper.php:202 16 Komento::getConfig() JROOT/components/com_komento/helpers/helper.php:697 15 Komento::commentify() JROOT/plugins/content/komento/komento.php:166 14 plgContentKomento->execute() JROOT/plugins/content/komento/komento.php:111 13 plgContentKomento->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:1085 10 shopFunctionsF::triggerContentPlugin() JROOT/components/com_virtuemart/views/productdetails/view.html.php:353 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.64 ms Después de la última consulta: 62.34 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 19.044 MB Filas devueltas: 1
SELECT `db_virtuemart_products`.* ,`db_virtuemart_products_es_es`.*
FROM `db_virtuemart_products`
INNER JOIN `db_virtuemart_products_es_es`
ON `db_virtuemart_products`.`virtuemart_product_id` = `db_virtuemart_products_es_es`.`virtuemart_product_id`
WHERE `db_virtuemart_products`.`virtuemart_product_id` = "5672"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_products NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE db_virtuemart_products_es_es NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.09 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.07 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 23 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 22 VmTable->load() JROOT/components/com_virtuemart/router.php:1155 21 vmrouterHelper->getProductName() JROOT/components/com_virtuemart/router.php:224 20 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/templates/theme657/html/com_virtuemart/productdetails/default.php:536 12 include JROOT/templates/theme657/html/com_virtuemart/productdetails/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_virtuemart/helpers/vmview.php:52 10 VmView->display() JROOT/components/com_virtuemart/views/productdetails/view.html.php:435 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.53 ms Después de la última consulta: 0.54 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 19.061 MB Filas devueltas: 1
SELECT `db_virtuemart_products`.* ,`db_virtuemart_products_es_es`.*
FROM `db_virtuemart_products`
INNER JOIN `db_virtuemart_products_es_es`
ON `db_virtuemart_products`.`virtuemart_product_id` = `db_virtuemart_products_es_es`.`virtuemart_product_id`
WHERE `db_virtuemart_products`.`virtuemart_product_id` = "6735"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_virtuemart_products NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE db_virtuemart_products_es_es NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 23 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1061 22 VmTable->load() JROOT/components/com_virtuemart/router.php:1155 21 vmrouterHelper->getProductName() JROOT/components/com_virtuemart/router.php:224 20 virtuemartBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 19 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 18 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 17 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 13 Joomla\CMS\Router\Route::_() JROOT/templates/theme657/html/com_virtuemart/productdetails/default.php:540 12 include JROOT/templates/theme657/html/com_virtuemart/productdetails/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 11 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_virtuemart/helpers/vmview.php:52 10 VmView->display() JROOT/components/com_virtuemart/views/productdetails/view.html.php:435 9 VirtueMartViewProductdetails->display() JROOT/components/com_virtuemart/controllers/productdetails.php:55 8 VirtueMartControllerProductdetails->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_virtuemart/virtuemart.php:115 6 require_once JROOT/components/com_virtuemart/virtuemart.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 2.14 ms Después de la última consulta: 14.02 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 19.610 MB Filas devueltas: 17
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM db_modules AS m
LEFT JOIN db_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN db_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-23 00:54:15')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-23 00:54:15')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL range PRIMARY,published,newsfeeds published 5 NULL 28 1.79 Using index condition; Using where; Usando 'filesort' 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 promolan_dbpromolan.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 promolan_dbpromolan.m.id 2 40.00 Using where; Using index Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.16 ms init 0.07 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.05 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 1.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Lo mismo que llamada de la línea de abajo. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/theme657/includes/includes.php:94 8 include_once JROOT/templates/theme657/includes/includes.php JROOT/templates/theme657/index.php:3 7 require JROOT/templates/theme657/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.55 ms Después de la última consulta: 16.85 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 20.029 MB Filas devueltas: 1
SELECT id,parent_id
FROM db_menu
WHERE id = 101id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/modules/mod_icemegamenu/libs/menucore.php:81 19 IceMenuTree->getCurrentMenuItem() JROOT/modules/mod_icemegamenu/libs/menucore.php:67 18 IceMenuTree->__construct() JROOT/modules/mod_icemegamenu/helper.php:45 17 modIceMegamenuHelper::buildXML() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 14 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/modules/mod_icemegamenu/helper.php:114 13 modIceMegamenuHelper->getXML() JROOT/modules/mod_icemegamenu/helper.php:153 12 modIceMegamenuHelper->render() JROOT/templates/theme657/html/mod_icemegamenu/default.php:27 11 require JROOT/templates/theme657/html/mod_icemegamenu/default.php JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65 10 include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.41 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 20.039 MB Filas devueltas: 1
SELECT id,parent_id
FROM db_menu
WHERE id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE db_menu NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.07 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/modules/mod_icemegamenu/libs/menucore.php:81 19 IceMenuTree->getCurrentMenuItem() JROOT/modules/mod_icemegamenu/libs/menucore.php:67 18 IceMenuTree->__construct() JROOT/modules/mod_icemegamenu/helper.php:45 17 modIceMegamenuHelper::buildXML() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 14 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/modules/mod_icemegamenu/helper.php:114 13 modIceMegamenuHelper->getXML() JROOT/modules/mod_icemegamenu/helper.php:153 12 modIceMegamenuHelper->render() JROOT/templates/theme657/html/mod_icemegamenu/default.php:27 11 require JROOT/templates/theme657/html/mod_icemegamenu/default.php JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65 10 include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.69 ms Después de la última consulta: 4.67 ms Consulta a la memoria: 0.011 MB memoria antes de la consulta: 20.258 MB Filas devueltas: 1
SELECT distinct(m.id), title, module, position, content, showtitle, params
FROM db_modules AS m
LEFT JOIN db_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.id in(258)
AND m.published > 0
ORDER BY position, ordering