Machos

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1561405392,
                "last": 1561405392,
                "now": 1561405392
            },
            "token": "LOWwEX89qbYj8hcqzYUyjUxCuhX82h7f"
        },
        "registry": {
            "com_virtuemart": {
                "categoryc20": {
                    "limit": "24"
                },
                "categoryc20m0": {
                    "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": 20,
        "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}"
    }
}

Hora

Memoria

120 consultas registradas 48.00 ms

1. Tiempo de consulta: 0.34 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.586 MB Filas entregadas por la consulta: 0

   SELECT `data`
   
     FROM `mtqeg_session`
   
     WHERE `session_id` = 'rgbedequvnn4ecfgah64t9sap5'

   Explicar

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

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Igual que la llamada en la línea de abajo.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   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.]

   ---

2. Tiempo de consulta: 0.24 ms Después de la última consulta: 3.97 ms Memoria de consulta: 0.013 MB memoria antes de consulta: 1.644 MB Filas entregadas por la consulta: 0

   SELECT `session_id`
   
     FROM `mtqeg_session`
   
     WHERE `session_id` = 'rgbedequvnn4ecfgah64t9sap5' 
     LIMIT 1

   Explicar

   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

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   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

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

   ---

3. Tiempo de consulta: 1.86 ms Después de la última consulta: 0.25 ms Memoria de consulta: 0.010 MB memoria antes de consulta: 1.660 MB

   INSERT INTO `mtqeg_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('rgbedequvnn4ecfgah64t9sap5', 1, 1561405392, 0, '')

   Explicar

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

   Perfil

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   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.]

   ---

4. Tiempo de consulta: 0.68 ms Después de la última consulta: 8.49 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 1.740 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

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   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.]

   ---

5. Tiempo de consulta: 0.26 ms Después de la última consulta: 7.35 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.839 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

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   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.]

   ---

6. Tiempo de consulta: 0.31 ms Después de la última consulta: 0.25 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.864 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

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   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.]

   ---

7. Tiempo de consulta: 1.18 ms Después de la última consulta: 2.03 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 1.903 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

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   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.]

   ---

8. Tiempo de consulta: 1.06 ms Después de la última consulta: 93.08 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 2.931 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

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   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.]

   ---

9. Tiempo de consulta: 1.26 ms Después de la última consulta: 62.79 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 3.511 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

   Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

   Call Stack

   #	Caller	Número de archivo y de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   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.]

   ---

10. Tiempo de consulta: 0.39 ms Después de la última consulta: 0.20 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.533 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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    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.]

    ---

11. Tiempo de consulta: 0.48 ms Después de la última consulta: 1.37 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 3.623 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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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.]

    ---

12. Tiempo de consulta: 0.88 ms Después de la última consulta: 0.71 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 3.664 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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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.]

    ---

13. Tiempo de consulta: 0.60 ms Después de la última consulta: 3.79 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 3.805 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	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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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.]

    ---

14. Tiempo de consulta: 0.52 ms Después de la última consulta: 0.51 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 3.823 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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    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.]

    ---

15. Tiempo de consulta: 0.67 ms Después de la última consulta: 0.22 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.843 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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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.]

    ---

16. Tiempo de consulta: 0.39 ms Después de la última consulta: 0.35 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 3.867 MB Filas entregadas por la consulta: 1

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

    Explicar

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

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    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.]

    ---

17. Tiempo de consulta: 0.48 ms Después de la última consulta: 6.51 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.014 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` = "20"

    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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    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.]

    ---

18. Tiempo de consulta: 0.36 ms Después de la última consulta: 2.50 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.118 MB Filas entregadas por la consulta: 1

    SELECT `virtuemart_media_id` 
      FROM `mtqeg_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "20" 
      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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    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.]

    ---

19. Tiempo de consulta: 0.35 ms Después de la última consulta: 0.21 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 4.138 MB Filas entregadas por la consulta: 0

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

    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	1	Using index

    Perfil

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    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.]

    ---

20. Tiempo de consulta: 0.50 ms Después de la última consulta: 0.18 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.157 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` = "20"
      
      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	110	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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    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.]

    ---

21. Tiempo de consulta: 0.33 ms Después de la última consulta: 0.21 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.177 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`= 20

    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

    Sin SHOW PROFILE (tal vez poeque hay más de 100 consultas)

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    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.]

    ---

22. Tiempo de consulta: 0.30 ms Después de la última consulta: 0.31 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 4.198 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`= 19

    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.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.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 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.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
    15	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:781
    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.]

    ---

23. Tiempo de consulta: 0.30 ms Después de la última consulta: 0.24 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.222 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 = 19

    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.02 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.03 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    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.]

    ---

24. Tiempo de consulta: 0.24 ms Después de la última consulta: 0.25 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.242 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 = 20

    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.02 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.00 ms
    Unlocking tables	0.01 ms
    executing	0.00 ms
    Sending data	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.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    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.]

    ---

