GANADO

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1575822030,
                "last": 1575822030,
                "now": 1575822030
            },
            "token": "no9nECVLEQQ9MuIG6u5F1NaCSL8xY3bD"
        },
        "registry": {
            "com_virtuemart": {
                "categoryc23": {
                    "limit": "24"
                },
                "categoryc23m0": {
                    "limitstart": 0
                }
            },
            "global": {
                "list": {
                    "limit": 24
                }
            },
            "com_ganalytics": {
                "profiles": {
                    "ordercol": null,
                    "limitstart": 0
                }
            }
        },
        "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": 193,
        "vmlastvisitedcategoryid": 23,
        "vmlastvisitedmanuid": -1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"es-CO\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}"
    }
}

Información de perfil

Hora

Memoria

Hora: 59.50 ms / 59.50 ms Memoria: 0.870 MB / 1.09 MB Application: afterLoad

Hora: 191.37 ms / 250.88 ms Memoria: 1.822 MB / 2.91 MB Application: afterInitialise

Hora: 76.92 ms / 327.80 ms Memoria: 0.809 MB / 3.72 MB Application: Before Access::preloadComponents (all components)

Hora: 1.52 ms / 329.32 ms Memoria: 0.104 MB / 3.82 MB Application: After Access::preloadComponents (all components)

Hora: 0.05 ms / 329.37 ms Memoria: 0.000 MB / 3.82 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Hora: 1.81 ms / 331.19 ms Memoria: 0.022 MB / 3.84 MB Application: After Access::getAssetRules (id:1 name:root.1)

Hora: 39.14 ms / 370.33 ms Memoria: 0.710 MB / 4.55 MB Application: afterRoute

Hora: 0.54 ms / 370.86 ms Memoria: 0.012 MB / 4.56 MB Application: beforeRenderComponent com_virtuemart

Hora: 174.63 ms / 545.50 ms Memoria: 3.620 MB / 8.18 MB Application: afterRenderComponent com_virtuemart

Hora: 30.03 ms / 575.52 ms Memoria: 0.191 MB / 8.37 MB Application: afterDispatch

Hora: 5.06 ms / 580.58 ms Memoria: 0.053 MB / 8.42 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Hora: 0.16 ms / 580.74 ms Memoria: 0.010 MB / 8.43 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Hora: 4.75 ms / 585.49 ms Memoria: 0.089 MB / 8.52 MB Application: beforeRenderModule mod_custom (Payu)

Hora: 2.60 ms / 588.08 ms Memoria: 0.013 MB / 8.54 MB Application: afterRenderModule mod_custom (Payu)

Hora: 0.08 ms / 588.16 ms Memoria: 0.000 MB / 8.53 MB Application: beforeRenderModule mod_custom (Footer)

Hora: 0.24 ms / 588.40 ms Memoria: 0.007 MB / 8.54 MB Application: afterRenderModule mod_custom (Footer)

Hora: 0.19 ms / 588.59 ms Memoria: 0.000 MB / 8.53 MB Application: beforeRenderModule mod_custom (Mapa)

Hora: 0.24 ms / 588.83 ms Memoria: 0.007 MB / 8.54 MB Application: afterRenderModule mod_custom (Mapa)

Hora: 0.15 ms / 588.98 ms Memoria: 0.000 MB / 8.54 MB Application: beforeRenderModule mod_custom (Contacto)

Hora: 0.23 ms / 589.21 ms Memoria: 0.007 MB / 8.55 MB Application: afterRenderModule mod_custom (Contacto)

Hora: 0.15 ms / 589.36 ms Memoria: 0.000 MB / 8.54 MB Application: beforeRenderModule mod_custom (Eventos)

Hora: 0.25 ms / 589.61 ms Memoria: 0.007 MB / 8.55 MB Application: afterRenderModule mod_custom (Eventos)

Hora: 0.15 ms / 589.76 ms Memoria: 0.000 MB / 8.55 MB Application: beforeRenderModule mod_login (Ingrese para registrar)

Hora: 9.64 ms / 599.40 ms Memoria: 0.068 MB / 8.62 MB Application: afterRenderModule mod_login (Ingrese para registrar)

Hora: 0.21 ms / 599.61 ms Memoria: 0.000 MB / 8.61 MB Application: beforeRenderModule mod_custom (Publicar en Nuestro foro)

