Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgSystemJagooglemap has a deprecated constructor in /home/minis/domains/ministeriofama.org/public_html/portal/plugins/system/jagooglemap/jagooglemap.php on line 22

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/minis/domains/ministeriofama.org/public_html/portal/plugins/system/t3/includes/menu/megamenu.php on line 141

Warning: count(): Parameter must be an array or an object that implements Countable in /home/minis/domains/ministeriofama.org/public_html/portal/libraries/cms/application/cms.php on line 464
Pr. Acyr de Gerone | Como viver as promessas de Deus - Culto de Adoração - Assembléia de Deus Ministério Fama

Pr. Acyr de Gerone | Como viver as promessas de Deus - Culto de Adoração

Em um culto emocionante na última semana, a pastora Acyr De Gerone ministrou sobre Gênesis 21, destacando como Abraão e Sara viram a promessa de um filho se cumprir após 25 anos de espera. Com uma mensagem intitulada "Como Viver as Promessas de Deus", ela enfatizou que o sobrenatural acontece quando confiamos no tempo d’Ele, não na nossa ansiedade.

Destaques da Pregação:

Deus age no impossível: Sara, estéril e idosa, gerou Isaque porque "nada é difícil demais para o Senhor" (Gênesis 18:14).
O perigo da pressa humana: Ismael (filho da escrava Agar) simboliza soluções apressadas, enquanto Isaque representa a promessa divina.
Celebração antecipada: Abraão fez um banquete quando Isaque foi desmamado — um ato de fé de que Deus completaria o milagre.

A pastora também alertou: "Muitos perdem as promessas por não valorizarem o que já receberam". Ela citou exemplos de casamentos, empregos e ministérios negligenciados após a conquista.

Texto de Referência:

Gênesis 21
Gálatas 3:16
Hebreus 11:11-12
Isaías 55:11
Romanos 4:18

Pr. Abinair Vargas - Atributos de Deus - Culto de Ensino
< Ant
Pr. Carlinhos Felix | Obediência Salva, Restaura e Transforma! - Culto...
Próximo >

Console de depuração do Joomla!

Sessão

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1769999023,
                "last": 1769999023,
                "now": 1769999023
            },
            "client": {
                "forwarded": "10.1.63.230"
            },
            "token": "gL5EJRFhbL8Ad41s9lcyxCtIGP1WXIlY"
        },
        "registry": {
            "cmobile": {
                "ismobile": false,
                "isdevice": false,
                "device": "{}",
                "detection": {
                    "system": false
                }
            }
        },
        "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_mailto": {
            "links": {
                "f1eba951041f41707c8a06cb09df919e3e61302f": {
                    "link": "http:\/\/www.ministeriofama.org\/portal\/noticias\/1344-pr-acyr-de-gerone-como-viver-as-promessas-de-deus-culto-de-adoracao-ad-fama-sede",
                    "expiry": 1769999023
                }
            }
        }
    }
}

Informação do perfil

Tempo

Memória

Tempo: 10.70 ms / 10.70 ms Memória: 0.551 MB / 0.94 MB Application: afterLoad

Tempo: 66.00 ms / 76.69 ms Memória: 4.412 MB / 5.35 MB Application: afterInitialise

Tempo: 24.68 ms / 101.37 ms Memória: 1.759 MB / 7.11 MB Application: afterRoute

Tempo: 5.39 ms / 106.76 ms Memória: 0.201 MB / 7.31 MB Application: beforeRenderComponent com_content

Tempo: 7.60 ms / 114.36 ms Memória: 0.440 MB / 7.75 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 1.03 ms / 115.39 ms Memória: 0.034 MB / 7.78 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.05 ms / 115.45 ms Memória: 0.000 MB / 7.78 MB Application: Start JAccess::preload(components)

Tempo: 2.83 ms / 118.28 ms Memória: 0.207 MB / 7.99 MB Application: Finish JAccess::preload(components)

Tempo: 22.18 ms / 140.46 ms Memória: 1.181 MB / 9.17 MB Application: New JAccess Preloading Process(com_content.article)

Tempo: 5.75 ms / 146.21 ms Memória: 0.753 MB / 9.92 MB Application: After preloadPermissionsParentIdMapping (com_content.article)

Tempo: 8.44 ms / 154.65 ms Memória: 1.143 MB / 11.06 MB Application: After preloadPermissions (com_content.article)

Tempo: 0.01 ms / 154.66 ms Memória: 0.001 MB / 11.06 MB Application: End New JAccess Preloading Process(com_content.article)

Tempo: 0.02 ms / 154.68 ms Memória: 0.001 MB / 11.06 MB Application: Start JAccess::getAssetRules New (com_content.article.1344)

Tempo: 0.11 ms / 154.79 ms Memória: 0.007 MB / 11.07 MB Application: Finish JAccess::getAssetRules New (com_content.article.1344)

Tempo: 23.06 ms / 177.85 ms Memória: 0.784 MB / 11.86 MB Application: beforeRenderModule mod_custom (JA Tabs)

Tempo: 1.50 ms / 179.35 ms Memória: 0.049 MB / 11.91 MB Application: afterRenderModule mod_custom (JA Tabs)

Tempo: 0.04 ms / 179.40 ms Memória: 0.000 MB / 11.90 MB Application: beforeRenderModule mod_banners (ciben-adv2)

Tempo: 4.46 ms / 183.86 ms Memória: 0.185 MB / 12.09 MB Application: afterRenderModule mod_banners (ciben-adv2)

Tempo: 0.04 ms / 183.90 ms Memória: 0.000 MB / 12.09 MB Application: beforeRenderModule mod_banners (Adv3)

Tempo: 2.93 ms / 186.83 ms Memória: 0.106 MB / 12.19 MB Application: afterRenderModule mod_banners (Adv3)

Tempo: 46.57 ms / 233.40 ms Memória: 0.257 MB / 12.45 MB Application: afterRenderComponent com_content

Tempo: 2.73 ms / 236.13 ms Memória: 0.167 MB / 12.62 MB Application: afterDispatch

Tempo: 5.60 ms / 241.73 ms Memória: 0.175 MB / 12.79 MB Application: beforeRenderModule mod_custom (Footer Social )

Tempo: 0.34 ms / 242.07 ms Memória: 0.004 MB / 12.80 MB Application: afterRenderModule mod_custom (Footer Social )

Tempo: 0.06 ms / 242.13 ms Memória: 0.000 MB / 12.80 MB Application: beforeRenderModule mod_custom (Logo Footer)

Tempo: 0.28 ms / 242.42 ms Memória: 0.003 MB / 12.80 MB Application: afterRenderModule mod_custom (Logo Footer)

Tempo: 0.06 ms / 242.48 ms Memória: 0.000 MB / 12.80 MB Application: beforeRenderModule mod_menu (Mídia)

Tempo: 1.87 ms / 244.34 ms Memória: 0.037 MB / 12.84 MB Application: afterRenderModule mod_menu (Mídia)

Tempo: 0.07 ms / 244.41 ms Memória: 0.000 MB / 12.83 MB Application: beforeRenderModule mod_menu (Quem somos)

Tempo: 2.80 ms / 247.21 ms Memória: 0.030 MB / 12.86 MB Application: afterRenderModule mod_menu (Quem somos)

Tempo: 0.07 ms / 247.28 ms Memória: 0.000 MB / 12.86 MB Application: beforeRenderModule mod_search (Search)

Tempo: 1.17 ms / 248.45 ms Memória: 0.015 MB / 12.88 MB Application: afterRenderModule mod_search (Search)

Tempo: 0.06 ms / 248.51 ms Memória: 0.000 MB / 12.87 MB Application: beforeRenderModule mod_login (Login)

Tempo: 4.93 ms / 253.44 ms Memória: 0.260 MB / 13.13 MB Application: afterRenderModule mod_login (Login)

Tempo: 0.07 ms / 253.51 ms Memória: 0.000 MB / 13.13 MB Application: beforeRenderModule mod_custom (Social )

Tempo: 0.35 ms / 253.86 ms Memória: 0.003 MB / 13.13 MB Application: afterRenderModule mod_custom (Social )

Tempo: 0.07 ms / 253.93 ms Memória: 0.001 MB / 13.13 MB Application: beforeRenderModule mod_janewsticker (JA News Ticker - Ultimas)

Tempo: 11.03 ms / 264.96 ms Memória: 0.140 MB / 13.27 MB Application: afterRenderModule mod_janewsticker (JA News Ticker - Ultimas)

Tempo: 16.47 ms / 281.43 ms Memória: 0.624 MB / 13.90 MB Application: beforeRenderModule mod_articles_category (Mais lidos)

Tempo: 16.44 ms / 297.87 ms Memória: 0.277 MB / 14.18 MB Application: afterRenderModule mod_articles_category (Mais lidos)

Tempo: 0.07 ms / 297.94 ms Memória: 0.000 MB / 14.08 MB Application: beforeRenderModule mod_articles_category (Últimos)

Tempo: 10.42 ms / 308.36 ms Memória: 0.181 MB / 14.26 MB Application: afterRenderModule mod_articles_category (Últimos)

Tempo: 1.21 ms / 309.57 ms Memória: 0.000 MB / 14.14 MB Application: afterRender

Total de consultas ao banco de dados: 92.74 ms

Memória Utilizada

Consultas ao banco

66 Queries Registradas 92.74 ms

4 duplicatas encontradas!

2 duplicadas: #25 #60

2 duplicadas: #33 #35

Tempo da consulta: 0.38 ms Memória de consulta: 0.022 MB de memória antes da consulta: 2.528 MB Linhas retornadas: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'fb5668672450abafcff35e33a2b85b9c'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	766	const	1

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Igual à chamada na linha abaixo.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
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: 0.31 ms Após última consulta: 2.65 ms Memória de consulta: 0.003 MB de memória antes da consulta: 2.655 MB

DELETE 

  FROM `jos_session`

  WHERE `time` < '1769998123'

Explicar

EXPLAIN não é possível na consulta: DELETE FROM `jos_session` WHERE `time` < '1769998123'

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.05 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
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: 0.28 ms Após última consulta: 0.09 ms Memória de consulta: 0.019 MB de memória antes da consulta: 2.660 MB Linhas retornadas: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'fb5668672450abafcff35e33a2b85b9c' 
  LIMIT 1

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 0.82 ms Após última consulta: 0.09 ms Memória de consulta: 0.003 MB de memória antes da consulta: 2.665 MB

INSERT INTO `jos_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('fb5668672450abafcff35e33a2b85b9c', 0, 1, '1769999023', 0, '')

Explicar

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

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.46 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 0.57 ms Após última consulta: 2.87 ms Memória de consulta: 0.023 MB de memória antes da consulta: 2.839 MB Linhas retornadas: 36

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

  FROM `jos_extensions`

  WHERE `type` = 'component'

Explicar

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

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	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.47 ms Após última consulta: 1.91 ms Memória de consulta: 0.021 MB de memória antes da consulta: 2.976 MB Linhas retornadas: 1

SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Perfil

Status	Duration
Starting	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.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.29 ms Após última consulta: 0.72 ms Memória de consulta: 0.021 MB de memória antes da consulta: 3.021 MB Linhas retornadas: 4

SELECT id, rules

  FROM `jos_viewlevels`

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 0.89 ms Após última consulta: 0.09 ms Memória de consulta: 0.023 MB de memória antes da consulta: 3.029 MB Linhas retornadas: 60

SELECT folder AS type, element AS name, params

  FROM jos_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	jos_extensions	ALL	extension	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	186	Using where; Usando filesort

Perfil

Status	Duration
Starting	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.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.48 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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: 2.08 ms Após última consulta: 33.06 ms Memória de consulta: 0.197 MB de memória antes da consulta: 5.559 MB Linhas retornadas: 155

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

  LEFT JOIN jos_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	ALL	idx_client_id_parent_id_alias_language	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	225	Using where; Usando filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	minis_portal.m.component_id	1	Using where

Perfil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.53 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/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.98 ms Após última consulta: 13.06 ms Memória de consulta: 0.021 MB de memória antes da consulta: 6.856 MB Linhas retornadas: 0

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

  FROM jos_categories as c

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

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

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

  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	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	14	Using index condition; Using where; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.18 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.18 ms
Optimizing	0.08 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.13 ms
Preparing	0.04 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 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/libraries/legacy/categories/categories.php:309
11	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
10	JCategories->get()	JROOT/components/com_content/router.php:341
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
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.29 ms Após última consulta: 0.07 ms Memória de consulta: 0.021 MB de memória antes da consulta: 6.859 MB Linhas retornadas: 1

SELECT `alias`,`catid`

  FROM `jos_content`

  WHERE `id` = 1344

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
10	JDatabaseDriver->loadObject()	JROOT/components/com_content/router.php:357
9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
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.53 ms Após última consulta: 0.16 ms Memória de consulta: 0.038 MB de memória antes da consulta: 6.847 MB Linhas retornadas: 11

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	minis_portal.e.element	1	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/libraries/cms/application/site.php:484
10	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	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.37 ms Após última consulta: 5.70 ms Memória de consulta: 0.022 MB de memória antes da consulta: 7.145 MB Linhas retornadas: 1

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

  FROM `jos_extensions`

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

Explicar

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

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	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: 0.76 ms Após última consulta: 0.15 ms Memória de consulta: 0.005 MB de memória antes da consulta: 7.135 MB

UPDATE `jos_extensions`

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

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

Explicar

EXPLAIN não é possível na consulta: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"e540760bf16e5d178e50d8127f334cee\"}' 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.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.06 ms
Updating	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.40 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.39 ms Após última consulta: 2.39 ms Memória de consulta: 0.019 MB de memória antes da consulta: 7.289 MB Linhas retornadas: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.84 ms Após última consulta: 6.58 ms Memória de consulta: 0.027 MB de memória antes da consulta: 7.708 MB Linhas retornadas: 8

SHOW FULL COLUMNS 
  FROM `jos_assets`

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.10 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.30 ms Após última consulta: 0.67 ms Memória de consulta: 0.025 MB de memória antes da consulta: 7.744 MB Linhas retornadas: 1

SELECT *

  FROM jos_assets

  WHERE `id` = '1'

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 0.11 ms Memória de consulta: 0.023 MB de memória antes da consulta: 7.751 MB Linhas retornadas: 1

SELECT a.rules

  FROM jos_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
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.45 ms Após última consulta: 0.67 ms Memória de consulta: 0.025 MB de memória antes da consulta: 7.780 MB Linhas retornadas: 36

SELECT element

  FROM jos_extensions

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

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.14 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.85 ms Após última consulta: 0.17 ms Memória de consulta: 0.026 MB de memória antes da consulta: 7.794 MB Linhas retornadas: 36

SELECT a.name, a.rules

  FROM jos_assets AS a

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	37	Using index condition

Perfil

Status	Duration
Starting	0.09 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.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.34 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.93 ms Após última consulta: 1.96 ms Memória de consulta: 0.031 MB de memória antes da consulta: 8.076 MB Linhas retornadas: 30

SHOW FULL COLUMNS 
  FROM `jos_content`

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.15 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/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/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.40 ms Após última consulta: 3.39 ms Memória de consulta: 0.022 MB de memória antes da consulta: 8.587 MB Linhas retornadas: 1

SELECT *

  FROM jos_content

  WHERE `id` = '1344'

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.15 ms Memória de consulta: 0.005 MB de memória antes da consulta: 8.596 MB

UPDATE jos_content

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

  WHERE `id` = '1344'

Explicar

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

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.04 ms
Updating	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.28 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.24 ms Após última consulta: 1.71 ms Memória de consulta: 0.023 MB de memória antes da consulta: 8.703 MB Linhas retornadas: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM jos_content AS a

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

  LEFT JOIN jos_users AS u 
  on u.id = a.created_by

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

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 1344 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43') 
  AND (a.state = 1 OR a.state =2)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	13	Using index condition; Using where; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.06 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Statistics	0.15 ms
Preparing	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 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_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 3.37 ms Após última consulta: 1.78 ms Memória de consulta: 0.024 MB de memória antes da consulta: 8.799 MB Linhas retornadas: 3

Consultas duplicadas: #60

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

  FROM jos_categories as c

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

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

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

  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	ALL	cat_idx,idx_access,idx_left_right	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	165	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	minis_portal.c.id	10	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	14	Using index condition; Using temporary; Usando filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	165	Using where; Using index; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.16 ms
Optimizing	0.06 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Statistics	0.16 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.08 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	1.05 ms
Creating sort index	0.04 ms
Removing tmp table	0.01 ms
Creating sort index	0.88 ms
Creating sort index	0.09 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	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/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.63 ms Após última consulta: 0.90 ms Memória de consulta: 0.022 MB de memória antes da consulta: 8.825 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1344 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.09 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/libraries/cms/helper/tags.php:435
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.37 ms Após última consulta: 5.93 ms Memória de consulta: 0.023 MB de memória antes da consulta: 9.158 MB Linhas retornadas: 1

SELECT MAX(contact.id) AS contactid

  FROM `jos_contact_details` AS `contact`

  WHERE contact.published = 1 
  AND contact.user_id = 957

Explicar

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

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/plugins/content/contact/contact.php:110
14	PlgContentContact->getContactId()	JROOT/plugins/content/contact/contact.php:60
13	PlgContentContact->onContentPrepare()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:161
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 3.29 ms Após última consulta: 0.24 ms Memória de consulta: 0.111 MB de memória antes da consulta: 9.168 MB Linhas retornadas: 1418

SELECT a.id, a.parent_id

  FROM jos_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Explicar

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

Perfil

Status	Duration
Starting	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.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	2.77 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
17	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 3.41 ms Após última consulta: 2.87 ms Memória de consulta: 0.333 MB de memória antes da consulta: 9.995 MB Linhas retornadas: 1418

SELECT a.id, a.name, a.rules

  FROM jos_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Explicar

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

Perfil

Status	Duration
Starting	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.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	3.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
18	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
17	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 3.46 ms Após última consulta: 4.86 ms Memória de consulta: 0.081 MB de memória antes da consulta: 11.082 MB Linhas retornadas: 219

SELECT a.id, a.title, a.catid, a.language, 
  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 jos_content AS a

  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 80 
  AND a.state = 1 
  AND a.access IN (1,1)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-02-02 02:23:43') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-02-02 02:23:43')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	234	Using where; Usando filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.08 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	2.82 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/plugins/content/pagenavigation/pagenavigation.php:152
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:167
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 3.02 ms Após última consulta: 5.76 ms Memória de consulta: 0.074 MB de memória antes da consulta: 11.428 MB Linhas retornadas: 219

SELECT a.id,a.title, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM jos_content AS a

  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 80 
  AND a.state = 1 
  AND a.access = 1 
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-02-02 02:23:43') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-02-02 02:23:43')

  ORDER BY a.created DESC

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	234	Using where; Usando filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Perfil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	2.44 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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/templates/ja_magz/templateHelper.php:187
14	MagzHelper::getNav()	JROOT/templates/ja_magz/html/com_content/article/default.php:51
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.02 ms Após última consulta: 7.52 ms Memória de consulta: 0.051 MB de memória antes da consulta: 11.817 MB Linhas retornadas: 52

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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 <= '2026-02-02 02:23:43') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-02 02:23:43') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 545 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	ALL	PRIMARY,published,newsfeeds	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	101	Using where; Usando filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	minis_portal.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	minis_portal.m.id	4	Using where; Using index

Perfil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.07 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.43 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cache/controller/callback.php:152
21	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:446
20	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:382
19	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:84
18	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
17	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:640
16	T3Template->countModules()	JROOT/templates/ja_magz/html/com_content/article/default_text.php:52
15	include JROOT/templates/ja_magz/html/com_content/article/default_text.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:270
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.37 ms Após última consulta: 3.94 ms Memória de consulta: 0.028 MB de memória antes da consulta: 11.978 MB Linhas retornadas: 0

Consultas duplicadas: #35

SELECT *

  FROM jos_banners

  WHERE '2026-02-02 02:23:43' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

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

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
20	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
18	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
17	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
16	JDocumentRendererHtmlModules->render()	JROOT/templates/ja_magz/html/com_content/article/default_text.php:161
15	include JROOT/templates/ja_magz/html/com_content/article/default_text.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:270
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.54 ms Após última consulta: 1.75 ms Memória de consulta: 0.028 MB de memória antes da consulta: 12.096 MB Linhas retornadas: 0

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM jos_banners as a

  LEFT JOIN jos_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (98)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 5

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where; Usando filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	minis_portal.a.cid	1

Perfil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
23	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
22	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:205
21	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
20	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
18	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
17	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
16	JDocumentRendererHtmlModules->render()	JROOT/templates/ja_magz/html/com_content/article/default_text.php:161
15	include JROOT/templates/ja_magz/html/com_content/article/default_text.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:270
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.33 ms Após última consulta: 0.80 ms Memória de consulta: 0.027 MB de memória antes da consulta: 12.108 MB Linhas retornadas: 0

Consultas duplicadas: #33

SELECT *

  FROM jos_banners

  WHERE '2026-02-02 02:23:43' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

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

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
20	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
18	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
17	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
16	JDocumentRendererHtmlModules->render()	JROOT/templates/ja_magz/html/com_content/article/default_text.php:161
15	include JROOT/templates/ja_magz/html/com_content/article/default_text.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:270
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.52 ms Após última consulta: 0.19 ms Memória de consulta: 0.028 MB de memória antes da consulta: 12.124 MB Linhas retornadas: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM jos_banners as a

  LEFT JOIN jos_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (90)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	Using where; Usando filesort
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	minis_portal.a.cid	1

Perfil

Status	Duration
Starting	0.09 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.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
23	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
22	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:205
21	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
20	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
18	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
17	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
16	JDocumentRendererHtmlModules->render()	JROOT/templates/ja_magz/html/com_content/article/default_text.php:161
15	include JROOT/templates/ja_magz/html/com_content/article/default_text.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:270
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.19 ms Memória de consulta: 0.011 MB de memória antes da consulta: 12.141 MB

UPDATE jos_banners

  SET impmade = (impmade + 1)

  WHERE id IN (6)

Explicar

EXPLAIN não é possível na consulta: UPDATE jos_banners SET impmade = (impmade + 1) WHERE id IN (6)

Perfil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.04 ms
Updating	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.42 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
22	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:246
21	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
20	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
19	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
18	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
17	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
16	JDocumentRendererHtmlModules->render()	JROOT/templates/ja_magz/html/com_content/article/default_text.php:161
15	include JROOT/templates/ja_magz/html/com_content/article/default_text.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:270
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 4.01 ms Após última consulta: 2.64 ms Memória de consulta: 0.085 MB de memória antes da consulta: 12.270 MB Linhas retornadas: 12

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM jos_content AS a

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

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

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

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

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.id NOT IN (1344) 
  AND a.catid IN (80) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43')

  ORDER BY  a.created  DESC 
  LIMIT 12

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	PRIMARY,idx_access,idx_catid	idx_catid	4	const	234	Using index condition; Using where; Usando filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	minis_portal.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	minis_portal.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	minis_portal.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	14	Using index condition; Using where; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.26 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.16 ms
Optimizing	0.09 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.15 ms
Preparing	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	1.38 ms
Executing	0.01 ms
Sending data	0.15 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	0.12 ms
Executing	0.01 ms
Sending data	0.12 ms
Executing	0.01 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.11 ms
Executing	0.01 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 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/legacy/model/legacy.php:310
18	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
17	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.58 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.405 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1365 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.53 ms Após última consulta: 0.25 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.424 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1363 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.49 ms Após última consulta: 0.25 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.442 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1362 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	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.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.50 ms Após última consulta: 0.27 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.461 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1361 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.52 ms Após última consulta: 0.24 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.480 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1360 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.49 ms Após última consulta: 0.23 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.499 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1357 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.48 ms Após última consulta: 0.25 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.517 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1353 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	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.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.50 ms Após última consulta: 0.26 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.536 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1352 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.52 ms Após última consulta: 0.24 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.555 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1347 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.50 ms Após última consulta: 0.26 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.574 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1342 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.48 ms Após última consulta: 0.24 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.592 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1341 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.49 ms Após última consulta: 0.27 ms Memória de consulta: 0.025 MB de memória antes da consulta: 12.611 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1337 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
17	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
16	ContentModelArticles->getItems()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:58
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 21.77 ms Após última consulta: 1.40 ms Memória de consulta: 0.026 MB de memória antes da consulta: 12.702 MB Linhas retornadas: 1

SELECT COUNT(*)

  FROM jos_content AS a

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

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

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

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

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.id NOT IN (1344) 
  AND a.catid IN (80) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	PRIMARY,idx_access,idx_catid	idx_catid	4	const	234	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	14	Using index condition; Using where; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.11 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.00 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.11 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.00 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.12 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.00 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.13 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.00 ms
Sending data	0.11 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.00 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.00 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
19	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
18	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
17	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
16	JModelList->getPagination()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:62
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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.31 ms Após última consulta: 7.54 ms Memória de consulta: 0.027 MB de memória antes da consulta: 12.771 MB Linhas retornadas: 1

SELECT alias

  FROM jos_content

  WHERE id=1344

Explicar

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

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
22	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
21	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
20	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
19	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
18	JRouter->build()	JROOT/libraries/cms/router/site.php:147
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/templates/ja_magz/html/com_content/article/default_related.php:104
15	include JROOT/templates/ja_magz/html/com_content/article/default_related.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/templates/ja_magz/html/com_content/article/default.php:384
13	include JROOT/templates/ja_magz/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_content/views/article/view.html.php:178
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.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: 5.99 ms Após última consulta: 22.65 ms Memória de consulta: 0.057 MB de memória antes da consulta: 13.237 MB Linhas retornadas: 5

SELECT a.*,cc.alias AS category_alias, cc.description as catdesc, cc.title as cattitle, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":",cc.id,cc.alias) ELSE cc.id END as catslug
 
  FROM jos_content AS a 
  INNER JOIN jos_categories AS cc 
  ON cc.id = a.catid
 
  WHERE a.state = 1
 
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43' )
 
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43' ) 
  AND a.access IN (1,1) 
  AND cc.id IN('79','80','81','82','83','84','92') 
  ORDER BY  a.created DESC 
  LIMIT 5

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	range	PRIMARY	PRIMARY	4	NULL	7	Using where; Using temporary; Usando filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	minis_portal.cc.id	18	Using index condition; Using where

Perfil

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.06 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	4.25 ms
Creating sort index	0.72 ms
Removing tmp table	0.18 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 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/modules/mod_janewsticker/jast_articles.php:111
13	JAStArticles->getListArticles()	JROOT/modules/mod_janewsticker/helper.php:259
12	modjanewstickerHelper::getArticles()	JROOT/modules/mod_janewsticker/helper.php:76
11	modjanewstickerHelper::getList()	JROOT/modules/mod_janewsticker/mod_janewsticker.php:50
10	include JROOT/modules/mod_janewsticker/mod_janewsticker.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
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: 4.24 ms Após última consulta: 21.39 ms Memória de consulta: 0.045 MB de memória antes da consulta: 14.022 MB Linhas retornadas: 5

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM jos_content AS a

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

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

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

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

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (79,80,81,82,83,84) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43')

  ORDER BY a.hits DESC 
  LIMIT 5

Explicar

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

Perfil

Status	Duration
Starting	0.29 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.18 ms
Optimizing	0.10 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Statistics	0.15 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.11 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1.62 ms
Executing	0.01 ms
Sending data	1.07 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
19	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
18	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.64 ms Após última consulta: 0.55 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.088 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 176 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.50 ms Após última consulta: 0.43 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.106 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 919 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.48 ms Após última consulta: 0.26 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.125 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 928 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.51 ms Após última consulta: 0.23 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.143 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 193 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.06 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.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.50 ms Após última consulta: 0.23 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.162 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 208 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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: 3.43 ms Após última consulta: 2.19 ms Memória de consulta: 0.026 MB de memória antes da consulta: 14.197 MB Linhas retornadas: 3

Consultas duplicadas: #25

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

  FROM jos_categories as c

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

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

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

  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	ALL	cat_idx,idx_access,idx_left_right	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	165	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	minis_portal.c.id	10	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	14	Using index condition; Using temporary; Usando filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	165	Using where; Using index; Using join buffer (flat, BNL join)

Perfil

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.17 ms
Optimizing	0.06 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.17 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.09 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	1.06 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.90 ms
Creating sort index	0.09 ms
Removing tmp table	0.12 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
15	JCategories->get()	JROOT/templates/ja_magz/html/mod_articles_category/tab.php:206
14	require JROOT/templates/ja_magz/html/mod_articles_category/tab.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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: 4.29 ms Após última consulta: 1.15 ms Memória de consulta: 0.045 MB de memória antes da consulta: 14.135 MB Linhas retornadas: 5

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM jos_content AS a

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

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

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

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

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (79,80,81,82,83,84) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-02 02:23:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-02 02:23:43')

  ORDER BY a.title ASC 
  LIMIT 5

Explicar

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

Perfil

Status	Duration
Starting	0.27 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.14 ms
Optimizing	0.09 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Statistics	0.14 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.11 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.11 ms
Creating sort index	1.76 ms
Executing	0.01 ms
Sending data	1.05 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
19	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
18	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.55 ms Após última consulta: 0.30 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.206 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1236 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.49 ms Após última consulta: 0.25 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.225 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 395 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	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.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.49 ms Após última consulta: 0.25 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.244 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 778 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.49 ms Após última consulta: 0.23 ms Memória de consulta: 0.030 MB de memória antes da consulta: 14.272 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 872 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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.48 ms Após última consulta: 0.23 ms Memória de consulta: 0.025 MB de memória antes da consulta: 14.296 MB Linhas retornadas: 0

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

  FROM `jos_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 915 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	minis_portal.t.id	2	Using index condition; Using where

Perfil

Status	Duration
Starting	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.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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/cms/helper/tags.php:435
18	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:209
16	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:568
14	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
13	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
12	JModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
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]

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

SELECT Tables:

23 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jos_contentitem_tag_map` AS m  
  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

3 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

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

2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM jos_banners as a 
  LEFT JOIN jos_banner_clients AS cl 
  ON cl.id = a.cid

```
2 × SELECT * 
  FROM jos_banners
```

1 × SELECT `data` 
  FROM `jos_session`

```
1 × SELECT alias 
  FROM jos_content
```

1 × SELECT COUNT(*) 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT a.id,a.title, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid

1 × SELECT a.id, a.title, a.catid, a.language, 
  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 jos_content AS a 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid

1 × SELECT a.id, a.name, a.rules 
  FROM jos_assets AS a

1 × SELECT a.id, a.parent_id 
  FROM jos_assets AS a

1 × SELECT MAX(contact.id) AS contactid 
  FROM `jos_contact_details` AS `contact`

```
1 × SELECT * 
  FROM jos_content
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jos_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `session_id` 
  FROM `jos_session`

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

1 × SELECT element 
  FROM jos_extensions

1 × SELECT a.rules 
  FROM jos_assets AS a

```
1 × SELECT * 
  FROM jos_assets
```
```
1 × SELECT * 
  FROM jos_languages
```

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

1 × SELECT `alias`,`catid` 
  FROM `jos_content`

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

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

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

1 × SELECT a.*,cc.alias AS category_alias, cc.description as catdesc, cc.title as cattitle, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":",cc.id,cc.alias) ELSE cc.id END as catslug  
  FROM jos_content AS a 
  INNER JOIN jos_categories AS cc 
  ON cc.id = a.catid

Outras Tabelas:

```
1 × DELETE  
  FROM `jos_session`
```

1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('fb5668672450abafcff35e33a2b85b9c', 0, 1, '1769999023', 0, ''

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"e540760bf16e5d178e50d8127f334cee\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_assets

1 × SHOW FULL COLUMNS 
  FROM `jos_content

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

1 × UPDATE jos_banners 
  SET impmade = (impmade + 1)

Notícias

Pr. Acyr de Gerone | Como viver as promessas de Deus - Culto de Adoração

Mais lidos

Últimos

Inagurada Catedral da AD Fama na cidade de Inhumas

O que é ser igreja?

Amizades que te levam ao céu

Seminário de Jovens 2014

79 anos do Pastor Abigail

Console de depuração do Joomla!

Sessão

Informação do perfil

Tempo

Memória

Memória Utilizada

Consultas ao banco

66 Queries Registradas 92.74 ms

4 duplicatas encontradas!

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

SELECT Tables:

Outras Tabelas:

Login

Notícias

Mais lidos

Últimos

Veja também:

Console de depuração do Joomla!

Sessão

Informação do perfil

Tempo

Memória

Memória Utilizada

Consultas ao banco

66 Queries Registradas 92.74 ms

4 duplicatas encontradas!

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

SELECT Tables:

Outras Tabelas: