Console de depuração do Joomla!

Sessão

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614330776,
                "last": 1614330776,
                "now": 1614330776
            },
            "honeypot": "efd26a2a23ec573589a9feb8bce2c442",
            "token": "7nupGgP47OlMvXpIlJjrOaYoXUh8jZse"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_rsfirewall": {
            "geoip": "US"
        }
    }
}

Informação do perfil

Memória Utilizada

Consultas ao banco

46 Queries Registradas 31.55 ms

6 duplicatas encontradas!

2 duplicadas: #12 #46

2 duplicadas: #16 #29

2 duplicadas: #44 #45

Tempo da consulta: 0.75 ms Memória de consulta: 0.012 MB de memória antes da consulta: 1.007 MB Linhas retornadas: 0

SELECT `session_id`

  FROM `d374f_session`

  WHERE `session_id` = 'f8ca5o0b1ua43hh8d6c1nhibf4' 
  LIMIT 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.28 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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: 1.39 ms Após última consulta: 0.21 ms Memória de consulta: 0.009 MB de memória antes da consulta: 1.023 MB

INSERT INTO `d374f_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('f8ca5o0b1ua43hh8d6c1nhibf4', 0, 1, '1614330776', 0, '')

Explicar

EXPLAIN não é possível na consulta: INSERT INTO `d374f_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('f8ca5o0b1ua43hh8d6c1nhibf4', 0, 1, '1614330776', 0, '')

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
update	0.09 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.00 ms
query end	1.11 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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: 1.11 ms Após última consulta: 1.64 ms Memória de consulta: 0.022 MB de memória antes da consulta: 1.082 MB Linhas retornadas: 37

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

  FROM `d374f_extensions`

  WHERE `type` = 'component'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_extensions	ref	extension	extension	82	const	37	Using index condition

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.13 ms
Waiting for query cache lock	0.00 ms
Sending data	0.56 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Após última consulta: 1.15 ms Memória de consulta: 0.015 MB de memória antes da consulta: 1.164 MB Linhas retornadas: 1

SELECT b.id

  FROM d374f_usergroups AS a

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

  WHERE a.id = 1

Explicar

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

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Após última consulta: 0.41 ms Memória de consulta: 0.014 MB de memória antes da consulta: 1.185 MB Linhas retornadas: 3

SELECT id, rules

  FROM `d374f_viewlevels`

Explicar

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

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.19 ms Após última consulta: 0.21 ms Memória de consulta: 0.014 MB de memória antes da consulta: 1.203 MB Linhas retornadas: 66

SELECT folder AS type, element AS name, params

  FROM d374f_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_extensions	ref	extension	extension	82	const	82	Using index condition; Using where; Usando filesort

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.28 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.39 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.14 ms Após última consulta: 6.65 ms Memória de consulta: 0.017 MB de memória antes da consulta: 1.619 MB Linhas retornadas: 0

SELECT `path`

  FROM d374f_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Após última consulta: 0.15 ms Memória de consulta: 0.017 MB de memória antes da consulta: 1.635 MB Linhas retornadas: 0

SELECT `file`

  FROM d374f_rsfirewall_hashes

  WHERE `type`='protect'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_rsfirewall_hashes	ALL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	380	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.13 ms Após última consulta: 0.10 ms Memória de consulta: 0.019 MB de memória antes da consulta: 1.650 MB Linhas retornadas: 61

SELECT *

  FROM d374f_rsfirewall_configuration

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_rsfirewall_configuration	ALL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	61

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.84 ms Após última consulta: 6.28 ms Memória de consulta: 0.024 MB de memória antes da consulta: 2.018 MB Linhas retornadas: 10

SHOW FULL COLUMNS 
  FROM `d374f_rsfirewall_logs`

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRsfirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.30 ms Após última consulta: 3.61 ms Memória de consulta: 0.013 MB de memória antes da consulta: 2.136 MB Linhas retornadas: 1