Hora: 0.26 ms / 599.87 ms Memoria: 0.007 MB / 8.62 MB Application: afterRenderModule mod_custom (Publicar en Nuestro foro)

Hora: 0.15 ms / 600.02 ms Memoria: 0.000 MB / 8.62 MB Application: beforeRenderModule mod_breadcrumbs (Migas)

Hora: 18.24 ms / 618.27 ms Memoria: 0.285 MB / 8.90 MB Application: afterRenderModule mod_breadcrumbs (Migas)

Hora: 0.33 ms / 618.60 ms Memoria: 0.000 MB / 8.89 MB Application: beforeRenderModule mod_menu (Main Menu 2)

Hora: 7.48 ms / 626.08 ms Memoria: 0.077 MB / 8.97 MB Application: afterRenderModule mod_menu (Main Menu 2)

Hora: 0.20 ms / 626.28 ms Memoria: 0.000 MB / 8.96 MB Application: beforeRenderModule mod_custom (Llamenos)

Hora: 0.24 ms / 626.52 ms Memoria: 0.007 MB / 8.97 MB Application: afterRenderModule mod_custom (Llamenos)

Hora: 0.15 ms / 626.67 ms Memoria: 0.000 MB / 8.97 MB Application: beforeRenderModule mod_virtuemart_cart (Sus compras)

Hora: 64.79 ms / 691.46 ms Memoria: 0.867 MB / 9.83 MB Application: afterRenderModule mod_virtuemart_cart (Sus compras)

Hora: 0.16 ms / 691.62 ms Memoria: 0.012 MB / 9.85 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Hora: 5.85 ms / 697.48 ms Memoria: 0.157 MB / 10.00 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Hora: 0.32 ms / 697.79 ms Memoria: 0.000 MB / 9.85 MB Application: beforeRenderModule mod_custom (Logo)

Hora: 0.24 ms / 698.03 ms Memoria: 0.007 MB / 9.85 MB Application: afterRenderModule mod_custom (Logo)

Hora: 817.22 ms / 1515.25 ms Memoria: 0.967 MB / 10.82 MB Application: afterRender

Total de consultas de base de datos: 61.92 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_session	const	PRIMARY	PRIMARY	194	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	Caller	Número de archivo y 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

No es posible hacer EXPLAIN en la consulta: INSERT INTO `mtqeg_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'6f69653534746c63753438696b30346b743836696b6c74663335', 1, 1575822030, 0, '')

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
update	0.09 ms
end	0.01 ms
query end	24.80 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.72 ms Después de la última consulta: 8.65 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.793 MB Filas entregadas por la consulta: 42

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `mtqeg_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_extensions	ref	extension	extension	82	const	42	Using index condition; Using where

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y 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}()	Igual que la llamada en 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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.27 ms Después de la última consulta: 7.27 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.892 MB Filas entregadas por la consulta: 5

SELECT id, rules

  FROM `mtqeg_viewlevels`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_viewlevels	ALL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	5

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y 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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.37 ms Después de la última consulta: 0.24 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.917 MB Filas entregadas por la consulta: 2

SELECT b.id

  FROM mtqeg_usergroups AS a

  LEFT JOIN mtqeg_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y 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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.24 ms Después de la última consulta: 2.04 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 1.956 MB Filas entregadas por la consulta: 92

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM mtqeg_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_extensions	ref	extension	extension	82	const	143	Using index condition; Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.64 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual que la llamada en 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:359
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.04 ms Después de la última consulta: 92.39 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 2.991 MB Filas entregadas por la consulta: 22

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 mtqeg_menu AS m

  LEFT JOIN mtqeg_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	23	Using index condition; Using where; Utilizando filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	acriader_cms.m.component_id	1	Using where

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.19 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y 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}()	Igual que la llamada en 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:76
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:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
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:64
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:491
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:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.98 ms Después de la última consulta: 65.51 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 3.571 MB Filas entregadas por la consulta: 1

SHOW TABLES LIKE "mtqeg_virtuemart_configs"

Explicar

No es posible hacer EXPLAIN en la consulta: SHOW TABLES LIKE "mtqeg_virtuemart_configs"

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.63 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:575
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:933
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.28 ms Después de la última consulta: 0.25 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.593 MB Filas entregadas por la consulta: 1

