Consola de depuração Joomla

{
    "__default": {
        "session": {
            "counter": 125,
            "timer": {
                "start": 1583343311,
                "last": 1583346078,
                "now": 1583346097
            },
            "token": "BTU88EAgZ50QfYLRcRw9cX4hLzeLe2iJ"
        },
        "registry": {
            "com_tz_portfolio": {
                "portfolio": {
                    "ordercol": null
                },
                "tags": {
                    "ordercol": null
                },
                "category": {
                    "list": {
                        "9:188": {
                            "limit": "10"
                        }
                    }
                }
            },
            "global": {
                "list": {
                    "limit": 10
                }
            },
            "com_contact": {
                "contact": {
                    "data": {
                        "catid": "25"
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "da6b29d93878ce734f47b9ac9079dda6efc61ec6": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=37:t-shirt-de-senhora&catid=16&Itemid=111",
                    "expiry": 1583345350
                },
                "5762ebfc3cc15af1c9169d5ec2b20714adc66c67": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=38:camisa-de-homem&catid=16&Itemid=111",
                    "expiry": 1583345430
                },
                "3565b7aafef70dbca39848d7c110cf37003d358c": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=39:blusao-termico-impermiavel&catid=16&Itemid=111",
                    "expiry": 1583345511
                },
                "da79c2c62f17fb1ef37559d8999fefb45fd613cc": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=36:t-shirt-de-homem&catid=16&Itemid=111",
                    "expiry": 1583345582
                },
                "b362caf84671119cbedd1b61eb2ed5cb270263df": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=46:terminologia&catid=11&Itemid=178",
                    "expiry": 1583345663
                },
                "a9dc202893e2155347e402398bca5aebb98bcefe": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=45:antes-de-iniciar-uma-viagem&catid=11&Itemid=178",
                    "expiry": 1583345735
                },
                "212da3b549802e4862627df9c896cc9319cb4ef0": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=91:regulamento-geral-proteccao-de-dados&catid=8",
                    "expiry": 1583344707
                },
                "680673e9dd5a627ca321775f803015204bc98b55": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=62:logo&catid=8",
                    "expiry": 1583344744
                },
                "6bf061aa4a6bed79b16370c066b5551ce1affc2d": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=17:conducao-em-grupo&catid=11&Itemid=178",
                    "expiry": 1583345808
                },
                "3722288cffb896a95d1676f972c465c672bfe2bf": {
                    "link": "index.php?option=com_tz_portfolio&view=article&id=18:sinalizacao-gestual&catid=11&Itemid=178",
                    "expiry": 1583345876
                }
            },
            "formtime": 1583346011
        },
        "params": {
            "show_page_heading": null,
            "picasaUsername": "114679013513407169774",
            "picasaAlbumid": "{picasa album id}",
            "picasaMaxPhotosPerPage": "25",
            "picasaMaxPhotosPerRow": "5",
            "picasaPagingNumbers": "10",
            "picasaThumbnailImagesize": "144",
            "picasaImagesize": "800",
            "picasaWelcomeTitle": "Dezembro de 2010 at\u00e9 aos dias de hoje",
            "menu_text": 1,
            "secure": 0,
            "page_title": "Dez. 2010 - Hoje",
            "page_description": "Bem vindo ao website do Mototurismo do Centro",
            "page_rights": null,
            "robots": null
        },
        "singleAbumView": "0"
    }
}

Hora

Memória

17 pedidos registados 16.27 ms

1. Tempo da consulta: 0.80 ms Consulta a Memória: 0.003 MB de memória antes da consulta: 0.757 MB

   DELETE 
   
     FROM `yj12h_session`
   
     WHERE `time` < '1583345197'

   Explica

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yj12h_session	range	time	time	59	NULL	1	100.00	Using where

   Perfil

   Status	Duration
   starting	0.08 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   After opening tables	0.04 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.11 ms
   updating	0.07 ms
   end	0.02 ms
   query end	0.04 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.06 ms
   cleaning up	0.04 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
   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:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Tempo da consulta: 0.78 ms Após a última consulta: 0.68 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 0.765 MB Linhas devolvidas: 1

   SELECT `data`
   
     FROM `yj12h_session`
   
     WHERE `session_id` = '360fd330a841cc4625f5797e984c905d'

   Explica

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

   Perfil

   Status	Duration
   starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.04 ms
   optimizing	0.03 ms
   statistics	0.08 ms
   preparing	0.02 ms
   Unlocking tables	0.05 ms
   executing	0.02 ms
   Sending data	0.03 ms
   end	0.02 ms
   query end	0.03 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.04 ms
   cleaning up	0.03 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   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: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:829
   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:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Tempo da consulta: 1.39 ms Após a última consulta: 2.71 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.898 MB Linhas devolvidas: 42

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `yj12h_extensions`
   
     WHERE `type` = 'component'

   Explica

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yj12h_extensions	ref	extension	extension	82	const	42	100.00	Using index condition

   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.04 ms
   init	0.05 ms
   optimizing	0.03 ms
   statistics	0.10 ms
   preparing	0.05 ms
   executing	0.02 ms
   Sending data	0.55 ms
   end	0.03 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.03 ms
   updating status	0.06 ms
   cleaning up	0.03 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   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

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

   ---

4. Tempo da consulta: 0.69 ms Após a última consulta: 2.13 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.949 MB Linhas devolvidas: 5

   SELECT id, rules
   
     FROM `yj12h_viewlevels`

   Explica

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

   Perfil

   Status	Duration
   starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.03 ms
   optimizing	0.03 ms
   statistics	0.03 ms
   preparing	0.03 ms
   executing	0.02 ms
   Sending data	0.09 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.03 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.04 ms
   cleaning up	0.03 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   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

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

   ---

5. Tempo da consulta: 0.73 ms Após a última consulta: 0.28 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.961 MB Linhas devolvidas: 0

   SELECT b.id
   
     FROM yj12h_usergroups AS a
   
     LEFT JOIN yj12h_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 13

   Explica

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Perfil

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.05 ms
   optimizing	0.05 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.04 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.04 ms
   cleaning up	0.03 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   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:1093
   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

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

   ---

6. Tempo da consulta: 2.48 ms Após a última consulta: 0.56 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.982 MB Linhas devolvidas: 86

   SELECT `folder` AS `type`,`element` AS `name`,`params`
   
     FROM yj12h_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explica

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yj12h_extensions	ref	extension	extension	82	const	117	100.00	Using index condition; Using where; Filesort em utilização

   Perfil

   Status	Duration
   starting	0.11 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.06 ms
   optimizing	0.05 ms
   statistics	0.10 ms
   preparing	0.10 ms
   Sorting result	0.03 ms
   executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	1.47 ms
   end	0.04 ms
   query end	0.03 ms
   closing tables	0.03 ms
   Unlocking tables	0.04 ms
   freeing items	0.03 ms
   updating status	0.05 ms
   cleaning up	0.03 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
   8	JPluginHelper::{closure}()	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

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

   ---

7. Tempo da consulta: 1.02 ms Após a última consulta: 15.35 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 1.400 MB Linhas devolvidas: 1

   SELECT `enabled`
   
     FROM `yj12h_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explica

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

   Perfil

   Status	Duration
   starting	0.10 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.06 ms
   optimizing	0.04 ms
   statistics	0.17 ms
   preparing	0.06 ms
   executing	0.02 ms
   Sending data	0.12 ms
   end	0.03 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.03 ms
   updating status	0.04 ms
   cleaning up	0.02 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:71
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   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

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

   ---

8. Tempo da consulta: 1.80 ms Após a última consulta: 5.72 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 1.570 MB Linhas devolvidas: 32

   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 yj12h_menu AS m
   
     LEFT JOIN yj12h_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

   Explica

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	71	100.00	Using index condition; Using where; Filesort em utilização
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.m.component_id	1	100.00	Using where

   Perfil

   Status	Duration
   starting	0.14 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.06 ms
   optimizing	0.04 ms
   statistics	0.08 ms
   preparing	0.05 ms
   Sorting result	0.02 ms
   executing	0.01 ms
   Sending data	0.04 ms
   Creating sort index	0.98 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   freeing items	0.02 ms
   updating status	0.04 ms
   cleaning up	0.01 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
   16	JMenuSite->{closure}()	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:444
   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:549
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
   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

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

   ---

9. Tempo da consulta: 0.61 ms Após a última consulta: 6.42 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 1.863 MB Linhas devolvidas: 4

   SELECT id, home, template, s.params
   
     FROM yj12h_template_styles as s
   
     LEFT JOIN yj12h_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

   Explica

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	100.00	Using index condition; Using where
   1	SIMPLE	s	ALL	idx_template	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	6	83.33	Using where; Using join buffer (flat, BNL join)

   Perfil

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.03 ms
   optimizing	0.03 ms
   statistics	0.06 ms
   preparing	0.04 ms
   executing	0.01 ms
   Sending data	0.10 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   freeing items	0.02 ms
   updating status	0.03 ms
   cleaning up	0.01 ms

   Chamada de dados

   #	Chamador	Ficheiro e número da linha
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
   10	JApplicationSite->getTemplate()	JROOT/plugins/system/plazart/includes/core/plazart.php:226
   9	Plazart::detect()	JROOT/plugins/system/plazart/plazart.php:44
   8	plgSystemPlazart->onAfterRoute()	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:1155
   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

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

   ---

10. Tempo da consulta: 0.71 ms Após a última consulta: 4.24 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 1.993 MB Linhas devolvidas: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `yj12h_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explica

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

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Tempo da consulta: 0.65 ms Após a última consulta: 0.24 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 1.984 MB

    UPDATE `yj12h_extensions`
    
      SET `params` = '{\"mediaversion\":\"8a4ac282af5d5d2a8fcb47084a9cf258\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yj12h_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.07 ms
    updating	0.07 ms
    end	0.01 ms
    query end	0.31 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Tempo da consulta: 0.41 ms Após a última consulta: 0.65 ms Consulta a Memória: 0.003 MB de memória antes da consulta: 2.057 MB Linhas devolvidas: 1

    SELECT *
    
      FROM yj12h_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yj12h_languages	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	2	100.00	Using where; Filesort em utilização

    Perfil

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

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Tempo da consulta: 0.96 ms Após a última consulta: 6.59 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.319 MB Linhas devolvidas: 0
    Consultas duplicadas: #14

    SELECT c.* 
      FROM yj12h_content AS c 
      LEFT JOIN yj12h_categories AS cc 
      ON cc.id=c.catid 
      LEFT JOIN yj12h_tz_portfolio_tags_xref AS x 
      ON x.contentid=c.id 
      LEFT JOIN yj12h_tz_portfolio_tags AS t 
      ON t.id=x.tagsid 
      WHERE c.state=1 
      AND c.catid IN(29) 
      GROUP BY c.id

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where; Using temporary; Filesort em utilização
    1	SIMPLE	x	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	44	100.00	Using where; Using join buffer (flat, BNL join)

    Perfil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.29 ms
    Creating sort index	0.03 ms
    removing tmp table	0.07 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    13	JDatabase->query()	JROOT/components/com_tz_portfolio/models/gallery.php:93
    12	TZ_PortfolioModelGallery->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/gallery/view.html.php:54
    10	TZ_PortfolioViewGallery->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:117
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

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

    ---

14. Tempo da consulta: 0.77 ms Após a última consulta: 0.04 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.326 MB Linhas devolvidas: 0
    Consultas duplicadas: #13

    SELECT c.* 
      FROM yj12h_content AS c 
      LEFT JOIN yj12h_categories AS cc 
      ON cc.id=c.catid 
      LEFT JOIN yj12h_tz_portfolio_tags_xref AS x 
      ON x.contentid=c.id 
      LEFT JOIN yj12h_tz_portfolio_tags AS t 
      ON t.id=x.tagsid 
      WHERE c.state=1 
      AND c.catid IN(29) 
      GROUP BY c.id

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where; Using temporary; Filesort em utilização
    1	SIMPLE	x	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	44	100.00	Using where; Using join buffer (flat, BNL join)

    Perfil

    Status	Duration
    starting	0.04 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
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.23 ms
    Creating sort index	0.02 ms
    removing tmp table	0.07 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    13	JDatabase->query()	JROOT/components/com_tz_portfolio/models/gallery.php:94
    12	TZ_PortfolioModelGallery->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/gallery/view.html.php:54
    10	TZ_PortfolioViewGallery->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:117
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

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

    ---

15. Tempo da consulta: 0.82 ms Após a última consulta: 0.07 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.334 MB Linhas devolvidas: 0
    Consultas duplicadas: #16

    SELECT c.*,cc.title AS category_title,u.name AS author, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, 
      CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore 
      FROM yj12h_content AS c 
      LEFT JOIN yj12h_categories AS cc 
      ON cc.id=c.catid 
      LEFT JOIN yj12h_users AS u 
      ON u.id=c.created_by 
      WHERE c.state=1 
      AND c.catid IN(29) 
      GROUP BY c.id 
      ORDER BY created DESC

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where; Using temporary; Filesort em utilização
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.c.created_by	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting for group	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.28 ms
    Creating sort index	0.02 ms
    removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    13	JDatabase->query()	JROOT/components/com_tz_portfolio/models/gallery.php:167
    12	TZ_PortfolioModelGallery->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/gallery/view.html.php:54
    10	TZ_PortfolioViewGallery->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:117
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

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

    ---

16. Tempo da consulta: 0.68 ms Após a última consulta: 0.03 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.341 MB Linhas devolvidas: 0
    Consultas duplicadas: #15

    SELECT c.*,cc.title AS category_title,u.name AS author, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, 
      CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore 
      FROM yj12h_content AS c 
      LEFT JOIN yj12h_categories AS cc 
      ON cc.id=c.catid 
      LEFT JOIN yj12h_users AS u 
      ON u.id=c.created_by 
      WHERE c.state=1 
      AND c.catid IN(29) 
      GROUP BY c.id 
      ORDER BY created DESC

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where; Using temporary; Filesort em utilização
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.c.created_by	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting for group	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.23 ms
    Creating sort index	0.02 ms
    removing tmp table	0.05 ms
    Creating sort index	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/gallery.php:172
    12	TZ_PortfolioModelGallery->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/gallery/view.html.php:54
    10	TZ_PortfolioViewGallery->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:117
    8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:32
    6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

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

    ---

17. Tempo da consulta: 0.98 ms Após a última consulta: 5.79 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 2.459 MB Linhas devolvidas: 13

    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM yj12h_modules AS m
    
      LEFT JOIN yj12h_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN yj12h_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 <= '2020-03-04 18:21:37') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-03-04 18:21:37') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 190 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explica

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

    Perfil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.46 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:424
    14	JModuleHelper::_load()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:102
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    12	JDocumentHtml->countModules()	JROOT/plugins/system/plazart/includes/core/template.php:1208
    11	PlazartTemplate::countModules()	JROOT/templates/tz_eventory_joomla/layouts/default.php:32
    10	include JROOT/templates/tz_eventory_joomla/layouts/default.php	JROOT/plugins/system/plazart/includes/core/template.php:137
    9	PlazartTemplate->loadLayout()	JROOT/templates/tz_eventory_joomla/libraries/plazart.render.php:66
    8	PlazartRender->__construct()	JROOT/templates/tz_eventory_joomla/index.php:26
    7	require JROOT/templates/tz_eventory_joomla/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:1102
    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

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

    ---

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

ESCOLHER tabelas:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `yj12h_extensions`

2. 2 × SELECT c.* 
     FROM yj12h_content AS c 
     LEFT JOIN yj12h_categories AS cc 
     ON cc.id=c.catid 
     LEFT JOIN yj12h_tz_portfolio_tags_xref AS x 
     ON x.contentid=c.id 
     LEFT JOIN yj12h_tz_portfolio_tags AS t 
     ON t.id=x.tagsid

3. 2 × SELECT c.*,cc.title AS category_title,u.name AS author, 
     CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug, 
     CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, 
     CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore 
     FROM yj12h_content AS c 
     LEFT JOIN yj12h_categories AS cc 
     ON cc.id=c.catid 
     LEFT JOIN yj12h_users AS u 
     ON u.id=c.created_by

4. 1 × SELECT `data` 
     FROM `yj12h_session`

5. 1 × SELECT id, rules 
     FROM `yj12h_viewlevels

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

7. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
     FROM yj12h_extensions

8. 1 × SELECT `enabled` 
     FROM `yj12h_extensions`

9. 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 yj12h_menu AS m 
     LEFT JOIN yj12h_extensions AS e 
     ON m.component_id = e.extension_id

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

11. 1 × SELECT * 
      FROM yj12h_languages

12. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM yj12h_modules AS m 
      LEFT JOIN yj12h_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN yj12h_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

OUTRAS tabelas:

1. 1 × DELETE  
     FROM `yj12h_session`

2. 1 × UPDATE `yj12h_extensions` 
     SET `params` = '{\"mediaversion\":\"8a4ac282af5d5d2a8fcb47084a9cf258\"}'