Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726666394,
                "last": 1726666394,
                "now": 1726666394
            },
            "token": "UtYyFyoy1kyux2C36hPEEAK0DjfOqkBD"
        },
        "registry": {
            "com_tz_portfolio": {
                "tags": {
                    "ordercol": null
                }
            }
        },
        "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
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 116.43 ms / 116.43 ms Memoria: 0.202 MB / 0.58 MB Application: afterLoad

Tempo: 323.56 ms / 439.99 ms Memoria: 1.208 MB / 1.79 MB Application: afterInitialise

Tempo: 229.61 ms / 669.60 ms Memoria: 1.313 MB / 3.10 MB Application: afterRoute

Tempo: 3.27 ms / 672.87 ms Memoria: 0.058 MB / 3.16 MB Application: beforeRenderComponent com_tz_portfolio

Tempo: 78.65 ms / 751.53 ms Memoria: 1.270 MB / 4.43 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 2.98 ms / 754.51 ms Memoria: 0.058 MB / 4.48 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.06 ms / 754.57 ms Memoria: 0.000 MB / 4.48 MB Application: Before JAccess::getAssetRules (id:54 name:com_tz_portfolio)

Tempo: 2.58 ms / 757.15 ms Memoria: 0.027 MB / 4.51 MB Application: After JAccess::getAssetRules (id:54 name:com_tz_portfolio)

Tempo: 187.56 ms / 944.71 ms Memoria: 1.710 MB / 6.22 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.09 ms / 944.80 ms Memoria: 0.007 MB / 6.23 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 69.94 ms / 1014.74 ms Memoria: 1.102 MB / 7.33 MB Application: afterRenderComponent com_tz_portfolio

Tempo: 5.98 ms / 1020.72 ms Memoria: 0.127 MB / 7.45 MB Application: afterDispatch

Tempo: 92.34 ms / 1113.06 ms Memoria: 4.787 MB / 12.24 MB Application: beforeRenderModule mod_mylivechat (MyLiveChat)

Tempo: 7.51 ms / 1120.57 ms Memoria: 0.067 MB / 12.31 MB Application: afterRenderModule mod_mylivechat (MyLiveChat)

Tempo: 102.46 ms / 1223.03 ms Memoria: 0.126 MB / 12.44 MB Application: beforeRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 24.39 ms / 1247.41 ms Memoria: 0.238 MB / 12.67 MB Application: afterRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 108.09 ms / 1355.50 ms Memoria: 0.023 MB / 12.70 MB Application: beforeRenderModule mod_tz_tags (Cerca per argomento)

Tempo: 21.74 ms / 1377.24 ms Memoria: 0.158 MB / 12.85 MB Application: afterRenderModule mod_tz_tags (Cerca per argomento)

Tempo: 1.88 ms / 1379.12 ms Memoria: 0.013 MB / 12.87 MB Application: beforeRenderModule mod_tz_news_pro ( Tab Blog)

Tempo: 3.58 ms / 1382.71 ms Memoria: 0.090 MB / 12.96 MB Application: beforeRenderModule mod_tz_news_pro (NUOVI)

Tempo: 21.55 ms / 1404.26 ms Memoria: 0.225 MB / 13.18 MB Application: afterRenderModule mod_tz_news_pro (NUOVI)

Tempo: 2.39 ms / 1406.65 ms Memoria: 0.000 MB / 13.09 MB Application: beforeRenderModule mod_tz_news_pro (PIU' LETTI)

Tempo: 22.03 ms / 1428.68 ms Memoria: 0.212 MB / 13.30 MB Application: afterRenderModule mod_tz_news_pro (PIU' LETTI)

Tempo: 26.49 ms / 1455.18 ms Memoria: 0.042 MB / 13.34 MB Application: beforeRenderModule mod_tz_news_pro (NUOVI)

Tempo: 9.93 ms / 1465.10 ms Memoria: 0.188 MB / 13.53 MB Application: afterRenderModule mod_tz_news_pro (NUOVI)

Tempo: 0.57 ms / 1465.67 ms Memoria: 0.000 MB / 13.41 MB Application: beforeRenderModule mod_tz_news_pro (PIU' LETTI)

Tempo: 10.25 ms / 1475.91 ms Memoria: 0.193 MB / 13.61 MB Application: afterRenderModule mod_tz_news_pro (PIU' LETTI)

Tempo: 0.23 ms / 1476.14 ms Memoria: 0.000 MB / 13.44 MB Application: afterRenderModule mod_tz_news_pro ( Tab Blog)

Tempo: 126.85 ms / 1603.00 ms Memoria: 0.000 MB / 9.51 MB Application: afterRender

Query totali del database: 124.45 ms

Utilizzo memoria

Query Database

84 query eseguite 124.45 ms

Trovati 54 duplicati!

3 duplicati: #8 #11 #30

3 duplicati: #9 #12 #31

3 duplicati: #10 #13 #32

2 duplicati: #16 #17

2 duplicati: #20 #21

3 duplicati: #23 #24 #25

2 duplicati: #26 #27

2 duplicati: #28 #29

5 duplicati: #49 #50 #51 #69 #71

2 duplicati: #52 #72

2 duplicati: #54 #73

2 duplicati: #55 #74

2 duplicati: #56 #75

2 duplicati: #57 #76

2 duplicati: #58 #77

5 duplicati: #59 #60 #61 #70 #78

2 duplicati: #62 #79

2 duplicati: #63 #80

2 duplicati: #64 #81

2 duplicati: #65 #82

2 duplicati: #66 #83

2 duplicati: #67 #84

Tempo della query: 0.74 ms Memoria query: 0.025 MB memoria prima della query: 0.970 MB Righe restituite: 0

SELECT `data`

  FROM `ecw3r_session`

  WHERE `session_id` = '5p4ath91i330n3mq1610qjlpb5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.07 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.09 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:832
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.60 ms Dopo l'ultima query: 6.73 ms Memoria query: 0.021 MB memoria prima della query: 0.985 MB Righe restituite: 0

SELECT `session_id`

  FROM `ecw3r_session`

  WHERE `session_id` = '5p4ath91i330n3mq1610qjlpb5' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.00 ms

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.06 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.003 MB memoria prima della query: 0.989 MB

INSERT INTO `ecw3r_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('5p4ath91i330n3mq1610qjlpb5', 1, '1726666394', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5p4ath91i330n3mq1610qjlpb5', 1, '1726666394', 0, '', 0)

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.47 ms
Waiting for query cache lock	0.01 ms
update	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.08 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.96 ms Dopo l'ultima query: 46.71 ms Memoria query: 0.022 MB memoria prima della query: 1.205 MB Righe restituite: 2

SELECT b.id

  FROM ecw3r_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.06 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.68 ms Dopo l'ultima query: 5.44 ms Memoria query: 0.023 MB memoria prima della query: 1.211 MB Righe restituite: 5

SELECT id, rules

  FROM `ecw3r_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

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

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.11 ms Dopo l'ultima query: 307.92 ms Memoria query: 0.006 MB memoria prima della query: 2.680 MB

UPDATE `ecw3r_extensions`

  SET `params` = '{\"mediaversion\":\"2631dd31ee48e4153c69da07b197fb38\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.42 ms
updating	0.12 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->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:1158
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:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.73 ms Dopo l'ultima query: 117.28 ms Memoria query: 0.029 MB memoria prima della query: 4.022 MB Righe restituite: 7

SHOW FULL COLUMNS 
  FROM `ecw3r_tz_portfolio_templates`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `ecw3r_tz_portfolio_templates`

Profilo

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:41
13	TZ_PortfolioTableTemplates->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:32
11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.51 ms Dopo l'ultima query: 4.85 ms Memoria query: 0.025 MB memoria prima della query: 4.058 MB Righe restituite: 1

Query duplicate: #11 #30

SELECT COUNT(*)

  FROM ecw3r_tz_portfolio_templates

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Select tables optimized away

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:49
14	TZ_PortfolioTableTemplates->hasData()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:61
13	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.52 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.024 MB memoria prima della query: 4.066 MB Righe restituite: 1

Query duplicate: #12 #31

SELECT COUNT(*)

  FROM ecw3r_tz_portfolio_templates

  WHERE `home`= 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 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.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:67
13	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.66 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.034 MB memoria prima della query: 4.073 MB Righe restituite: 1

Query duplicate: #13 #32

SELECT *

  FROM ecw3r_tz_portfolio_templates

  WHERE `home`= 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:81
12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
10	TZ_PortfolioControllerLegacy->getView()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:40
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.44 ms Dopo l'ultima query: 10.67 ms Memoria query: 0.026 MB memoria prima della query: 4.369 MB Righe restituite: 1

Query duplicate: #8 #30

SELECT COUNT(*)

  FROM ecw3r_tz_portfolio_templates

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Select tables optimized away

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:49
15	TZ_PortfolioTableTemplates->hasData()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:61
14	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
13	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.41 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.025 MB memoria prima della query: 4.378 MB Righe restituite: 1

Query duplicate: #9 #31

SELECT COUNT(*)

  FROM ecw3r_tz_portfolio_templates

  WHERE `home`= 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.04 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:67
14	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
13	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.46 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.026 MB memoria prima della query: 4.385 MB Righe restituite: 1

Query duplicate: #10 #32

SELECT *

  FROM ecw3r_tz_portfolio_templates

  WHERE `home`= 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:81
13	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
12	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:67
11	TZ_PortfolioControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.53 ms Dopo l'ultima query: 6.74 ms Memoria query: 0.032 MB memoria prima della query: 4.431 MB Righe restituite: 39

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

  FROM `ecw3r_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_foxcontact','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_k2','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_multipurpose','com_tz_portfolio','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap') OR `parent_id` = 0

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.12 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.31 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.32 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
16	JUser->authorise()	JROOT/components/com_tz_portfolio/models/tags.php:93
15	TZ_PortfolioModelTags->populateState()	JROOT/libraries/legacy/model/legacy.php:434
14	JModelLegacy->getState()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:43
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 4.19 ms Dopo l'ultima query: 3.30 ms Memoria query: 0.038 MB memoria prima della query: 4.515 MB Righe restituite: 1

SELECT c.*,cc.title AS category_title,cc.parent_id,u.name AS author,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(c.fulltext) THEN c.fulltext ELSE null END as readmore

  FROM `ecw3r_content` AS c

  LEFT JOIN `ecw3r_categories` AS cc 
  ON cc.id = c.catid

  LEFT JOIN `ecw3r_tz_portfolio_tags_xref` AS x 
  ON c.id=x.contentid

  LEFT JOIN `ecw3r_tz_portfolio_tags` AS t 
  ON t.id=x.tagsid

  LEFT JOIN `ecw3r_users` AS u 
  ON u.id=c.created_by

  WHERE c.state = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-09-18 13:33:14') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-09-18 13:33:14') 
  AND c.access IN (1,1,5) 
  AND cc.access IN (1,1,5) 
  AND t.published=1 
  AND x.tagsid=1

  ORDER BY created DESC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	Sql1009297_1.x.contentid	1	100.00	Using index condition; Using where
1	SIMPLE	cc	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql1009297_1.c.catid	1	100.00	Using index condition; Using where
1	SIMPLE	u	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.12 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
System lock	0.07 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.07 ms
Creating tmp table	0.15 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.94 ms
Creating sort index	0.09 ms
end	0.07 ms
removing tmp table	1.37 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.06 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.07 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/components/com_tz_portfolio/models/tags.php:229
14	TZ_PortfolioModelTags->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:64
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.71 ms Dopo l'ultima query: 6.09 ms Memoria query: 0.037 MB memoria prima della query: 4.763 MB Righe restituite: 2

Query duplicate: #17

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 ecw3r_categories as c

  LEFT JOIN ecw3r_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,5) 
  AND c.published = 1 
  AND s.id=16

  GROUP BY 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

  ORDER BY c.lft

Explain

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	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.02 ms
checking query cache for query	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.14 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.28 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
15	JCategories->get()	JROOT/components/com_tz_portfolio/models/tags.php:239
14	TZ_PortfolioModelTags->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:64
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.98 ms Dopo l'ultima query: 3.08 ms Memoria query: 0.038 MB memoria prima della query: 4.866 MB Righe restituite: 2

Query duplicate: #16

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 ecw3r_categories as c

  LEFT JOIN ecw3r_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,5) 
  AND c.published = 1 
  AND s.id=16

  GROUP BY 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

  ORDER BY c.lft

Explain

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	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.22 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
16	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:92
15	TZ_PortfolioHelperRoute::getPortfolioArticleRoute()	JROOT/components/com_tz_portfolio/models/tags.php:306
14	TZ_PortfolioModelTags->getItems()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:64
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.93 ms Dopo l'ultima query: 184.65 ms Memoria query: 0.030 MB memoria prima della query: 6.538 MB Righe restituite: 0

SELECT *

  FROM `ecw3r_extensions`

  WHERE `enabled`=1 
  AND `type`='plugin' 
  AND `folder`='tz_portfolio'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_extensions	ref	extension	extension	62	const	113	100.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.23 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.34 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:101
15	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
14	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
13	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:288
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.36 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.025 MB memoria prima della query: 6.547 MB Righe restituite: 0

SELECT p.*,x.element

  FROM `ecw3r_tz_portfolio_plugin` AS p

  LEFT JOIN `ecw3r_extensions` AS x 
  ON p.pluginid = x.extension_id

  WHERE x.enabled = 1 
  AND x.folder = 'tz_portfolio' 
  AND p.contentid IN(15)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.26 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.15 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
13	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:288
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.72 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.026 MB memoria prima della query: 6.550 MB Righe restituite: 1

Query duplicate: #21

SELECT * 
  FROM ecw3r_tz_portfolio_tags 
  WHERE id=1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 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.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/components/com_tz_portfolio/models/tags.php:428
14	TZ_PortfolioModelTags->getTag()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:306
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.71 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.026 MB memoria prima della query: 6.558 MB Righe restituite: 1

Query duplicate: #20

SELECT * 
  FROM ecw3r_tz_portfolio_tags 
  WHERE id=1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/tags.php:432
14	TZ_PortfolioModelTags->getTag()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:306
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.19 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.026 MB memoria prima della query: 6.578 MB Righe restituite: 1

SELECT COUNT(*)

  FROM `ecw3r_content` AS c

  LEFT JOIN `ecw3r_categories` AS cc 
  ON cc.id = c.catid

  LEFT JOIN `ecw3r_tz_portfolio_tags_xref` AS x 
  ON c.id=x.contentid

  LEFT JOIN `ecw3r_tz_portfolio_tags` AS t 
  ON t.id=x.tagsid

  LEFT JOIN `ecw3r_users` AS u 
  ON u.id=c.created_by

  WHERE c.state = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-09-18 13:33:14') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-09-18 13:33:14') 
  AND c.access IN (1,1,5) 
  AND cc.access IN (1,1,5) 
  AND t.published=1 
  AND x.tagsid=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	Sql1009297_1.x.contentid	1	100.00	Using index condition; Using where
1	SIMPLE	cc	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql1009297_1.c.catid	1	100.00	Using index condition; Using where
1	SIMPLE	u	index	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.04 ms
optimizing	0.05 ms
statistics	0.15 ms
preparing	0.08 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.06 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
14	JModelList->getPagination()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:308
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.62 ms Dopo l'ultima query: 8.28 ms Memoria query: 0.027 MB memoria prima della query: 7.002 MB Righe restituite: 1

Query duplicate: #24 #25

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
19	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:412
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.41 ms Dopo l'ultima query: 6.87 ms Memoria query: 0.027 MB memoria prima della query: 7.136 MB Righe restituite: 1

Query duplicate: #23 #25

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
19	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
15	JRouter->build()	JROOT/libraries/cms/router/site.php:149
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:414
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.39 ms Dopo l'ultima query: 5.82 ms Memoria query: 0.028 MB memoria prima della query: 7.181 MB Righe restituite: 1

Query duplicate: #23 #24

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
23	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
22	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
21	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
20	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
19	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php:55
15	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
13	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:417
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.05 ms Dopo l'ultima query: 7.16 ms Memoria query: 0.039 MB memoria prima della query: 7.388 MB Righe restituite: 1

Query duplicate: #27

SELECT c.featured,xc.*,c.catid,c.attribs AS param,c.title AS c_title

  FROM ecw3r_tz_portfolio_xref_content AS xc

  LEFT JOIN ecw3r_content AS c 
  ON c.id=xc.contentid

  WHERE c.state = 1 
  AND xc.contentid=15

Explain

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	NULL
1	SIMPLE	xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.23 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/media.php:102
18	TZ_PortfolioModelMedia->getMedia()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php:29
17	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
16	JViewLegacy->loadTemplate()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php:73
15	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
13	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:417
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.58 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.039 MB memoria prima della query: 7.398 MB Righe restituite: 1

Query duplicate: #26

SELECT c.featured,xc.*,c.catid,c.attribs AS param,c.title AS c_title

  FROM ecw3r_tz_portfolio_xref_content AS xc

  LEFT JOIN ecw3r_content AS c 
  ON c.id=xc.contentid

  WHERE c.state = 1 
  AND xc.contentid=15

Explain

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	NULL
1	SIMPLE	xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT/components/com_tz_portfolio/models/media.php:107
18	TZ_PortfolioModelMedia->getMedia()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php:29
17	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
16	JViewLegacy->loadTemplate()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php:73
15	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
13	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:417
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.57 ms Dopo l'ultima query: 3.63 ms Memoria query: 0.029 MB memoria prima della query: 7.410 MB Righe restituite: 0

Query duplicate: #29

SELECT t.*,f.title 
  FROM ecw3r_tz_portfolio AS t 
  LEFT JOIN ecw3r_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN ecw3r_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=15 
  ORDER BY f.id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
19	JDatabase->query()	JROOT/components/com_tz_portfolio/models/extrafields.php:116
18	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php:216
17	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
16	JViewLegacy->loadTemplate()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php:73
15	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
13	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:417
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.32 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.029 MB memoria prima della query: 7.421 MB Righe restituite: 0

Query duplicate: #28

SELECT t.*,f.title 
  FROM ecw3r_tz_portfolio AS t 
  LEFT JOIN ecw3r_tz_portfolio_fields AS f 
  ON f.id=t.fieldsid 
  LEFT JOIN ecw3r_content AS c 
  ON c.id=t.contentid 
  WHERE c.state=1 
  AND t.contentid=15 
  ORDER BY f.id DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/extrafields.php:120
18	TZ_PortfolioModelExtraFields->getExtraFields()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php:216
17	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default_item.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
16	JViewLegacy->loadTemplate()	JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php:73
15	include JROOT/components/com_tz_portfolio/views/tags/tmpl/default.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
14	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
13	JViewLegacy->display()	JROOT/components/com_tz_portfolio/views/tags/view.html.php:417
12	TZ_PortfolioViewTags->display()	JROOT/libraries/joomla/cache/controller/view.php:98
11	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
10	JControllerLegacy->display()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:52
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.32 ms Dopo l'ultima query: 8.31 ms Memoria query: 0.025 MB memoria prima della query: 7.327 MB Righe restituite: 1

Query duplicate: #8 #11

SELECT COUNT(*)

  FROM ecw3r_tz_portfolio_templates

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	Select tables optimized away

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:49
14	TZ_PortfolioTableTemplates->hasData()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:61
13	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:114
10	TZ_PortfolioControllerLegacy->parseDocument()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:56
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.28 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.024 MB memoria prima della query: 7.335 MB Righe restituite: 1

Query duplicate: #9 #12

SELECT COUNT(*)

  FROM ecw3r_tz_portfolio_templates

  WHERE `home`= 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:67
13	TZ_PortfolioTableTemplates->_hasHome()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:75
12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:114
10	TZ_PortfolioControllerLegacy->parseDocument()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:56
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.46 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.026 MB memoria prima della query: 7.341 MB Righe restituite: 1

Query duplicate: #10 #13

SELECT *

  FROM ecw3r_tz_portfolio_templates

  WHERE `home`= 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_tz_portfolio_templates	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.06 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_tz_portfolio/tables/templates.php:81
12	TZ_PortfolioTableTemplates->getHome()	JROOT/administrator/components/com_tz_portfolio/libraries/core/template.php:44
11	TZ_PortfolioTemplate::getTemplate()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:114
10	TZ_PortfolioControllerLegacy->parseDocument()	JROOT/administrator/components/com_tz_portfolio/libraries/core/controller.php:56
9	TZ_PortfolioControllerLegacy->display()	JROOT/components/com_tz_portfolio/controller.php:113
8	TZ_PortfolioController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tz_portfolio/tz_portfolio.php:36
6	require_once JROOT/components/com_tz_portfolio/tz_portfolio.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 15.68 ms Dopo l'ultima query: 46.94 ms Memoria query: 0.037 MB memoria prima della query: 7.976 MB Righe restituite: 20

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

  FROM ecw3r_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-09-18 13:33:14') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-18 13:33:14') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 145 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	191	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	Sql1009297_1.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql1009297_1.m.id	3	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.02 ms
Waiting on query cache mutex	0.00 ms
System lock	0.05 ms
optimizing	0.05 ms
statistics	0.12 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	5.57 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	8.38 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.08 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:424
17	JModuleHelper::_load()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:102
16	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
15	JDocumentHtml->countModules()	JROOT/plugins/system/plazart/includes/core/template.php:1471
14	PlazartTemplate::countModules()	JROOT/plugins/system/plazart/includes/core/template.php:998
13	PlazartTemplate::showRow()	JROOT/plugins/system/plazart/includes/core/template.php:1118
12	PlazartTemplate->generatelayout()	JROOT/plugins/system/plazart/includes/core/template.php:1445
11	PlazartTemplate::layout()	JROOT/templates/tz_jollyany_joomla/layouts/default.php:38
10	include JROOT/templates/tz_jollyany_joomla/layouts/default.php	JROOT/plugins/system/plazart/includes/core/template.php:138
9	PlazartTemplate->loadLayout()	JROOT/templates/tz_jollyany_joomla/libraries/plazart.render.php:67
8	PlazartRender->__construct()	JROOT/templates/tz_jollyany_joomla/index.php:26
7	require JROOT/templates/tz_jollyany_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:1105
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 4.44 ms Dopo l'ultima query: 162.35 ms Memoria query: 0.058 MB memoria prima della query: 12.600 MB Righe restituite: 6

SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.*

  FROM ecw3r_content as ct

  LEFT JOIN ecw3r_categories as cat 
  on cat.id = ct.catid

  LEFT JOIN ecw3r_users as us 
  on us.id = ct.created_by

  LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
  on tz_xc.contentid = ct.id

  WHERE (tz_xc.type not in('audio','quote','link') or tz_xc.type is null) 
  AND  ct.catid IN(8) 
  and ct.state = 1  
  ORDER BY ct.created DESC 
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ct	index_merge	idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	5	80.00	Using intersect(idx_catid,idx_state); Using where; Using temporary; Using filesort
1	SIMPLE	cat	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	us	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	tz_xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where; Using join buffer (Block Nested Loop)

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.06 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.13 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	2.50 ms
Creating sort index	0.10 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
Creating sort index	0.10 ms
end	0.06 ms
removing tmp table	0.50 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.06 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tz_news_pro/helper.php:105
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.85 ms Dopo l'ultima query: 0.84 ms Memoria query: 0.036 MB memoria prima della query: 12.691 MB Righe restituite: 2

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 ecw3r_categories as c

  LEFT JOIN ecw3r_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,5) 
  AND c.published = 1 
  AND s.id=8

  GROUP BY 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

  ORDER BY c.lft

Explain

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	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.02 ms
checking query cache for query	0.23 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.14 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.07 ms
optimizing	0.03 ms
statistics	0.23 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.10 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.02 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
13	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:45
12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/modules/mod_tz_news_pro/helper.php:148
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.71 ms Dopo l'ultima query: 117.25 ms Memoria query: 0.025 MB memoria prima della query: 12.732 MB Righe restituite: 13

SELECT COUNT(tag.name) as total, tag.name as tag, tag.id as id  
  FROM ecw3r_tz_portfolio_tags_xref tagx
        
  LEFT JOIN ecw3r_tz_portfolio_tags tag 
  ON (tagx.tagsid = tag.id)
        
  LEFT JOIN ecw3r_content cont 
  ON (tagx.contentid = cont.id)
        
  WHERE cont.catid in(8,9) 
  group by tag.name

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tagx	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using temporary; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.tagx.tagsid	1	100.00	NULL
1	SIMPLE	cont	eq_ref	PRIMARY,idx_catid	PRIMARY	4	Sql1009297_1.tagx.contentid	1	100.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.07 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	1.93 ms
Creating sort index	0.05 ms
end	0.01 ms
removing tmp table	0.80 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tz_tags/helper.php:56
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.19 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.027 MB memoria prima della query: 12.748 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=11

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 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.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.78 ms Dopo l'ultima query: 0.38 ms Memoria query: 0.027 MB memoria prima della query: 12.758 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=3

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.12 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.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.66 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.027 MB memoria prima della query: 12.769 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=8

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 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.03 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.62 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.027 MB memoria prima della query: 12.779 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=2

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.74 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.027 MB memoria prima della query: 12.789 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=4

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.02 ms
Waiting on query cache mutex	0.04 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.13 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.59 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.027 MB memoria prima della query: 12.799 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=5

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.60 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.027 MB memoria prima della query: 12.810 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=20

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.76 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.027 MB memoria prima della query: 12.820 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=9

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 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.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.23 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.11 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.60 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.027 MB memoria prima della query: 12.830 MB Righe restituite: 1

SELECT name

  FROM ecw3r_tz_portfolio_tags

  WHERE id=7

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/components/com_tz_portfolio/router.php:249
18	TZ_PortfolioBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_tz_tags/helper.php:65
11	modTzTagsHelper::getList()	JROOT/modules/mod_tz_tags/mod_tz_tags.php:31
10	include JROOT/modules/mod_tz_tags/mod_tz_tags.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.59 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.027 MB memoria prima della query: 12.841 MB Righe restituite: 1

Piscina in residence Feature

Seguici su Facebook

Cosa fa Sandrini?

Resta aggiornato

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

84 query eseguite 124.45 ms

Trovati 54 duplicati!