Carro de compra

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1656130598,
                "last": 1656130598,
                "now": 1656130598
            },
            "token": "84MveINTSSECsthKtirCkkthEypfOlbz"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "manage": 0,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":{\"virtuemart_country_id\":195,\"virtuemart_state_id\":352},\"ST\":{\"address_type_name\":\"Nombre corto de direcci\\u00f3n\"},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"es-ES\",\"pricesCurrency\":\"47\",\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":[],\"byDefaultST\":{\"address_type_name\":1},\"cartLoaded\":[]}",
        "paypal": "{\"selected_method\":0,\"cc_type\":\"\",\"cc_number\":\"Y8zcuPixYC2bhLtcnBNHGv7vsVc0RaDfM1q1AKUYkmF7bo08IixbvGP8VFqdvIVG\",\"cc_cvv\":\"YHvBJDkxo0dUzM8ht9W6i\\\/7vsVc0RaDfM1q1AKUYkmF7bo08IixbvGP8VFqdvIVG\",\"cc_expire_month\":\"\",\"cc_expire_year\":\"\",\"cc_valid\":false,\"autobilling_max_amount\":\"\",\"token\":\"\",\"payer_id\":\"\",\"first_name\":\"\",\"last_name\":\"\",\"payer_email\":\"\"}"
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 10.88 ms / 10.88 ms Memoria: 1.655 MB / 2.02 MB Application: afterLoad

Fecha y hora: 63.42 ms / 74.30 ms Memoria: 5.570 MB / 7.59 MB Application: afterInitialise

Fecha y hora: 38.37 ms / 112.67 ms Memoria: 3.151 MB / 10.74 MB Application: Before Access::preloadComponents (all components)

Fecha y hora: 1.49 ms / 114.16 ms Memoria: 0.068 MB / 10.81 MB Application: After Access::preloadComponents (all components)

Fecha y hora: 0.03 ms / 114.19 ms Memoria: -0.003 MB / 10.81 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Fecha y hora: 0.36 ms / 114.55 ms Memoria: 0.026 MB / 10.83 MB Application: After Access::getAssetRules (id:1 name:root.1)

Fecha y hora: 0.02 ms / 114.57 ms Memoria: 0.001 MB / 10.83 MB Application: Before Access::getAssetRules (id:262 name:com_virtuemart)

Fecha y hora: 0.01 ms / 114.58 ms Memoria: 0.002 MB / 10.84 MB Application: After Access::getAssetRules (id:262 name:com_virtuemart)

Fecha y hora: 254.65 ms / 369.23 ms Memoria: 6.429 MB / 17.27 MB Application: afterRoute

Fecha y hora: 1.06 ms / 370.29 ms Memoria: 0.046 MB / 17.31 MB Application: beforeRenderComponent com_virtuemart

Fecha y hora: 313.89 ms / 684.18 ms Memoria: 3.895 MB / 21.21 MB Application: afterRenderComponent com_virtuemart

Fecha y hora: 1.24 ms / 685.42 ms Memoria: 0.097 MB / 21.30 MB Application: afterDispatch

Fecha y hora: 247.64 ms / 933.06 ms Memoria: 25.358 MB / 46.66 MB Application: beforeRenderModule mod_search (Search)

Fecha y hora: 1.20 ms / 934.26 ms Memoria: 0.041 MB / 46.70 MB Application: afterRenderModule mod_search (Search)

Fecha y hora: 0.39 ms / 934.65 ms Memoria: -0.002 MB / 46.70 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Fecha y hora: 22.85 ms / 957.51 ms Memoria: 0.051 MB / 46.75 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Fecha y hora: 184.14 ms / 1141.65 ms Memoria: 0.045 MB / 46.80 MB Application: beforeRenderModule mod_menu (Información General)

Fecha y hora: 1.33 ms / 1142.98 ms Memoria: 0.034 MB / 46.83 MB Application: afterRenderModule mod_menu (Información General)

Fecha y hora: 0.13 ms / 1143.11 ms Memoria: -0.027 MB / 46.80 MB Application: beforeRenderModule mod_articles_categories (Condiciones Generales v1)

Fecha y hora: 1.25 ms / 1144.36 ms Memoria: 0.028 MB / 46.83 MB Application: afterRenderModule mod_articles_categories (Condiciones Generales v1)

