Não há artigos nesta categoria. Se há subcategorias mostradas nesta página, elas podem conter artigos.

Debug de template
Prefixo de posicoes de modulo: com_content-featured

( ! ) Notice: Trying to get property of non-object in /app/www/mapa/templates/padraogoverno01/helper.php on line 339
Call Stack
#	Time	Memory	Function	Location
1	0.0001	230864	{main}( )	../index.php:0
2	0.0624	1291976	JApplicationCms->execute( )	../index.php:49
3	0.2644	5067288	JApplicationSite->render( )	../cms.php:271
4	0.2645	5067864	JApplicationCms->render( )	../site.php:777
5	0.2646	5069008	JDocumentHtml->parse( )	../cms.php:1098
6	0.2646	5069056	JDocumentHtml->_fetchTemplate( )	../html.php:530
7	0.2648	5069608	JDocumentHtml->_loadTemplate( )	../html.php:715
8	0.2649	5087216	require( '/app/www/mapa/templates/padraogoverno01/index.php' )	../html.php:653
9	0.2768	5432016	TmplPadraoGoverno01Helper::debug( )	../index.php:322

ID Item de menu ativo:

( ! ) Notice: Trying to get property of non-object in /app/www/mapa/templates/padraogoverno01/helper.php on line 340
Call Stack
#	Time	Memory	Function	Location
1	0.0001	230864	{main}( )	../index.php:0
2	0.0624	1291976	JApplicationCms->execute( )	../index.php:49
3	0.2644	5067288	JApplicationSite->render( )	../cms.php:271
4	0.2645	5067864	JApplicationCms->render( )	../site.php:777
5	0.2646	5069008	JDocumentHtml->parse( )	../cms.php:1098
6	0.2646	5069056	JDocumentHtml->_fetchTemplate( )	../html.php:530
7	0.2648	5069608	JDocumentHtml->_loadTemplate( )	../html.php:715
8	0.2649	5087216	require( '/app/www/mapa/templates/padraogoverno01/index.php' )	../html.php:653
9	0.2768	5432016	TmplPadraoGoverno01Helper::debug( )	../index.php:322

LINK Item de menu ativo:

Console de depuração do Joomla!

Sessão

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726205409,
                "last": 1726205409,
                "now": 1726205409
            },
            "client": {
                "forwarded": "18.205.56.209"
            }
        },
        "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
        }
    }
}

Informação do perfil

Time

Memory

Time: 16.76 ms / 16.76 ms Memory: 0.232 MB / 0.45 MB Application: afterLoad

Time: 96.89 ms / 113.65 ms Memory: 1.781 MB / 2.23 MB Application: afterInitialise

Time: 79.87 ms / 193.52 ms Memory: 1.254 MB / 3.49 MB Application: afterRoute

Time: 1.65 ms / 195.18 ms Memory: 0.022 MB / 3.51 MB Application: beforeRenderComponent com_content

Time: 21.81 ms / 216.99 ms Memory: 0.630 MB / 4.14 MB Application: Before JAccess::preloadComponents (all components)

Time: 4.83 ms / 221.82 ms Memory: 0.096 MB / 4.24 MB Application: After JAccess::preloadComponents (all components)

Time: 0.20 ms / 222.02 ms Memory: 0.000 MB / 4.23 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Time: 1.77 ms / 223.80 ms Memory: 0.019 MB / 4.25 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Time: 35.19 ms / 258.99 ms Memory: 0.471 MB / 4.72 MB Application: afterRenderComponent com_content

Time: 5.23 ms / 264.22 ms Memory: 0.110 MB / 4.83 MB Application: afterDispatch

Time: 16.28 ms / 280.50 ms Memory: 0.403 MB / 5.23 MB Application: beforeRenderModule mod_menu (Assuntos)

Time: 23.18 ms / 303.67 ms Memory: 0.225 MB / 5.46 MB Application: afterRenderModule mod_menu (Assuntos)

Time: 0.24 ms / 303.91 ms Memory: 0.000 MB / 5.45 MB Application: beforeRenderModule mod_menu (Serviços)

Time: 6.33 ms / 310.24 ms Memory: 0.033 MB / 5.49 MB Application: afterRenderModule mod_menu (Serviços)

Time: 0.21 ms / 310.45 ms Memory: 0.000 MB / 5.48 MB Application: beforeRenderModule mod_menu (Redes Sociais)

Time: 8.71 ms / 319.16 ms Memory: 0.047 MB / 5.53 MB Application: afterRenderModule mod_menu (Redes Sociais)

Time: 0.21 ms / 319.37 ms Memory: 0.000 MB / 5.52 MB Application: beforeRenderModule mod_menu (RSS)

Time: 5.61 ms / 324.98 ms Memory: 0.030 MB / 5.55 MB Application: afterRenderModule mod_menu (RSS)

Time: 0.32 ms / 325.30 ms Memory: 0.000 MB / 5.55 MB Application: beforeRenderModule mod_menu (Sobre o site)

Time: 5.55 ms / 330.85 ms Memory: 0.022 MB / 5.57 MB Application: afterRenderModule mod_menu (Sobre o site)

Time: 0.68 ms / 331.53 ms Memory: 0.000 MB / 5.57 MB Application: beforeRenderModule mod_menu (Menu de Relevância)

Time: 2.33 ms / 333.86 ms Memory: 0.009 MB / 5.58 MB Application: afterRenderModule mod_menu (Menu de Relevância)

Time: 0.27 ms / 334.13 ms Memory: 0.000 MB / 5.57 MB Application: beforeRenderModule mod_menu (Assuntos)

Time: 8.19 ms / 342.32 ms Memory: 0.013 MB / 5.58 MB Application: afterRenderModule mod_menu (Assuntos)

Time: 0.22 ms / 342.54 ms Memory: 0.000 MB / 5.58 MB Application: beforeRenderModule mod_menu (Acesso à Informação)

Time: 2.44 ms / 344.98 ms Memory: 0.009 MB / 5.58 MB Application: afterRenderModule mod_menu (Acesso à Informação)

Time: 0.25 ms / 345.23 ms Memory: 0.000 MB / 5.58 MB Application: beforeRenderModule mod_menu (Central de conteúdos)

Time: 6.98 ms / 352.22 ms Memory: 0.041 MB / 5.62 MB Application: afterRenderModule mod_menu (Central de conteúdos)

Time: 0.61 ms / 352.82 ms Memory: 0.000 MB / 5.61 MB Application: beforeRenderModule mod_breadcrumbs (Rastro de navegação)

Time: 10.07 ms / 362.89 ms Memory: 0.051 MB / 5.66 MB Application: afterRenderModule mod_breadcrumbs (Rastro de navegação)

Time: 0.60 ms / 363.48 ms Memory: 0.000 MB / 5.66 MB Application: beforeRenderModule mod_menu (Serviços)

Time: 4.02 ms / 367.51 ms Memory: 0.011 MB / 5.67 MB Application: afterRenderModule mod_menu (Serviços)

Time: 0.56 ms / 368.07 ms Memory: 0.000 MB / 5.66 MB Application: beforeRenderModule mod_search (Buscar no portal)

Time: 4.42 ms / 372.49 ms Memory: 0.024 MB / 5.69 MB Application: afterRenderModule mod_search (Buscar no portal)

Time: 0.22 ms / 372.71 ms Memory: 0.000 MB / 5.68 MB Application: beforeRenderModule mod_menu (Redes Sociais)

Time: 6.13 ms / 378.84 ms Memory: 0.011 MB / 5.69 MB Application: afterRenderModule mod_menu (Redes Sociais)

Time: 0.65 ms / 379.49 ms Memory: 0.000 MB / 5.69 MB Application: beforeRenderModule mod_menu (Opções de acessibilidade)

Time: 5.02 ms / 384.52 ms Memory: 0.032 MB / 5.72 MB Application: afterRenderModule mod_menu (Opções de acessibilidade)

Time: 0.59 ms / 385.11 ms Memory: 0.000 MB / 5.71 MB Application: beforeRenderModule mod_barradogoverno (mod_barradogoverno)

Time: 1.09 ms / 386.19 ms Memory: 0.018 MB / 5.73 MB Application: afterRenderModule mod_barradogoverno (mod_barradogoverno)

Time: 38.59 ms / 424.78 ms Memory: 0.072 MB / 5.80 MB Application: afterRender

Database queries total: 37.92 ms

Memória Utilizada

Consultas ao banco

17 Queries Registradas 37.92 ms

Query Time: 5.48 ms Query memory: 0.008 MB Memory before query: 1.136 MB

DELETE 

  FROM `mdbmtur_session`

  WHERE `time` < '1726204509'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	mdbmtur_session	NULL	range	time	time	59	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.80 ms After last query: 1.45 ms Query memory: 0.019 MB Memory before query: 1.161 MB Rows returned: 0

SELECT `data`

  FROM `mdbmtur_session`

  WHERE `session_id` = 'aiu3h71ebttqjjms94a5vmbsa3'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.13 ms After last query: 3.82 ms Query memory: 0.010 MB Memory before query: 1.213 MB Rows returned: 0

SELECT `session_id`

  FROM `mdbmtur_session`

  WHERE `session_id` = 'aiu3h71ebttqjjms94a5vmbsa3' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.61 ms After last query: 1.70 ms Query memory: 0.009 MB Memory before query: 1.228 MB

INSERT INTO `mdbmtur_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('aiu3h71ebttqjjms94a5vmbsa3', 1, '1726205409', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `mdbmtur_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('aiu3h71ebttqjjms94a5vmbsa3', 1, '1726205409', 0, '', 0)

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.07 ms
end	0.01 ms
query end	3.34 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.52 ms After last query: 4.20 ms Query memory: 0.013 MB Memory before query: 1.363 MB Rows returned: 38

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

  FROM `mdbmtur_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mdbmtur_extensions	NULL	ref	extension	extension	82	const	38	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
9	JComponentHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.05 ms After last query: 3.45 ms Query memory: 0.013 MB Memory before query: 1.482 MB Rows returned: 1

SELECT b.id

  FROM mdbmtur_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.72 ms After last query: 0.77 ms Query memory: 0.012 MB Memory before query: 1.502 MB Rows returned: 3

SELECT id, rules

  FROM `mdbmtur_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mdbmtur_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.45 ms After last query: 1.38 ms Query memory: 0.013 MB Memory before query: 1.540 MB Rows returned: 71

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

  FROM mdbmtur_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mdbmtur_extensions	NULL	ref	extension	extension	82	const	91	0.49	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
9	JPluginHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.36 ms After last query: 45.41 ms Query memory: 0.022 MB Memory before query: 2.343 MB Rows returned: 80

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

  LEFT JOIN mdbmtur_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

Explain

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	147	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
17	JMenuSite->{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1141
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.28 ms After last query: 42.73 ms Query memory: 0.023 MB Memory before query: 3.046 MB Rows returned: 1

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

  FROM `mdbmtur_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
18	JLibraryHelper::{closure}()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
15	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.78 ms After last query: 1.49 ms Query memory: 0.017 MB Memory before query: 3.053 MB

UPDATE `mdbmtur_extensions`

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.18 ms After last query: 3.89 ms Query memory: 0.017 MB Memory before query: 3.257 MB Rows returned: 1

SELECT *

  FROM mdbmtur_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mdbmtur_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.04 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.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:315
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.97 ms After last query: 4.37 ms Query memory: 0.024 MB Memory before query: 3.448 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM mdbmtur_template_styles as s

  LEFT JOIN mdbmtur_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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	jo_regionalizacao.s.template,const	1	4.56	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
16	JHtml::call()	JROOT/libraries/cms/html/html.php:140
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:63
14	JHtmlBehavior::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:76
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.70 ms After last query: 32.13 ms Query memory: 0.025 MB Memory before query: 4.147 MB Rows returned: 38

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

  FROM `mdbmtur_assets`

  WHERE `name` IN ('com_admin','com_agendadirigentes','com_ajax','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_youtubegallery') OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mdbmtur_assets	NULL	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	39	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_content/models/articles.php:113
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:434
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.06 ms After last query: 9.17 ms Query memory: 0.021 MB Memory before query: 4.326 MB Rows returned: 0

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,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,
  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 mdbmtur_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-13 05:30:09') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-13 05:30:09')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 9

Explain

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_featured_catid	idx_featured_catid	1	const	5	16.00	Using where; Using temporary; Using filesort
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.a.modified_by	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	jo_regionalizacao.a.catid	1	10.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.c.parent_id	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.a.id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
15	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
14	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
12	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.40 ms After last query: 5.49 ms Query memory: 0.019 MB Memory before query: 4.513 MB Rows returned: 1

SELECT COUNT(*)

  FROM mdbmtur_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-13 05:30:09') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-13 05:30:09')

Explain

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_featured_catid	idx_featured_catid	1	const	5	16.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	jo_regionalizacao.a.catid	1	10.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.c.parent_id	1	100.00	Using where; Using index
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	jo_regionalizacao.a.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.43 ms After last query: 28.41 ms Query memory: 0.018 MB Memory before query: 4.917 MB Rows returned: 76

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

  FROM mdbmtur_modules AS m

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

  LEFT JOIN mdbmtur_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-09-13 05:30:09') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-13 05:30:09') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
8	JDocumentHtml->countModules()	JROOT/templates/padraogoverno01/index.php:131
7	require JROOT/templates/padraogoverno01/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

SELECT Tables:

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

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

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

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,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,
  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 mdbmtur_content AS a 
  LEFT JOIN mdbmtur_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN mdbmtur_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN mdbmtur_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN mdbmtur_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN mdbmtur_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT COUNT(*) 
  FROM mdbmtur_content AS a 
  LEFT JOIN mdbmtur_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN mdbmtur_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN mdbmtur_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN mdbmtur_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN mdbmtur_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 mdbmtur_modules AS m 
  LEFT JOIN mdbmtur_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN mdbmtur_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT * 
  FROM mdbmtur_languages

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

1 × SELECT `session_id` 
  FROM `mdbmtur_session`

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

1 × SELECT id, rules 
  FROM `mdbmtur_viewlevels

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM mdbmtur_extensions

1 × SELECT `data` 
  FROM `mdbmtur_session`

Outras Tabelas:

1 × UPDATE `mdbmtur_extensions` 
  SET `params` = '{\"mediaversion\":\"dc38ac71f5fd4804bd0812d0abe8676f\"}'

1 × INSERT INTO `mdbmtur_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('aiu3h71ebttqjjms94a5vmbsa3', 1, '1726205409', 0, '', 0

```
1 × DELETE  
  FROM `mdbmtur_session`
```