SELECT `enabled`

  FROM `d374f_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.81 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:71
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.40 ms Após última consulta: 5.68 ms Memória de consulta: 0.043 MB de memória antes da consulta: 2.381 MB Linhas retornadas: 120

Consultas duplicadas: #46

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 d374f_menu AS m

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

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

  ORDER BY m.lft

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.06 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.15 ms Após última consulta: 10.62 ms Memória de consulta: 0.017 MB de memória antes da consulta: 4.061 MB Linhas retornadas: 8

SELECT `id`

  FROM `d374f_usergroups`

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_usergroups	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	8	Using index

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:25
11	RSFirewallUsersHelper::getAdminGroups()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:43
10	RSFirewallUsersHelper::getAdminUsers()	JROOT/plugins/system/rsfirewall/rsfirewall.php:942
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.86 ms Após última consulta: 0.80 ms Memória de consulta: 0.028 MB de memória antes da consulta: 4.146 MB Linhas retornadas: 8

SHOW FULL COLUMNS 
  FROM `d374f_assets`

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
16	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
15	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
14	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
13	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
12	JAccess::getAssetRules()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:26
11	RSFirewallUsersHelper::getAdminGroups()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:43
10	RSFirewallUsersHelper::getAdminUsers()	JROOT/plugins/system/rsfirewall/rsfirewall.php:942
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Após última consulta: 0.34 ms Memória de consulta: 0.022 MB de memória antes da consulta: 4.193 MB Linhas retornadas: 1

SELECT *

  FROM d374f_assets

  WHERE `id` = '1'

Explicar

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

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
14	JTable->load()	JROOT/libraries/joomla/access/access.php:697
13	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
12	JAccess::getAssetRules()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:26
11	RSFirewallUsersHelper::getAdminGroups()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:43
10	RSFirewallUsersHelper::getAdminUsers()	JROOT/plugins/system/rsfirewall/rsfirewall.php:942
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.09 ms Após última consulta: 0.25 ms Memória de consulta: 0.018 MB de memória antes da consulta: 4.209 MB Linhas retornadas: 1

Consultas duplicadas: #29

SELECT a.rules

  FROM d374f_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
12	JAccess::getAssetRules()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:26
11	RSFirewallUsersHelper::getAdminGroups()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:43
10	RSFirewallUsersHelper::getAdminUsers()	JROOT/plugins/system/rsfirewall/rsfirewall.php:942
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.12 ms Após última consulta: 0.75 ms Memória de consulta: 0.017 MB de memória antes da consulta: 4.236 MB Linhas retornadas: 1

SELECT DISTINCT(user_id)

  FROM d374f_usergroups as ug1

  INNER JOIN d374f_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN d374f_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id='6'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	2	Using index
1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	spidoimp_2020.m.group_id	1	Using where; Distinct

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:884
11	JAccess::getUsersByGroup()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:46
10	RSFirewallUsersHelper::getAdminUsers()	JROOT/plugins/system/rsfirewall/rsfirewall.php:942
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.09 ms Após última consulta: 0.15 ms Memória de consulta: 0.017 MB de memória antes da consulta: 4.253 MB Linhas retornadas: 1

SELECT DISTINCT(user_id)

  FROM d374f_usergroups as ug1

  INNER JOIN d374f_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN d374f_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id='8'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	2	Using index
1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	spidoimp_2020.m.group_id	1	Using where; Distinct

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:884
11	JAccess::getUsersByGroup()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:46
10	RSFirewallUsersHelper::getAdminUsers()	JROOT/plugins/system/rsfirewall/rsfirewall.php:942
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.09 ms Após última consulta: 0.13 ms Memória de consulta: 0.019 MB de memória antes da consulta: 4.268 MB Linhas retornadas: 2

SELECT u.*

  FROM d374f_users u

  WHERE u.id IN (694,693)

  ORDER BY u.username ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	u	range	PRIMARY	PRIMARY	4	NULL	2	Using where; Usando filesort

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/users.php:58
10	RSFirewallUsersHelper::getAdminUsers()	JROOT/plugins/system/rsfirewall/rsfirewall.php:942
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Após última consulta: 0.30 ms Memória de consulta: 0.016 MB de memória antes da consulta: 4.290 MB Linhas retornadas: 4

SELECT *

  FROM d374f_rsfirewall_hashes

  WHERE (`type`='3.6.5' OR `type`='protect') 
  AND `flag`!='C'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_rsfirewall_hashes	ALL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	380	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1008
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.14 ms Após última consulta: 0.77 ms Memória de consulta: 0.017 MB de memória antes da consulta: 4.315 MB Linhas retornadas: 0

SELECT *

  FROM d374f_rsfirewall_snapshots

  WHERE `type`='protect'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1031
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.09 ms Após última consulta: 0.22 ms Memória de consulta: 0.017 MB de memória antes da consulta: 4.332 MB Linhas retornadas: 0

SELECT `ip`,`reason`

  FROM d374f_rsfirewall_lists

  WHERE (`ip`='3.239.33.139' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_rsfirewall_lists	ref	published,type,ip	type	1	const	1	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
10	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1067
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.08 ms Após última consulta: 0.17 ms Memória de consulta: 0.017 MB de memória antes da consulta: 4.349 MB Linhas retornadas: 0

SELECT `ip`,`reason`

  FROM d374f_rsfirewall_lists

  WHERE (`ip`='3.239.33.139' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_rsfirewall_lists	ALL	published,type,ip	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	22	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
10	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1071
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.14 ms Após última consulta: 7.29 ms Memória de consulta: 0.018 MB de memória antes da consulta: 4.497 MB Linhas retornadas: 0

SELECT *

  FROM d374f_rsfirewall_exceptions

  WHERE `published`='1'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:674
10	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1202
9	plgSystemRsfirewall->onAfterRoute()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.87 ms Após última consulta: 0.74 ms Memória de consulta: 0.019 MB de memória antes da consulta: 4.525 MB Linhas retornadas: 1

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

  FROM `d374f_extensions`

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

Explicar

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

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.38 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	Igual à chamada na linha abaixo.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.75 ms Após última consulta: 0.29 ms Memória de consulta: 0.012 MB de memória antes da consulta: 4.526 MB

UPDATE `d374f_extensions`

  SET `params` = '{\"mediaversion\":\"913be992da8620b1e2c64e39292a4e27\"}'

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.06 ms
Updating	0.15 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.63 ms
query end	0.75 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Após última consulta: 1.75 ms Memória de consulta: 0.014 MB de memória antes da consulta: 4.674 MB Linhas retornadas: 1

SELECT *

  FROM d374f_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.78 ms Após última consulta: 0.47 ms Memória de consulta: 0.010 MB de memória antes da consulta: 4.694 MB Linhas retornadas: 5

SELECT id, home, template, s.params

  FROM d374f_template_styles as s

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

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	11	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	spidoimp_2020.s.template,const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.28 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.17 ms Após última consulta: 34.88 ms Memória de consulta: 0.023 MB de memória antes da consulta: 6.405 MB Linhas retornadas: 1

Consultas duplicadas: #16

SELECT a.rules

  FROM d374f_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/components/com_contactenhanced/models/contact.php:47
13	ContactenhancedModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:33
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.58 ms Após última consulta: 0.32 ms Memória de consulta: 0.026 MB de memória antes da consulta: 6.431 MB Linhas retornadas: 37

SELECT element

  FROM d374f_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explicar

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

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/components/com_contactenhanced/models/contact.php:47
13	ContactenhancedModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:33
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.12 ms Após última consulta: 0.24 ms Memória de consulta: 0.026 MB de memória antes da consulta: 6.464 MB Linhas retornadas: 37

SELECT a.name, a.rules

  FROM d374f_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_cmssecurity','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_asset_name	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	199	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/components/com_contactenhanced/models/contact.php:47
13	ContactenhancedModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:33
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.39 ms Após última consulta: 1.97 ms Memória de consulta: 0.035 MB de memória antes da consulta: 6.798 MB Linhas retornadas: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) 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 d374f_ce_details AS a

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

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

  WHERE a.id = 31 
  AND (a.published = 1 OR a.published =2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-26 09:12:56') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-26 09:12:56')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.66 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.04 ms
init	0.11 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_contactenhanced/models/contact.php:120
12	ContactenhancedModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:34
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.43 ms Após última consulta: 1.38 ms Memória de consulta: 0.021 MB de memória antes da consulta: 6.887 MB Linhas retornadas: 0

SELECT `t`.`id`

  FROM `d374f_tags` AS t 

  INNER JOIN `d374f_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` IN ( 31)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	3	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	spidoimp_2020.m.tag_id	1	Using index

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/cms/helper/tags.php:487
13	JHelperTags->getTagIds()	JROOT/components/com_contactenhanced/models/contact.php:150
12	ContactenhancedModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:34
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.55 ms Após última consulta: 0.29 ms Memória de consulta: 0.035 MB de memória antes da consulta: 6.911 MB Linhas retornadas: 1

SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM d374f_ce_details AS a

  INNER JOIN d374f_categories AS cc 
  on cc.id = a.catid

  WHERE a.id = 31 
  AND a.published IN (1,2) 
  AND cc.published IN (1,2) 
  AND a.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.08 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
14	JDatabaseDriver->loadObject()	JROOT/components/com_contactenhanced/models/contact.php:245
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:182
12	ContactenhancedModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:34
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.74 ms Após última consulta: 0.49 ms Memória de consulta: 0.022 MB de memória antes da consulta: 6.950 MB Linhas retornadas: 0

SELECT a.id,a.title,a.state,a.access,a.created, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug

  FROM d374f_content as a

  LEFT JOIN d374f_categories as c 
  on a.catid=c.id

  WHERE a.created_by = 0 
  AND a.access IN (1,1) 
  AND a.state IN (1,2)

  ORDER BY a.state DESC, a.created DESC 
  LIMIT 10

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_createdby	idx_createdby	4	const	1	Using where; Usando filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	spidoimp_2020.a.catid	1	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.83 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_contactenhanced/models/contact.php:310
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:182
12	ContactenhancedModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:34
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.81 ms Após última consulta: 11.25 ms Memória de consulta: 0.033 MB de memória antes da consulta: 7.655 MB Linhas retornadas: 16

SHOW FULL COLUMNS 
  FROM `d374f_users`

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
18	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/administrator/components/com_users/models/user.php:57
16	UsersModelUser->getTable()	JROOT/libraries/legacy/model/admin.php:886
15	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:73
14	UsersModelUser->getItem()	JROOT/components/com_contactenhanced/models/contact.php:316
13	ContactenhancedModelContact->getContactQuery()	JROOT/components/com_contactenhanced/models/contact.php:182
12	ContactenhancedModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contactenhanced/views/contact/view.html.php:34
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.59 ms Após última consulta: 9.77 ms Memória de consulta: 0.025 MB de memória antes da consulta: 8.260 MB Linhas retornadas: 4

SELECT cf.*

  FROM d374f_ce_cf AS cf

  WHERE cf.access IN (1,1) 
  AND (cf.catid = '60' OR cf.catid = 0) 
  AND (cf.published > 0 OR (cf.published = 0 
  AND cf.iscore = 1) ) 
  AND cf.language IN ('pt-BR','*')

  ORDER BY cf.catid, cf.ordering ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cf	ALL	idx_ce_cf_language,idx_ce_cf_published,idx_ce_cf_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	4	Using where; Usando filesort

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	1.84 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.06 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_contactenhanced/models/customfields.php:85
13	ContactenhancedModelCustomfields->getItems()	JROOT/components/com_contactenhanced/helpers/helper.php:524
12	ceHelper::getCustomFields()	JROOT/components/com_contactenhanced/models/contact.php:192
11	ContactenhancedModelContact->getCustomFields()	JROOT/components/com_contactenhanced/views/contact/view.html.php:37
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.71 ms Após última consulta: 2.18 ms Memória de consulta: 0.028 MB de memória antes da consulta: 8.348 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,COUNT(i.`id`) AS numitems

  FROM d374f_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM d374f_categories AS cat JOIN d374f_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_contactenhanced' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN d374f_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `d374f_ce_details` AS i 
  ON i.`catid` = c.id 
  AND i.published = 1

  WHERE (c.extension='com_contactenhanced' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=60

  GROUP BY 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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Usando filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	2	Using index condition; Using where
1	PRIMARY	i	ref	idx_state,idx_catid	idx_state	1	const	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	spidoimp_2020.c.id	9	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Usando filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	47	Using where; Using index; Using join buffer (flat, BNL join)

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.16 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.07 ms
init	0.11 ms
optimizing	0.00 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.12 ms
statistics	0.23 ms
preparing	0.05 ms
executing	0.00 ms
Creating tmp table	0.32 ms
Copying to tmp table	0.08 ms
executing	0.01 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.03 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.15 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.00 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.83 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_contactenhanced/models/category.php:274
12	ContactenhancedModelCategory->getCategory()	JROOT/components/com_contactenhanced/models/category.php:60
11	ContactenhancedModelCategory->getItems()	JROOT/components/com_contactenhanced/views/contact/view.html.php:58
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.29 ms Após última consulta: 3.23 ms Memória de consulta: 0.036 MB de memória antes da consulta: 8.563 MB Linhas retornadas: 1

SELECT a.id, a.name, a.alias, a.name AS title, a.alias AS title_alias, a.params, a.checked_out, a.checked_out_time, a.birthdate, a.misc, a.con_position, a.address, a.suburb, a.state , a.country, a.postcode, a.telephone, a.fax, a.mobile, a.skype, a.twitter, a.facebook, a.linkedin, a.webpage, a.image, a.extra_field_1, a.extra_field_2, a.extra_field_3, a.extra_field_4, a.extra_field_5,a.lat, a.lng, a.email_to,a.catid, a.created, a.created_by, a.created_by_alias,  
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.metadata, a.metakey, a.metadesc, a.access, a.xreference, a.featured ,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS published,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM d374f_ce_details AS a

  LEFT JOIN d374f_categories AS c 
  ON c.id = a.catid

  LEFT JOIN d374f_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN d374f_users AS uam 
  ON uam.id = a.modified_by

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM d374f_categories AS cat JOIN d374f_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_contactenhanced' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE 
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 
  AND a.catid = 60 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-26 09:12:56') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-26 09:12:56')

  ORDER BY ordering  ASC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_catid	idx_catid	4	const	1	Using where; Usando filesort
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	spidoimp_2020.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	spidoimp_2020.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	spidoimp_2020.c.parent_id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	spidoimp_2020.c.id	9	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Usando filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	47	Using where; Using index; Using join buffer (flat, BNL join)

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.05 ms
init	0.15 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.12 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.10 ms
executing	0.00 ms
Creating tmp table	0.01 ms
Copying to tmp table	0.03 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_contactenhanced/models/contacts.php:512
12	ContactenhancedModelContacts->getItems()	JROOT/components/com_contactenhanced/models/category.php:78
11	ContactenhancedModelCategory->getItems()	JROOT/components/com_contactenhanced/views/contact/view.html.php:58
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.84 ms Após última consulta: 2.05 ms Memória de consulta: 0.022 MB de memória antes da consulta: 8.795 MB Linhas retornadas: 1

SELECT COUNT(*)

  FROM d374f_ce_details AS a

  LEFT JOIN d374f_categories AS c 
  ON c.id = a.catid

  LEFT JOIN d374f_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN d374f_users AS uam 
  ON uam.id = a.modified_by

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM d374f_categories AS cat JOIN d374f_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_contactenhanced' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE 
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 
  AND a.catid = 60 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-02-26 09:12:56') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-02-26 09:12:56')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_catid	idx_catid	4	const	1	Using where
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	<derived2>	ref	key0	key0	5	spidoimp_2020.c.id	9	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Usando filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	47	Using where; Using index; Using join buffer (flat, BNL join)

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.03 ms
init	0.06 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.06 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.03 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.05 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
12	JModelList->getPagination()	JROOT/components/com_contactenhanced/models/category.php:88
11	ContactenhancedModelCategory->getItems()	JROOT/components/com_contactenhanced/views/contact/view.html.php:58
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.30 ms Após última consulta: 12.83 ms Memória de consulta: 0.029 MB de memória antes da consulta: 9.300 MB Linhas retornadas: 9

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

  FROM d374f_modules AS m

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

  LEFT JOIN d374f_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 <= '2021-02-26 09:12:56') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-02-26 09:12:56') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 318 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.04 ms
init	0.04 ms
optimizing	0.06 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.00 ms
Sorting result	0.15 ms
Sending data	0.45 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.05 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	Igual à chamada na linha abaixo.
19	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
18	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
17	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
16	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
15	JModuleHelper::getModules()	JROOT/components/com_contactenhanced/helpers/helper.php:2125
14	ceHelper::loadModulePosition()	JROOT/components/com_contactenhanced/views/contact/tmpl/default.php:49
13	include JROOT/components/com_contactenhanced/views/contact/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_contactenhanced/views/contact/view.html.php:211
10	ContactenhancedViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contactenhanced/controller.php:53
8	ContactenhancedController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contactenhanced/contactenhanced.php:40
6	require_once JROOT/components/com_contactenhanced/contactenhanced.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.24 ms Após última consulta: 45.05 ms Memória de consulta: 0.017 MB de memória antes da consulta: 11.846 MB Linhas retornadas: 1

SELECT * 
  FROM d374f_template_styles 
  WHERE template = 'cleanout';

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_template_styles	ref	idx_template	idx_template	202	const	1	Using index condition

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/templates/cleanout/vertex/parameters.php:19
9	getTemplateName()	JROOT/templates/cleanout/vertex/parameters.php:167
8	require JROOT/templates/cleanout/vertex/parameters.php	JROOT/templates/cleanout/index.php:21
7	require JROOT/templates/cleanout/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.57 ms Após última consulta: 0.21 ms Memória de consulta: 0.021 MB de memória antes da consulta: 11.863 MB Linhas retornadas: 0

SELECT * 
  FROM d374f_menu 
  WHERE template_style_id IN (22) 
  AND alias = 'contato'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_menu	ref	idx_alias	idx_alias	402	const	1	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.03 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
10	JDatabaseDriver->loadAssocList()	JROOT/templates/cleanout/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/cleanout/vertex/parameters.php:167
8	require JROOT/templates/cleanout/vertex/parameters.php	JROOT/templates/cleanout/index.php:21
7	require JROOT/templates/cleanout/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.27 ms Após última consulta: 21.69 ms Memória de consulta: 0.017 MB de memória antes da consulta: 12.122 MB Linhas retornadas: 0

Consultas duplicadas: #45

SELECT menutype  
  FROM  d374f_menu 
  WHERE language = 'pt-BR' 
  AND home = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/templates/cleanout/vertex/responsive/responsive_mobile_menu.php:139
10	include JROOT/templates/cleanout/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/cleanout/vertex/responsive/responsive_mobile_top_bar.php:85
9	require JROOT/templates/cleanout/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/cleanout/vertex/includes/vertex_includes_top.php:12
8	require JROOT/templates/cleanout/vertex/includes/vertex_includes_top.php	JROOT/templates/cleanout/index.php:98
7	require JROOT/templates/cleanout/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.24 ms Após última consulta: 6.51 ms Memória de consulta: 0.015 MB de memória antes da consulta: 12.211 MB Linhas retornadas: 0

Consultas duplicadas: #44

SELECT menutype  
  FROM  d374f_menu 
  WHERE language = 'pt-BR' 
  AND home = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d374f_menu	ref	idx_language	idx_language	28	const	1	Using index condition; Using where

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/templates/cleanout/vertex/s5flex_menu/default.php:45
8	include JROOT/templates/cleanout/vertex/s5flex_menu/default.php	JROOT/templates/cleanout/index.php:167
7	require JROOT/templates/cleanout/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.60 ms Após última consulta: 3.90 ms Memória de consulta: 0.043 MB de memória antes da consulta: 12.480 MB Linhas retornadas: 120

Consultas duplicadas: #12

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 d374f_menu AS m

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

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

  ORDER BY m.lft

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
Waiting for query cache lock	0.00 ms
After table lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.59 ms
Sending data	0.14 ms
Waiting for query cache lock	0.01 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Sending data	0.17 ms
Waiting for query cache lock	0.01 ms
Sending data	0.15 ms
Waiting for query cache lock	0.01 ms
Sending data	0.16 ms
Waiting for query cache lock	0.01 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Sending data	0.12 ms
Waiting for query cache lock	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.63 ms
cleaning up	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
11	JMenuSite->__construct()	JROOT/templates/cleanout/vertex/s5flex_menu/helpers.php:41
10	S5modMainMenuHelper::getList()	JROOT/templates/cleanout/vertex/s5flex_menu/helpers.php:141
9	S5modMainMenuHelper->S5buildXML()	JROOT/templates/cleanout/vertex/s5flex_menu/default.php:54
8	include JROOT/templates/cleanout/vertex/s5flex_menu/default.php	JROOT/templates/cleanout/index.php:167
7	require JROOT/templates/cleanout/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT Tables:

2 × SELECT a.rules 
  FROM d374f_assets AS a

2 × SELECT DISTINCT(user_id) 
  FROM d374f_usergroups as ug1 
  INNER JOIN d374f_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN d374f_user_usergroup_map AS m 
  ON ug2.id=m.group_id

2 × SELECT menutype  
  FROM  d374f_menu

2 × 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 d374f_menu AS m 
  LEFT JOIN d374f_extensions AS e 
  ON m.component_id = e.extension_id

2 × SELECT `ip`,`reason` 
  FROM d374f_rsfirewall_lists

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

1 × SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM d374f_ce_details AS a 
  INNER JOIN d374f_categories AS cc 
  on cc.id = a.catid

1 × SELECT a.id,a.title,a.state,a.access,a.created, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM d374f_content as a 
  LEFT JOIN d374f_categories as c 
  on a.catid=c.id

1 × SELECT `t`.`id` 
  FROM `d374f_tags` AS t  
  INNER JOIN `d374f_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` IN ( 31

1 × SELECT a.name, a.rules 
  FROM d374f_assets AS a

1 × SELECT element 
  FROM d374f_extensions

1 × SELECT cf.* 
  FROM d374f_ce_cf AS cf

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) 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 d374f_ce_details AS a 
  LEFT JOIN d374f_categories AS c 
  on c.id = a.catid 
  LEFT JOIN d374f_categories as parent 
  ON parent.id = c.parent_id

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

1 × SELECT * 
  FROM d374f_template_styles

```
1 × SELECT * 
  FROM d374f_menu
```

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

1 × SELECT COUNT(*) 
  FROM d374f_ce_details AS a 
  LEFT JOIN d374f_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN d374f_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN d374f_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN d374f_categories as parent 
  ON parent.id = c.parent_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM d374f_categories AS cat JOIN d374f_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.name, a.alias, a.name AS title, a.alias AS title_alias, a.params, a.checked_out, a.checked_out_time, a.birthdate, a.misc, a.con_position, a.address, a.suburb, a.state , a.country, a.postcode, a.telephone, a.fax, a.mobile, a.skype, a.twitter, a.facebook, a.linkedin, a.webpage, a.image, a.extra_field_1, a.extra_field_2, a.extra_field_3, a.extra_field_4, a.extra_field_5,a.lat, a.lng, a.email_to,a.catid, a.created, a.created_by, a.created_by_alias,  
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.metadata, a.metakey, a.metadesc, a.access, a.xreference, a.featured ,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS published,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM d374f_ce_details AS a 
  LEFT JOIN d374f_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN d374f_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN d374f_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN d374f_categories as parent 
  ON parent.id = c.parent_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM d374f_categories AS cat JOIN d374f_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

```
1 × SELECT * 
  FROM d374f_languages
```

1 × SELECT `id` 
  FROM `d374f_usergroups

```
1 × SELECT * 
  FROM d374f_assets
```

1 × SELECT folder AS type, element AS name, params 
  FROM d374f_extensions

1 × SELECT `enabled` 
  FROM `d374f_extensions`

1 × SELECT `file` 
  FROM d374f_rsfirewall_hashes

1 × SELECT * 
  FROM d374f_rsfirewall_configuratio

1 × SELECT id, rules 
  FROM `d374f_viewlevels

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

1 × SELECT `session_id` 
  FROM `d374f_session`

1 × SELECT * 
  FROM d374f_rsfirewall_exceptions

1 × SELECT * 
  FROM d374f_rsfirewall_snapshots

1 × SELECT * 
  FROM d374f_rsfirewall_hashes

```
1 × SELECT u.* 
  FROM d374f_users u
```

1 × SELECT `path` 
  FROM d374f_rsfirewall_ignored

Outras Tabelas:

1 × SHOW FULL COLUMNS 
  FROM `d374f_users

1 × UPDATE `d374f_extensions` 
  SET `params` = '{\"mediaversion\":\"913be992da8620b1e2c64e39292a4e27\"}'

1 × SHOW FULL COLUMNS 
  FROM `d374f_assets

1 × SHOW FULL COLUMNS 
  FROM `d374f_rsfirewall_logs

1 × INSERT INTO `d374f_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('f8ca5o0b1ua43hh8d6c1nhibf4', 0, 1, '1614330776', 0, ''

Contato

Login

Register

Console de depuração do Joomla!

Sessão

Informação do perfil

Hora

Memória

Memória Utilizada

Consultas ao banco

46 Queries Registradas 31.55 ms

6 duplicatas encontradas!

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

SELECT Tables:

Outras Tabelas: