Machos

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1575820791,
                "last": 1575820791,
                "now": 1575820791
            },
            "token": "sf5MxOgyzQZj0uAS2imAMgl12Z9wC8rc"
        },
        "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

125 consultas registradas 86.94 ms

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

   SELECT `data`
   
     FROM `mtqeg_session`
   
     WHERE `session_id` = X'357264643733616c6a396f363634707139366473753734676331'

   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:1740
   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.39 ms Después de la última consulta: 6.48 ms Memoria de consulta: 0.013 MB memoria antes de consulta: 1.697 MB Filas entregadas por la consulta: 0

   SELECT `session_id`
   
     FROM `mtqeg_session`
   
     WHERE `session_id` = X'357264643733616c6a396f363634707139366473753734676331' 
     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:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Tiempo de consulta: 28.82 ms Después de la última consulta: 0.41 ms Memoria de consulta: 0.010 MB memoria antes de consulta: 1.713 MB

   INSERT INTO `mtqeg_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   (X'357264643733616c6a396f363634707139366473753734676331', 1, 1575820791, 0, '')

   Explicar

   No es posible hacer EXPLAIN en la consulta: INSERT INTO `mtqeg_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'357264643733616c6a396f363634707139366473753734676331', 1, 1575820791, 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.72 ms Después de la última consulta: 12.03 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.794 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:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Igual que la llamada en la línea de abajo.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Tiempo de consulta: 0.46 ms Después de la última consulta: 8.01 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.893 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:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Tiempo de consulta: 0.36 ms Después de la última consulta: 0.29 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.918 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:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Tiempo de consulta: 1.27 ms Después de la última consulta: 2.25 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 1.957 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:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual que la llamada en la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tiempo de consulta: 0.97 ms Después de la última consulta: 100.33 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 2.993 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:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual que la llamada en la línea de abajo.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tiempo de consulta: 1.28 ms Después de la última consulta: 68.71 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 3.572 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:1740
   15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701
   14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:575
   13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:933
   12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
   11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
   10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
   9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Tiempo de consulta: 0.33 ms Después de la última consulta: 0.25 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.594 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:1740
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:981
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tiempo de consulta: 0.46 ms Después de la última consulta: 1.69 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 3.685 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:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:77
    14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:64
    13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1002
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tiempo de consulta: 0.85 ms Después de la última consulta: 0.80 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 3.725 MB Filas entregadas por la consulta: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `mtqeg_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforums','com_cjlib','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_ganalytics','com_installer','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')

    Explicar

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

    Perfil

    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:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1342
    14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:643
    13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1003
    12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tiempo de consulta: 0.63 ms Después de la última consulta: 5.19 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 3.866 MB Filas entregadas por la consulta: 4

    SELECT id, home, template, s.params
    
      FROM mtqeg_template_styles as s
    
      LEFT JOIN mtqeg_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explicar

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

    Perfil

    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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:803
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

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

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

    Explicar

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

    Perfil

    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:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:814
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tiempo de consulta: 0.59 ms Después de la última consulta: 0.19 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.904 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:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1229
    13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:821
    12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
    11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tiempo de consulta: 0.32 ms Después de la última consulta: 0.37 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 3.928 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:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1165
    12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:996
    11	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:705
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tiempo de consulta: 1.36 ms Después de la última consulta: 8.79 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.075 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:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:84
    12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
    11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tiempo de consulta: 0.47 ms Después de la última consulta: 4.67 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.180 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:1550
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:87
    12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
    11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tiempo de consulta: 0.44 ms Después de la última consulta: 0.33 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 4.199 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.87 ms Después de la última consulta: 0.27 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.218 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	123	Using where; Using index
    1	SIMPLE	p	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	acriader_cms.pc.virtuemart_product_id	1	Using where

    Perfil

    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:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:417
    13	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:124
    12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
    11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tiempo de consulta: 0.57 ms Después de la última consulta: 0.39 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.238 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:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
    14	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:716
    13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:127
    12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
    11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tiempo de consulta: 0.63 ms Después de la última consulta: 0.38 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 4.259 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

    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:1662
    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.82 ms Después de la última consulta: 0.63 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.283 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

    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:1662
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:735
    13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:127
    12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
    11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tiempo de consulta: 0.41 ms Después de la última consulta: 0.51 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.303 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

    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:1662
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:735
    13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:127
    12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
    11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
    10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tiempo de consulta: 1.27 ms Después de la última consulta: 2.86 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 4.343 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

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

    Call Stack

    #	Caller	Número de archivo y de línea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual que la llamada en la línea de abajo.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:53
    9	plgSystemJqueryeasy->onAfterRoute()	Igual que la llamada en la línea de abajo.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tiempo de consulta: 4.05 ms Después de la última consulta: 0.90 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 4.351 MB

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

    Explicar

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

    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/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: 1.64 ms Después de la última consulta: 109.74 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 5.227 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.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    executing	0.01 ms
    Creating tmp table	0.43 ms
    Copying to tmp table	0.28 ms
    Sorting result	0.03 ms
    Sending data	0.05 ms
    end	0.01 ms
    removing tmp table	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/views/category/view.html.php:541
    10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:215
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tiempo de consulta: 0.55 ms Después de la última consulta: 11.05 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 5.455 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.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:459
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tiempo de consulta: 0.26 ms Después de la última consulta: 0.42 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 5.524 MB Filas entregadas por la consulta: 1

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

    Explicar

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

    Perfil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    executing	0.01 ms
    Sending data	0.02 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
    16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
    15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
    14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
    13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
    12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
    11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:459
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tiempo de consulta: 1.30 ms Después de la última consulta: 4.81 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.606 MB Filas entregadas por la consulta: 6

    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	123	Using where
    1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	acriader_cms.pc.virtuemart_product_id	1	Using where

    Perfil

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

    Call Stack

    #	Caller	Número de archivo y de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:749
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tiempo de consulta: 0.21 ms Después de la última consulta: 0.41 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.625 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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:855
    11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:749
    10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tiempo de consulta: 0.68 ms Después de la última consulta: 8.36 ms Memoria de consulta: 0.033 MB memoria antes de consulta: 5.769 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.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.07 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
    13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1378
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tiempo de consulta: 0.53 ms Después de la última consulta: 1.57 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.840 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.07 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1383
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tiempo de consulta: 0.35 ms Después de la última consulta: 1.00 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.902 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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1386
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tiempo de consulta: 0.55 ms Después de la última consulta: 0.41 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 5.920 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-12-08 15:59:52" )
    		        
      AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2019-12-08 15:59:52" ) ) 
      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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.04 ms
    statistics	0.09 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.05 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1182
    14	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
    13	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1401
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Tiempo de consulta: 0.40 ms Después de la última consulta: 1.31 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.976 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	mtqeg_virtuemart_product_manufacturers	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	Using index

    Perfil

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

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
    13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1405
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Tiempo de consulta: 0.29 ms Después de la última consulta: 0.20 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 5.996 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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	Número de archivo y de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1644
    14	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1621
    13	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1421
    12	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:984
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Tiempo de consulta: 0.74 ms Después de la última consulta: 7.73 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 6.114 MB Filas entregadas por la consulta: 4

    SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
    		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
    		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
    		
      FROM `mtqeg_virtuemart_customs` AS c 
      LEFT JOIN `mtqeg_virtuemart_product_customfields` AS field 
      ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
      WHERE field.`virtuemart_product_id` IN (1282) 
      AND c.`published` = "1"  
      ORDER BY field.`ordering` ASC

    Explicar

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

    Perfil

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

    Call Stack

    #	Caller	Número de archivo y de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:150
    13	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2574
    12	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1070
    11	VirtueMartModelProduct->getProduct()	JROOT/administrator/components/com_virtuemart/models/product.php:1799
    10	VirtueMartModelProduct->getProducts()	JROOT/components/com_virtuemart/views/category/view.html.php:246
    9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
    8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
    6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Tiempo de consulta: 0.47 ms Después de la última consulta: 3.96 ms Memoria de consulta: 0.034 MB memoria antes de consulta: 6.258 MB Filas entregadas por la consulta: 1