SELECT `config` 
  FROM `mtqeg_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_configs	system	PRIMARY	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	1

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:981
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.40 ms Después de la última consulta: 1.36 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 3.684 MB Filas entregadas por la consulta: 2

SELECT *

  FROM mtqeg_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_languages	ALL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	2	Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.06 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:77
14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:64
13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1002
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.78 ms Después de la última consulta: 0.68 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 3.725 MB Filas entregadas por la consulta: 42

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `mtqeg_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforums','com_cjlib','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_ganalytics','com_installer','com_joomlaupdate','com_kunena','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_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_assets	ALL	idx_asset_name	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	101	Using where

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1342
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1003
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.61 ms Después de la última consulta: 4.65 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 3.865 MB Filas entregadas por la consulta: 4

SELECT id, home, template, s.params

  FROM mtqeg_template_styles as s

  LEFT JOIN mtqeg_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 = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	acriader_cms.s.template,const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y 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:803
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.43 ms Después de la última consulta: 0.43 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 3.884 MB Filas entregadas por la consulta: 1

SELECT `id` 
  FROM `mtqeg_menu` 
  WHERE `home`="1" 
  and (language="*" or language = "es-CO" ) 
  ORDER BY `language` DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_menu	ALL	idx_language	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	84	Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.14 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:814
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.63 ms Después de la última consulta: 0.19 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.903 MB Filas entregadas por la consulta: 1

SELECT * 
  FROM `mtqeg_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "es-CO" ) 
  AND ( access="1" OR access="5" )  
  ORDER BY `language` DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	24	Using index condition; Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.23 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1229
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:821
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.30 ms Después de la última consulta: 0.36 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 3.927 MB Filas entregadas por la consulta: 1

SELECT l.virtuemart_category_id  
  FROM `mtqeg_virtuemart_categories_es_co` as l  
  WHERE l.slug = "ganado"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	const	slug	slug	578	const	1

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1165
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:996
11	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:705
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.49 ms Después de la última consulta: 7.72 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.074 MB Filas entregadas por la consulta: 1

SELECT `mtqeg_virtuemart_categories`.* ,`mtqeg_virtuemart_categories_es_co`.*  
  FROM `mtqeg_virtuemart_categories` 
  INNER JOIN `mtqeg_virtuemart_categories_es_co` using (`virtuemart_category_id`) 
  WHERE `mtqeg_virtuemart_categories`.`virtuemart_category_id` = "23"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_categories	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	mtqeg_virtuemart_categories_es_co	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:84
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.31 ms Después de la última consulta: 2.53 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.178 MB Filas entregadas por la consulta: 0

SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "23" 
  ORDER BY `ordering`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:87
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.24 ms Después de la última consulta: 0.17 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 4.198 MB Filas entregadas por la consulta: 3

SELECT `category_child_id`
			
  FROM `mtqeg_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 23

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_category_categories	ref	category_parent_id	category_parent_id	4	const	3	Using index

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:687
13	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:114
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.10 ms Después de la última consulta: 4.62 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 4.272 MB Filas entregadas por la consulta: 3

SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug 
  FROM mtqeg_virtuemart_categories as c  
  LEFT JOIN `mtqeg_virtuemart_categories_es_co` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  LEFT JOIN `mtqeg_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 23  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY c.ordering,category_name ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cx	ref	category_parent_id,category_child_id	category_parent_id	4	const	3	Using index; Using temporary; Utilizando filesort
1	SIMPLE	c	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	acriader_cms.cx.category_child_id	1	Using where
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	acriader_cms.cx.category_child_id	1

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.14 ms
Copying to tmp table	0.22 ms
Sorting result	0.05 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:238
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en 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/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.26 ms Después de la última consulta: 0.27 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.308 MB Filas entregadas por la consulta: 0

SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "30" 
  ORDER BY `ordering`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:243
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en 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/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.24 ms Después de la última consulta: 0.29 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.332 MB Filas entregadas por la consulta: 0

SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "24" 
  ORDER BY `ordering`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:243
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en 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/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.24 ms Después de la última consulta: 0.21 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.357 MB Filas entregadas por la consulta: 0

SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "25" 
  ORDER BY `ordering`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:243
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en 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/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.40 ms Después de la última consulta: 0.34 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.353 MB Filas entregadas por la consulta: 1

SELECT count(`p`.virtuemart_product_id) AS total	
  
  FROM `mtqeg_virtuemart_product_categories` as `pc`
  
  LEFT JOIN `mtqeg_virtuemart_products` as `p` 
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
  
  WHERE `pc`.`virtuemart_category_id` = "23"
  
  AND `p`.`virtuemart_vendor_id` = "1"
  
  AND `p`.`published` = "1"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	index	virtuemart_product_id	virtuemart_product_id	8	NULL	123	Using where; Using index
1	SIMPLE	p	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	acriader_cms.pc.virtuemart_product_id	1	Using where

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:417
13	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:124
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.25 ms Después de la última consulta: 0.16 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.373 MB Filas entregadas por la consulta: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  mtqeg_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 23

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	category_child_id	category_child_id	4	const	1

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
14	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:716
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:127
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.24 ms Después de la última consulta: 0.23 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.395 MB Filas entregadas por la consulta: 1

SELECT l.virtuemart_category_id, l.category_name  
  FROM `mtqeg_virtuemart_categories_es_co` as l  
  WHERE l.virtuemart_category_id = 23

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:735
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:127
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.39 ms Después de la última consulta: 1.52 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 4.437 MB Filas entregadas por la consulta: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `mtqeg_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual que la llamada en la línea de abajo.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:53
9	plgSystemJqueryeasy->onAfterRoute()	Igual que la llamada en la línea de abajo.
8	call_user_func_array()	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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.98 ms Después de la última consulta: 0.40 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 4.444 MB

UPDATE `mtqeg_extensions`

  SET `params` = '{\"mediaversion\":\"0f998739924164c30bad5ba425ea5435\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explicar

No es posible hacer EXPLAIN en la consulta: UPDATE `mtqeg_extensions` SET `params` = '{\"mediaversion\":\"0f998739924164c30bad5ba425ea5435\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
updating	0.09 ms
end	0.01 ms
query end	1.65 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:53
9	plgSystemJqueryeasy->onAfterRoute()	Igual que la llamada en la línea de abajo.
8	call_user_func_array()	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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.27 ms Después de la última consulta: 78.39 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 5.294 MB Filas entregadas por la consulta: 0

SELECT c.* 
  FROM mtqeg_virtuemart_customs  as c 
  INNER JOIN mtqeg_virtuemart_product_customfields as pc 
  on (c.virtuemart_custom_id=pc.virtuemart_custom_id)

  INNER JOIN mtqeg_virtuemart_product_categories as cat 
  ON (pc.virtuemart_product_id=cat.virtuemart_product_id) 
  WHERE virtuemart_category_id="23" 
  and searchable="1" 
  and (field_type="S" or field_type="P") 
  and c.published = 1 
  GROUP BY c.virtuemart_custom_id

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,field_type,searchable,published	searchable	1	const	1	Using where; Using temporary; Utilizando filesort
1	SIMPLE	pc	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_custom_id	4	acriader_cms.c.virtuemart_custom_id	131	Using index condition
1	SIMPLE	cat	eq_ref	virtuemart_product_id	virtuemart_product_id	8	acriader_cms.pc.virtuemart_product_id,const	1	Using where; Using index

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.01 ms
Creating tmp table	0.42 ms
Copying to tmp table	0.04 ms
Sorting result	0.03 ms
Sending data	0.04 ms
end	0.01 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/views/category/view.html.php:541
10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:215
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.46 ms Después de la última consulta: 9.14 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 5.522 MB Filas entregadas por la consulta: 1

SELECT * 
  FROM `mtqeg_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	3	Using where

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:459
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.25 ms Después de la última consulta: 0.38 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 5.591 MB Filas entregadas por la consulta: 1

SELECT `mtqeg_virtuemart_shoppergroups`.*  
  FROM `mtqeg_virtuemart_shoppergroups`  
  WHERE `mtqeg_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:459
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.71 ms Después de la última consulta: 3.81 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.673 MB Filas entregadas por la consulta: 1

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
		
  FROM `mtqeg_virtuemart_products` as p  
 
  LEFT JOIN `mtqeg_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 
  LEFT JOIN `mtqeg_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 
 
  WHERE ( `pc`.`virtuemart_category_id` = 23 
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
 
  group by p.`virtuemart_product_id` 
 
  ORDER BY `pc`.`ordering` ASC, p.`virtuemart_product_id` ASC 
  LIMIT 0, 24

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ps	system	virtuemart_product_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found; Using temporary; Utilizando filesort
1	SIMPLE	pc	ALL	virtuemart_product_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	123	Using where
1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	acriader_cms.pc.virtuemart_product_id	1	Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Creating tmp table	0.03 ms
Copying to tmp table	0.08 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:749
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.14 ms Después de la última consulta: 0.20 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.691 MB Filas entregadas por la consulta: 1

SELECT FOUND_ROWS()

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	NULL	No tables used

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.00 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:749
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.65 ms Después de la última consulta: 5.49 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.827 MB Filas entregadas por la consulta: 0

SELECT DISTINCT  l.virtuemart_manufacturer_id, l.mf_name  
  FROM `mtqeg_virtuemart_manufacturers_es_co` as l  
  INNER JOIN `mtqeg_virtuemart_product_manufacturers` AS pm 
  ON pm.`virtuemart_manufacturer_id` = l.`virtuemart_manufacturer_id`  
  INNER JOIN `mtqeg_virtuemart_products` as p 
  ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`  
  INNER JOIN `mtqeg_virtuemart_product_categories` as pc 
  ON pc.`virtuemart_product_id` = pm.`virtuemart_product_id`  
  WHERE p.`published` = "1" 
  AND pc.`virtuemart_category_id` = "23" 
  ORDER BY `mf_name`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	ALL	PRIMARY	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	3	Using temporary; Utilizando filesort
1	SIMPLE	pm	index	virtuemart_product_id	virtuemart_product_id	10	NULL	4	Using where; Using index; Distinct; Using join buffer (flat, BNL join)
1	SIMPLE	pc	eq_ref	virtuemart_product_id	virtuemart_product_id	8	acriader_cms.pm.virtuemart_product_id,const	1	Using where; Using index; Distinct
1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	acriader_cms.pm.virtuemart_product_id	1	Using index condition; Using where; Distinct

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.07 ms
executing	0.01 ms
Creating tmp table	0.03 ms
Copying to tmp table	0.07 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:220
14	VirtueMartModelManufacturer::getManufacturersOfProductsInCategory()	Igual que la llamada en la línea de abajo.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/product.php:2647
10	VirtueMartModelProduct->getOrderByList()	JROOT/components/com_virtuemart/views/category/view.html.php:245
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.47 ms Después de la última consulta: 2.13 ms Memoria de consulta: 0.033 MB memoria antes de consulta: 5.857 MB Filas entregadas por la consulta: 1

SELECT `mtqeg_virtuemart_products`.* ,`mtqeg_virtuemart_products_es_co`.*  
  FROM `mtqeg_virtuemart_products` 
  INNER JOIN `mtqeg_virtuemart_products_es_co` using (`virtuemart_product_id`) 
  WHERE `mtqeg_virtuemart_products`.`virtuemart_product_id` = "1420"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_products	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	mtqeg_virtuemart_products_es_co	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1378
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.30 ms Después de la última consulta: 1.00 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.927 MB Filas entregadas por la consulta: 3

SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "1420" 
  ORDER BY `ordering`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	2	Using where

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1383
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.20 ms Después de la última consulta: 0.66 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.988 MB Filas entregadas por la consulta: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `mtqeg_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "1420"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1386
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.45 ms Después de la última consulta: 0.31 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 6.006 MB Filas entregadas por la consulta: 1

SELECT * 
  FROM `mtqeg_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "1420"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2019-12-08 16:20:31" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-08 16:20:31" ) ) 
  ORDER BY `product_price` DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_product_prices	ref	virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down,virtuemart_product_id	virtuemart_product_id	4	const	6	Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1182
14	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
13	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1401
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.24 ms Después de la última consulta: 0.73 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 6.067 MB Filas entregadas por la consulta: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `mtqeg_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "1420"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_product_manufacturers	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	Using index

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1405
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.24 ms Después de la última consulta: 0.17 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 6.087 MB Filas entregadas por la consulta: 1

SELECT * 
  FROM `mtqeg_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 1420

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	1

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1644
14	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1621
13	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1421
12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.54 ms Después de la última consulta: 7.07 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 6.202 MB Filas entregadas por la consulta: 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.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
		
  FROM `mtqeg_virtuemart_customs` AS c 
  LEFT JOIN `mtqeg_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (1420) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	acriader_cms.field.virtuemart_custom_id	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:150
13	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2574
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.39 ms Después de la última consulta: 1.36 ms Memoria de consulta: 0.034 MB memoria antes de consulta: 6.282 MB Filas entregadas por la consulta: 1

SELECT *  
  FROM `mtqeg_virtuemart_currencies` AS c
			
  LEFT JOIN `mtqeg_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v	system	PRIMARY,vendor_currency	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
17	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
16	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
15	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2581
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.30 ms Después de la última consulta: 2.56 ms Memoria de consulta: 0.031 MB memoria antes de consulta: 6.400 MB Filas entregadas por la consulta: 1

SELECT `mtqeg_virtuemart_currencies`.*  
  FROM `mtqeg_virtuemart_currencies`  
  WHERE `mtqeg_virtuemart_currencies`.`virtuemart_currency_id` = "31"

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_currencies	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
15	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2581
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 1.15 ms Después de la última consulta: 14.49 ms Memoria de consulta: 0.038 MB memoria antes de consulta: 6.557 MB Filas entregadas por la consulta: 31

SHOW FULL COLUMNS  
  FROM `mtqeg_virtuemart_userfields`

Explicar

No es posible hacer EXPLAIN en la consulta: SHOW FULL COLUMNS FROM `mtqeg_virtuemart_userfields`

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
checking permissions	0.02 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
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
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
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
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
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:662
24	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
23	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:219
22	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434
21	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396
20	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602
19	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:52
18	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554
17	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:251
16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2581
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.64 ms Después de la última consulta: 0.51 ms Memoria de consulta: 0.040 MB memoria antes de consulta: 6.653 MB Filas entregadas por la consulta: 17

SELECT * 
  FROM `mtqeg_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type') = 0  
  ORDER BY ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_userfields	ref	published,account	account	1	const	19	Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.14 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:504
17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2581
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.30 ms Después de la última consulta: 0.80 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 6.806 MB Filas entregadas por la consulta: 2

SELECT `fieldtitle`, `fieldvalue` 
  FROM `mtqeg_virtuemart_userfield_values` 
  WHERE `virtuemart_userfield_id` = 23 
  ORDER BY `ordering`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_userfield_values	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1037
17	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:267
16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2581
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.44 ms Después de la última consulta: 4.17 ms Memoria de consulta: 0.033 MB memoria antes de consulta: 6.929 MB Filas entregadas por la consulta: 10

SELECT * 
  FROM `mtqeg_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY country_name ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_countries	ref	published	published	1	const	11	Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.10 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
20	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
19	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
18	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:848
17	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:267
16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2581
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.57 ms Después de la última consulta: 2.69 ms Memoria de consulta: 0.039 MB memoria antes de consulta: 7.038 MB Filas entregadas por la consulta: 10

SELECT * 
  FROM `mtqeg_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 ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_userfields	ref	published,shipment	shipment	1	const	11	Using where; Utilizando filesort

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.10 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
18	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:510
17	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
16	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
15	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
14	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
13	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2581
12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Agregue la directiva xdebug.file_link_format al archivo php.ini para tener enlaces para los archivos.]

Tiempo de consulta: 0.61 ms Después de la última consulta: 3.14 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 7.228 MB Filas entregadas por la consulta: 4

Llámenos
(+57)3132526318
(+57)3133969237

Ganado Paturro Mini Cattle

Leche

Carne

GANADO

TERNERAS GYRHOLANDAS

Publicar en Nuestro foro

Ingrese para registrar

Eventos

Contacto

Formulario de contacto

Consola de depuración de Joomla!

Sesión

Información de perfil

Hora

Memoria

Uso de la memoria

Consultas de base de datos

84 consultas registradas 61.92 ms

2 duplicado encontrado!

Llámenos (+57)3132526318 (+57)3133969237

Ganado Paturro Mini Cattle

Leche

Carne

GANADO

TERNERAS GYRHOLANDAS

Publicar en Nuestro foro

Ingrese para registrar

Eventos

Contacto

Formulario de contacto

Consola de depuración de Joomla!

Sesión

Información de perfil

Hora

Memoria

Uso de la memoria

Consultas de base de datos

84 consultas registradas 61.92 ms

2 duplicado encontrado!

Llámenos
(+57)3132526318
(+57)3133969237