Portfólio

Consola de depuração Joomla

Sessão

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1793527102,
                "last": 1793527102,
                "now": 1793527102
            },
            "token": "ly803hpLGDKZZO8ARrgpBGh4xxr2LPzj"
        },
        "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-PT"
        }
    }
}

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josrn_session	const	PRIMARY	PRIMARY	194	const	1

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

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

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

Perfil

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

Chamada de dados

#	Chamador	Ficheiro 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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 1.37 ms Após a última consulta: 15.47 ms Consulta a Memória: 0.023 MB de memória antes da consulta: 4.777 MB Linhas devolvidas: 5

SELECT id, rules

  FROM `josrn_viewlevels`

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josrn_viewlevels	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	5

Perfil

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

Chamada de dados

#	Chamador	Ficheiro 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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 1.30 ms Após a última consulta: 0.28 ms Consulta a Memória: 0.023 MB de memória antes da consulta: 4.789 MB Linhas devolvidas: 2

SELECT b.id

  FROM josrn_usergroups AS a

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

  WHERE a.id = 9

Explica

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

Perfil

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

Chamada de dados

#	Chamador	Ficheiro 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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 28.99 ms Após a última consulta: 125.16 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 8.920 MB

UPDATE `josrn_extensions`

  SET `params` = '{\"mediaversion\":\"1e4cf52aa9c69b8a8b5230b0d01a196b\"}'

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

Explica

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

Perfil

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

Chamada de dados

#	Chamador	Ficheiro 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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 1.33 ms Após a última consulta: 14.32 ms Consulta a Memória: 0.023 MB de memória antes da consulta: 9.155 MB Linhas devolvidas: 1

SELECT params 
  FROM josrn_os_gallery 
  WHERE id=1

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josrn_os_gallery	system	PRIMARY	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	1

Perfil

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

Chamada de dados

#	Chamador	Ficheiro e número da linha
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:46
7	osGalleryHelperSite::displayView()	JROOT/components/com_osgallery/osgallery.php:29
6	require_once JROOT/components/com_osgallery/osgallery.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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 3.54 ms Após a última consulta: 0.28 ms Consulta a Memória: 0.029 MB de memória antes da consulta: 9.166 MB Linhas devolvidas: 30

SELECT gim.* , gc.fk_cat_id, cat.name as cat_name, gal.id as galId 
  FROM josrn_os_gallery_img as gim 
 
  LEFT JOIN josrn_os_gallery_connect as gc 
  ON gim.id=gc.fk_gal_img_id
 
  LEFT JOIN josrn_os_gallery_categories as cat 
  ON cat.id=gc.fk_cat_id 
 
  LEFT JOIN josrn_os_gallery as gal 
  ON gal.id=cat.fk_gal_id 
 
  WHERE cat.fk_gal_id =1 
  AND gal.published
 
  ORDER BY cat.ordering ASC

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cat	system	PRIMARY,fk_gal_id	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	1
1	SIMPLE	gal	system	PRIMARY	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	1
1	SIMPLE	gc	ALL	fk_cat_id,fk_gal_img_id	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	30	Using where
1	SIMPLE	gim	eq_ref	PRIMARY	PRIMARY	4	piscinasbrandao_prod.gc.fk_gal_img_id	1

Perfil

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

Chamada de dados

#	Chamador	Ficheiro e número da linha
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:61
7	osGalleryHelperSite::displayView()	JROOT/components/com_osgallery/osgallery.php:29
6	require_once JROOT/components/com_osgallery/osgallery.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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 0.97 ms Após a última consulta: 0.53 ms Consulta a Memória: 0.023 MB de memória antes da consulta: 9.206 MB Linhas devolvidas: 1

SELECT DISTINCT id,params 
  FROM josrn_os_gallery_categories
 
  WHERE fk_gal_id =1

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josrn_os_gallery_categories	system	fk_gal_id	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	1

Perfil

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

Chamada de dados

#	Chamador	Ficheiro e número da linha
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:81
7	osGalleryHelperSite::displayView()	JROOT/components/com_osgallery/osgallery.php:29
6	require_once JROOT/components/com_osgallery/osgallery.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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 5.17 ms Após a última consulta: 0.22 ms Consulta a Memória: 0.024 MB de memória antes da consulta: 9.213 MB Linhas devolvidas: 30

SELECT DISTINCT galImg.id,galImg.params 
  FROM josrn_os_gallery_img as galImg
 
  LEFT JOIN josrn_os_gallery_connect as galCon 
  ON galCon.fk_gal_img_id = galImg.id
 
  LEFT JOIN josrn_os_gallery_categories as cat 
  ON cat.id = galCon.fk_cat_id
 
  WHERE cat.fk_gal_id =1

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cat	system	PRIMARY,fk_gal_id	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	1	Using temporary
1	SIMPLE	galCon	ALL	fk_cat_id,fk_gal_img_id	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	30	Using where
1	SIMPLE	galImg	eq_ref	PRIMARY	PRIMARY	4	piscinasbrandao_prod.galCon.fk_gal_img_id	1

Perfil

Status	Duration
Starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.09 ms
Creating tmp table	0.12 ms
Executing	0.03 ms
Sending data	3.28 ms
Removing tmp table	0.26 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.10 ms
Reset for next command	0.03 ms

Chamada de dados

#	Chamador	Ficheiro e número da linha
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgallery/helpers/osGalleryHelperSite.php:89
7	osGalleryHelperSite::displayView()	JROOT/components/com_osgallery/osgallery.php:29
6	require_once JROOT/components/com_osgallery/osgallery.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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 1.58 ms Após a última consulta: 4.55 ms Consulta a Memória: 0.023 MB de memória antes da consulta: 9.228 MB Linhas devolvidas: 3

SELECT language,id

  FROM `josrn_menu`

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

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josrn_menu	ALL	idx_client_id_parent_id_alias_language	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	173	Using where

Perfil

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

Chamada de dados

#	Chamador	Ficheiro 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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 3.23 ms Após a última consulta: 25.17 ms Consulta a Memória: 0.037 MB de memória antes da consulta: 9.864 MB Linhas devolvidas: 18

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

  FROM josrn_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-11-01 09:58:22') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-01 09:58:22') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 113 OR mm.menuid <= 0) 
  AND m.language IN ('pt-PT','*')

  ORDER BY m.position, m.ordering

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	35	Using index condition; Using where; Filesort em utilização
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	piscinasbrandao_prod.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	piscinasbrandao_prod.m.module,const	1	Using index condition; Using where

Perfil

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

Chamada de dados

#	Chamador	Ficheiro e número da linha
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Igual à chamada na linha abaixo.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/joomtemplate2/logic.php:51
8	include JROOT/templates/joomtemplate2/logic.php	JROOT/templates/joomtemplate2/index.php:7
7	require JROOT/templates/joomtemplate2/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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

Tempo da consulta: 1.50 ms Após a última consulta: 138.25 ms Consulta a Memória: 0.031 MB de memória antes da consulta: 11.077 MB Linhas devolvidas: 86

SELECT * 
  FROM josrn_acymailing_config

Explica

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	josrn_acymailing_config	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	86

Perfil

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

Chamada de dados

#	Chamador	Ficheiro e número da linha
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:474
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:815
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->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

[Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

13 tipos de pedidos registados, ordenados por ocorrências.

ESCOLHER tabelas:

1 × SELECT `data` 
  FROM `josrn_session`

1 × SELECT `session_id` 
  FROM `josrn_session`

1 × SELECT id, rules 
  FROM `josrn_viewlevels

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

1 × SELECT params 
  FROM josrn_os_gallery

1 × SELECT gim.* , gc.fk_cat_id, cat.name as cat_name, gal.id as galId 
  FROM josrn_os_gallery_img as gim   
  LEFT JOIN josrn_os_gallery_connect as gc 
  ON gim.id=gc.fk_gal_img_id  
  LEFT JOIN josrn_os_gallery_categories as cat 
  ON cat.id=gc.fk_cat_id   
  LEFT JOIN josrn_os_gallery as gal 
  ON gal.id=cat.fk_gal_id

1 × SELECT DISTINCT id,params 
  FROM josrn_os_gallery_categories

1 × SELECT DISTINCT galImg.id,galImg.params 
  FROM josrn_os_gallery_img as galImg  
  LEFT JOIN josrn_os_gallery_connect as galCon 
  ON galCon.fk_gal_img_id = galImg.id  
  LEFT JOIN josrn_os_gallery_categories as cat 
  ON cat.id = galCon.fk_cat_id

1 × SELECT language,id 
  FROM `josrn_menu`

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

1 × SELECT * 
  FROM josrn_acymailing_confi

OUTRAS tabelas:

1 × INSERT INTO `josrn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3864373161316362623334633931316535343064353765356662323038373230', 1, 1793527102, 0, '', 0

1 × UPDATE `josrn_extensions` 
  SET `params` = '{\"mediaversion\":\"1e4cf52aa9c69b8a8b5230b0d01a196b\"}'

Empresa

Parceiros

Consola de depuração Joomla

Sessão

Dados do perfil

Hora

Memória

Utilização de memória

Pedidos à Base de dados

13 pedidos registados 53.08 ms

13 tipos de pedidos registados, ordenados por ocorrências.

ESCOLHER tabelas:

OUTRAS tabelas: