{
    "__default": {
        "session": {
            "counter": 108,
            "timer": {
                "start": 1583343311,
                "last": 1583345804,
                "now": 1583345808
            },
            "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
                }
            },
            "formtime": 1583345804
        },
        "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

37 pedidos registados 11.57 ms

1. Tempo da consulta: 0.23 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 0.759 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.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   Unlocking tables	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.03 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: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]

   ---

2. Tempo da consulta: 0.35 ms Após a última consulta: 0.75 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.894 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.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.11 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.02 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
   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]

   ---

3. Tempo da consulta: 0.19 ms Após a última consulta: 0.59 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.945 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.01 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 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]

   ---

4. Tempo da consulta: 0.18 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.957 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.02 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 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]

   ---

5. Tempo da consulta: 0.57 ms Após a última consulta: 0.11 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 0.978 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.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.29 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
   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]

   ---

6. Tempo da consulta: 0.21 ms Após a última consulta: 4.04 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 1.395 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.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 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
   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]

   ---

7. Tempo da consulta: 0.48 ms Após a última consulta: 1.61 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 1.566 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.03 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.25 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 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
   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]

   ---

8. Tempo da consulta: 0.28 ms Após a última consulta: 2.67 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 1.893 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.03 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 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
   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]

   ---

9. Tempo da consulta: 0.24 ms Após a última consulta: 1.76 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.024 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.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 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/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]

   ---

10. Tempo da consulta: 0.43 ms Após a última consulta: 0.08 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 2.015 MB

    UPDATE `yj12h_extensions`
    
      SET `params` = '{\"mediaversion\":\"e3cec688c795de8155554fdb054ebcb4\"}'
    
      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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.03 ms
    updating	0.03 ms
    end	0.01 ms
    query end	0.27 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 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]

    ---

11. Tempo da consulta: 0.18 ms Após a última consulta: 0.28 ms Consulta a Memória: 0.003 MB de memória antes da consulta: 2.065 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.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 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]

    ---

12. Tempo da consulta: 0.51 ms Após a última consulta: 4.07 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 2.419 MB Linhas devolvidas: 41

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `yj12h_assets`
    
      WHERE `name` IN ('com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_jsecurelite','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_tz_media','com_tz_portfolio','com_uniform','com_users','com_weblinks','com_wgpicasa','com_wrapper','com_youtubegallery') OR `parent_id` = 0

    Explica

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

    Perfil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    14	JUser->authorise()	JROOT/components/com_tz_portfolio/models/media.php:35
    13	TZ_PortfolioModelMedia->populateState()	JROOT/libraries/legacy/model/legacy.php:434
    12	JModelLegacy->getState()	JROOT/components/com_tz_portfolio/models/media.php:66
    11	TZ_PortfolioModelMedia->getMedia()	JROOT/components/com_tz_portfolio/views/article/view.html.php:49
    10	TZ_PortfolioViewArticle->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]

    ---

13. Tempo da consulta: 0.26 ms Após a última consulta: 0.28 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.487 MB Linhas devolvidas: 1
    Consultas duplicadas: #14

    SELECT c.featured,xc.*,c.catid,c.attribs AS param
    
      FROM yj12h_tz_portfolio_xref_content AS xc
    
      LEFT JOIN yj12h_content AS c 
      ON c.id=xc.contentid
    
      WHERE c.state = 1 
      AND xc.contentid=17

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00
    1	SIMPLE	xc	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	91	100.00	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/media.php:99
    11	TZ_PortfolioModelMedia->getMedia()	JROOT/components/com_tz_portfolio/views/article/view.html.php:49
    10	TZ_PortfolioViewArticle->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.24 ms Após a última consulta: 0.04 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.493 MB Linhas devolvidas: 1
    Consultas duplicadas: #13

    SELECT c.featured,xc.*,c.catid,c.attribs AS param
    
      FROM yj12h_tz_portfolio_xref_content AS xc
    
      LEFT JOIN yj12h_content AS c 
      ON c.id=xc.contentid
    
      WHERE c.state = 1 
      AND xc.contentid=17

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00
    1	SIMPLE	xc	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	91	100.00	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    12	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/media.php:104
    11	TZ_PortfolioModelMedia->getMedia()	JROOT/components/com_tz_portfolio/views/article/view.html.php:49
    10	TZ_PortfolioViewArticle->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.22 ms Após a última consulta: 0.25 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.505 MB Linhas devolvidas: 1
    Consultas duplicadas: #16

    SELECT xc.*,c.attribs AS param 
      FROM yj12h_tz_portfolio_xref_content AS xc 
      LEFT JOIN yj12h_content AS c 
      ON c.id=xc.contentid 
      WHERE c.state=1 
      AND xc.contentid=17

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00
    1	SIMPLE	xc	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	91	100.00	Using where

    Perfil

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

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/attachments.php:40
    11	TZ_PortfolioModelAttachments->getAttachments()	JROOT/components/com_tz_portfolio/views/article/view.html.php:56
    10	TZ_PortfolioViewArticle->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.21 ms Após a última consulta: 0.02 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.512 MB Linhas devolvidas: 1
    Consultas duplicadas: #15

    SELECT xc.*,c.attribs AS param 
      FROM yj12h_tz_portfolio_xref_content AS xc 
      LEFT JOIN yj12h_content AS c 
      ON c.id=xc.contentid 
      WHERE c.state=1 
      AND xc.contentid=17

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00
    1	SIMPLE	xc	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	91	100.00	Using where

    Perfil

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

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    12	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/attachments.php:44
    11	TZ_PortfolioModelAttachments->getAttachments()	JROOT/components/com_tz_portfolio/views/article/view.html.php:56
    10	TZ_PortfolioViewArticle->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.19 ms Após a última consulta: 0.06 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.520 MB Linhas devolvidas: 0
    Consultas duplicadas: #18

    SELECT u.id,u.name,u.email,tu.images,tu.url,tu.gender,tu.description,tu.twitter,tu.facebook,tu.google_one 
      FROM yj12h_users AS u 
      LEFT JOIN yj12h_tz_portfolio_users AS tu 
      ON tu.usersid=u.id 
      LEFT JOIN yj12h_content AS c 
      ON c.created_by=u.id 
      WHERE c.id=17

    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.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	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.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/user.php:40
    11	TZ_PortfolioModelUser->getUser()	JROOT/components/com_tz_portfolio/views/article/view.html.php:57
    10	TZ_PortfolioViewArticle->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]

    ---

18. Tempo da consulta: 0.17 ms Após a última consulta: 0.02 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.527 MB Linhas devolvidas: 0
    Consultas duplicadas: #17

    SELECT u.id,u.name,u.email,tu.images,tu.url,tu.gender,tu.description,tu.twitter,tu.facebook,tu.google_one 
      FROM yj12h_users AS u 
      LEFT JOIN yj12h_tz_portfolio_users AS tu 
      ON tu.usersid=u.id 
      LEFT JOIN yj12h_content AS c 
      ON c.created_by=u.id 
      WHERE c.id=17

    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.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	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.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    12	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/user.php:45
    11	TZ_PortfolioModelUser->getUser()	JROOT/components/com_tz_portfolio/views/article/view.html.php:57
    10	TZ_PortfolioViewArticle->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]

    ---

19. Tempo da consulta: 0.15 ms Após a última consulta: 0.07 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.533 MB Linhas devolvidas: 0
    Consultas duplicadas: #20

    SELECT t.* 
      FROM yj12h_tz_portfolio_tags AS t 
      INNER JOIN yj12h_tz_portfolio_tags_xref AS x 
      ON t.id=x.tagsid 
      WHERE t.published=1 
      AND x.contentid=17

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	x	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	44	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.x.tagsid	1	100.00	Using where

    Perfil

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

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/tag.php:38
    11	TZ_PortfolioModelTag->getTag()	JROOT/components/com_tz_portfolio/views/article/view.html.php:58
    10	TZ_PortfolioViewArticle->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]

    ---

20. Tempo da consulta: 0.14 ms Após a última consulta: 0.01 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.539 MB Linhas devolvidas: 0
    Consultas duplicadas: #19

    SELECT t.* 
      FROM yj12h_tz_portfolio_tags AS t 
      INNER JOIN yj12h_tz_portfolio_tags_xref AS x 
      ON t.id=x.tagsid 
      WHERE t.published=1 
      AND x.contentid=17

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	x	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	44	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.x.tagsid	1	100.00	Using where

    Perfil

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

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/tag.php:43
    11	TZ_PortfolioModelTag->getTag()	JROOT/components/com_tz_portfolio/views/article/view.html.php:58
    10	TZ_PortfolioViewArticle->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]

    ---

21. Tempo da consulta: 0.71 ms Após a última consulta: 0.20 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.560 MB Linhas devolvidas: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM yj12h_content AS a
    
      LEFT JOIN yj12h_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN yj12h_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN (
    SELECT contact.user_id, MAX(contact.id) AS id, contact.language
    
      FROM yj12h_contact_details AS contact
    
      WHERE contact.published = 1
    
      GROUP BY contact.user_id, contact.language) AS contact 
      ON contact.user_id = a.created_by
    
      LEFT JOIN yj12h_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN yj12h_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM yj12h_categories AS cat JOIN yj12h_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 17 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-03-04 18:16:48') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-03-04 18:16:48') 
      AND (a.state = 1 OR a.state =2)

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	0.00	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	PRIMARY	<derived3>	ref	key0	key0	5	const	3	100.00	Using where
    3	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	100.00	Using index condition; Using temporary; Filesort em utilização
    3	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	31	100.00	Using where; Using index; Using join buffer (flat, BNL join)
    2	DERIVED	contact	ref	idx_state	idx_state	1	const	1	100.00	Using where; Using temporary; Filesort em utilização

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    removing tmp table	0.01 ms
    Creating sort index	0.02 ms
    executing	0.00 ms
    Sending data	0.05 ms
    Creating sort index	0.01 ms
    removing tmp table	0.01 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 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/driver.php:1642
    13	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/article.php:249
    12	TZ_PortfolioModelArticle->getItem()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/article/view.html.php:64
    10	TZ_PortfolioViewArticle->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]

    ---

22. Tempo da consulta: 0.36 ms Após a última consulta: 0.24 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.589 MB Linhas devolvidas: 2
    Consultas duplicadas: #25

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM yj12h_categories as c
    
      LEFT JOIN yj12h_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=11
    
      ORDER BY c.lft

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	31	29.03	Using where; Filesort em utilização

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    Sorting result	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_tz_portfolio/models/article.php:269
    12	TZ_PortfolioModelArticle->getItem()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/article/view.html.php:64
    10	TZ_PortfolioViewArticle->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]

    ---

23. Tempo da consulta: 0.86 ms Após a última consulta: 0.25 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.619 MB Linhas devolvidas: 3
    Consultas duplicadas: #24

    SELECT c.*,
      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 
      FROM yj12h_content AS c 
      LEFT JOIN yj12h_categories AS cc 
      ON cc.id=c.catid 
      LEFT JOIN yj12h_tz_portfolio_xref_content AS x 
      ON x.contentid = c.id 
      WHERE c.state = 1 
      AND NOT c.id=17 
      AND NOT type='quote' 
      AND NOT type='link' 
      AND c.catid=11 
      ORDER BY c.created DESC 
      LIMIT 0, 9

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	PRIMARY,idx_state,idx_catid	idx_catid	4	const	9	100.00	Using index condition; Using where; Using temporary; Filesort em utilização
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	x	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	91	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.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.40 ms
    Creating sort index	0.04 ms
    removing tmp table	0.11 ms
    Creating sort index	0.01 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 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/article.php:149
    12	TZ_PortfolioModelArticle->getItemRelated()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/article/view.html.php:65
    10	TZ_PortfolioViewArticle->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]

    ---

24. Tempo da consulta: 0.78 ms Após a última consulta: 0.02 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.626 MB Linhas devolvidas: 3
    Consultas duplicadas: #23

    SELECT c.*,
      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 
      FROM yj12h_content AS c 
      LEFT JOIN yj12h_categories AS cc 
      ON cc.id=c.catid 
      LEFT JOIN yj12h_tz_portfolio_xref_content AS x 
      ON x.contentid = c.id 
      WHERE c.state = 1 
      AND NOT c.id=17 
      AND NOT type='quote' 
      AND NOT type='link' 
      AND c.catid=11 
      ORDER BY c.created DESC 
      LIMIT 0, 9

    Explica

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

    Perfil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.35 ms
    Creating sort index	0.04 ms
    removing tmp table	0.07 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.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/article.php:154
    12	TZ_PortfolioModelArticle->getItemRelated()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/article/view.html.php:65
    10	TZ_PortfolioViewArticle->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]

    ---

25. Tempo da consulta: 0.32 ms Após a última consulta: 0.27 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.670 MB Linhas devolvidas: 2
    Consultas duplicadas: #22

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM yj12h_categories as c
    
      LEFT JOIN yj12h_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=11
    
      ORDER BY c.lft

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	31	29.03	Using where; Filesort em utilização

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Unlocking tables	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    12	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:41
    11	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/components/com_tz_portfolio/views/article/view.html.php:156
    10	TZ_PortfolioViewArticle->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]

    ---

26. Tempo da consulta: 0.42 ms Após a última consulta: 1.34 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 2.759 MB Linhas devolvidas: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM yj12h_fields AS a
    
      LEFT JOIN `yj12h_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN yj12h_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN yj12h_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN yj12h_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN yj12h_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `yj12h_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_tz_portfolio.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (11,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Filesort em utilização
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	mototuri_portal.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.a.checked_out	1	100.00
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	mototuri_portal.a.id	1	100.00	Using where; Using index

    Perfil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 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.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
    16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_tz_portfolio/views/article/view.html.php:314
    10	TZ_PortfolioViewArticle->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]

    ---

27. Tempo da consulta: 0.26 ms Após a última consulta: 0.51 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.871 MB Linhas devolvidas: 3

    SELECT *
    
      FROM `yj12h_extensions`
    
      WHERE `enabled`=1 
      AND `type`='plugin' 
      AND `folder`='tz_portfolio'

    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

    Perfil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:100
    13	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
    12	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
    11	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/article/view.html.php:336
    10	TZ_PortfolioViewArticle->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]

    ---

28. Tempo da consulta: 0.20 ms Após a última consulta: 0.06 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.888 MB Linhas devolvidas: 1

    SELECT p.*,x.element
    
      FROM `yj12h_tz_portfolio_plugin` AS p
    
      LEFT JOIN `yj12h_extensions` AS x 
      ON p.pluginid = x.extension_id
    
      WHERE x.enabled = 1 
      AND x.folder = 'tz_portfolio' 
      AND p.contentid IN(17)

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	p	ALL	NULL	Nehnuma INDEX KEY pode ser utilizada	NULL	NULL	91	100.00	Using where
    1	SIMPLE	x	eq_ref	PRIMARY	PRIMARY	4	mototuri_portal.p.pluginid	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
    11	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/article/view.html.php:336
    10	TZ_PortfolioViewArticle->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]

    ---

29. Tempo da consulta: 0.33 ms Após a última consulta: 0.12 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.889 MB

    UPDATE yj12h_content 
      SET hits = hits + 1 
      WHERE id = 17

    Explica

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yj12h_content	range	PRIMARY	PRIMARY	4	NULL	1	100.00	Using where

    Perfil

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

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/article.php:371
    11	TZ_PortfolioModelArticle->hit()	JROOT/components/com_tz_portfolio/views/article/view.html.php:356
    10	TZ_PortfolioViewArticle->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]

    ---

30. Tempo da consulta: 0.18 ms Após a última consulta: 0.16 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.898 MB Linhas devolvidas: 0
    Consultas duplicadas: #31  #34  #35

    SELECT t.*,f.title 
      FROM yj12h_tz_portfolio AS t 
      LEFT JOIN yj12h_tz_portfolio_fields AS f 
      ON f.id=t.fieldsid 
      LEFT JOIN yj12h_content AS c 
      ON c.id=t.contentid 
      WHERE c.state=1 
      AND t.contentid=17 
      ORDER BY f.id DESC

    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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:109
    11	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/components/com_tz_portfolio/views/article/view.html.php:394
    10	TZ_PortfolioViewArticle->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]

    ---

31. Tempo da consulta: 0.16 ms Após a última consulta: 0.02 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.905 MB Linhas devolvidas: 0
    Consultas duplicadas: #30  #34  #35

    SELECT t.*,f.title 
      FROM yj12h_tz_portfolio AS t 
      LEFT JOIN yj12h_tz_portfolio_fields AS f 
      ON f.id=t.fieldsid 
      LEFT JOIN yj12h_content AS c 
      ON c.id=t.contentid 
      WHERE c.state=1 
      AND t.contentid=17 
      ORDER BY f.id DESC

    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.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	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.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/extrafields.php:113
    11	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/components/com_tz_portfolio/views/article/view.html.php:394
    10	TZ_PortfolioViewArticle->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]

    ---

32. Tempo da consulta: 0.14 ms Após a última consulta: 0.03 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.911 MB Linhas devolvidas: 1
    Consultas duplicadas: #33

    SELECT params 
      FROM yj12h_categories 
      WHERE id=11

    Explica

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

    Perfil

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

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/media.php:50
    11	TZ_PortfolioModelMedia->getCatParams()	JROOT/components/com_tz_portfolio/views/article/view.html.php:396
    10	TZ_PortfolioViewArticle->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]

    ---

33. Tempo da consulta: 0.13 ms Após a última consulta: 0.02 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 2.923 MB Linhas devolvidas: 1
    Consultas duplicadas: #32

    SELECT params 
      FROM yj12h_categories 
      WHERE id=11

    Explica

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

    Perfil

    Status	Duration
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.00 ms
    Unlocking tables	0.01 ms
    executing	0.00 ms
    Sending data	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.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    12	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/media.php:54
    11	TZ_PortfolioModelMedia->getCatParams()	JROOT/components/com_tz_portfolio/views/article/view.html.php:396
    10	TZ_PortfolioViewArticle->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]

    ---

34. Tempo da consulta: 0.17 ms Após a última consulta: 0.16 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.944 MB Linhas devolvidas: 0
    Consultas duplicadas: #30  #31  #35

    SELECT t.*,f.title 
      FROM yj12h_tz_portfolio AS t 
      LEFT JOIN yj12h_tz_portfolio_fields AS f 
      ON f.id=t.fieldsid 
      LEFT JOIN yj12h_content AS c 
      ON c.id=t.contentid 
      WHERE c.state=1 
      AND t.contentid=17 
      ORDER BY f.id DESC

    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.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	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.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:109
    11	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/components/com_tz_portfolio/views/article/view.html.php:596
    10	TZ_PortfolioViewArticle->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]

    ---

35. Tempo da consulta: 0.16 ms Após a última consulta: 0.02 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 2.951 MB Linhas devolvidas: 0
    Consultas duplicadas: #30  #31  #34

    SELECT t.*,f.title 
      FROM yj12h_tz_portfolio AS t 
      LEFT JOIN yj12h_tz_portfolio_fields AS f 
      ON f.id=t.fieldsid 
      LEFT JOIN yj12h_content AS c 
      ON c.id=t.contentid 
      WHERE c.state=1 
      AND t.contentid=17 
      ORDER BY f.id DESC

    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.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/extrafields.php:113
    11	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/components/com_tz_portfolio/views/article/view.html.php:596
    10	TZ_PortfolioViewArticle->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]

    ---

36. Tempo da consulta: 0.66 ms Após a última consulta: 9.93 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 3.094 MB Linhas devolvidas: 14

    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:16:48') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-03-04 18:16:48') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 178 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.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.04 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.33 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 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
    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]

    ---

37. Tempo da consulta: 0.26 ms Após a última consulta: 4.87 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 3.417 MB Linhas devolvidas: 1

    SELECT catid 
      FROM yj12h_content AS c 
      WHERE c.id = 17 
      LIMIT 1

    Explica

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

    Perfil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.01 ms
    Sending data	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.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Chamada de dados

    #	Chamador	Ficheiro e número da linha
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    10	JDatabaseDriver->loadObjectList()	JROOT/templates/tz_eventory_joomla/libraries/helpers/social.php:48
    9	TZTemplateSocial->socialApiParser()	JROOT/templates/tz_eventory_joomla/libraries/plazart.render.php:68
    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]

    ---