Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726674863,
                "last": 1726674863,
                "now": 1726674863
            },
            "token": "z281w349ZuM7G2Vn5Qn5Cb15J5zJ9g7U"
        },
        "registry": {
            "com_tz_portfolio": {
                "portfolio": {
                    "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: 99.16 ms / 99.16 ms Memoria: 0.202 MB / 0.58 MB Application: afterLoad

Tempo: 276.75 ms / 375.92 ms Memoria: 1.211 MB / 1.79 MB Application: afterInitialise

Tempo: 218.03 ms / 593.95 ms Memoria: 1.283 MB / 3.07 MB Application: afterRoute

Tempo: 2.41 ms / 596.37 ms Memoria: 0.059 MB / 3.13 MB Application: beforeRenderComponent com_tz_portfolio

Tempo: 75.62 ms / 671.99 ms Memoria: 1.449 MB / 4.58 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 3.44 ms / 675.43 ms Memoria: 0.058 MB / 4.64 MB Application: After JAccess::preloadComponents (all components)

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

Tempo: 2.69 ms / 678.18 ms Memoria: 0.027 MB / 4.66 MB Application: After JAccess::getAssetRules (id:54 name:com_tz_portfolio)

Tempo: 184.10 ms / 862.28 ms Memoria: 2.054 MB / 6.72 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.07 ms / 862.35 ms Memoria: 0.007 MB / 6.72 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 129.41 ms / 991.76 ms Memoria: 1.351 MB / 8.07 MB Application: afterRenderComponent com_tz_portfolio

Tempo: 6.50 ms / 998.26 ms Memoria: 0.130 MB / 8.21 MB Application: afterDispatch

Tempo: 144.26 ms / 1142.53 ms Memoria: 15.917 MB / 24.12 MB Application: beforeRenderModule mod_menu (Footer Menu)

Tempo: 18.20 ms / 1160.73 ms Memoria: 0.119 MB / 24.24 MB Application: afterRenderModule mod_menu (Footer Menu)

Tempo: 3.87 ms / 1164.59 ms Memoria: 0.000 MB / 24.22 MB Application: beforeRenderModule mod_mylivechat (MyLiveChat)

Tempo: 3.86 ms / 1168.45 ms Memoria: 0.020 MB / 24.24 MB Application: afterRenderModule mod_mylivechat (MyLiveChat)

Tempo: 313.41 ms / 1481.86 ms Memoria: 0.144 MB / 24.38 MB Application: beforeRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 34.23 ms / 1516.09 ms Memoria: 0.226 MB / 24.61 MB Application: afterRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 363.97 ms / 1880.06 ms Memoria: 0.055 MB / 24.67 MB Application: beforeRenderModule mod_custom (Per e aziende e con le aziende, ti aiutiamo a lavorare meglio.)

Tempo: 4.46 ms / 1884.53 ms Memoria: 0.005 MB / 24.67 MB Application: afterRenderModule mod_custom (Per e aziende e con le aziende, ti aiutiamo a lavorare meglio.)

Tempo: 154.62 ms / 2039.14 ms Memoria: 0.000 MB / 9.74 MB Application: afterRender

Query totali del database: 109.09 ms

Utilizzo memoria

Query Database

88 query eseguite 109.09 ms

Trovati 67 duplicati!

3 duplicati: #9 #12 #84

3 duplicati: #10 #13 #85

3 duplicati: #11 #14 #86

2 duplicati: #17 #18

6 duplicati: #19 #23 #27 #31 #35 #39

2 duplicati: #21 #22

2 duplicati: #25 #26

2 duplicati: #29 #30

2 duplicati: #33 #34

2 duplicati: #37 #38

2 duplicati: #41 #42

2 duplicati: #43 #44

4 duplicati: #48 #49 #50 #51

2 duplicati: #52 #53

4 duplicati: #54 #55 #56 #57

2 duplicati: #58 #59

4 duplicati: #60 #61 #62 #63

2 duplicati: #64 #65

4 duplicati: #66 #67 #68 #69

2 duplicati: #70 #71

4 duplicati: #72 #73 #74 #75

2 duplicati: #76 #77

4 duplicati: #78 #79 #80 #81

2 duplicati: #82 #83

Tempo della query: 0.57 ms Memoria query: 0.003 MB memoria prima della query: 0.967 MB

DELETE 

  FROM `ecw3r_session`

  WHERE `time` < '1726584863'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	range	time	time	45	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:825
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.71 ms Dopo l'ultima query: 1.39 ms Memoria query: 0.024 MB memoria prima della query: 0.975 MB Righe restituite: 0

SELECT `data`

  FROM `ecw3r_session`

  WHERE `session_id` = '841d2gr0j8umdka96tvi0j31a3'

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.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.04 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.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 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.03 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.17 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.77 ms Dopo l'ultima query: 6.11 ms Memoria query: 0.021 MB memoria prima della query: 0.990 MB Righe restituite: 0

SELECT `session_id`

  FROM `ecw3r_session`

  WHERE `session_id` = '841d2gr0j8umdka96tvi0j31a3' 
  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.03 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.07 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.08 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.20 ms
cleaning up	0.01 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.56 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.003 MB memoria prima della query: 0.994 MB

INSERT INTO `ecw3r_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('841d2gr0j8umdka96tvi0j31a3', 1, '1726674863', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('841d2gr0j8umdka96tvi0j31a3', 1, '1726674863', 0, '', 0)

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.20 ms
Waiting for query cache lock	0.01 ms
update	0.83 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.07 ms
freeing items	0.04 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.86 ms Dopo l'ultima query: 39.87 ms Memoria query: 0.022 MB memoria prima della query: 1.208 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.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 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.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.00 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.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
storing result in query cache	0.11 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.73 ms Dopo l'ultima query: 4.06 ms Memoria query: 0.023 MB memoria prima della query: 1.214 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.10 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 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.01 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.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.01 ms
freeing items	0.00 ms
storing result in query cache	0.11 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.21 ms Dopo l'ultima query: 290.98 ms Memoria query: 0.006 MB memoria prima della query: 2.653 MB

UPDATE `ecw3r_extensions`

  SET `params` = '{\"mediaversion\":\"9d43065789acafc61606749fa1ff2cc0\"}'

  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.03 ms
System lock	0.47 ms
updating	0.14 ms
end	0.01 ms
Waiting for query cache lock	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.06 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: 2.02 ms Dopo l'ultima query: 103.03 ms Memoria query: 0.029 MB memoria prima della query: 4.004 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.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.66 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.39 ms
closing tables	0.03 ms
freeing items	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/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.58 ms Dopo l'ultima query: 5.03 ms Memoria query: 0.025 MB memoria prima della query: 4.040 MB Righe restituite: 1

Query duplicate: #12 #84

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.03 ms
checking permissions	0.03 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
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.03 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.30 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: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.61 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.024 MB memoria prima della query: 4.048 MB Righe restituite: 1

Query duplicate: #13 #85

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.01 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.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.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.20 ms
cleaning up	0.01 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.81 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.034 MB memoria prima della query: 4.055 MB Righe restituite: 1

Query duplicate: #14 #86

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.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
Sending data	0.05 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.03 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.02 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.40 ms Dopo l'ultima query: 12.02 ms Memoria query: 0.026 MB memoria prima della query: 4.520 MB Righe restituite: 1

Query duplicate: #9 #84

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.01 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.03 ms
cleaning up	0.02 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.35 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.025 MB memoria prima della query: 4.529 MB Righe restituite: 1

Query duplicate: #10 #85

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.03 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.03 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: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.54 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.026 MB memoria prima della query: 4.536 MB Righe restituite: 1

Query duplicate: #11 #86

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.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
sending cached result to clien	0.06 ms
cleaning up	0.00 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.96 ms Dopo l'ultima query: 5.90 ms Memoria query: 0.032 MB memoria prima della query: 4.584 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.10 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.06 ms
optimizing	0.03 ms
statistics	0.36 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.55 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.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
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/portfolio.php:108
15	TZ_PortfolioModelPortfolio->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/portfolio/view.html.php:55
12	TZ_PortfolioViewPortfolio->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: 7.66 ms Dopo l'ultima query: 3.55 ms Memoria query: 0.053 MB memoria prima della query: 4.734 MB Righe restituite: 6

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

  FROM `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 x.contentid=c.id

  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 cc.published = 1 
  AND c.state = 1 
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2024-09-18 15:54:24') 
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-09-18 15:54:24') 
  AND c.access IN (1,1,5) 
  AND cc.access IN (1,1,5) 
  AND c.catid IN(8)

  GROUP BY c.id

  ORDER BY created DESC 
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	c	index_merge	PRIMARY,idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	5	80.00	Using intersect(idx_catid,idx_state); Using where
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	100.00	NULL
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.c.created_by	1	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.01 ms
checking query cache for query	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.15 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.10 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.06 ms
Creating tmp table	0.21 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	3.46 ms
Creating sort index	0.30 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
Creating sort index	0.19 ms
end	0.10 ms
removing tmp table	1.73 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.12 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.07 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:626
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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: 5.41 ms Memoria query: 0.038 MB memoria prima della query: 4.985 MB Righe restituite: 2

Query duplicate: #18

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.00 ms
init	0.02 ms
checking query cache for query	0.26 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.13 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.41 ms
preparing	0.04 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.07 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 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
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/models/portfolio.php:652
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.87 ms Dopo l'ultima query: 2.75 ms Memoria query: 0.038 MB memoria prima della query: 5.090 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=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.04 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.07 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/libraries/legacy/categories/categories.php:301
18	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
17	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:92
16	TZ_PortfolioHelperRoute::getPortfolioArticleRoute()	JROOT/components/com_tz_portfolio/models/portfolio.php:718
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.39 ms Dopo l'ultima query: 112.27 ms Memoria query: 0.032 MB memoria prima della query: 5.566 MB Righe restituite: 0

Query duplicate: #23 #27 #31 #35 #39

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.01 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.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.03 ms
statistics	0.28 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.01 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.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.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:101
18	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
17	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.64 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.027 MB memoria prima della query: 5.576 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(11)

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.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.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.02 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.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.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/components/com_tz_portfolio/models/plugins.php:81
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.82 ms Dopo l'ultima query: 63.31 ms Memoria query: 0.027 MB memoria prima della query: 7.020 MB Righe restituite: 2

Query duplicate: #22

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=11 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	100.00	Using where

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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
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.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 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.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_tz_portfolio/models/portfolio.php:447
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.36 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.027 MB memoria prima della query: 7.028 MB Righe restituite: 2

Query duplicate: #21

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=11 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/portfolio.php:448
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.45 ms Dopo l'ultima query: 8.26 ms Memoria query: 0.032 MB memoria prima della query: 7.339 MB Righe restituite: 0

Query duplicate: #19 #27 #31 #35 #39

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.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 privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:101
18	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
17	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.66 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.027 MB memoria prima della query: 7.349 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(14)

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.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.04 ms
optimizing	0.02 ms
statistics	0.02 ms
executing	0.02 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.02 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.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.70 ms Dopo l'ultima query: 0.41 ms Memoria query: 0.027 MB memoria prima della query: 7.356 MB Righe restituite: 1

Query duplicate: #26

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=14 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	100.00	Using where

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.05 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.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 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.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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_tz_portfolio/models/portfolio.php:447
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.37 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.027 MB memoria prima della query: 7.364 MB Righe restituite: 1

Query duplicate: #25

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=14 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/portfolio.php:448
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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: 0.26 ms Memoria query: 0.032 MB memoria prima della query: 7.375 MB Righe restituite: 0

Query duplicate: #19 #23 #31 #35 #39

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.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.03 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/administrator/components/com_tz_portfolio/models/plugin.php:101
18	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
17	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.59 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.027 MB memoria prima della query: 7.385 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(16)

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.01 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.05 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.02 ms
optimizing	0.02 ms
statistics	0.02 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.01 ms
Waiting on query cache mutex	0.01 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.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.66 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.027 MB memoria prima della query: 7.392 MB Righe restituite: 1

Query duplicate: #30

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=16 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.02 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.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 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.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_tz_portfolio/models/portfolio.php:447
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.34 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.027 MB memoria prima della query: 7.400 MB Righe restituite: 1

Query duplicate: #29

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=16 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/portfolio.php:448
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.40 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.032 MB memoria prima della query: 7.411 MB Righe restituite: 0

Query duplicate: #19 #23 #27 #35 #39

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.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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 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/administrator/components/com_tz_portfolio/models/plugin.php:101
18	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
17	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.60 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.027 MB memoria prima della query: 7.421 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(7)

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.01 ms
checking query cache for query	0.05 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.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 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.03 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.00 ms
storing result in query cache	0.01 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/components/com_tz_portfolio/models/plugins.php:81
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.67 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.029 MB memoria prima della query: 7.434 MB Righe restituite: 4

Query duplicate: #34

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=7 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 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.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.10 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.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_tz_portfolio/models/portfolio.php:447
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.35 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.027 MB memoria prima della query: 7.444 MB Righe restituite: 4

Query duplicate: #33

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=7 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/portfolio.php:448
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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: 0.35 ms Memoria query: 0.032 MB memoria prima della query: 7.455 MB Righe restituite: 0

Query duplicate: #19 #23 #27 #31 #39

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.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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_tz_portfolio/models/plugin.php:101
18	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
17	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.07 ms Memoria query: 0.027 MB memoria prima della query: 7.465 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(6)

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.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.05 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.02 ms
statistics	0.02 ms
executing	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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.68 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.027 MB memoria prima della query: 7.472 MB Righe restituite: 1

Query duplicate: #38

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=6 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.02 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 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.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 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.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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_tz_portfolio/models/portfolio.php:447
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.36 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.027 MB memoria prima della query: 7.480 MB Righe restituite: 1

Query duplicate: #37

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=6 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 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
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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/portfolio.php:448
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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: 0.24 ms Memoria query: 0.032 MB memoria prima della query: 7.491 MB Righe restituite: 0

Query duplicate: #19 #23 #27 #31 #35

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.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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 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/administrator/components/com_tz_portfolio/models/plugin.php:101
18	TZ_PortfolioModelPlugin->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:46
17	TZ_PortfolioModelPlugins->getPluginItems()	JROOT/components/com_tz_portfolio/models/plugins.php:72
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.65 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.027 MB memoria prima della query: 7.501 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(5)

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.01 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 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.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.06 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.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/plugins.php:81
16	TZ_PortfolioModelPlugins->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:870
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.65 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.027 MB memoria prima della query: 7.508 MB Righe restituite: 1

Query duplicate: #42

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=5 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.02 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.00 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.02 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.06 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_tz_portfolio/models/portfolio.php:447
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.36 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.027 MB memoria prima della query: 7.516 MB Righe restituite: 1

Query duplicate: #41

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON x.tagsid=t.id 
  WHERE x.contentid=5 
  AND t.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.02 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/portfolio.php:448
16	TZ_PortfolioModelPortfolio->getTagName()	JROOT/components/com_tz_portfolio/models/portfolio.php:925
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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: 2.18 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.028 MB memoria prima della query: 7.525 MB Righe restituite: 8

Query duplicate: #44

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON t.id=x.tagsid 
  WHERE x.contentid IN(11,14,16,7,6,5) 
  AND t.published = 1 
  GROUP BY t.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.71 ms
Creating sort index	0.11 ms
end	0.01 ms
removing tmp table	0.63 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.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.12 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_tz_portfolio/models/portfolio.php:472
16	TZ_PortfolioModelPortfolio->_Tags()	JROOT/components/com_tz_portfolio/models/portfolio.php:939
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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.34 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.028 MB memoria prima della query: 7.534 MB Righe restituite: 8

Query duplicate: #43

SELECT t.* 
  FROM ecw3r_tz_portfolio_tags AS t 
  LEFT JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON t.id=x.tagsid 
  WHERE x.contentid IN(11,14,16,7,6,5) 
  AND t.published = 1 
  GROUP BY t.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 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/components/com_tz_portfolio/models/portfolio.php:476
16	TZ_PortfolioModelPortfolio->_Tags()	JROOT/components/com_tz_portfolio/models/portfolio.php:939
15	TZ_PortfolioModelPortfolio->getItems()	JROOT/components/com_tz_portfolio/models/portfolio.php:948
14	TZ_PortfolioModelPortfolio->getArticle()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:202
12	TZ_PortfolioViewPortfolio->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: 2.50 ms Dopo l'ultima query: 0.53 ms Memoria query: 0.028 MB memoria prima della query: 7.437 MB Righe restituite: 18

SELECT t.*

  FROM ecw3r_tz_portfolio_tags AS t

  INNER JOIN ecw3r_tz_portfolio_tags_xref AS x 
  ON t.id = x.tagsid

  WHERE t.published = 1

  GROUP BY t.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	100.00	Using temporary; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.x.tagsid	1	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.01 ms
checking query cache for query	0.05 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.02 ms
statistics	0.03 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	1.30 ms
Creating sort index	0.17 ms
end	0.01 ms
removing tmp table	0.31 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.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.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_tz_portfolio/models/portfolio.php:424
14	TZ_PortfolioModelPortfolio->getAllTags()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
13	JViewLegacy->get()	JROOT/components/com_tz_portfolio/views/portfolio/view.html.php:205
12	TZ_PortfolioViewPortfolio->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.79 ms Dopo l'ultima query: 1.01 ms Memoria query: 0.032 MB memoria prima della query: 7.459 MB Righe restituite: 1

Cosa potrebbe fare Sandrini per la tua azienda?

Lavori e progetti per l'industria, il commercio e il terziario.

Supervisione e controllo Industriale

Supervisione e controllo Ospedali

Impianti elettrici

Sicurezza e controllo in azienda

Networking

Moduli e impianti fotovoltaici

Seguici su Facebook

Cosa fa Sandrini?

Resta aggiornato

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

88 query eseguite 109.09 ms

Trovati 67 duplicati!