PJá faz algum tempo que vemos a sigla SaaS associada a vários softwares que utilizamos no nosso dia a dia. Em muitos outros casos, usamos soluções sem nos darmos conta que seja SaaS. Mas afinal, o que essa sigla quer dizer?

Quais as vantagens de uma solução SaaS?

: MaxProcess; 28 Junho 2021

Já faz algum tempo que vemos a sigla SaaS associada a vários softwares que utilizamos no nosso dia a dia. E ainda há soluções que usamos sem nos darmos conta que seja SaaS. Mas afinal, o que essa sigla quer dizer?

1. Conhecendo o SaaS

SaaS (Software as a Service) é um modelo de negócio no qual você utiliza um software hospedado em um computador remoto, de modo que o software é disponibilizado como um serviço e não como um produto. Atualmente, o termo é frequentemente utilizado no lugar de cloud computing e vice-versa.

Embora esteja associado à computação em nuvem, SaaS não é sinônimo exato de cloud computing, pois corresponde a uma das modalidades da cloud.

No modelo SaaS, os usuários se conectam aos softwares na nuvem por meio da Internet a partir de qualquer local e qualquer device (computador, notebook ou smartphone). Não é preciso fazer o download e instalação do software. Basta realizar o login e você já pode utilizar o software como um serviço. O gerenciamento de hardware e software é de responsabilidade do fornecedor da solução SaaS.

A última década assistiu a uma explosão de soluções em SaaS. A Netflix, o Spotify, o WhatsApp, a Amazon Prime, o Gmail e o Yahoo Mail são alguns exemplos famosos de softwares como serviço. Não se surpreenda se dissermos que SaaS não é um conceito novo. Isso mesmo! O termo surgiu na década de 60 e apenas se popularizou no início dos anos 2000.

O serviço pode ser gratuito ou não. Quando comercializado, geralmente o modelo de negócio assume um plano mensal ou anual a ser feito pelo usuário. O pagamento é realizado conforme o uso, por exemplo, em mensalidades enquanto o usuário tiver interesse em utilizar o serviço.

Softwares como serviço podem ser contratados de modo individual, como a sua assinatura da Netflix ou do Spotify, ou de modo coletivo, para todos os empregados de uma organização.

2. Saas x Modelo Tradicional

E quais são as diferenças entre SaaS e o modelo tradicional de oferta de software?

1. Instalação e Manutenção
Primeiramente, na modalidade SaaS, você não precisa instalar o software em um computador, pois o software é executado na nuvem. As atualizações e as manutenções são realizadas na nuvem, sem que o usuário se preocupe com isso. O provedor SaaS garante a infraestrutura necessária para a solução como a base de dados, os servidores de aplicações, os softwares dos aplicativos, as rotinas de backup e as atualizações de versões.

No modelo tradicional, toda a infraestrutura é de responsabilidade do cliente que adquiriu o software, sendo considerado um software para cada computador. O usuário deve ainda garantir que o computador tenha configuração compatível com os requisitos do software. Depois, é de responsabilidade do usuário realizar a sua instalação, aceitar as atualizações e implementá-las.

2. Aquisição e Pagamento
O modelo SaaS adota um pagamento recorrente, sendo comum um período inicial gratuito como demonstração. Já o modelo tradicional considera o pagamento do software em uma única vez com o valor fixo no momento da compra e que antecede o seu envio ao usuário.

3. Acesso
O software como SaaS pode ser acessado de qualquer lugar usando um dos dispositivos (computador desktop, notebook, tablet ou smartphone). Também permite que múltiplos usuários acessem o sistema ao mesmo tempo. Por outro lado, o software tradicional é utilizado apenas a partir do local onde ele foi instalado e permite acesso de um ou poucos usuários, dado que utilizam o mesmo dispositivo.

4. Segurança
Por fim, mas não menos importante está o aspecto de segurança. O SaaS é um modelo seguro, cuja proteção a ataques, falhas e desastres é garantida pelo provedor SaaS juntamente com o provedor da computação em nuvem. O modelo tradicional implica que o usuário, responsável pelo ambiente de instalação do software, também se responsabilize pelos sistemas de proteção de dados e rotinas de backup. Para saber mais sobre esse aspecto, veja também nosso artigo sobre Segurança de Dados em Cloud Computing.

3. O que está incluído no SaaS?

Também chamado de cloud computing, o SaaS é uma das 3 principais categorias da computação em nuvem, sendo as outras duas o IaaS e o PaaS. Vamos nos familiarizar com essas siglas?

IaaS

IaaS (Infraestruture as a Service) é primeiro tipo de serviço de computação em nuvem que entrega recursos de computação, de rede e de armazenamento sob demanda, sendo pagos conforme o uso.

No IaaS estão incluídos o ambiente de datacenter, a rede de segurança e proteção de dados e os servidores e base de dados. O redimensionamento de recursos em escala vertical (maior capacidade por máquina) ou horizontal (mais máquinas) é facilmente aplicada pelo provedor da solução.

PaaS

PaaS (Plataform as a Service) é segundo tipo de serviço cloud que oferece um ambiente de desenvolvimento e implantação em nuvem para você desenvolver aplicativos simples ou sofisticados também em nuvem.

O provedor PaaS também fornece a infraestrutura subjacente, ou seja, o IaaS com servidores, rede e armazenamento e acrescenta ferramentas de desenvolvimento, sistemas de gerenciamento de banco de dados, Business Intelligence (BI), fluxo de trabalho, diretórios, segurança e agendamento.

Com isso, todo o ciclo de vida do aplicativo web é considerado, o que inclui compilação, teste, implantação, gerenciamento e atualização. Os recursos são solicitados conforme a demanda ao provedor de serviços e o valor de pagamento é calculado de acordo com o uso.

SaaS

SaaS (Software as a Service), o terceiro tipo de serviço cloud, é a oferta de softwares e aplicativos pela internet, como um serviço em nuvem, como detalhamos anteriormente. No SaaS estão presentes os componentes do PaaS e IaaS, como podemos ver na imagem a seguir.

4. Vantagens do SaaS

Uma das grandes vantagens do SaaS é a imensa flexibilidade tanto para usuários quanto para provedores de serviços em SaaS. Há quem diga que não demora muito tempo para que esse modelo de negócio seja adotado por praticamente todas as empresas que almejam uma abrangência global da sua operação.

Vamos descobrir os motivos para o SaaS estar em amplo crescimento?

A. Rápida Implantação

A primeira vantagem a ser mencionada é a rapidez da implantação. O usuário ou empresa contratante não precisa se preocupar com o ambiente do sistema, com aquisições de infraestrutura ou contratação de pessoal necessário para implantar e gerenciar o software. Tudo isso está incluso no SaaS e a primeira utilização pode ser feita, em muitos casos, imediatamente.

B. Custo

Em muitos cenários, o custo é o que torna o SaaS como modelo de negócio insuperável. Não é preciso o investimento inicial de implantação, nem os custos com pessoal e infraestrutura para mantê-lo.

O SaaS é bem mais flexível para se encaixar no orçamento anual. Você paga por aquilo que utilizar e o provedor do serviço aloca os recursos em escala horizontal ou vertical de acordo com o nível de uso.

Por esses motivos, o SaaS conseguiu levar às organizações softwares cuja implantação em outra modalidade seria impraticável. Em outras palavras, é um modelo acessível a todas as empresas, não importando se são pequenas ou grandes e nem a sua capacidade de investimento.

C. Cloud Computing

Outra grande vantagem do SaaS é ser justamente um serviço em cloud computing garantindo que qualquer usuário pode acessar de onde estiver, a partir de computadores, tablets ou smartphones com conexão à internet.

O desenvolvimento de aplicativos e a sua compatibilidade com a diversidade de computadores e outros dispositivos não é um problema do usuário, pois cabe ao provedor SaaS pensar nesses aspectos.

Além disso, você não precisa de especialistas para gerenciar problemas de segurança inerentes na computação móvel, pois o provedor de serviço garantirá a segurança de seus dados.

5. Gestão de Serviços em SaaS

Finalmente queremos conversar sobre soluções de gestão de serviços em campo e vendas externas ofertadas como SaaS.

Os softwares de Field Service Management (FSM) e Field Sales Management agregam os benefícios de ser um serviço SaaS com todas as vantagens de um gerenciamento de serviços em campo. A implantação é rápida, a um custo extremamente acessível e com toda a flexibilidade de expansão como é próprio de uma solução em cloud.

E as funcionalidades dos sistemas de gestão estão disponíveis para customização por cliente, como automatização das atividades rotineiras como escalas de trabalho, priorização e planejamento de serviços e visitas, roteirização, georreferenciamento de serviços e equipes, monitoramento em tempo real e análise de resultados com Business Intelligence.

Quer saber mais sobre gestão de vendas e serviços em campo na modalidade SaaS? Conheça os sistemas MaxSales e MaxService.

Não deixe de visitar também o nosso blog.

Segurança de Dados em Cloud Computing

Smartphone e Controle de Jornada

MaxField

Menu Navegação

Últimos Posts

Como impulsionar as vendas externas?

Como fazer supervisão em campo?

Saneamento - Qualidade da Água

Quais as vantagens de uma solução SaaS?

Newsletter Subscribe

Sistema MaxField

A plataforma MaxField disponibiliza soluções fim a fim para Field Sales e Field Service, com funcionalidades de despacho, agenda e gerenciamento on-line de visitas e serviços em campo.

Console de depuração do Joomla!

Sessão

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713517709,
                "last": 1713517709,
                "now": 1713517709
            },
            "token": "7ijtOQglPAIILzfYjm30RImKttCCArfc"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "pt-BR"
        }
    }
}

Informação do perfil

Hora

Memória

Hora: 103.81 ms / 103.81 ms Memória: 2.090 MB / 2.47 MB Application: afterLoad

Hora: 413.44 ms / 517.25 ms Memória: 6.120 MB / 8.59 MB Application: afterInitialise

Hora: 143.25 ms / 660.50 ms Memória: 3.077 MB / 11.66 MB Application: afterRoute

Hora: 26.52 ms / 687.02 ms Memória: 1.059 MB / 12.72 MB Application: beforeRenderComponent com_content

Hora: 21.79 ms / 708.80 ms Memória: 0.397 MB / 13.12 MB Application: Before Access::preloadComponents (all components)

Hora: 8.86 ms / 717.67 ms Memória: 0.064 MB / 13.18 MB Application: After Access::preloadComponents (all components)

Hora: 0.04 ms / 717.71 ms Memória: -0.003 MB / 13.18 MB Application: Before Access::preloadPermissions (com_content)

Hora: 5.85 ms / 723.55 ms Memória: 0.102 MB / 13.28 MB Application: After Access::preloadPermissions (com_content)

Hora: 0.04 ms / 723.59 ms Memória: -0.007 MB / 13.27 MB Application: Before Access::getAssetRules (id:354 name:com_content.article.93)

Hora: 2.04 ms / 725.63 ms Memória: 0.039 MB / 13.31 MB Application: After Access::getAssetRules (id:354 name:com_content.article.93)

Hora: 797.04 ms / 1522.68 ms Memória: 11.255 MB / 24.57 MB Application: afterRenderComponent com_content

Hora: 4.59 ms / 1527.27 ms Memória: 0.044 MB / 24.61 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Hora: 0.04 ms / 1527.30 ms Memória: 0.002 MB / 24.61 MB Application: After Access::getAssetRules (id:8 name:com_content)

Hora: 10.34 ms / 1537.64 ms Memória: 0.103 MB / 24.72 MB Application: afterDispatch

Hora: 149.76 ms / 1687.40 ms Memória: 1.176 MB / 25.89 MB Application: beforeRenderModule mod_search (Search)

Hora: 5.71 ms / 1693.11 ms Memória: 0.040 MB / 25.93 MB Application: afterRenderModule mod_search (Search)

Hora: 0.06 ms / 1693.17 ms Memória: -0.004 MB / 25.93 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Hora: 11.03 ms / 1704.20 ms Memória: 0.065 MB / 25.99 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Hora: 0.14 ms / 1704.34 ms Memória: -0.002 MB / 25.99 MB Application: beforeRenderModule mod_jbcookies (mod_jbcookies)

Hora: 12.74 ms / 1717.09 ms Memória: 0.172 MB / 26.16 MB Application: afterRenderModule mod_jbcookies (mod_jbcookies)

Hora: 0.08 ms / 1717.17 ms Memória: -0.015 MB / 26.15 MB Application: beforeRenderModule mod_mylivechat (MyLiveChat)

Hora: 1.92 ms / 1719.09 ms Memória: 0.022 MB / 26.17 MB Application: afterRenderModule mod_mylivechat (MyLiveChat)

Hora: 0.13 ms / 1719.21 ms Memória: 0.002 MB / 26.17 MB Application: beforeRenderModule mod_menu (Menu Navegação)

Hora: 6.95 ms / 1726.16 ms Memória: 0.012 MB / 26.18 MB Application: afterRenderModule mod_menu (Menu Navegação)

Hora: 0.07 ms / 1726.23 ms Memória: -0.009 MB / 26.18 MB Application: beforeRenderModule mod_articles_latest (Últimos Posts)

Hora: 24.95 ms / 1751.18 ms Memória: 0.265 MB / 26.44 MB Application: afterRenderModule mod_articles_latest (Últimos Posts)

Hora: 0.09 ms / 1751.27 ms Memória: -0.131 MB / 26.31 MB Application: beforeRenderModule mod_acym (Newsletter Subscribe)

Hora: 20.41 ms / 1771.69 ms Memória: 0.461 MB / 26.77 MB Application: afterRenderModule mod_acym (Newsletter Subscribe)

Hora: 0.07 ms / 1771.75 ms Memória: -0.017 MB / 26.75 MB Application: beforeRenderModule mod_custom (Sistema MaxField)

Hora: 3.45 ms / 1775.20 ms Memória: 0.007 MB / 26.76 MB Application: afterRenderModule mod_custom (Sistema MaxField)

Hora: 28.62 ms / 1803.82 ms Memória: 0.472 MB / 27.23 MB Application: afterRender

Total de consultas ao banco de dados: 431.04 ms

Memória Utilizada

Consultas ao banco

61 Queries Registradas 431.04 ms

7 duplicatas encontradas!

2 duplicadas: #33 #34

3 duplicadas: #36 #37 #38

2 duplicadas: #42 #43

Tempo da consulta: 8.25 ms Memória de consulta: 0.007 MB de memória antes da consulta: 4.134 MB Linhas retornadas: 0

SELECT `data`

  FROM `hz7r8_session`

  WHERE `session_id` = X'3462336438303439313335316638396664386435653433373434373361396132'

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	5.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	1.96 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Pilha de chamadas

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

[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: 5.82 ms Memória de consulta: 0.004 MB de memória antes da consulta: 4.230 MB Linhas retornadas: 0

SELECT `session_id`

  FROM `hz7r8_session`

  WHERE `session_id` = X'3462336438303439313335316638396664386435653433373434373361396132' 
  LIMIT 1

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tempo da consulta: 5.00 ms Após última consulta: 0.19 ms Memória de consulta: 0.004 MB de memória antes da consulta: 4.235 MB

INSERT INTO `hz7r8_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3462336438303439313335316638396664386435653433373434373361396132', 1, 1713517709, 0, '', 0)

Explicar

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

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.00 ms
update	4.44 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Pilha de chamadas

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

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

Tempo da consulta: 20.56 ms Após última consulta: 10.88 ms Memória de consulta: 0.006 MB de memória antes da consulta: 4.487 MB Linhas retornadas: 41

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

  FROM `hz7r8_extensions`

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

Explicar

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

Perfil

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

Pilha de chamadas

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

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

Tempo da consulta: 6.06 ms Após última consulta: 11.56 ms Memória de consulta: 0.005 MB de memória antes da consulta: 4.682 MB Linhas retornadas: 5

SELECT id, rules

  FROM `hz7r8_viewlevels`

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 5.05 ms Após última consulta: 0.15 ms Memória de consulta: 0.005 MB de memória antes da consulta: 4.694 MB Linhas retornadas: 2

SELECT b.id

  FROM hz7r8_usergroups AS a

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

  WHERE a.id = 9

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 2.02 ms Após última consulta: 1.88 ms Memória de consulta: 0.005 MB de memória antes da consulta: 4.762 MB Linhas retornadas: 121

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

  FROM hz7r8_extensions

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

  ORDER BY ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hz7r8_extensions	NULL	ref	extension	extension	82	const	133	0.60	Using index condition; Using where; Usando filesort

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Igual à chamada na linha abaixo.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 6.36 ms Após última consulta: 100.44 ms Memória de consulta: 0.005 MB de memória antes da consulta: 6.598 MB Linhas retornadas: 3

SELECT *

  FROM hz7r8_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.53 ms Após última consulta: 0.27 ms Memória de consulta: 0.005 MB de memória antes da consulta: 6.610 MB Linhas retornadas: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `hz7r8_extensions`

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

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 21.62 ms Após última consulta: 47.71 ms Memória de consulta: 0.005 MB de memória antes da consulta: 7.498 MB

Update
                        hz7r8_contentbuilder_articles As articles,
                        hz7r8_content As content, 
                        hz7r8_contentbuilder_forms As forms,
                        hz7r8_contentbuilder_registered_users As cbusers,
                        hz7r8_users As users
                    
  Set 
                        content.state = 0
                    
  Where 
                        articles.article_id = content.id
                    
  And
                        content.state = 1
                    
  And
                        articles.form_id = forms.id
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        content.created_by = cbusers.user_id
                    
  And
                      (
                        (
                            users.id = cbusers.user_id
                          
  And
                            users.block = 1
                        )
                      )

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	forms	NULL	ALL	PRIMARY	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	1	100.00	Using where
1	SIMPLE	cbusers	NULL	index	user_id	user_id	16	NULL	1	100.00	Using where; Using index
1	SIMPLE	users	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	maxfield.cbusers.user_id	1	33.33	Using where
1	SIMPLE	articles	NULL	ALL	article_id	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	10	10.00	Using where
1	UPDATE	content	NULL	eq_ref	PRIMARY,idx_state,idx_createdby	PRIMARY	4	maxfield.articles.article_id	1	5.00	Using where

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	20.99 ms
init	0.02 ms
updating main table	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
updating reference tables	0.00 ms
end	0.00 ms
end	0.00 ms
removing tmp table	0.00 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:417
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 3.18 ms Após última consulta: 0.19 ms Memória de consulta: 0.005 MB de memória antes da consulta: 7.504 MB

Update 
                        hz7r8_contentbuilder_articles As articles,
                        hz7r8_content As content, 
                        hz7r8_contentbuilder_forms As forms,
                        hz7r8_contentbuilder_records As records,
                        hz7r8_contentbuilder_registered_users As cbusers,
                        hz7r8_users As users
                    
  Set 
                        content.state = forms.auto_publish
                    
  Where 
                        articles.article_id = content.id
                    
  And
                        content.state = 0
                    
  And
                        articles.form_id = forms.id
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        content.created_by = cbusers.user_id
                    
  And
                        users.id = cbusers.user_id
                    
  And
                        records.record_id = cbusers.record_id
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        users.block = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	content	NULL	ref	PRIMARY,idx_state,idx_createdby	idx_state	1	const	1	100.00	NULL
1	SIMPLE	cbusers	NULL	ref	user_id	user_id	4	maxfield.content.created_by	1	100.00	Using where; Using index
1	SIMPLE	forms	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.cbusers.form_id	1	100.00	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	maxfield.cbusers.user_id	1	33.33	Using where
1	SIMPLE	records	NULL	ref	record_id,type,type_2	record_id	8	maxfield.cbusers.record_id	1	100.00	Using where
1	SIMPLE	articles	NULL	ref	article_id	article_id	4	maxfield.content.id	1	10.00	Using where

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	2.58 ms
init	0.03 ms
updating main table	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
updating reference tables	0.00 ms
end	0.00 ms
end	0.00 ms
removing tmp table	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:450
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.07 ms Após última consulta: 19.39 ms Memória de consulta: 0.005 MB de memória antes da consulta: 8.208 MB Linhas retornadas: 0

Select 
                    form.id As form_id,
                    form.act_as_registration,
                    form.default_category,
                    form.registration_name_field, 
                    form.registration_username_field, 
                    form.registration_email_field, 
                    form.registration_email_repeat_field, 
                    form.`last_update`,
                    article.`article_id`,
                    form.`title_field`,
                    form.`create_articles`,
                    form.`name`,
                    form.`use_view_name_as_title`,
                    form.`protect_upload_directory`,
                    form.`reference_id`,
                    records.`record_id`,
                    form.`type`,
                    form.`published_only`,
                    form.`own_only`,
                    form.`own_only_fe`,
                    records.`last_update` As record_last_update,
                    article.`last_update` As article_last_update
                
  From
                    hz7r8_contentbuilder_records As records
                    
  Left Join hz7r8_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )
                    
  Left Join hz7r8_contentbuilder_articles As article 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )
                    
  Left Join hz7r8_content As content 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.article_id = content.id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )
                
  Where 
                    form.`published` = 1
                
  And
                    form.create_articles = 1
                
  And
                    form.`type` = records.`type`
                
  And 
                    form.reference_id = records.reference_id
                
  And
                   (
                     (
                        article.form_id = form.id 
                      
  And 
                        article.record_id = records.record_id
                      
  And 
                        article.article_id = content.id 
                      
  And 
                        ( content.state = 1 Or content.state = 0 )
                      
  And
                      (
                        form.`last_update` > article.`last_update`   
                       Or
                        records.`last_update` > article.`last_update`
                      )
                     )
                     Or
                     (
                        form.id Is Not Null 
  And records.id Is Not Null 
  And content.id Is Null 
  And article.id Is Null
                     )
                   )
                
  Limit 50

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	form	NULL	ALL	PRIMARY,reference_id	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	1	100.00	Using where
1	SIMPLE	records	NULL	ALL	PRIMARY,record_id,reference_id,type,type_2	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	7	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	article	NULL	ref	record_id,record_id_2	record_id	12	maxfield.records.record_id,maxfield.form.id	1	60.00	Using where
1	SIMPLE	content	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.article.article_id	1	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:516
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 16.64 ms Após última consulta: 8.81 ms Memória de consulta: 0.010 MB de memória antes da consulta: 8.403 MB Linhas retornadas: 16

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

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

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

  ORDER BY m.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; Usando filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.m.component_id	1	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Igual à chamada na linha abaixo.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 5.44 ms Após última consulta: 133.87 ms Memória de consulta: 0.006 MB de memória antes da consulta: 11.561 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 `hz7r8_categories` AS `s`

  INNER JOIN `hz7r8_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('pt-BR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 4.81 ms Após última consulta: 0.13 ms Memória de consulta: 0.006 MB de memória antes da consulta: 11.566 MB Linhas retornadas: 1

SELECT `alias`,`catid`

  FROM `hz7r8_content`

  WHERE `id` = 93

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.50 ms Após última consulta: 4.66 ms Memória de consulta: 0.005 MB de memória antes da consulta: 11.646 MB Linhas retornadas: 0

Select `type`, `reference_id` 
  From hz7r8_contentbuilder_forms 
  Where published = 1

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:236
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.39 ms Após última consulta: 0.18 ms Memória de consulta: 0.005 MB de memória antes da consulta: 11.653 MB

Update hz7r8_contentbuilder_records 
  Set published = 1 
  Where is_future = 1 
  And publish_up <> '0000-00-00 00:00:00' 
  And publish_up <= '2024-04-19 09:08:29'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	hz7r8_contentbuilder_records	NULL	index	NULL	PRIMARY	8	NULL	7	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:256
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Update hz7r8_contentbuilder_records 
  Set published = 0 
  Where publish_down <> '0000-00-00 00:00:00' 
  And publish_down <= '2024-04-19 09:08:29'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	hz7r8_contentbuilder_records	NULL	index	NULL	PRIMARY	8	NULL	7	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:259
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.52 ms Após última consulta: 1.77 ms Memória de consulta: 0.007 MB de memória antes da consulta: 11.762 MB Linhas retornadas: 1

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

  FROM `hz7r8_extensions`

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

Explicar

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

Perfil

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

Pilha de chamadas

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

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

Tempo da consulta: 0.48 ms Após última consulta: 0.19 ms Memória de consulta: 0.005 MB de memória antes da consulta: 11.753 MB

UPDATE `hz7r8_extensions`

  SET `params` = '{\"mediaversion\":\"0979eb3729352b11ff0f459fe01db8bf\"}'

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

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.13 ms
updating	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Pilha de chamadas

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

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

Tempo da consulta: 14.37 ms Após última consulta: 5.42 ms Memória de consulta: 0.003 MB de memória antes da consulta: 12.575 MB Linhas retornadas: 9

SELECT id, home, template, s.params

  FROM hz7r8_template_styles as s

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

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

Explicar

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

Perfil

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

Pilha de chamadas

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

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

Tempo da consulta: 8.55 ms Após última consulta: 26.05 ms Memória de consulta: 0.009 MB de memória antes da consulta: 13.122 MB Linhas retornadas: 41

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

  FROM `hz7r8_assets`

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

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 5.53 ms Após última consulta: 0.26 ms Memória de consulta: 0.009 MB de memória antes da consulta: 13.180 MB Linhas retornadas: 83

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

  FROM `hz7r8_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hz7r8_assets	NULL	ALL	idx_asset_name,idx_parent_id	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	298	22.95	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.12 ms Após última consulta: 3.81 ms Memória de consulta: 0.007 MB de memória antes da consulta: 13.343 MB Linhas retornadas: 31

SHOW FULL COLUMNS 
  FROM `hz7r8_content`

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 3.90 ms Após última consulta: 10.04 ms Memória de consulta: 0.005 MB de memória antes da consulta: 13.652 MB

UPDATE hz7r8_content

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

  WHERE `id` = '93'

Explicar

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

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.05 ms
updating	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 7.67 ms Após última consulta: 4.50 ms Memória de consulta: 0.007 MB de memória antes da consulta: 13.773 MB Linhas retornadas: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 hz7r8_content AS a

  INNER JOIN hz7r8_categories AS c 
  on c.id = a.catid

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

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

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

  WHERE a.id = 93 
  AND c.published > 0 
  AND a.language in ('pt-BR','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 09:08:29') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 09:08:29') 
  AND (a.state = 1 OR a.state =2)

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.88 ms Após última consulta: 5.53 ms Memória de consulta: 0.011 MB de memória antes da consulta: 13.904 MB Linhas retornadas: 5

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 `hz7r8_categories` AS `s`

  INNER JOIN `hz7r8_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('pt-BR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Usando filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	23	11.64	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Igual à chamada na linha abaixo.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 13.08 ms Após última consulta: 1.55 ms Memória de consulta: 0.006 MB de memória antes da consulta: 13.980 MB Linhas retornadas: 1

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

  FROM `hz7r8_contentitem_tag_map` AS m 

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

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	2	100.00	Using index condition
1	SIMPLE	m	NULL	ref	idx_tag_type	idx_tag_type	4	maxfield.t.id	8	1.35	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.89 ms Após última consulta: 7.75 ms Memória de consulta: 0.007 MB de memória antes da consulta: 14.152 MB Linhas retornadas: 1

SELECT enabled 
  FROM hz7r8_extensions 
  WHERE element = 'com_sppagebuilder' 
  AND type = 'component'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:182
14	PlgContentSppagebuilder->isSppagebuilderEnabled()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:36
13	PlgContentSppagebuilder->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 16.81 ms Após última consulta: 29.98 ms Memória de consulta: 0.009 MB de memória antes da consulta: 15.225 MB Linhas retornadas: 0

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

  FROM hz7r8_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (33,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','pt-BR')

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 6.25 ms Após última consulta: 5.34 ms Memória de consulta: 0.008 MB de memória antes da consulta: 15.594 MB Linhas retornadas: 1

SELECT a.id

  FROM hz7r8_sppagebuilder_integrations as a

  WHERE `component` = 'com_content' 
  AND `state` = 1

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:250
15	SppagebuilderHelper::getIntegration()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:133
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 126.01 ms Após última consulta: 0.12 ms Memória de consulta: 0.008 MB de memória antes da consulta: 15.602 MB Linhas retornadas: 1

SELECT *

  FROM `hz7r8_sppagebuilder`

  WHERE `extension` = 'com_content' 
  AND `extension_view` = 'article' 
  AND `view_id` = '93' 
  AND `active` = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hz7r8_sppagebuilder	NULL	ALL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	121	0.83	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:173
15	SppagebuilderHelper::getPageContent()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:137
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.50 ms Após última consulta: 8.16 ms Memória de consulta: 0.011 MB de memória antes da consulta: 15.910 MB Linhas retornadas: 1

Consultas duplicadas: #34

SELECT `template`

  FROM `hz7r8_template_styles`

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

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:643
17	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
16	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:739
15	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:140
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.37 ms Após última consulta: 129.91 ms Memória de consulta: 0.009 MB de memória antes da consulta: 20.908 MB Linhas retornadas: 1

Consultas duplicadas: #33

SELECT `template`

  FROM `hz7r8_template_styles`

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

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
17	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.01 ms Após última consulta: 12.24 ms Memória de consulta: 0.010 MB de memória antes da consulta: 21.279 MB Linhas retornadas: 7

SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id

  FROM (
SELECT id,title,level,published,parent_id,lft,rgt

  FROM hz7r8_tags

  WHERE `published` = '1') AS a

  LEFT JOIN `hz7r8_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE `a`.`level` != '0'

  ORDER BY a.lft ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hz7r8_tags	NULL	ref	tag_idx	tag_idx	1	const	8	90.00	Using index condition; Using where; Using temporary; Usando filesort
1	SIMPLE	b	NULL	ALL	idx_left_right	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	16	100.00	Range checked for each record (index map: 0x10); Distinct

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:194
18	SpPgaeBuilderBase::getArticleTags()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:163
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.53 ms Após última consulta: 0.18 ms Memória de consulta: 0.010 MB de memória antes da consulta: 21.287 MB Linhas retornadas: 0

Consultas duplicadas: #37 #38

SELECT a.enabled

  FROM `hz7r8_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:172
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.49 ms Após última consulta: 0.20 ms Memória de consulta: 0.010 MB de memória antes da consulta: 21.302 MB Linhas retornadas: 0

Consultas duplicadas: #36 #38

SELECT a.enabled

  FROM `hz7r8_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:279
17	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.60 ms Após última consulta: 2.53 ms Memória de consulta: 0.010 MB de memória antes da consulta: 21.429 MB Linhas retornadas: 0

Consultas duplicadas: #36 #37

SELECT a.enabled

  FROM `hz7r8_extensions` AS `a`

  WHERE `a`.`name` = 'com_k2'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
18	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
17	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.58 ms Após última consulta: 57.45 ms Memória de consulta: 0.010 MB de memória antes da consulta: 23.633 MB Linhas retornadas: 1

SELECT a.enabled

  FROM `hz7r8_extensions` AS `a`

  WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	100.00	Using index condition

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470
18	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
17	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.88 ms Após última consulta: 0.15 ms Memória de consulta: 0.010 MB de memória antes da consulta: 23.645 MB Linhas retornadas: 1

SELECT `e`.`manifest_cache`

  FROM `hz7r8_extensions` AS `e`

  WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	100.00	Using index condition

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:529
19	SpPgaeBuilderBase::getExtensionVersion()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:475
18	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
17	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 8.73 ms Após última consulta: 0.17 ms Memória de consulta: 0.010 MB de memória antes da consulta: 23.656 MB Linhas retornadas: 3

SELECT `id`,`name`

  FROM `hz7r8_acym_list`

  WHERE `active` = '1'

  ORDER BY name DESC

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:492
18	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
17	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
16	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
15	AddonParser::viewAddons()	JROOT/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:157
14	SppagebuilderHelper::onIntegrationPrepareContent()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:110
13	PlgContentSppagebuilder->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 3.36 ms Após última consulta: 268.92 ms Memória de consulta: 0.007 MB de memória antes da consulta: 24.332 MB Linhas retornadas: 0

Consultas duplicadas: #43

Select form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From hz7r8_contentbuilder_articles As article, hz7r8_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	article	NULL	ref	article_id	article_id	4	const	1	100.00	NULL
1	SIMPLE	form	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.article.form_id	1	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/contentbuilder_download/contentbuilder_download.php:212
13	plgContentContentbuilder_download->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.28 ms Após última consulta: 0.43 ms Memória de consulta: 0.007 MB de memória antes da consulta: 24.340 MB Linhas retornadas: 0

Consultas duplicadas: #42

Select form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From hz7r8_contentbuilder_articles As article, hz7r8_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	article	NULL	ref	article_id	article_id	4	const	1	100.00	NULL
1	SIMPLE	form	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.article.form_id	1	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/contentbuilder_image_scale/contentbuilder_image_scale.php:172
13	plgContentContentbuilder_image_scale->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.42 ms Após última consulta: 0.23 ms Memória de consulta: 0.007 MB de memória antes da consulta: 24.346 MB Linhas retornadas: 0

Select form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From hz7r8_contentbuilder_articles As article, hz7r8_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	article	NULL	ref	article_id	article_id	4	const	1	100.00	NULL
1	SIMPLE	form	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.article.form_id	1	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/contentbuilder_permission_observer/contentbuilder_permission_observer.php:67
13	plgContentContentbuilder_permission_observer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.49 ms Após última consulta: 1.10 ms Memória de consulta: 0.007 MB de memória antes da consulta: 24.355 MB Linhas retornadas: 0

Select form.rating_slots,form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From hz7r8_contentbuilder_articles As article, hz7r8_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '93'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	article	NULL	ref	article_id	article_id	4	const	1	100.00	NULL
1	SIMPLE	form	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.article.form_id	1	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:130
13	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 26.60 ms Após última consulta: 0.94 ms Memória de consulta: 0.007 MB de memória antes da consulta: 24.379 MB Linhas retornadas: 12

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 hz7r8_content AS a

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

  WHERE a.catid = 33 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 09:08:29') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 09:08:29') 
  AND a.language in ('pt-BR','*')

  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	12	6.04	Using index condition; Using where; Usando filesort
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 1.25 ms Após última consulta: 23.37 ms Memória de consulta: 0.005 MB de memória antes da consulta: 24.570 MB Linhas retornadas: 1

SELECT language,id

  FROM `hz7r8_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hz7r8_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	148	1.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.40 ms Após última consulta: 0.37 ms Memória de consulta: 0.009 MB de memória antes da consulta: 24.578 MB Linhas retornadas: 1

SELECT `alias`

  FROM `hz7r8_content`

  WHERE id = '93'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Igual à chamada na linha abaixo.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.30 ms Após última consulta: 0.19 ms Memória de consulta: 0.008 MB de memória antes da consulta: 24.586 MB Linhas retornadas: 1

SELECT alias

  FROM hz7r8_content

  WHERE id=93

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 4.70 ms Após última consulta: 1.64 ms Memória de consulta: 0.005 MB de memória antes da consulta: 24.618 MB Linhas retornadas: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `hz7r8_content` AS `c`

  INNER JOIN `hz7r8_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `hz7r8_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `hz7r8_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `hz7r8_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 93 
  AND c2.access IN (1,1,5) 
  AND c2.language != 'pt-BR' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-04-19 09:08:29') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-04-19 09:08:29') 
  AND c2.state = 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NENHUMA CHAVE DE ÍNDICE PÔDE SER USADA	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	4.02 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Pilha de chamadas

#	Chamador	Arquivo e número da linha
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 28.73 ms Após última consulta: 105.15 ms Memória de consulta: 0.009 MB de memória antes da consulta: 25.865 MB Linhas retornadas: 29

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

  FROM hz7r8_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-19 09:08:29') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 09:08:29') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 718 OR mm.menuid <= 0) 
  AND m.language IN ('pt-BR','*')

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	6	1.96	Using index condition; Using where; Usando filesort
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	maxfield.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_folder_clientid	402	maxfield.m.module	11	1.00	Using index condition; Using where

Perfil

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

Pilha de chamadas

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

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

Tempo da consulta: 17.24 ms Após última consulta: 65.15 ms Memória de consulta: 0.007 MB de memória antes da consulta: 26.307 MB Linhas retornadas: 4

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM hz7r8_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 09:08:29') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 09:08:29') 
  AND a.language IN ('pt-BR','*')

  ORDER BY a.created DESC 
  LIMIT 4

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_language	idx_state	1	const	17	16.00	Using index condition; Using where; Usando filesort
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.a.modified_by	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	maxfield.a.catid	1	10.00	Using index condition; Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.c.parent_id	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	maxfield.a.id	1	100.00	Using where

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 4.45 ms Após última consulta: 5.64 ms Memória de consulta: 0.008 MB de memória antes da consulta: 26.369 MB Linhas retornadas: 118

SELECT * 
  FROM hz7r8_acym_configuration

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:15
14	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:37
13	acym_config()	JROOT/administrator/components/com_acym/helpers/global/email.php:5
12	acym_getEmailRegex()	JROOT/administrator/components/com_acym/helpers/global/module.php:43
11	acym_initModule()	JROOT/modules/mod_acym/mod_acym.php:13
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.81 ms Após última consulta: 6.07 ms Memória de consulta: 0.007 MB de memória antes da consulta: 26.776 MB Linhas retornadas: 3

SELECT * 
  FROM hz7r8_acym_list 
  WHERE `type` = 'standard'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:498
11	AcyMailing\Classes\ListClass->getAllWithoutManagement()	JROOT/modules/mod_acym/mod_acym.php:36
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 4.67 ms Após última consulta: 0.12 ms Memória de consulta: 0.007 MB de memória antes da consulta: 26.788 MB Linhas retornadas: 1

SELECT * 
  FROM hz7r8_acym_field 
  WHERE `id` IN(2) 
  ORDER BY `ordering` ASC

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
12	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/field.php:46
11	AcyMailing\Classes\FieldClass->getFieldsByID()	JROOT/modules/mod_acym/mod_acym.php:39
10	include JROOT/modules/mod_acym/mod_acym.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.45 ms Após última consulta: 10.00 ms Memória de consulta: 0.008 MB de memória antes da consulta: 26.882 MB Linhas retornadas: 3

SELECT * 
  FROM hz7r8_acym_list 
  WHERE type = 'standard'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:479
14	AcyMailing\Classes\ListClass->getAllForSelect()	JROOT/administrator/components/com_acym/classes/form.php:24
13	AcyMailing\Classes\FormClass->__construct()	JROOT/plugins/system/acymtriggers/acymtriggers.php:106
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.36 ms Após última consulta: 0.19 ms Memória de consulta: 0.008 MB de memória antes da consulta: 26.890 MB Linhas retornadas: 3

SELECT * 
  FROM hz7r8_acym_field

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
15	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:62
14	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/classes/form.php:27
13	AcyMailing\Classes\FormClass->__construct()	JROOT/plugins/system/acymtriggers/acymtriggers.php:106
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 2.39 ms Após última consulta: 0.22 ms Memória de consulta: 0.007 MB de memória antes da consulta: 26.920 MB Linhas retornadas: 0

SELECT * 
  FROM hz7r8_acym_form 
  WHERE active = 1 
  AND type != 'shortcode'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
14	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/form.php:449
13	AcyMailing\Classes\FormClass->getAllFormsToDisplay()	JROOT/plugins/system/acymtriggers/acymtriggers.php:107
12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.67 ms Após última consulta: 15.04 ms Memória de consulta: 0.009 MB de memória antes da consulta: 27.209 MB Linhas retornadas: 1

SELECT `alias`

  FROM `hz7r8_content`

  WHERE id = '62'

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Igual à chamada na linha abaixo.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.89 ms Após última consulta: 0.20 ms Memória de consulta: 0.009 MB de memória antes da consulta: 27.221 MB Linhas retornadas: 1

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

  FROM `hz7r8_categories` AS `s`

  INNER JOIN `hz7r8_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('pt-BR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Igual à chamada na linha abaixo.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo da consulta: 0.61 ms Após última consulta: 0.19 ms Memória de consulta: 0.008 MB de memória antes da consulta: 27.227 MB Linhas retornadas: 1

SELECT alias

  FROM hz7r8_content

  WHERE id=62

Explicar

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

Perfil

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

Pilha de chamadas

#	Chamador	Arquivo e número da linha
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT Tables:

4 × SELECT a.enabled 
  FROM `hz7r8_extensions` AS `a`

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 `hz7r8_categories` AS `s` 
  INNER JOIN `hz7r8_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('pt-BR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

2 × SELECT `template` 
  FROM `hz7r8_template_styles`

2 × Select form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From hz7r8_contentbuilder_articles As article, hz7r8_contentbuilder_forms As form

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `hz7r8_assets`

2 × SELECT `alias` 
  FROM `hz7r8_content`

2 × SELECT alias 
  FROM hz7r8_content

```
2 × SELECT * 
  FROM hz7r8_acym_list
```

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

1 × 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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM hz7r8_content AS a 
  LEFT JOIN hz7r8_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN hz7r8_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN hz7r8_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN hz7r8_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN hz7r8_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `hz7r8_content` AS `c` 
  INNER JOIN `hz7r8_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `hz7r8_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `hz7r8_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `hz7r8_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT * 
  FROM hz7r8_acym_configuratio

```
1 × SELECT * 
  FROM hz7r8_acym_field
```

1 × SELECT language,id 
  FROM `hz7r8_menu`

```
1 × SELECT * 
  FROM hz7r8_acym_fiel
```

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 hz7r8_content AS a 
  LEFT JOIN hz7r8_categories AS cc 
  ON cc.id = a.catid

1 × Select form.rating_slots,form.`title_field`,form.`protect_upload_directory`,form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From hz7r8_contentbuilder_articles As article, hz7r8_contentbuilder_forms As form

1 × Select form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From hz7r8_contentbuilder_articles As article, hz7r8_contentbuilder_forms As form

1 × SELECT `id`,`name` 
  FROM `hz7r8_acym_list`

1 × SELECT `e`.`manifest_cache` 
  FROM `hz7r8_extensions` AS `e`

1 × SELECT `data` 
  FROM `hz7r8_session`

1 × SELECT * 
  FROM `hz7r8_sppagebuilder`

1 × SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id 
  FROM ( SELECT id,title,level,published,parent_id,lft,rgt 
  FROM hz7r8_tags

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 hz7r8_menu AS m 
  LEFT JOIN hz7r8_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, rules 
  FROM `hz7r8_viewlevels

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

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

```
1 × SELECT * 
  FROM hz7r8_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `hz7r8_extensions`

1 × Select                      form.id As form_id,                     form.act_as_registration,                     form.default_category,                     form.registration_name_field,                      form.registration_username_field,                      form.registration_email_field,                      form.registration_email_repeat_field,                      form.`last_update`,                     article.`article_id`,                     form.`title_field`,                     form.`create_articles`,                     form.`name`,                     form.`use_view_name_as_title`,                     form.`protect_upload_directory`,                     form.`reference_id`,                     records.`record_id`,                     form.`type`,                     form.`published_only`,                     form.`own_only`,                     form.`own_only_fe`,                     records.`last_update` As record_last_update,                     article.`last_update` As article_last_update                 
  From                     hz7r8_contentbuilder_records As records                     
  Left Join hz7r8_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )                     
  Left Join hz7r8_contentbuilder_articles As article 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )                     
  Left Join hz7r8_content As content 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.article_id = content.id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )

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

1 × SELECT `session_id` 
  FROM `hz7r8_session`

1 × Select `type`, `reference_id` 
  From hz7r8_contentbuilder_forms

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

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 hz7r8_content AS a 
  INNER JOIN hz7r8_categories AS c 
  on c.id = a.catid 
  LEFT JOIN hz7r8_users AS u 
  on u.id = a.created_by 
  LEFT JOIN hz7r8_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN hz7r8_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT enabled 
  FROM hz7r8_extensions

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

1 × SELECT a.id 
  FROM hz7r8_sppagebuilder_integrations as a

```
1 × SELECT * 
  FROM hz7r8_acym_form
```

Outras Tabelas:

1 × INSERT INTO `hz7r8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3462336438303439313335316638396664386435653433373434373361396132', 1, 1713517709, 0, '', 0

1 × Update                         hz7r8_contentbuilder_articles As articles,                         hz7r8_content As content,                          hz7r8_contentbuilder_forms As forms,                         hz7r8_contentbuilder_registered_users As cbusers,                         hz7r8_users As users                     
  Set                          content.state = 0

1 × Update                          hz7r8_contentbuilder_articles As articles,                         hz7r8_content As content,                          hz7r8_contentbuilder_forms As forms,                         hz7r8_contentbuilder_records As records,                         hz7r8_contentbuilder_registered_users As cbusers,                         hz7r8_users As users                     
  Set                          content.state = forms.auto_publish

1 × Update hz7r8_contentbuilder_records 
  Set published = 1

1 × Update hz7r8_contentbuilder_records 
  Set published = 0

1 × UPDATE `hz7r8_extensions` 
  SET `params` = '{\"mediaversion\":\"0979eb3729352b11ff0f459fe01db8bf\"}'

1 × SHOW FULL COLUMNS 
  FROM `hz7r8_content

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