Fecha y hora: 289.73 ms / 1434.10 ms Memoria: 0.101 MB / 46.93 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 1.09 ms / 1435.19 ms Memoria: 0.025 MB / 46.96 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 429.83 ms / 1865.01 ms Memoria: -23.391 MB / 23.57 MB Application: afterRender

Total de consultas a la base de datos: 89.39 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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

'Explicar' no es posible en la consulta: INSERT INTO `ma_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3936666662653466333034306239396434396234623765353265373639623866', 1, 1656130598, 0, '', 0)

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	2.96 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.64 ms Después de la última consulta: 4.86 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.493 MB Filas devueltas: 5

SELECT id, rules

  FROM `ma_viewlevels`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_viewlevels	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.62 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.506 MB Filas devueltas: 1

SELECT b.id

  FROM ma_usergroups AS a

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

  WHERE a.id = 1

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.73 ms Después de la última consulta: 28.76 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 7.491 MB Filas devueltas: 1

SELECT count(*)

  FROM `ma_cwgears_schedule`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_cwgears_schedule	NULL	index	NULL	PRIMARY	4	NULL	1	100.00	Using index

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:103
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 7.496 MB Filas devueltas: 1

SELECT count(*)

  FROM `ma_cwgears_schedule`

  WHERE time + '86400'<'1656130598'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_cwgears_schedule	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:146
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 4.37 ms Después de la última consulta: 13.66 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 8.785 MB

UPDATE `ma_extensions`

  SET `params` = '{\"mediaversion\":\"9ef48de9ec02be52302350f7cbbebae7\"}'

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ma_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.47 ms
init	0.05 ms
System lock	0.26 ms
updating	0.17 ms
end	0.02 ms
query end	2.89 ms
closing tables	0.05 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.64 ms Después de la última consulta: 17.81 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 10.565 MB Filas devueltas: 1

SHOW TABLES LIKE "ma_virtuemart_configs"

Explicar

'Explicar' no es posible en la consulta: SHOW TABLES LIKE "ma_virtuemart_configs"

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.26 ms
Sending data	0.01 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
freeing items	0.02 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:724
13	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:580
12	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:415
11	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
10	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
9	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.59 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 10.611 MB Filas devueltas: 1

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_configs	NULL	const	PRIMARY	PRIMARY	1	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:455
11	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
10	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
9	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.20 ms Después de la última consulta: 2.09 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 10.751 MB Filas devueltas: 49

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

  FROM `ma_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_advancedsalesreport','com_advportfoliopro','com_ajax','com_akeeba','com_analytic_record','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_quix','com_redirect','com_search','com_smartforms','com_tags','com_tcpdf','com_templates','com_uniterevolution2','com_users','com_virtuemart','com_virtuemart_allinone','com_vmcustomadvanced','com_wrapper')

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_assets	NULL	ALL	idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	211	23.70	Using where

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:136
13	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
12	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:477
11	VmConfig::loadConfig()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
10	VPOPCHelper->__construct()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
9	VPOPCHelper::getInstance()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.64 ms Después de la última consulta: 6.90 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.572 MB Filas devueltas: 1

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_shoppergroups	NULL	ALL	virtuemart_vendor_id,shared,published	No pudo usarse una clave de índice	NULL	NULL	8	12.50	Using where

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:179
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:130
10	VirtueMartCart::getCart()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:139
9	VPOPCHelper->isCart()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:113
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.32 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.595 MB Filas devueltas: 1

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_shoppergroups	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1058
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1023
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:179
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:130
10	VirtueMartCart::getCart()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:139
9	VPOPCHelper->isCart()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:113
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.19 ms Después de la última consulta: 2.21 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 11.802 MB Filas devueltas: 32

SHOW FULL COLUMNS  
  FROM `ma_virtuemart_userfields`

Explicar

'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `ma_virtuemart_userfields`

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.19 ms
checking permissions	0.03 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.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
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.13 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:685
19	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
18	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:210
17	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
16	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
15	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:607
14	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
13	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:559
12	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:307
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
10	VirtueMartCart::getCart()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:139
9	VPOPCHelper->isCart()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:113
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.57 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 11.838 MB Filas devueltas: 17

SELECT * 
  FROM `ma_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_userfields	NULL	ALL	published,account	No pudo usarse una clave de índice	NULL	NULL	29	62.78	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:483
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:348
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
10	VirtueMartCart::getCart()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:139
9	VPOPCHelper->isCart()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:113
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.84 ms Después de la última consulta: 36.30 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 15.924 MB Filas devueltas: 10

SELECT * 
  FROM `ma_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	14	75.86	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
14	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
13	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:489
12	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:348
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
10	VirtueMartCart::getCart()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:139
9	VPOPCHelper->isCart()	JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:113
8	plgSystemVPOnePageCheckout->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.19 ms Después de la última consulta: 197.29 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 17.223 MB Filas devueltas: 0

SELECT ip

  FROM `ma_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_cwtraffic_knownips	NULL	ref	idx_state	idx_state	1	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.49 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.06 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:158
8	plgSystemCwtrafficCount->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.50 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 17.229 MB Filas devueltas: 0

SELECT botname

  FROM `ma_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_cwtraffic_knownips	NULL	ref	idx_state	idx_state	1	const	1	100.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:186
8	plgSystemCwtrafficCount->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.25 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 17.234 MB Filas devueltas: 1

SELECT count(*)

  FROM `ma_cwtraffic`

  WHERE iphash = UNHEX(SHA1('44.201.94.72')) 
  AND tm + '3600'>'1656130598'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_cwtraffic	NULL	ref	idx_iphash,idx_iphashtm	idx_iphash	20	const	1	100.00	Using index condition; Using where

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.41 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.22 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.05 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:242
8	plgSystemCwtrafficCount->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 4.53 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 17.239 MB

INSERT INTO `ma_cwtraffic`
(tm, ip, iphash, browser, bversion, platform, referer, country_code, country_name, city, location_latitude, location_longitude, location_time_zone, continent_code) 
  VALUES 
('1656130598','44.201.94.72', UNHEX(SHA1('44.201.94.72')),'Robot','Unknown','Unknown','Unknown','','','','','','','')

Explicar

'Explicar' no es posible en la consulta: INSERT INTO `ma_cwtraffic` (tm, ip, iphash, browser, bversion, platform, referer, country_code, country_name, city, location_latitude, location_longitude, location_time_zone, continent_code) VALUES ('1656130598','44.201.94.72', UNHEX(SHA1('44.201.94.72')),'Robot','Unknown','Unknown','Unknown','','','','','','','')

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.29 ms
end	0.01 ms
query end	3.71 ms
closing tables	0.09 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:300
8	plgSystemCwtrafficCount->onAfterRoute()	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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.79 ms Después de la última consulta: 26.31 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 18.546 MB Filas devueltas: 1

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	NULL	const	PRIMARY,vendor_currency	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.73 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:321
15	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
14	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
13	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2057
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2160
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:79
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.66 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 18.616 MB Filas devueltas: 1

SELECT `ma_virtuemart_currencies`.*  
  FROM `ma_virtuemart_currencies`  
  WHERE `ma_virtuemart_currencies`.`virtuemart_currency_id` = "47"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_currencies	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1058
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1023
14	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
13	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2057
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2160
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:79
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.83 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 18.697 MB Filas devueltas: 2

SELECT c.* 
  FROM ma_virtuemart_calcs as c  
  LEFT JOIN ma_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 <= "2022-06-25 04:16:38" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2022-06-25 04:16:38" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	No pudo usarse una clave de índice	NULL	NULL	9	11.11	Using where
1	SIMPLE	cs	NULL	ref	virtuemart_calc_id	virtuemart_calc_id	4	dbs702056.c.virtuemart_calc_id	1	36.00	Using where; Using index

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.61 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.07 ms
statistics	0.29 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172
13	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
12	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:106
11	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:2057
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2160
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:79
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.35 ms Después de la última consulta: 2.06 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 18.948 MB Filas devueltas: 0

SELECT * 
  FROM ma_virtuemart_calcs  
  LEFT JOIN ma_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 <= "2022-06-25 04:16:38" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2022-06-25 04:16:38" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_calcs	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	11.11	Using where
1	SIMPLE	ma_virtuemart_calc_shoppergroups	NULL	ref	virtuemart_calc_id	virtuemart_calc_id	4	dbs702056.ma_virtuemart_calcs.virtuemart_calc_id	1	36.00	Using where; Using index

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1499
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:756
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2061
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2160
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:79
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 18.955 MB Filas devueltas: 0

SELECT * 
  FROM ma_virtuemart_calcs  
  LEFT JOIN ma_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 <= "2022-06-25 04:16:38" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2022-06-25 04:16:38" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_calcs	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	11.11	Using where
1	SIMPLE	ma_virtuemart_calc_shoppergroups	NULL	ref	virtuemart_calc_id	virtuemart_calc_id	4	dbs702056.ma_virtuemart_calcs.virtuemart_calc_id	1	36.00	Using where; Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1499
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:757
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2061
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2160
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:79
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.50 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 18.962 MB Filas devueltas: 0

SELECT * 
  FROM ma_virtuemart_calcs  
  LEFT JOIN ma_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 <= "2022-06-25 04:16:38" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2022-06-25 04:16:38" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_calcs	NULL	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	calc_kind	50	const	1	11.11	Using where
1	SIMPLE	ma_virtuemart_calc_shoppergroups	NULL	ref	virtuemart_calc_id	virtuemart_calc_id	4	dbs702056.ma_virtuemart_calcs.virtuemart_calc_id	1	36.00	Using where; Using index

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1499
12	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:758
11	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2061
10	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:2160
9	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/controllers/cart.php:79
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.25 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.429 MB memoria antes de la consulta: 19.043 MB Filas devueltas: 1

SELECT `ma_virtuemart_vendors`.* ,`ma_virtuemart_vendors_es_es`.*  
  FROM `ma_virtuemart_vendors` 
  INNER JOIN `ma_virtuemart_vendors_es_es` 
  ON `ma_virtuemart_vendors`.`virtuemart_vendor_id` = `ma_virtuemart_vendors_es_es`.`virtuemart_vendor_id`  
  WHERE `ma_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_vendors	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ma_virtuemart_vendors_es_es	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.23 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	1.82 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1058
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:82
12	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/helpers/cart.php:2080
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1581
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:1407
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:101
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.63 ms Después de la última consulta: 0.98 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 19.313 MB Filas devueltas: 1

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_vendor_medias	NULL	ref	virtuemart_vendor_id	virtuemart_vendor_id	4	const	1	100.00	Using index condition; Usando 'filesort'

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:128
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:93
12	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/helpers/cart.php:2080
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1581
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:1407
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:101
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.61 ms Después de la última consulta: 1.34 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 19.425 MB Filas devueltas: 1

SELECT `ma_virtuemart_medias`.*  
  FROM `ma_virtuemart_medias`  
  WHERE `ma_virtuemart_medias`.`virtuemart_media_id` = "115"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_medias	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1058
15	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
14	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:484
13	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1187
12	VmModel->addImages()	JROOT/components/com_virtuemart/helpers/cart.php:2081
11	VirtueMartCart->prepareVendor()	JROOT/components/com_virtuemart/helpers/cart.php:1581
10	VirtueMartCart->checkPurchaseValue()	JROOT/components/com_virtuemart/helpers/cart.php:1407
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:101
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 4.69 ms Después de la última consulta: 11.76 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 19.633 MB Filas devueltas: 9

SELECT * 
  FROM `ma_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`="1" 
  AND published = 1 
  AND required = 1 
  AND type != 'delimiter' 
  AND type != 'captcha' 
  AND FIND_IN_SET(name, 'delimiter_userinfo,name,username,password,password2,address_type_name,address_type,user_is_vendor,agreed') = 0  
  ORDER BY ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_userfields	NULL	ALL	published,account	No pudo usarse una clave de índice	NULL	NULL	29	5.09	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.21 ms
checking permissions	0.07 ms
Opening tables	0.02 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.10 ms
Creating sort index	0.45 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.06 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
13	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
12	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/user.php:1144
11	VirtueMartModelUser->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:1604
10	VirtueMartCart->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:1416
9	VirtueMartCart->checkoutData()	JROOT/components/com_virtuemart/controllers/cart.php:101
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 5.66 ms Después de la última consulta: 1.22 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 19.769 MB Filas devueltas: 1

SELECT *

  FROM `ma_virtuemart_vmusers` AS a

  LEFT JOIN `ma_virtuemart_userinfos` AS b 
  ON a.`virtuemart_user_id` = b.`virtuemart_user_id`

  WHERE a.`virtuemart_vendor_id` = 1 
  AND b.`address_type` = 'BT'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	PRIMARY,u_virtuemart_user_id,virtuemart_vendor_id	virtuemart_vendor_id	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	ref	virtuemart_user_id,address_type	virtuemart_user_id	10	dbs702056.a.virtuemart_user_id,const	1	100.00	NULL

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	4.69 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:2213
12	VPOPCHelper->getVendor()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2669
11	VirtueMartViewCart->getVendorCountryState()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2590
10	VirtueMartViewCart->setDefaultCountry()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1326
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 19.779 MB Filas devueltas: 1

SELECT `virtuemart_userfield_id`

  FROM `ma_virtuemart_userfields`

  WHERE `name` = 'virtuemart_country_id' 
  AND `account` = '1' 
  AND `published` = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_userfields	NULL	const	name,published,account	name	752	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/vponepagecheckout/cart/helper.php:2167
11	VPOPCHelper->accountFieldExists()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2605
10	VirtueMartViewCart->setDefaultCountry()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1326
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.52 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 19.799 MB

UPDATE `ma_session`

  SET `data` = ''
	, `time` = 1656130598

  WHERE `session_id` = X'3936666662653466333034306239396434396234623765353265373639623866'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ma_session	NULL	range	PRIMARY	PRIMARY	194	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.03 ms
updating	0.09 ms
end	0.01 ms
query end	3.10 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/session/storage/database.php:84
14	JSessionStorageDatabase->write()	Lo mismo que llamada de la línea de abajo.
13	session_write_close()	JROOT/components/com_virtuemart/helpers/cart.php:657
12	VirtueMartCart->setCartIntoSession()	JROOT/components/com_virtuemart/helpers/cart.php:1865
11	VirtueMartCart->saveAddressInCart()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2632
10	VirtueMartViewCart->setDefaultCountry()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1326
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.36 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 19.807 MB Filas devueltas: 1

Consultas duplicadas: #1

SELECT `data`

  FROM `ma_session`

  WHERE `session_id` = X'3936666662653466333034306239396434396234623765353265373639623866'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Lo mismo que llamada de la línea de abajo.
13	session_start()	JROOT/components/com_virtuemart/helpers/cart.php:658
12	VirtueMartCart->setCartIntoSession()	JROOT/components/com_virtuemart/helpers/cart.php:1865
11	VirtueMartCart->saveAddressInCart()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2632
10	VirtueMartViewCart->setDefaultCountry()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1326
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 4.56 ms Después de la última consulta: 13.65 ms Consulta a la memoria: 0.094 MB memoria antes de la consulta: 19.859 MB Filas devueltas: 245

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

 
  ORDER BY ordering, country_name ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_countries	NULL	ALL	published	No pudo usarse una clave de índice	NULL	NULL	245	100.00	Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	2.01 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.07 ms
Creating sort index	1.68 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:868
15	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:142
14	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:145
13	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:853
12	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:351
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1816
10	VirtueMartViewCart->prepareAddressFields()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1329
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.58 ms Después de la última consulta: 36.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.240 MB Filas devueltas: 1

SELECT `ma_virtuemart_countries`.*  
  FROM `ma_virtuemart_countries`  
  WHERE `ma_virtuemart_countries`.`virtuemart_country_id` = "195"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_countries	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1058
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/userfields.php:861
12	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:351
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1816
10	VirtueMartViewCart->prepareAddressFields()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1329
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.60 ms Después de la última consulta: 5.61 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 20.276 MB Filas devueltas: 1

SELECT * 
  FROM `ma_virtuemart_states` 
  WHERE virtuemart_state_id = "352"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_states	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	1.78 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/models/userfields.php:909
12	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:351
11	VirtueMartCart->setupAddressFieldsForCart()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1816
10	VirtueMartViewCart->prepareAddressFields()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1329
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.61 ms Después de la última consulta: 1.50 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 20.300 MB Filas devueltas: 1

SELECT *

  FROM `ma_virtuemart_countries`

  WHERE `virtuemart_country_id` = '195'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_countries	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2050
10	VirtueMartViewCart->prepareAddressFields()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1329
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.58 ms Después de la última consulta: 0.93 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 20.319 MB Filas devueltas: 1

SELECT *

  FROM `ma_virtuemart_states`

  WHERE `virtuemart_state_id` = '352'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_states	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2068
10	VirtueMartViewCart->prepareAddressFields()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1329
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.71 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 20.331 MB Filas devueltas: 0

SELECT virtuemart_userinfo_id AS value, address_type_name AS text

  FROM ma_virtuemart_userinfos

  WHERE virtuemart_user_id = 0 
  AND address_type = 'ST'

  ORDER BY address_type_name ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_userinfos	NULL	ref	virtuemart_user_id,address_type	virtuemart_user_id	10	const,const	1	100.00	Using index condition; Usando 'filesort'

Perfil

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.05 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2908
11	VirtueMartViewCart->getUserSTList()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2088
10	VirtueMartViewCart->prepareAddressFields()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1329
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.92 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.331 MB Filas devueltas: 2

SELECT * 
  FROM `ma_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `cart`="1" 
  AND published = 1 
  AND type != 'delimiter' 
  AND type != 'captcha' 
  AND FIND_IN_SET(name, 'delimiter_userinfo,user_is_vendor,username,password,password2,agreed,address_type') = 0  
  ORDER BY ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_userfields	NULL	ref	published,cart	cart	1	const	4	61.45	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:503
11	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
10	VirtueMartModelUserfields->getUserFields()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1360
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 2.92 ms Después de la última consulta: 11.17 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 20.465 MB Filas devueltas: 2

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	82	0.59	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.61 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.96 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1391
24	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:907
23	vmrouterHelper->setRoutingQuery()	JROOT/components/com_virtuemart/router.php:889
22	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:956
21	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/tos.php:41
12	include JROOT/components/com_virtuemart/sublayouts/tos.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:502
11	shopFunctionsF::renderVmSubLayout()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1031
10	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1361
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.70 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 20.479 MB Filas devueltas: 1

SELECT l.slug  
  FROM `ma_virtuemart_vendors_es_es` as l  
  WHERE l.virtuemart_vendor_id = "1"

Explicar

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

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1319
22	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1284
21	vmrouterHelper->getVendorName()	JROOT/components/com_virtuemart/router.php:304
20	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/tos.php:41
12	include JROOT/components/com_virtuemart/sublayouts/tos.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:502
11	shopFunctionsF::renderVmSubLayout()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1031
10	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1361
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 3.58 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 20.643 MB Filas devueltas: 5

SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
				j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.payment_name, l.payment_desc 
  FROM ma_virtuemart_paymentmethods as i 
 
  LEFT JOIN `ma_virtuemart_paymentmethods_es_es` as l 
  ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id` 
 
  LEFT JOIN `ma_extensions` as j 
  ON j.`extension_id` =  i.`payment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `ma_virtuemart_paymentmethod_shoppergroups` AS s 
  ON i.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`  
  WHERE i.`published` = "1" 
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
									
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_paymentmethod_id` 
  ORDER BY i.`ordering`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	index	PRIMARY,payment_jplugin_id,virtuemart_vendor_id,payment_element,ordering	PRIMARY	4	NULL	5	20.00	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs702056.i.virtuemart_paymentmethod_id	1	100.00	NULL