25. Tiempo de consulta: 0.33 ms Después de la última consulta: 1.52 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 4.282 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.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.06 ms
    preparing	0.02 ms
    executing	0.00 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.00 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    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.]

    ---

26. Tiempo de consulta: 2.11 ms Después de la última consulta: 0.37 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 4.290 MB

    UPDATE `mtqeg_extensions`
    
      SET `params` = '{\"mediaversion\":\"3222ec80c731d7e0a597a2a8e46286a0\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explicar

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

    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.00 ms
    init	0.06 ms
    updating	0.08 ms
    end	0.01 ms
    query end	1.75 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.]

    ---

27. Tiempo de consulta: 0.66 ms Después de la última consulta: 63.62 ms Memoria de consulta: 0.041 MB memoria antes de consulta: 4.998 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` = "19"

    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.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:84
    22	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:969
    21	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:938
    20	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:898
    19	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:82
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/category/view.html.php:513
    10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:131
    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.]

    ---

28. Tiempo de consulta: 0.30 ms Después de la última consulta: 0.56 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 5.041 MB Filas entregadas por la consulta: 0

    SELECT `virtuemart_media_id` 
      FROM `mtqeg_virtuemart_category_medias` 
      WHERE `virtuemart_category_id` = "19" 
      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.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.02 ms
    executing	0.00 ms
    Sorting result	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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:87
    22	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:969
    21	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:938
    20	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:898
    19	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:82
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/category/view.html.php:513
    10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:131
    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.]

    ---

29. Tiempo de consulta: 1.19 ms Después de la última consulta: 18.23 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 5.269 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="20" 
      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.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.05 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.04 ms
    executing	0.01 ms
    Creating tmp table	0.40 ms
    Copying to tmp table	0.08 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.01 ms
    removing tmp table	0.11 ms
    end	0.01 ms
    query end	0.01 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
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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.]

    ---

30. Tiempo de consulta: 0.37 ms Después de la última consulta: 8.77 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 5.496 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.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.03 ms
    optimizing	0.02 ms
    statistics	0.04 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    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.]

    ---

31. Tiempo de consulta: 0.28 ms Después de la última consulta: 0.51 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 5.566 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.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.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.00 ms
    Unlocking tables	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.00 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:1459
    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.]

    ---

32. Tiempo de consulta: 0.62 ms Después de la última consulta: 3.55 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.647 MB Filas entregadas por la consulta: 5

    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` = 20 
      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	110	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.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 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.03 ms
    executing	0.00 ms
    Creating tmp table	0.02 ms
    Copying to tmp table	0.11 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    end	0.00 ms
    removing tmp table	0.05 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    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.]

    ---

33. Tiempo de consulta: 0.23 ms Después de la última consulta: 0.21 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.666 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.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 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.00 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:1734
    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.]

    ---

34. Tiempo de consulta: 0.37 ms Después de la última consulta: 5.43 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.806 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` = "20" 
      ORDER BY `mf_name`

    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.05 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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.]

    ---

35. Tiempo de consulta: 0.45 ms Después de la última consulta: 2.19 ms Memoria de consulta: 0.033 MB memoria antes de consulta: 5.836 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` = "1282"

    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.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.00 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    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.]

    ---

36. Tiempo de consulta: 0.26 ms Después de la última consulta: 0.98 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.906 MB Filas entregadas por la consulta: 4

    SELECT `virtuemart_media_id` 
      FROM `mtqeg_virtuemart_product_medias` 
      WHERE `virtuemart_product_id` = "1282" 
      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	4	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.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:1544
    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.]

    ---

37. Tiempo de consulta: 0.19 ms Después de la última consulta: 0.69 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 5.967 MB Filas entregadas por la consulta: 0

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

    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.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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 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:1544
    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.]

    ---

38. Tiempo de consulta: 0.42 ms Después de la última consulta: 0.33 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 5.985 MB Filas entregadas por la consulta: 0

    SELECT * 
      FROM `mtqeg_virtuemart_product_prices` 
      WHERE `virtuemart_product_id` = "1282"  
      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-06-24 19:43:12" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-06-24 19:43:12" ) ) 
      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	1	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.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.04 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.03 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:1500
    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.]

    ---

39. Tiempo de consulta: 0.19 ms Después de la última consulta: 0.75 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 6.042 MB Filas entregadas por la consulta: 0

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

    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.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.01 ms
    preparing	0.00 ms
    Unlocking tables	0.01 ms
    executing	0.01 ms
    end	0.00 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:1544
    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.]

    ---

40. Tiempo de consulta: 0.22 ms Después de la última consulta: 0.16 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 6.062 MB Filas entregadas por la consulta: 1

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

    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.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.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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    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/