GANADO

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1571781904,
                "last": 1571781904,
                "now": 1571781904
            },
            "token": "BlkwUWqxaytoNVkqULe1JTuyBrvBNRO0"
        },
        "registry": {
            "com_virtuemart": {
                "categoryc23": {
                    "limit": "24"
                },
                "categoryc23m0": {
                    "limitstart": 0
                }
            },
            "global": {
                "list": {
                    "limit": 24
                }
            },
            "com_ganalytics": {
                "profiles": {
                    "ordercol": null,
                    "limitstart": 0
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 193,
        "vmlastvisitedcategoryid": 23,
        "vmlastvisitedmanuid": -1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"es-CO\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}"
    }
}

Información de perfil

Hora

Memoria

Hora: 61.69 ms / 61.69 ms Memoria: 0.820 MB / 1.04 MB Application: afterLoad

Hora: 186.32 ms / 248.00 ms Memoria: 1.813 MB / 2.85 MB Application: afterInitialise

Hora: 94.76 ms / 342.76 ms Memoria: 0.809 MB / 3.66 MB Application: Before Access::preloadComponents (all components)

Hora: 2.33 ms / 345.09 ms Memoria: 0.104 MB / 3.76 MB Application: After Access::preloadComponents (all components)

Hora: 0.16 ms / 345.25 ms Memoria: 0.000 MB / 3.75 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Hora: 3.45 ms / 348.70 ms Memoria: 0.022 MB / 3.78 MB Application: After Access::getAssetRules (id:1 name:root.1)

Hora: 90.24 ms / 438.94 ms Memoria: 0.709 MB / 4.49 MB Application: afterRoute

Hora: 0.77 ms / 439.71 ms Memoria: 0.012 MB / 4.50 MB Application: beforeRenderComponent com_virtuemart

Hora: 190.36 ms / 630.07 ms Memoria: 1.888 MB / 6.39 MB Application: afterRenderComponent com_virtuemart

Hora: 35.72 ms / 665.79 ms Memoria: 0.191 MB / 6.58 MB Application: afterDispatch

Hora: 5.97 ms / 671.75 ms Memoria: 0.053 MB / 6.63 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Hora: 0.17 ms / 671.92 ms Memoria: 0.010 MB / 6.64 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Hora: 5.93 ms / 677.85 ms Memoria: 0.090 MB / 6.73 MB Application: beforeRenderModule mod_custom (Payu)

Hora: 3.30 ms / 681.15 ms Memoria: 0.013 MB / 6.74 MB Application: afterRenderModule mod_custom (Payu)

Hora: 0.09 ms / 681.24 ms Memoria: 0.000 MB / 6.74 MB Application: beforeRenderModule mod_custom (Footer)

Hora: 0.45 ms / 681.69 ms Memoria: 0.007 MB / 6.75 MB Application: afterRenderModule mod_custom (Footer)

Hora: 0.20 ms / 681.89 ms Memoria: 0.000 MB / 6.74 MB Application: beforeRenderModule mod_custom (Mapa)

Hora: 0.24 ms / 682.13 ms Memoria: 0.007 MB / 6.75 MB Application: afterRenderModule mod_custom (Mapa)

Hora: 0.15 ms / 682.28 ms Memoria: 0.000 MB / 6.75 MB Application: beforeRenderModule mod_custom (Contacto)

Hora: 0.34 ms / 682.62 ms Memoria: 0.007 MB / 6.75 MB Application: afterRenderModule mod_custom (Contacto)

Hora: 0.15 ms / 682.77 ms Memoria: 0.000 MB / 6.75 MB Application: beforeRenderModule mod_custom (Eventos)

Hora: 0.24 ms / 683.01 ms Memoria: 0.007 MB / 6.76 MB Application: afterRenderModule mod_custom (Eventos)

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

Hora: 13.48 ms / 696.64 ms Memoria: 0.076 MB / 6.83 MB Application: afterRenderModule mod_login (Ingrese para registrar)

Hora: 0.31 ms / 696.94 ms Memoria: 0.000 MB / 6.83 MB Application: beforeRenderModule mod_custom (Publicar en Nuestro foro)

Hora: 0.27 ms / 697.22 ms Memoria: 0.007 MB / 6.84 MB Application: afterRenderModule mod_custom (Publicar en Nuestro foro)

Hora: 0.27 ms / 697.49 ms Memoria: 0.000 MB / 6.83 MB Application: beforeRenderModule mod_breadcrumbs (Migas)

Hora: 20.15 ms / 717.64 ms Memoria: 0.284 MB / 7.12 MB Application: afterRenderModule mod_breadcrumbs (Migas)

Hora: 0.32 ms / 717.96 ms Memoria: 0.000 MB / 7.11 MB Application: beforeRenderModule mod_menu (Main Menu 2)

Hora: 7.91 ms / 725.87 ms Memoria: 0.077 MB / 7.19 MB Application: afterRenderModule mod_menu (Main Menu 2)

Hora: 0.19 ms / 726.06 ms Memoria: 0.000 MB / 7.18 MB Application: beforeRenderModule mod_custom (Llamenos)

Hora: 0.25 ms / 726.31 ms Memoria: 0.007 MB / 7.19 MB Application: afterRenderModule mod_custom (Llamenos)

Hora: 0.27 ms / 726.58 ms Memoria: 0.000 MB / 7.18 MB Application: beforeRenderModule mod_virtuemart_cart (Sus compras)

Hora: 91.37 ms / 817.95 ms Memoria: 1.662 MB / 8.85 MB Application: afterRenderModule mod_virtuemart_cart (Sus compras)

Hora: 0.16 ms / 818.11 ms Memoria: 0.012 MB / 8.86 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Hora: 5.81 ms / 823.93 ms Memoria: 0.156 MB / 9.01 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Hora: 0.30 ms / 824.22 ms Memoria: 0.000 MB / 8.86 MB Application: beforeRenderModule mod_custom (Logo)

Hora: 0.24 ms / 824.47 ms Memoria: 0.007 MB / 8.86 MB Application: afterRenderModule mod_custom (Logo)

Hora: 838.10 ms / 1662.56 ms Memoria: 0.953 MB / 9.82 MB Application: afterRender

Total de consultas de base de datos: 64.98 ms

Uso de la memoria

Consultas de base de datos

54 consultas registradas 64.98 ms

4 duplicado encontrado!

2 duplicados: #32 #34

2 duplicados: #51 #53

Tiempo de consulta: 0.43 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.587 MB Filas entregadas por la consulta: 0

SELECT `data`

  FROM `mtqeg_session`

  WHERE `session_id` = '78gig8ahilf0nisjrkkkkj7in2'

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

Status	Duration
starting	0.08 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.06 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Igual que la llamada en la línea de abajo.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tiempo de consulta: 0.39 ms Después de la última consulta: 4.33 ms Memoria de consulta: 0.013 MB memoria antes de consulta: 1.644 MB Filas entregadas por la consulta: 0

SELECT `session_id`

  FROM `mtqeg_session`

  WHERE `session_id` = '78gig8ahilf0nisjrkkkkj7in2' 
  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

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.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tiempo de consulta: 1.93 ms Después de la última consulta: 0.25 ms Memoria de consulta: 0.010 MB memoria antes de consulta: 1.661 MB

INSERT INTO `mtqeg_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('78gig8ahilf0nisjrkkkkj7in2', 1, 1571781904, 0, '')

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tiempo de consulta: 0.95 ms Después de la última consulta: 10.36 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 1.741 MB Filas entregadas por la consulta: 42

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

  FROM `mtqeg_extensions`

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

Explicar

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

Perfil

Status	Duration
starting	0.10 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.06 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Igual que la llamada en la línea de abajo.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.47 ms Después de la última consulta: 9.26 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.840 MB Filas entregadas por la consulta: 5

SELECT id, rules

  FROM `mtqeg_viewlevels`

Explicar

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

Perfil

Status	Duration
starting	0.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.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.43 ms Después de la última consulta: 0.31 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.864 MB Filas entregadas por la consulta: 2

SELECT b.id

  FROM mtqeg_usergroups AS a

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

  WHERE a.id = 9

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.00 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.45 ms Después de la última consulta: 2.44 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 1.903 MB Filas entregadas por la consulta: 92

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

  FROM mtqeg_extensions

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

  ORDER BY ordering

Explicar

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

Perfil

Status	Duration
starting	0.10 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.09 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.63 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual que la llamada en la línea de abajo.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.03 ms Después de la última consulta: 103.90 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 2.932 MB Filas entregadas por la consulta: 22

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM mtqeg_menu AS m

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

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

  ORDER BY m.lft

Explicar

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

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.18 ms
Sending data	0.24 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.23 ms Después de la última consulta: 81.39 ms Memoria de consulta: 0.022 MB memoria antes de consulta: 3.511 MB Filas entregadas por la consulta: 1

SHOW TABLES LIKE "mtqeg_virtuemart_configs"

Explicar

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

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.06 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.04 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.70 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.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:1734
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:575
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:933
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.45 ms Después de la última consulta: 0.34 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.533 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.08 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.05 ms
preparing	0.00 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:981
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.73 ms Después de la última consulta: 1.71 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 3.624 MB Filas entregadas por la consulta: 2

SELECT *

  FROM mtqeg_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:77
14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:64
13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1002
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:844
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.27 ms Después de la última consulta: 0.82 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 3.664 MB Filas entregadas por la consulta: 42

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

  FROM `mtqeg_assets`

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

Explicar

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

Perfil

Status	Duration
starting	0.14 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.10 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.35 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.07 ms
cleaning up	0.01 ms

Call Stack

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

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

Tiempo de consulta: 1.11 ms Después de la última consulta: 8.36 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 3.805 MB Filas entregadas por la consulta: 4

SELECT id, home, template, s.params

  FROM mtqeg_template_styles as s

  LEFT JOIN mtqeg_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explicar

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

Perfil

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.02 ms
init	0.09 ms
optimizing	0.04 ms
statistics	0.21 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 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:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:803
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explicar

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

Perfil

Status	Duration
starting	0.19 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.05 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.21 ms
Sending data	0.04 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:814
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.33 ms Después de la última consulta: 0.70 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 3.843 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.12 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.04 ms
init	0.07 ms
optimizing	0.09 ms
statistics	0.15 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.31 ms
Sending data	0.08 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.04 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:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1229
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:821
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:849
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:351
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1165
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:996
11	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:705
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.19 ms Después de la última consulta: 16.31 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.014 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.24 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.04 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:84
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.65 ms Después de la última consulta: 4.46 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.118 MB Filas entregadas por la consulta: 0

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

Explicar

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

Perfil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	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.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:1544
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:87
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.48 ms Después de la última consulta: 0.26 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 4.138 MB Filas entregadas por la consulta: 3

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

Explicar

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

Perfil

Status	Duration
starting	0.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.03 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.00 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
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:687
13	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:114
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 2.04 ms Después de la última consulta: 6.14 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 4.212 MB Filas entregadas por la consulta: 3

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

Explicar

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

Perfil

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.07 ms
optimizing	0.15 ms
statistics	0.18 ms
preparing	0.09 ms
executing	0.01 ms
Creating tmp table	0.21 ms
Copying to tmp table	0.34 ms
Sorting result	0.15 ms
Sending data	0.14 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:238
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.81 ms Después de la última consulta: 0.42 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.247 MB Filas entregadas por la consulta: 0

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

Explicar

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

Perfil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.02 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:243
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.64 ms Después de la última consulta: 0.52 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.272 MB Filas entregadas por la consulta: 0

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

Explicar

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

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 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.10 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:243
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.79 ms Después de la última consulta: 0.50 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.297 MB Filas entregadas por la consulta: 0

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

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:243
17	VirtueMartModelCategory::getChildCategoryListObject()	Igual que la llamada en la línea de abajo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:190
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:119
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.03 ms Después de la última consulta: 0.57 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.293 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.06 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.14 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.09 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:417
13	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:124
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.80 ms Después de la última consulta: 0.40 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.313 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.15 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.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:1656
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
14	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:716
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:127
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.83 ms Después de la última consulta: 0.49 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 4.335 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.02 ms
Unlocking tables	0.03 ms
executing	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.02 ms
freeing items	0.06 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:1656
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:735
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:127
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:878
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:709
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.13 ms Después de la última consulta: 2.30 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 4.376 MB Filas entregadas por la consulta: 1

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

  FROM `mtqeg_extensions`

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

Explicar

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

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.08 ms
optimizing	0.17 ms
statistics	0.23 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	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.04 ms
cleaning up	0.01 ms

Call Stack

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

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

Tiempo de consulta: 20.74 ms Después de la última consulta: 0.75 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 4.383 MB

UPDATE `mtqeg_extensions`

  SET `params` = '{\"mediaversion\":\"a2dc140a46895db51e5a7d0a4bd96798\"}'

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

Explicar

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

Perfil

Status	Duration
starting	0.20 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.42 ms
updating	0.27 ms
end	0.03 ms
query end	19.35 ms
closing tables	0.03 ms
Unlocking tables	0.05 ms
freeing items	0.03 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:53
9	plgSystemJqueryeasy->onAfterRoute()	Igual que la llamada en la línea de abajo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.51 ms Después de la última consulta: 122.82 ms Memoria de consulta: 0.023 MB memoria antes de consulta: 5.230 MB Filas entregadas por la consulta: 0

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

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

Explicar

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

Perfil

Status	Duration
starting	0.12 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.04 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.01 ms
Creating tmp table	0.45 ms
Copying to tmp table	0.05 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:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/views/category/view.html.php:541
10	VirtuemartViewCategory->getSearchCustom()	JROOT/components/com_virtuemart/views/category/view.html.php:215
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.82 ms Después de la última consulta: 13.55 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 5.457 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.16 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.06 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.08 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:459
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.61 ms Después de la última consulta: 0.65 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 5.526 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.11 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.05 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Tiempo de consulta: 1.08 ms Después de la última consulta: 5.34 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.608 MB Filas entregadas por la consulta: 0

Consultas duplicadas: #34

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ps	system	virtuemart_product_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found; Using temporary; Utilizando filesort
1	SIMPLE	pc	ALL	virtuemart_product_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	111	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.17 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.05 ms
optimizing	0.05 ms
statistics	0.20 ms
preparing	0.01 ms
Unlocking tables	0.11 ms
executing	0.01 ms
Creating tmp table	0.05 ms
Copying to tmp table	0.06 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 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:1544
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:749
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:243
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Call Stack

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

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

Tiempo de consulta: 0.80 ms Después de la última consulta: 0.20 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 5.644 MB Filas entregadas por la consulta: 0

Consultas duplicadas: #32

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ps	system	virtuemart_product_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found; Using temporary; Utilizando filesort
1	SIMPLE	pc	ALL	virtuemart_product_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	111	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.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
executing	0.01 ms
Creating tmp table	0.04 ms
Copying to tmp table	0.05 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.05 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Tiempo de consulta: 0.78 ms Después de la última consulta: 7.66 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 5.784 MB Filas entregadas por la consulta: 0

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	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.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/manufacturer.php:220
14	VirtueMartModelManufacturer::getManufacturersOfProductsInCategory()	Igual que la llamada en la línea de abajo.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/product.php:2647
10	VirtueMartModelProduct->getOrderByList()	JROOT/components/com_virtuemart/views/category/view.html.php:245
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.58 ms Después de la última consulta: 8.75 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 5.922 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.08 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
12	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
11	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:267
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.81 ms Después de la última consulta: 4.85 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 6.032 MB Filas entregadas por la consulta: 1

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

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1022
11	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:267
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.52 ms Después de la última consulta: 17.61 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 6.267 MB Filas entregadas por la consulta: 1

SELECT `mtqeg_virtuemart_vendors`.* ,`mtqeg_virtuemart_vendors_es_co`.*  
  FROM `mtqeg_virtuemart_vendors` 
  INNER JOIN `mtqeg_virtuemart_vendors_es_co` using (`virtuemart_vendor_id`) 
  WHERE `mtqeg_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

Explicar

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

Perfil

Status	Duration
starting	0.06 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.05 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:86
10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:372
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.30 ms Después de la última consulta: 1.36 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 6.338 MB Filas entregadas por la consulta: 1

SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_vendor_medias` 
  WHERE `virtuemart_vendor_id` = "1" 
  ORDER BY `ordering`

Explicar

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

Perfil

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

Call Stack

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

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

Tiempo de consulta: 2.07 ms Después de la última consulta: 59.46 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 6.679 MB Filas entregadas por la consulta: 20

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM mtqeg_modules AS m

  LEFT JOIN mtqeg_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN mtqeg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-10-22 22:05:04') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-22 22:05:04') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 193 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	28	Using index condition; Using where; Utilizando filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	acriader_cms.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	acriader_cms.m.module,const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.09 ms
optimizing	0.10 ms
statistics	0.12 ms
preparing	0.07 ms
executing	0.01 ms
Sorting result	0.63 ms
Sending data	0.58 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	Igual que la llamada en la línea de abajo.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
10	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
9	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
8	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.30 ms Después de la última consulta: 31.42 ms Memoria de consulta: 0.036 MB memoria antes de consulta: 6.986 MB Filas entregadas por la consulta: 1

SELECT * 
  FROM mtqeg_kunena_configuration 
  WHERE id=1

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
28	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1289
27	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1223
26	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
25	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:480
24	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
23	include_once JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:759
22	JLoader::_load()	JROOT/libraries/loader.php:707
21	JLoader::_autoload()	Igual que la llamada en la línea de abajo.
20	spl_autoload_call()	JROOT/components/com_kunena/router.php:38
19	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:61
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 1.28 ms Después de la última consulta: 27.03 ms Memoria de consulta: 0.039 MB memoria antes de consulta: 7.302 MB Filas entregadas por la consulta: 31

SHOW FULL COLUMNS  
  FROM `mtqeg_virtuemart_userfields`

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:662
25	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
24	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:219
23	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434
22	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396
21	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602
20	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:52
19	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554
18	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:251
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.88 ms Después de la última consulta: 0.78 ms Memoria de consulta: 0.041 MB memoria antes de consulta: 7.400 MB Filas entregadas por la consulta: 17

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

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 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.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.28 ms
Sending data	0.17 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:504
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.37 ms Después de la última consulta: 1.04 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 7.553 MB Filas entregadas por la consulta: 2

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
19	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1037
18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:267
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.56 ms Después de la última consulta: 2.68 ms Memoria de consulta: 0.035 MB memoria antes de consulta: 7.669 MB Filas entregadas por la consulta: 10

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

 
  ORDER BY country_name ASC

Explicar

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

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:846
21	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
20	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
19	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:848
18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:267
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.66 ms Después de la última consulta: 4.44 ms Memoria de consulta: 0.040 MB memoria antes de consulta: 7.778 MB Filas entregadas por la consulta: 10

SELECT * 
  FROM `mtqeg_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `shipment`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

Explicar

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

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.09 ms
Sending data	0.15 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:610
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:510
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.61 ms Después de la última consulta: 4.83 ms Memoria de consulta: 0.031 MB memoria antes de consulta: 7.970 MB Filas entregadas por la consulta: 4

SELECT c.* 
  FROM mtqeg_virtuemart_calcs as c 
  LEFT JOIN mtqeg_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id 
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-10-22 22:05:04" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-10-22 22:05:04" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cs	system	virtuemart_calc_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found
1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	3	Using where

Perfil

Status	Duration
starting	0.07 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.05 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184
16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.53 ms Después de la última consulta: 0.38 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 8.022 MB Filas entregadas por la consulta: 0

SELECT * 
  FROM mtqeg_virtuemart_calcs  
  LEFT JOIN mtqeg_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-10-22 22:05:04" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-10-22 22:05:04" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found
1	SIMPLE	mtqeg_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	Using index condition; Using where

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:726
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.57 ms Después de la última consulta: 0.19 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 8.045 MB Filas entregadas por la consulta: 0

SELECT * 
  FROM mtqeg_virtuemart_calcs  
  LEFT JOIN mtqeg_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-10-22 22:05:04" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-10-22 22:05:04" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found
1	SIMPLE	mtqeg_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 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.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:727
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.40 ms Después de la última consulta: 0.19 ms Memoria de consulta: 0.029 MB memoria antes de consulta: 8.068 MB Filas entregadas por la consulta: 0

SELECT * 
  FROM mtqeg_virtuemart_calcs  
  LEFT JOIN mtqeg_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-10-22 22:05:04" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-10-22 22:05:04" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found
1	SIMPLE	mtqeg_virtuemart_calcs	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	Using index condition; Using where

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1337
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:728
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1628
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1752
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.53 ms Después de la última consulta: 164.02 ms Memoria de consulta: 0.038 MB memoria antes de consulta: 9.030 MB Filas entregadas por la consulta: 1

Consultas duplicadas: #53

SELECT `alias`

  FROM `mtqeg_contact_details`

  WHERE id = '1'

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.13 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.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	Número de archivo y de línea
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
30	JDatabaseDriver->loadResult()	JROOT/components/com_contact/router.php:121
29	ContactRouter->getContactSegment()	Igual que la llamada en la línea de abajo.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
20	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/componentsanywhere/src/Data.php:85
19	RegularLabs\Plugin\System\ComponentsAnywhere\Data::getUrl()	JROOT/plugins/system/componentsanywhere/src/Data.php:39
18	RegularLabs\Plugin\System\ComponentsAnywhere\Data::get()	JROOT/plugins/system/componentsanywhere/src/Component.php:108
17	RegularLabs\Plugin\System\ComponentsAnywhere\Component::get()	JROOT/plugins/system/componentsanywhere/src/Replace.php:291
16	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processComponent()	JROOT/plugins/system/componentsanywhere/src/Replace.php:232
15	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processMatch()	JROOT/plugins/system/componentsanywhere/src/Replace.php:169
14	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::replace()	JROOT/plugins/system/componentsanywhere/src/Replace.php:122
13	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processComponents()	JROOT/plugins/system/componentsanywhere/src/Replace.php:90
12	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::replaceTags()	JROOT/plugins/system/componentsanywhere/src/Helper.php:92
11	RegularLabs\Plugin\System\ComponentsAnywhere\Helper->onAfterRender()	Igual que la llamada en la línea de abajo.
10	call_user_func_array()	JROOT/plugins/system/componentsanywhere/src/Plugin.php:97
9	RegularLabs\Plugin\System\ComponentsAnywhere\Plugin->run()	JROOT/plugins/system/componentsanywhere/componentsanywhere.php:60
8	PlgSystemComponentsAnywhere->onAfterRender()	Igual que la llamada en la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.82 ms Después de la última consulta: 3.90 ms Memoria de consulta: 0.047 MB memoria antes de consulta: 9.089 MB Filas entregadas por la consulta: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `mtqeg_categories` AS `s`

  INNER JOIN `mtqeg_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 1

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Utilizando filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	6	Using where

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
31	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
30	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/router.php:68
29	ContactRouter->getCategorySegment()	Igual que la llamada en la línea de abajo.
28	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
27	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
26	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
25	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
23	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
22	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
21	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
20	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/componentsanywhere/src/Data.php:85
19	RegularLabs\Plugin\System\ComponentsAnywhere\Data::getUrl()	JROOT/plugins/system/componentsanywhere/src/Data.php:39
18	RegularLabs\Plugin\System\ComponentsAnywhere\Data::get()	JROOT/plugins/system/componentsanywhere/src/Component.php:108
17	RegularLabs\Plugin\System\ComponentsAnywhere\Component::get()	JROOT/plugins/system/componentsanywhere/src/Replace.php:291
16	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processComponent()	JROOT/plugins/system/componentsanywhere/src/Replace.php:232
15	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processMatch()	JROOT/plugins/system/componentsanywhere/src/Replace.php:169
14	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::replace()	JROOT/plugins/system/componentsanywhere/src/Replace.php:122
13	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processComponents()	JROOT/plugins/system/componentsanywhere/src/Replace.php:90
12	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::replaceTags()	JROOT/plugins/system/componentsanywhere/src/Helper.php:92
11	RegularLabs\Plugin\System\ComponentsAnywhere\Helper->onAfterRender()	Igual que la llamada en la línea de abajo.
10	call_user_func_array()	JROOT/plugins/system/componentsanywhere/src/Plugin.php:97
9	RegularLabs\Plugin\System\ComponentsAnywhere\Plugin->run()	JROOT/plugins/system/componentsanywhere/componentsanywhere.php:60
8	PlgSystemComponentsAnywhere->onAfterRender()	Igual que la llamada en la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.64 ms Después de la última consulta: 684.20 ms Memoria de consulta: 0.034 MB memoria antes de consulta: 9.212 MB Filas entregadas por la consulta: 1

Consultas duplicadas: #51

SELECT `alias`

  FROM `mtqeg_contact_details`

  WHERE id = '1'

Explicar

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

Perfil

Status	Duration
starting	0.09 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.03 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.07 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
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
27	JDatabaseDriver->loadResult()	JROOT/components/com_contact/router.php:121
26	ContactRouter->getContactSegment()	Igual que la llamada en la línea de abajo.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/componentsanywhere/src/Replace.php:354
16	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processComponent()	JROOT/plugins/system/componentsanywhere/src/Replace.php:232
15	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processMatch()	JROOT/plugins/system/componentsanywhere/src/Replace.php:169
14	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::replace()	JROOT/plugins/system/componentsanywhere/src/Replace.php:122
13	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::processComponents()	JROOT/plugins/system/componentsanywhere/src/Replace.php:90
12	RegularLabs\Plugin\System\ComponentsAnywhere\Replace::replaceTags()	JROOT/plugins/system/componentsanywhere/src/Helper.php:92
11	RegularLabs\Plugin\System\ComponentsAnywhere\Helper->onAfterRender()	Igual que la llamada en la línea de abajo.
10	call_user_func_array()	JROOT/plugins/system/componentsanywhere/src/Plugin.php:97
9	RegularLabs\Plugin\System\ComponentsAnywhere\Plugin->run()	JROOT/plugins/system/componentsanywhere/componentsanywhere.php:60
8	PlgSystemComponentsAnywhere->onAfterRender()	Igual que la llamada en la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de consulta: 0.52 ms Después de la última consulta: 48.77 ms Memoria de consulta: 0.018 MB memoria antes de consulta: 9.803 MB Filas entregadas por la consulta: 0

SELECT *

  FROM mtqeg_ganalytics_profiles 
  LIMIT 24

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mtqeg_ganalytics_profiles	system	NULL	Ninguna llave índice (INDEX KEY) pudo ser utilizada	NULL	NULL	0	const row not found

Perfil

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

Call Stack

#	Caller	Número de archivo y de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
9	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/plugins/system/ganalytics/ganalytics.php:50
8	plgSystemGAnalytics->onAfterRender()	Igual que la llamada en la línea de abajo.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
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.]

45 tipos de consulta registrados, ordenados por ocurrencias.

SELECT Tables:

4 × SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_category_medias`

3 × SELECT * 
  FROM mtqeg_virtuemart_calcs  
  LEFT JOIN mtqeg_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `mtqeg_extensions`

2 × SELECT * 
  FROM `mtqeg_virtuemart_userfields`

2 × SELECT `alias` 
  FROM `mtqeg_contact_details`

2 × 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`

1 × SELECT `mtqeg_virtuemart_shoppergroups`.*  
  FROM `mtqeg_virtuemart_shoppergroups`

1 × SELECT `mtqeg_virtuemart_currencies`.*  
  FROM `mtqeg_virtuemart_currencies`

```
1 × SELECT FOUND_ROWS(
```

1 × SELECT `mtqeg_virtuemart_vendors`.* ,`mtqeg_virtuemart_vendors_es_co`.*  
  FROM `mtqeg_virtuemart_vendors` 
  INNER JOIN `mtqeg_virtuemart_vendors_es_co` using (`virtuemart_vendor_id`)

1 × SELECT DISTINCT  l.virtuemart_manufacturer_id, l.mf_name  
  FROM `mtqeg_virtuemart_manufacturers_es_co` as l  
  INNER JOIN `mtqeg_virtuemart_product_manufacturers` AS pm 
  ON pm.`virtuemart_manufacturer_id` = l.`virtuemart_manufacturer_id`  
  INNER JOIN `mtqeg_virtuemart_products` as p 
  ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`  
  INNER JOIN `mtqeg_virtuemart_product_categories` as pc 
  ON pc.`virtuemart_product_id` = pm.`virtuemart_product_id`

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

1 × SELECT * 
  FROM mtqeg_kunena_configuration

1 × SELECT c.* 
  FROM mtqeg_virtuemart_calcs as c 
  LEFT JOIN mtqeg_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `mtqeg_categories` AS `s` 
  INNER JOIN `mtqeg_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT * 
  FROM mtqeg_ganalytics_profiles 
  LIMIT 2

1 × SELECT * 
  FROM `mtqeg_virtuemart_countries`

1 × SELECT `fieldtitle`, `fieldvalue` 
  FROM `mtqeg_virtuemart_userfield_values`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM mtqeg_modules AS m 
  LEFT JOIN mtqeg_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN mtqeg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM `mtqeg_virtuemart_shoppergroups`

1 × SELECT `virtuemart_media_id` 
  FROM `mtqeg_virtuemart_vendor_medias`

1 × SELECT l.virtuemart_category_id, l.category_name  
  FROM `mtqeg_virtuemart_categories_es_co` as l

1 × SELECT `config` 
  FROM `mtqeg_virtuemart_configs`

```
1 × SELECT * 
  FROM mtqeg_languages
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `mtqeg_assets`

1 × 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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM mtqeg_extensions

1 × SELECT `session_id` 
  FROM `mtqeg_session`

1 × SELECT id, rules 
  FROM `mtqeg_viewlevels

1 × SELECT b.id 
  FROM mtqeg_usergroups AS a 
  LEFT JOIN mtqeg_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × 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

```
1 × SELECT `id` 
  FROM `mtqeg_menu`
```

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

1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  mtqeg_virtuemart_category_categories AS `xref`

1 × SELECT `data` 
  FROM `mtqeg_session`

1 × SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug 
  FROM mtqeg_virtuemart_categories as c  
  LEFT JOIN `mtqeg_virtuemart_categories_es_co` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  LEFT JOIN `mtqeg_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`

1 × SELECT `category_child_id`    
  FROM `mtqeg_virtuemart_category_categories`

```
1 × SELECT * 
  FROM `mtqeg_menu`
```

1 × SELECT l.virtuemart_category_id  
  FROM `mtqeg_virtuemart_categories_es_co` as l

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`)

1 × 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)

Otras tablas:

1 × SHOW FULL COLUMNS  
  FROM `mtqeg_virtuemart_userfields

1 × UPDATE `mtqeg_extensions` 
  SET `params` = '{\"mediaversion\":\"a2dc140a46895db51e5a7d0a4bd96798\"}'

1 × SHOW TABLES LIKE "mtqeg_virtuemart_configs

1 × INSERT INTO `mtqeg_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('78gig8ahilf0nisjrkkkkj7in2', 1, 1571781904, 0, ''

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

Ganado Paturro Mini Cattle

Leche

Carne

Publicar en Nuestro foro

Ingrese para registrar

Eventos

Contacto

Formulario de contacto

Consola de depuración de Joomla!

Sesión

Información de perfil

Hora

Memoria

Uso de la memoria

Consultas de base de datos

54 consultas registradas 64.98 ms

4 duplicado encontrado!

45 tipos de consulta registrados, ordenados por ocurrencias.

SELECT Tables:

Otras tablas:

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

Ganado Paturro Mini Cattle

Leche

Carne

Publicar en Nuestro foro

Ingrese para registrar

Eventos

Contacto

Formulario de contacto

Consola de depuración de Joomla!

Sesión

Información de perfil

Hora

Memoria

Uso de la memoria

Consultas de base de datos

54 consultas registradas 64.98 ms

4 duplicado encontrado!

45 tipos de consulta registrados, ordenados por ocurrencias.

SELECT Tables:

Otras tablas:

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