1	SIMPLE	j	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs702056.i.payment_jplugin_id	1	100.00	NULL
1	SIMPLE	s	NULL	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	dbs702056.i.virtuemart_paymentmethod_id	1	100.00	Using where; Using index

Perfil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.36 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.10 ms
Sorting for group	0.01 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.73 ms
Creating sort index	0.12 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.13 ms
query end	0.36 ms
closing tables	0.05 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:530
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmpayment/paypal/paypal.php:313
13	plgVmPaymentPaypal->plgVmOnCheckoutAdvertise()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2734
10	VirtueMartViewCart->getCheckoutAdvertise()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1372
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.56 ms Después de la última consulta: 12.53 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.749 MB Filas devueltas: 3

SELECT SQL_CALC_FOUND_ROWS i.*, l.shipment_name, l.shipment_desc  
  FROM `ma_virtuemart_shipmentmethods` as i  
  LEFT JOIN `ma_virtuemart_shipmentmethods_es_es` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id`

 
 
  ORDER BY i.ordering DESC 
  LIMIT 0, 24

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	3	100.00	Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	ALL	PRIMARY	No pudo usarse una clave de índice	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.58 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.31 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:868
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:140
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2530
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2251
10	VirtueMartViewCart->lSelectShipment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1378
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.21 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.763 MB Filas devueltas: 1

Consultas duplicadas: #52

SELECT FOUND_ROWS()

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	No tables used

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:877
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:140
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2530
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2251
10	VirtueMartViewCart->lSelectShipment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1378
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.59 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.775 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_shipmentmethod_shoppergroups 
  WHERE `virtuemart_shipmentmethod_id` = "1"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_shipmentmethod_shoppergroups	NULL	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	const	1	100.00	Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:161
13	VirtueMartModelShipmentmethod->getShipmentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:145
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2530
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2251
10	VirtueMartViewCart->lSelectShipment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1378
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.23 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.782 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_shipmentmethod_shoppergroups 
  WHERE `virtuemart_shipmentmethod_id` = "2"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_shipmentmethod_shoppergroups	NULL	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	const	1	100.00	Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:161
13	VirtueMartModelShipmentmethod->getShipmentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:145
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2530
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2251
10	VirtueMartViewCart->lSelectShipment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1378
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.789 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_shipmentmethod_shoppergroups 
  WHERE `virtuemart_shipmentmethod_id` = "3"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_shipmentmethod_shoppergroups	NULL	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	const	1	100.00	Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:161
13	VirtueMartModelShipmentmethod->getShipmentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/shipmentmethod.php:145
12	VirtueMartModelShipmentmethod->getShipments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2530
11	VirtueMartViewCart->checkShipmentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2251
10	VirtueMartViewCart->lSelectShipment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1378
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 1.17 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 20.794 MB Filas devueltas: 3

SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
				j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.shipment_name, l.shipment_desc 
  FROM ma_virtuemart_shipmentmethods as i 
 
  LEFT JOIN `ma_virtuemart_shipmentmethods_es_es` as l 
  ON l.`virtuemart_shipmentmethod_id` = i.`virtuemart_shipmentmethod_id` 
 
  LEFT JOIN `ma_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `ma_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE i.`published` = "1" 
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
									
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_shipmentmethod_id` 
  ORDER BY i.`ordering`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	index	PRIMARY,shipment_jplugin_id,shipment_element,ordering	PRIMARY	4	NULL	3	33.33	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs702056.i.virtuemart_shipmentmethod_id	1	100.00	NULL
1	SIMPLE	j	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs702056.i.shipment_jplugin_id	1	100.00	NULL
1	SIMPLE	s	NULL	ref	virtuemart_shipmentmethod_id	virtuemart_shipmentmethod_id	4	dbs702056.i.virtuemart_shipmentmethod_id	1	100.00	Using where; Using index

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting for group	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.39 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.12 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:530
15	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:128
14	vmPSPlugin->displayListFE()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:444
13	plgVmShipmentWeight_countries->plgVmDisplayListFEShipment()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2259
10	VirtueMartViewCart->lSelectShipment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1378
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.67 ms Después de la última consulta: 8.19 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 20.860 MB Filas devueltas: 5

SELECT SQL_CALC_FOUND_ROWS i.*, l.payment_name, l.payment_desc  
  FROM `ma_virtuemart_paymentmethods` as i  
  LEFT JOIN `ma_virtuemart_paymentmethods_es_es` as l 
  ON l.`virtuemart_paymentmethod_id` = i.`virtuemart_paymentmethod_id`
 
  WHERE  `published` = 1
 
 
  ORDER BY i.ordering DESC 
  LIMIT 0, 24

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs702056.i.virtuemart_paymentmethod_id	1	100.00	NULL

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:868
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:125
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2558
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2281
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.879 MB Filas devueltas: 1

Consultas duplicadas: #46

SELECT FOUND_ROWS()

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	No tables used

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.06 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:877
13	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:125
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2558
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2281
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.67 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.886 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "1"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_paymentmethod_shoppergroups	NULL	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	const	1	100.00	Using index

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.06 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:145
13	VirtueMartModelPaymentmethod->getPaymentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:131
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2558
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2281
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.55 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.893 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "2"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_paymentmethod_shoppergroups	NULL	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	const	1	100.00	Using index

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:145
13	VirtueMartModelPaymentmethod->getPaymentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:131
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2558
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2281
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.900 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "4"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_paymentmethod_shoppergroups	NULL	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	const	1	100.00	Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:145
13	VirtueMartModelPaymentmethod->getPaymentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:131
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2558
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2281
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.03 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.907 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "9"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_paymentmethod_shoppergroups	NULL	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	const	1	100.00	Using index

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:145
13	VirtueMartModelPaymentmethod->getPaymentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:131
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2558
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2281
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.43 ms Después de la última consulta: 0.04 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.914 MB Filas devueltas: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM ma_virtuemart_paymentmethod_shoppergroups 
  WHERE `virtuemart_paymentmethod_id` = "10"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_paymentmethod_shoppergroups	NULL	ref	virtuemart_paymentmethod_id	virtuemart_paymentmethod_id	4	const	1	100.00	Using index

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:145
13	VirtueMartModelPaymentmethod->getPaymentShopperGrps()	JROOT/administrator/components/com_virtuemart/models/paymentmethod.php:131
12	VirtueMartModelPaymentmethod->getPayments()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2558
11	VirtueMartViewCart->checkPaymentMethodsConfigured()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2281
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.55 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 20.908 MB Filas devueltas: 1

SELECT CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency` 
  FROM `ma_virtuemart_vendors` 
  WHERE `virtuemart_vendor_id`=1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_vendors	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/models/vendor.php:352
15	VirtueMartModelVendor->getVendorAndAcceptedCurrencies()	JROOT/plugins/vmpayment/paypal/paypal.php:415
14	plgVmPaymentPaypal::getPaymentCurrency()	JROOT/plugins/vmpayment/paypal/paypal.php:1292
13	plgVmPaymentPaypal->plgVmDisplayListFEPayment()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2289
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.47 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 20.980 MB Filas devueltas: 1

SELECT currency_code_3 AS fld 
  FROM `ma_virtuemart_currencies` 
  WHERE virtuemart_currency_id = 47

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_currencies	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/shopfunctions.php:846
19	ShopFunctions::getCurrencyByID()	JROOT/plugins/vmpayment/paypal/paypal/helpers/paypal.php:74
18	PaypalHelperPaypal->__construct()	JROOT/plugins/vmpayment/paypal/paypal/helpers/paypalstd.php:32
17	PaypalHelperPayPalStd->__construct()	JROOT/plugins/vmpayment/paypal/paypal.php:816
16	plgVmPaymentPaypal->_loadPayPalInterface()	JROOT/plugins/vmpayment/paypal/paypal.php:941
15	plgVmPaymentPaypal->displayExtraPluginNameInfo()	JROOT/plugins/vmpayment/paypal/paypal.php:934
14	plgVmPaymentPaypal->renderPluginName()	JROOT/plugins/vmpayment/paypal/paypal.php:1293
13	plgVmPaymentPaypal->plgVmDisplayListFEPayment()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2289
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.61 ms Después de la última consulta: 79.73 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 21.055 MB Filas devueltas: 5

SELECT virtuemart_paymentmethod_id, payment_element, payment_params

  FROM ma_virtuemart_paymentmethods

  WHERE published = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_paymentmethods	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	5	20.00	Using where

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2429
11	VirtueMartViewCart->getPaymentMethods()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:2306
10	VirtueMartViewCart->lSelectPayment()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1381
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.88 ms Después de la última consulta: 10.93 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 21.083 MB Filas devueltas: 1

SELECT `ma_virtuemart_countries`.*  
  FROM `ma_virtuemart_countries`  
  WHERE `ma_virtuemart_countries`.`virtuemart_country_id` = "195" 
  AND `published`="1"

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ma_virtuemart_countries	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1058
14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/state.php:109
13	VirtueMartModelState::testStateCountry()	JROOT/administrator/components/com_virtuemart/models/user.php:1167
12	VirtueMartModelUser->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:1604
11	VirtueMartCart->validateUserData()	JROOT/components/com_virtuemart/helpers/cart.php:1416
10	VirtueMartCart->checkoutData()	JROOT/plugins/system/vponepagecheckout/cart/cartview.html.php:1389
9	VirtueMartViewCart->display()	JROOT/components/com_virtuemart/controllers/cart.php:106
8	VirtueMartControllerCart->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

Tiempo de la consulta: 0.68 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 21.091 MB Filas devueltas: 1

Carrito

Carro vacío

Mascarillas de Alcalá

Contacto

Información General

Search

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

70 consultas registradas 89.39 ms

¡ 4 duplicaciones detectadas!