Fale Conosco - Uniforme Santos - Uniformes em Curitiba

Console de depuração do Joomla!

Sessão

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713606605,
                "last": 1713606605,
                "now": 1713606605
            },
            "token": "wWGCCIHgcOa4TTtRxlgxCIBPNPglti5M"
        },
        "registry": {
            "com_contact": {
                "contact": {
                    "data": {
                        "catid": "4"
                    }
                }
            }
        },
        "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": {
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"pt-BR\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}"
    }
}

Informação do perfil

Hora

Memória

Hora: 38.72 ms / 38.72 ms Memória: 0.798 MB / 1.16 MB Application: afterLoad

Hora: 140.50 ms / 179.22 ms Memória: 1.191 MB / 2.35 MB Application: afterInitialise

Hora: 27.40 ms / 206.62 ms Memória: 0.328 MB / 2.68 MB Application: afterRoute

Hora: 37.69 ms / 244.32 ms Memória: 0.130 MB / 2.81 MB Application: beforeRenderComponent com_contact

Hora: 115.27 ms / 359.59 ms Memória: 0.193 MB / 3.00 MB Application: Before Access::preloadComponents (all components)

Hora: 1.79 ms / 361.38 ms Memória: 0.061 MB / 3.06 MB Application: After Access::preloadComponents (all components)

Hora: 0.03 ms / 361.40 ms Memória: -0.002 MB / 3.06 MB Application: Before Access::getAssetRules (id:7 name:com_contact)

Hora: 0.96 ms / 362.36 ms Memória: 0.009 MB / 3.07 MB Application: After Access::getAssetRules (id:7 name:com_contact)

Hora: 1117.66 ms / 1480.02 ms Memória: 0.748 MB / 3.82 MB Application: afterRenderComponent com_contact

Hora: 0.70 ms / 1480.72 ms Memória: 0.005 MB / 3.82 MB Application: afterDispatch

Hora: 52.82 ms / 1533.54 ms Memória: 0.516 MB / 4.34 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Hora: 0.05 ms / 1533.59 ms Memória: 0.007 MB / 4.34 MB Application: After Access::getAssetRules (id:1 name:root.1)

Hora: 0.02 ms / 1533.61 ms Memória: 0.000 MB / 4.34 MB Application: Before Access::getAssetRules (id:63 name:com_virtuemart)

Hora: 0.01 ms / 1533.62 ms Memória: 0.002 MB / 4.35 MB Application: After Access::getAssetRules (id:63 name:com_virtuemart)

Hora: 14.85 ms / 1548.47 ms Memória: 0.124 MB / 4.47 MB Application: beforeRenderModule mod_menu (Menu)

Hora: 3.63 ms / 1552.11 ms Memória: 0.024 MB / 4.49 MB Application: afterRenderModule mod_menu (Menu)

Hora: 0.05 ms / 1552.16 ms Memória: -0.003 MB / 4.49 MB Application: beforeRenderModule mod_custom (face)

Hora: 0.71 ms / 1552.87 ms Memória: 0.007 MB / 4.50 MB Application: afterRenderModule mod_custom (face)

Hora: 0.05 ms / 1552.92 ms Memória: -0.000 MB / 4.50 MB Application: beforeRenderModule mod_virtuemart_category (Produtos)

Hora: 11.03 ms / 1563.95 ms Memória: 0.142 MB / 4.64 MB Application: afterRenderModule mod_virtuemart_category (Produtos)

Hora: 0.03 ms / 1563.97 ms Memória: -0.001 MB / 4.64 MB Application: beforeRenderModule mod_virtuemart_cart (Compras)

Hora: 90.30 ms / 1654.28 ms Memória: 1.199 MB / 5.84 MB Application: afterRenderModule mod_virtuemart_cart (Compras)

Hora: 0.04 ms / 1654.31 ms Memória: -0.002 MB / 5.84 MB Application: beforeRenderModule mod_login (Faça seu cadastro)

Hora: 2.39 ms / 1656.71 ms Memória: 0.017 MB / 5.85 MB Application: afterRenderModule mod_login (Faça seu cadastro)

Hora: 0.08 ms / 1656.79 ms Memória: 0.004 MB / 5.86 MB Application: beforeRenderModule mod_virtuemart_search (Busca)

Hora: 1.53 ms / 1658.32 ms Memória: 0.011 MB / 5.87 MB Application: afterRenderModule mod_virtuemart_search (Busca)

Hora: 0.05 ms / 1658.37 ms Memória: -0.004 MB / 5.86 MB Application: beforeRenderModule mod_custom (topo curitiba)

Hora: 0.16 ms / 1658.53 ms Memória: 0.003 MB / 5.87 MB Application: afterRenderModule mod_custom (topo curitiba)

Hora: 3.37 ms / 1661.90 ms Memória: 0.049 MB / 5.92 MB Application: afterRender

Total de consultas ao banco de dados: 214.82 ms

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

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Igual à chamada na linha abaixo.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Chamador	Arquivo e número da linha
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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN não é possível na consulta: INSERT INTO `awpim_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6334373161396630303833666131323233633664363237343365316239663463', 1, 1713606605, 0, '', 0)

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	15.50 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	29.61 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.82 ms Após última consulta: 5.09 ms Memória de consulta: 0.030 MB de memória antes da consulta: 1.737 MB Linhas retornadas: 38

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

  FROM `awpim_extensions`

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_extensions	NULL	ref	extension	extension	82	const	38	1.00	Using where

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.21 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Igual à chamada na linha abaixo.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.54 ms Após última consulta: 4.94 ms Memória de consulta: 0.022 MB de memória antes da consulta: 1.833 MB Linhas retornadas: 3

SELECT id, rules

  FROM `awpim_viewlevels`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_viewlevels	NULL	ALL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	3	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.09 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.61 ms Após última consulta: 0.08 ms Memória de consulta: 0.022 MB de memória antes da consulta: 1.844 MB Linhas retornadas: 1

SELECT b.id

  FROM awpim_usergroups AS a

  LEFT JOIN awpim_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.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 1.61 ms Após última consulta: 1.62 ms Memória de consulta: 0.034 MB de memória antes da consulta: 1.866 MB Linhas retornadas: 91

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

  FROM awpim_extensions

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

  ORDER BY ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_extensions	NULL	ref	extension	extension	82	const	131	0.43	Using where; Usando filesort

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	1.00 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.51 ms Após última consulta: 29.96 ms Memória de consulta: 0.022 MB de memória antes da consulta: 2.340 MB Linhas retornadas: 1

SELECT `template`

  FROM `awpim_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	7	10.00	Using where

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->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:668
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.82 ms Após última consulta: 9.05 ms Memória de consulta: 0.033 MB de memória antes da consulta: 2.444 MB Linhas retornadas: 6

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

  FROM awpim_menu AS m

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

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

  ORDER BY m.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	6	10.00	Using index condition; Using where; Usando filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.m.component_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.15 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual à chamada na linha abaixo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.59 ms Após última consulta: 22.52 ms Memória de consulta: 0.025 MB de memória antes da consulta: 2.696 MB Linhas retornadas: 1

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

  FROM `awpim_extensions`

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Igual à chamada na linha abaixo.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 29.37 ms Após última consulta: 0.13 ms Memória de consulta: 0.005 MB de memória antes da consulta: 2.686 MB

UPDATE `awpim_extensions`

  SET `params` = '{\"mediaversion\":\"66cb0b74a2d2d0c9f87a9c7fda4a96af\"}'

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

Explicar

EXPLAIN não é possível na consulta: UPDATE `awpim_extensions` SET `params` = '{\"mediaversion\":\"66cb0b74a2d2d0c9f87a9c7fda4a96af\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.07 ms
updating	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	28.77 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 1.39 ms Após última consulta: 3.99 ms Memória de consulta: 0.025 MB de memória antes da consulta: 2.722 MB Linhas retornadas: 1

SELECT *

  FROM awpim_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_languages	NULL	ALL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	1	100.00	Using where; Usando filesort

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.97 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.59 ms Após última consulta: 0.23 ms Memória de consulta: 0.031 MB de memória antes da consulta: 2.734 MB Linhas retornadas: 7

SELECT id, home, template, s.params

  FROM awpim_template_styles as s

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	11	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	uniformessantos_com_br.e.element	1	63.64	Using index condition; Using where

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.13 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 1.60 ms Após última consulta: 116.16 ms Memória de consulta: 0.031 MB de memória antes da consulta: 3.003 MB Linhas retornadas: 38

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

  FROM `awpim_assets`

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_assets	NULL	ALL	idx_asset_name	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	61	63.93	Using where

Perfil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.84 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.12 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
logging slow query	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_contact/models/contact.php:62
14	ContactModelContact->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_contact/models/contact.php:165
12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 3.08 ms Após última consulta: 1.19 ms Memória de consulta: 0.039 MB de memória antes da consulta: 3.071 MB Linhas retornadas: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM awpim_contact_details AS a

  LEFT JOIN awpim_categories AS c 
  on c.id = a.catid

  LEFT JOIN awpim_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.id = 1 
  AND (a.published = 1 OR a.published =2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 09:50:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 09:50:05')

Explicar

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

Perfil

Status	Duration
starting	0.15 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	2.37 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:225
12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 12.52 ms Após última consulta: 33.27 ms Memória de consulta: 0.035 MB de memória antes da consulta: 3.107 MB Linhas retornadas: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `awpim_contentitem_tag_map` AS m 

  INNER JOIN `awpim_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	uniformessantos_com_br.m.tag_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.95 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	8.89 ms
preparing	0.05 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.16 ms
freeing items	0.05 ms
logging slow query	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_contact/models/contact.php:255
12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 3.28 ms Após última consulta: 73.22 ms Memória de consulta: 0.033 MB de memória antes da consulta: 3.197 MB Linhas retornadas: 16

SHOW FULL COLUMNS 
  FROM `awpim_users`

Explicar

EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `awpim_users`

Perfil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.71 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.93 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.08 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_users/models/user.php:65
16	UsersModelUser->getTable()	JROOT/libraries/src/MVC/Model/AdminModel.php:971
15	Joomla\CMS\MVC\Model\AdminModel->getItem()	JROOT/administrator/components/com_users/models/user.php:90
14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:395
13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 4.84 ms Após última consulta: 162.63 ms Memória de consulta: 0.039 MB de memória antes da consulta: 3.329 MB Linhas retornadas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM awpim_fields AS a

  LEFT JOIN `awpim_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN awpim_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN awpim_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN awpim_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN awpim_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_users.user' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Usando filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	uniformessantos_com_br.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.group_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.17 ms
Executing hook on transaction	0.01 ms
starting	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
Opening tables	3.72 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.04 ms
Creating tmp table	0.08 ms
executing	0.09 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.15 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
17	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
16	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_contact/models/contact.php:411
13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.63 ms Após última consulta: 0.10 ms Memória de consulta: 0.032 MB de memória antes da consulta: 3.341 MB Linhas retornadas: 1

Consultas duplicadas: #21

SELECT *

  FROM `awpim_extensions`

  WHERE `type` = 'plugin' 
  AND `element` = 'helix3' 
  AND `folder` = 'system'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	10.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.17 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:277
17	plgSystemHelix3::getVersion()	JROOT/plugins/system/helix3/helix3.php:91
16	plgSystemHelix3->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_contact/models/contact.php:411
13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:291
12	ContactModelContact->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 1.25 ms Após última consulta: 44.89 ms Memória de consulta: 0.039 MB de memória antes da consulta: 3.367 MB Linhas retornadas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM awpim_fields AS a

  LEFT JOIN `awpim_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN awpim_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN awpim_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN awpim_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN awpim_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_contact.mail' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Usando filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	uniformessantos_com_br.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.group_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.23 ms
preparing	0.05 ms
Creating tmp table	0.10 ms
executing	0.10 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_contact/models/contact.php:82
12	ContactModelContact->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:84
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.54 ms Após última consulta: 0.10 ms Memória de consulta: 0.032 MB de memória antes da consulta: 3.379 MB Linhas retornadas: 1

Consultas duplicadas: #19

SELECT *

  FROM `awpim_extensions`

  WHERE `type` = 'plugin' 
  AND `element` = 'helix3' 
  AND `folder` = 'system'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	10.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.08 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:277
18	plgSystemHelix3::getVersion()	JROOT/plugins/system/helix3/helix3.php:91
17	plgSystemHelix3->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_contact/models/contact.php:82
12	ContactModelContact->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/contact/view.html.php:84
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 21.29 ms Após última consulta: 63.07 ms Memória de consulta: 0.039 MB de memória antes da consulta: 3.478 MB Linhas retornadas: 2

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

  FROM `awpim_categories` AS `s`

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

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

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando filesort
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	2	57.14	Using index condition; Using where

Perfil

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	20.23 ms
preparing	0.08 ms
executing	0.20 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.04 ms
freeing items	0.15 ms
cleaning up	0.03 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:309
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 2.06 ms Após última consulta: 1.45 ms Memória de consulta: 0.037 MB de memória antes da consulta: 3.493 MB Linhas retornadas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM awpim_fields AS a

  LEFT JOIN `awpim_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN awpim_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN awpim_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN awpim_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN awpim_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `awpim_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_contact.contact' 
  AND (fc.category_id IS NULL OR fc.category_id IN (4,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Usando filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	uniformessantos_com_br.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.a.id	1	100.00	Using where; Using index; Distinct

Perfil

Status	Duration
starting	0.20 ms
Executing hook on transaction	0.01 ms
starting	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.00 ms
checking permissions	0.01 ms
Opening tables	1.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.21 ms
preparing	0.05 ms
Creating tmp table	0.11 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_contact/views/contact/view.html.php:309
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 3.93 ms Após última consulta: 49.40 ms Memória de consulta: 0.037 MB de memória antes da consulta: 3.518 MB Linhas retornadas: 43

SHOW FULL COLUMNS 
  FROM `awpim_contact_details`

Explicar

EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `awpim_contact_details`

Perfil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.08 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.08 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.08 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:39
13	ContactTableContact->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_contact/models/contact.php:628
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:370
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 51.18 ms Após última consulta: 159.17 ms Memória de consulta: 0.006 MB de memória antes da consulta: 3.605 MB

UPDATE awpim_contact_details

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1'

Explicar

EXPLAIN não é possível na consulta: UPDATE awpim_contact_details SET `hits` = (`hits` + 1) WHERE `id` = '1'

Perfil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.06 ms
updating	0.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	50.49 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_contact/models/contact.php:629
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:370
10	ContactViewContact->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 2.49 ms Após última consulta: 474.85 ms Memória de consulta: 0.029 MB de memória antes da consulta: 4.270 MB Linhas retornadas: 1

SHOW TABLES LIKE "awpim_virtuemart_configs"

Explicar

EXPLAIN não é possível na consulta: SHOW TABLES LIKE "awpim_virtuemart_configs"

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.19 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.44 ms
checking permissions	0.29 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.10 ms
cleaning up	0.04 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701
25	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:569
24	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:930
23	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:874
22	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
21	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/helix3/core/classes/menu.php:135
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:42
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:918
11	Helix3::loadMegaMenu()	JROOT/templates/santos/features/menu.php:29
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:256
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:312
8	Helix3::generatelayout()	JROOT/templates/santos/index.php:157
7	require JROOT/templates/santos/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 1.39 ms Após última consulta: 0.10 ms Memória de consulta: 0.028 MB de memória antes da consulta: 4.282 MB Linhas retornadas: 1

SELECT `config` 
  FROM `awpim_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	awpim_virtuemart_configs	NULL	system	PRIMARY	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	1	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:978
23	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:874
22	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
21	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/helix3/core/classes/menu.php:135
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:42
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:918
11	Helix3::loadMegaMenu()	JROOT/templates/santos/features/menu.php:29
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:256
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:312
8	Helix3::generatelayout()	JROOT/templates/santos/index.php:157
7	require JROOT/templates/santos/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.56 ms Após última consulta: 1.44 ms Memória de consulta: 0.036 MB de memória antes da consulta: 4.359 MB Linhas retornadas: 2

SELECT * 
  FROM `awpim_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "pt-BR" ) 
  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	awpim_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	7	2.22	Using index condition; Using where; Usando filesort

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.13 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1264
24	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:850
23	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:879
22	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
21	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/helix3/core/classes/menu.php:135
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:42
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:918
11	Helix3::loadMegaMenu()	JROOT/templates/santos/features/menu.php:29
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:256
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:312
8	Helix3::generatelayout()	JROOT/templates/santos/index.php:157
7	require JROOT/templates/santos/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 2.13 ms Após última consulta: 4.26 ms Memória de consulta: 0.029 MB de memória antes da consulta: 4.491 MB Linhas retornadas: 8

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

  FROM awpim_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-20 09:50:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 09:50:05') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 111 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	9	3.57	Using index condition; Using where; Usando filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	uniformessantos_com_br.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	uniformessantos_com_br.m.id	1	40.00	Using where; Using index

Perfil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	1.38 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.25 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	Igual à chamada na linha abaixo.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:592
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:539
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:330
8	Helix3::generatelayout()	JROOT/templates/santos/index.php:157
7	require JROOT/templates/santos/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 2.05 ms Após última consulta: 36.23 ms Memória de consulta: 0.032 MB de memória antes da consulta: 4.944 MB Linhas retornadas: 1

SELECT * 
  FROM `awpim_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	awpim_virtuemart_shoppergroups	NULL	ref	shared,published,virtuemart_vendor_id	published	1	const	1	50.00	Using where

Perfil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.51 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.11 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:132
11	VirtueMartCart::getCart()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.29 ms Após última consulta: 0.12 ms Memória de consulta: 0.033 MB de memória antes da consulta: 4.974 MB Linhas retornadas: 1

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	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.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:132
11	VirtueMartCart::getCart()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:23
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 3.51 ms Após última consulta: 26.07 ms Memória de consulta: 0.040 MB de memória antes da consulta: 5.151 MB Linhas retornadas: 1

SELECT *  
  FROM `awpim_virtuemart_currencies` AS c
			
  LEFT JOIN `awpim_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	system	PRIMARY,vendor_currency	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.00 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.16 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
18	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
17	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.33 ms Após última consulta: 1.66 ms Memória de consulta: 0.036 MB de memória antes da consulta: 5.204 MB Linhas retornadas: 1

SELECT `awpim_virtuemart_currencies`.*  
  FROM `awpim_virtuemart_currencies`  
  WHERE `awpim_virtuemart_currencies`.`virtuemart_currency_id` = "20"

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1020
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1031
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 3.77 ms Após última consulta: 4.22 ms Memória de consulta: 0.040 MB de memória antes da consulta: 5.310 MB Linhas retornadas: 32

SHOW FULL COLUMNS  
  FROM `awpim_virtuemart_userfields`

Explicar

EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `awpim_virtuemart_userfields`

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.73 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.98 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.08 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.10 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:662
25	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
24	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:219
23	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:434
22	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:396
21	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:602
20	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:52
19	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:554
18	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:254
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 2.05 ms Após última consulta: 0.16 ms Memória de consulta: 0.048 MB de memória antes da consulta: 5.369 MB Linhas retornadas: 16

SELECT * 
  FROM `awpim_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	awpim_virtuemart_userfields	NULL	ref	published,account	published	1	const	17	85.19	Using where; Usando filesort

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.45 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.11 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:619
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:503
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:265
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 1.68 ms Após última consulta: 1.10 ms Memória de consulta: 0.034 MB de memória antes da consulta: 5.461 MB Linhas retornadas: 9

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

 
  ORDER BY country_name ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	awpim_virtuemart_countries	NULL	ref	published	published	1	const	9	100.00	Usando filesort

Perfil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.28 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:859
21	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
20	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:146
19	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:857
18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:269
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.49 ms Após última consulta: 4.01 ms Memória de consulta: 0.048 MB de memória antes da consulta: 5.521 MB Linhas retornadas: 9

SELECT * 
  FROM `awpim_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	awpim_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	15	62.96	Using where; Usando filesort

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.13 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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:499
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:619
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:509
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:265
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:274
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 3.22 ms Após última consulta: 1.48 ms Memória de consulta: 0.038 MB de memória antes da consulta: 5.593 MB Linhas retornadas: 0

SELECT c.* 
  FROM awpim_virtuemart_calcs as c  
  LEFT JOIN awpim_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 <= "2024-04-20 09:50:05" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-20 09:50:05" )
 
  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	NULL	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	2.77 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.12 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:172
16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1529
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.38 ms Após última consulta: 0.08 ms Memória de consulta: 0.038 MB de memória antes da consulta: 5.604 MB Linhas retornadas: 0

SELECT * 
  FROM awpim_virtuemart_calcs  
  LEFT JOIN awpim_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 <= "2024-04-20 09:50:05" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-20 09:50:05" )
 
  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	NULL	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.02 ms
executing	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.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:740
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1533
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.37 ms Após última consulta: 0.06 ms Memória de consulta: 0.038 MB de memória antes da consulta: 5.613 MB Linhas retornadas: 0

SELECT * 
  FROM awpim_virtuemart_calcs  
  LEFT JOIN awpim_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 <= "2024-04-20 09:50:05" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-20 09:50:05" )
 
  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	NULL	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:741
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1533
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

Tempo da consulta: 0.37 ms Após última consulta: 0.06 ms Memória de consulta: 0.038 MB de memória antes da consulta: 5.622 MB Linhas retornadas: 0

SELECT * 
  FROM awpim_virtuemart_calcs  
  LEFT JOIN awpim_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 <= "2024-04-20 09:50:05" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-20 09:50:05" )
 
  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	NULL	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.02 ms
executing	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.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1351
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:742
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1533
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1632
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1756
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php:30
10	include JROOT/modules/mod_virtuemart_cart/mod_virtuemart_cart.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

35 tipos de query registradas, sorteadas por ocorrências DESC

SELECT Tables:

3 × SELECT * 
  FROM awpim_virtuemart_calcs  
  LEFT JOIN awpim_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM awpim_fields AS a 
  LEFT JOIN `awpim_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN awpim_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN awpim_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN awpim_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN awpim_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT * 
  FROM `awpim_virtuemart_userfields`

2 × SELECT * 
  FROM `awpim_extensions`

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

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

1 × SELECT `config` 
  FROM `awpim_virtuemart_configs`

1 × SELECT c.* 
  FROM awpim_virtuemart_calcs as c  
  LEFT JOIN awpim_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT * 
  FROM `awpim_virtuemart_countries`

1 × SELECT `awpim_virtuemart_currencies`.*  
  FROM `awpim_virtuemart_currencies`

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

1 × SELECT `awpim_virtuemart_shoppergroups`.*  
  FROM `awpim_virtuemart_shoppergroups`

1 × SELECT * 
  FROM `awpim_virtuemart_shoppergroups`

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

```
1 × SELECT * 
  FROM `awpim_menu`
```

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM awpim_fields AS a 
  LEFT JOIN `awpim_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN awpim_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN awpim_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN awpim_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN awpim_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `awpim_fields_categories` AS fc 
  ON fc.field_id = a.id

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

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

1 × SELECT `session_id` 
  FROM `awpim_session`

1 × SELECT id, rules 
  FROM `awpim_viewlevels

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `awpim_contentitem_tag_map` AS m  
  INNER JOIN `awpim_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM awpim_contact_details AS a 
  LEFT JOIN awpim_categories AS c 
  on c.id = a.catid 
  LEFT JOIN awpim_categories as parent 
  ON parent.id = c.parent_id

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

1 × SELECT id, home, template, s.params 
  FROM awpim_template_styles as s 
  LEFT JOIN awpim_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM awpim_languages
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM awpim_menu AS m 
  LEFT JOIN awpim_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `template` 
  FROM `awpim_template_styles`

1 × SELECT `data` 
  FROM `awpim_session`

Outras Tabelas:

1 × INSERT INTO `awpim_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6334373161396630303833666131323233633664363237343365316239663463', 1, 1713606605, 0, '', 0

1 × UPDATE `awpim_extensions` 
  SET `params` = '{\"mediaversion\":\"66cb0b74a2d2d0c9f87a9c7fda4a96af\"}'

1 × SHOW FULL COLUMNS 
  FROM `awpim_users

1 × SHOW FULL COLUMNS 
  FROM `awpim_contact_details

1 × UPDATE awpim_contact_details 
  SET `hits` = (`hits` + 1)

1 × SHOW TABLES LIKE "awpim_virtuemart_configs

1 × SHOW FULL COLUMNS  
  FROM `awpim_virtuemart_userfields

Uniformes Santos

Contato

Formulário de Contato

Produtos

Compras

Faça seu cadastro

Console de depuração do Joomla!

Sessão

Informação do perfil

Hora

Memória

Memória Utilizada

Consultas ao banco

41 Queries Registradas 214.82 ms

2 duplicatas encontradas!

35 tipos de query registradas, sorteadas por ocorrências DESC

SELECT Tables:

Outras Tabelas: