Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726669555,
                "last": 1726669555,
                "now": 1726669555
            },
            "token": "wKaw583oyH3GMONm5UZuIa8qYbhGdgsu"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 408.16 ms / 522.74 ms Memoria: 1.215 MB / 1.79 MB Application: afterInitialise

Tempo: 286.36 ms / 809.10 ms Memoria: 1.564 MB / 3.36 MB Application: afterRoute

Tempo: 2.92 ms / 812.02 ms Memoria: 0.035 MB / 3.39 MB Application: beforeRenderComponent com_content

Tempo: 30.77 ms / 842.79 ms Memoria: 0.645 MB / 4.04 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 3.15 ms / 845.94 ms Memoria: 0.058 MB / 4.09 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.06 ms / 846.00 ms Memoria: 0.000 MB / 4.09 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Tempo: 3.12 ms / 849.12 ms Memoria: 0.027 MB / 4.12 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Tempo: 92.01 ms / 941.12 ms Memoria: 0.810 MB / 4.93 MB Application: afterRenderComponent com_content

Tempo: 33.06 ms / 974.18 ms Memoria: 0.656 MB / 5.58 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.12 ms / 974.30 ms Memoria: 0.007 MB / 5.59 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 22.00 ms / 996.30 ms Memoria: 0.283 MB / 5.87 MB Application: afterDispatch

Tempo: 157.34 ms / 1153.64 ms Memoria: 10.169 MB / 16.04 MB Application: beforeRenderModule mod_menu (Footer Menu)

Tempo: 21.09 ms / 1174.73 ms Memoria: 0.119 MB / 16.16 MB Application: afterRenderModule mod_menu (Footer Menu)

Tempo: 3.99 ms / 1178.72 ms Memoria: 0.000 MB / 16.16 MB Application: beforeRenderModule mod_custom (To Top)

Tempo: 4.90 ms / 1183.62 ms Memoria: 0.005 MB / 16.17 MB Application: afterRenderModule mod_custom (To Top)

Tempo: 1.49 ms / 1185.11 ms Memoria: 0.000 MB / 16.14 MB Application: beforeRenderModule mod_mylivechat (MyLiveChat)

Tempo: 4.55 ms / 1189.65 ms Memoria: 0.021 MB / 16.17 MB Application: afterRenderModule mod_mylivechat (MyLiveChat)

Tempo: 74.95 ms / 1264.60 ms Memoria: 0.056 MB / 16.22 MB Application: beforeRenderModule mod_custom (Copyright)

Tempo: 1.37 ms / 1265.97 ms Memoria: 0.003 MB / 16.23 MB Application: afterRenderModule mod_custom (Copyright)

Tempo: 74.03 ms / 1340.00 ms Memoria: 0.035 MB / 16.26 MB Application: beforeRenderModule mod_custom (Resta aggiornato)

Tempo: 1.16 ms / 1341.16 ms Memoria: 0.004 MB / 16.26 MB Application: afterRenderModule mod_custom (Resta aggiornato)

Tempo: 63.62 ms / 1404.78 ms Memoria: 0.036 MB / 16.30 MB Application: beforeRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 48.63 ms / 1453.41 ms Memoria: 0.849 MB / 17.15 MB Application: afterRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 71.27 ms / 1524.68 ms Memoria: 0.000 MB / 17.11 MB Application: beforeRenderModule mod_custom (Seguici su Facebook)

Tempo: 1.37 ms / 1526.05 ms Memoria: 0.004 MB / 17.11 MB Application: afterRenderModule mod_custom (Seguici su Facebook)

Tempo: 69.91 ms / 1595.97 ms Memoria: 0.036 MB / 17.15 MB Application: beforeRenderModule mod_custom (Sandrini indirizzo footer)

Tempo: 1.32 ms / 1597.29 ms Memoria: 0.004 MB / 17.15 MB Application: afterRenderModule mod_custom (Sandrini indirizzo footer)

Tempo: 3.94 ms / 1601.23 ms Memoria: 0.004 MB / 17.16 MB Application: beforeRenderModule mod_tz_social_custom (Social footer)

Tempo: 10.53 ms / 1611.76 ms Memoria: 0.117 MB / 17.27 MB Application: afterRenderModule mod_tz_social_custom (Social footer)

Tempo: 77.86 ms / 1689.62 ms Memoria: 0.032 MB / 17.31 MB Application: beforeRenderModule mod_custom (sandrini benvenuto home)

Tempo: 1.16 ms / 1690.78 ms Memoria: 0.004 MB / 17.31 MB Application: afterRenderModule mod_custom (sandrini benvenuto home)

Tempo: 74.37 ms / 1765.15 ms Memoria: 0.040 MB / 17.35 MB Application: beforeRenderModule mod_unite_revolution2 (Onepage Slider)

Tempo: 106.16 ms / 1871.31 ms Memoria: 2.516 MB / 19.86 MB Application: afterRenderModule mod_unite_revolution2 (Onepage Slider)

Tempo: 107.08 ms / 1978.39 ms Memoria: 0.000 MB / 10.66 MB Application: afterRender

Query totali del database: 103.61 ms

Utilizzo memoria

Query Database

25 query eseguite 103.61 ms

Trovati 4 duplicati!

4 duplicati: #22 #23 #24 #25

Tempo della query: 0.77 ms Memoria query: 0.003 MB memoria prima della query: 0.966 MB

DELETE 

  FROM `ecw3r_session`

  WHERE `time` < '1726579555'

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.05 ms
updating	0.23 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.07 ms
freeing items	0.04 ms
cleaning up	0.00 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: 2.66 ms Dopo l'ultima query: 1.51 ms Memoria query: 0.024 MB memoria prima della query: 0.974 MB Righe restituite: 0

SELECT `data`

  FROM `ecw3r_session`

  WHERE `session_id` = '925h06bh3e0pvqhefl7605o14j'

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.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.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	2.16 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.54 ms Dopo l'ultima query: 6.21 ms Memoria query: 0.021 MB memoria prima della query: 0.989 MB Righe restituite: 0

SELECT `session_id`

  FROM `ecw3r_session`

  WHERE `session_id` = '925h06bh3e0pvqhefl7605o14j' 
  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.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.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.04 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.01 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: 0.59 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.003 MB memoria prima della query: 0.993 MB

INSERT INTO `ecw3r_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('925h06bh3e0pvqhefl7605o14j', 1, '1726669555', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('925h06bh3e0pvqhefl7605o14j', 1, '1726669555', 0, '', 0)

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.13 ms
Waiting for query cache lock	0.00 ms
update	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.06 ms
freeing items	0.04 ms
cleaning up	0.00 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: 1.69 ms Dopo l'ultima query: 26.04 ms Memoria query: 0.050 MB memoria prima della query: 1.091 MB Righe restituite: 39

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ecw3r_extensions`

  WHERE `type` = 'component'

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.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.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.40 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.12 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.01 ms
Waiting on query cache mutex	0.00 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.00 ms
storing result in query cache	0.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php: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.76 ms Dopo l'ultima query: 20.54 ms Memoria query: 0.022 MB memoria prima della query: 1.213 MB Righe restituite: 2

SELECT b.id

  FROM ecw3r_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.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.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.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.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
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.56 ms Dopo l'ultima query: 3.84 ms Memoria query: 0.023 MB memoria prima della query: 1.218 MB Righe restituite: 5

SELECT id, rules

  FROM `ecw3r_viewlevels`

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
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: 2.85 ms Dopo l'ultima query: 2.56 ms Memoria query: 0.029 MB memoria prima della query: 1.249 MB Righe restituite: 72

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM ecw3r_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

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; Using filesort

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
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.03 ms
optimizing	0.02 ms
statistics	0.22 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.91 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
freeing items	0.05 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.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php: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: 13.35 ms Dopo l'ultima query: 153.11 ms Memoria query: 0.144 MB memoria prima della query: 1.889 MB Righe restituite: 66

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM ecw3r_menu AS m

  LEFT JOIN ecw3r_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	181	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.m.component_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	5.91 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.04 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	2.25 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.59 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.60 ms
Creating sort index	0.91 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.33 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	1.03 ms
Creating sort index	0.58 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.16 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.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.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/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:450
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:555
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1148
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: 17.34 ms Dopo l'ultima query: 88.74 ms Memoria query: 0.735 MB memoria prima della query: 2.430 MB Righe restituite: 43

SELECT id, home, template, s.params

  FROM ecw3r_template_styles as s

  LEFT JOIN ecw3r_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	152	Sql1009297_1.e.element	9	100.00	Using index condition; Using where

Profilo

Status	Duration
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.07 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.17 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	1.44 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.13 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.16 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.10 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.58 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.04 ms
Sending data	0.83 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.72 ms
Sending data	0.13 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.50 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.08 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.31 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.26 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.17 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.32 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	1.16 ms
Sending data	0.23 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.30 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.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
10	JApplicationSite->getTemplate()	JROOT/plugins/system/plazart/includes/core/plazart.php:226
9	Plazart::detect()	JROOT/plugins/system/plazart/plazart.php:44
8	plgSystemPlazart->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.10 ms Dopo l'ultima query: 61.81 ms Memoria query: 0.026 MB memoria prima della query: 2.651 MB Righe restituite: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ecw3r_extensions`

  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	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.43 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 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.11 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.11 ms Dopo l'ultima query: 1.27 ms Memoria query: 0.006 MB memoria prima della query: 2.643 MB

UPDATE `ecw3r_extensions`

  SET `params` = '{\"mediaversion\":\"3947297f947a48e325fb1a1f12f9fe78\"}'

  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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.39 ms
updating	0.11 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.12 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.00 ms Dopo l'ultima query: 29.88 ms Memoria query: 0.035 MB memoria prima della query: 2.777 MB Righe restituite: 91

SELECT *

  FROM `ecw3r_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_jcomments_settings	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	91	86.81	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.12 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.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.18 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
13	JCommentsCfg::_load()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/components/com_jcomments/classes/config.php:159
11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
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: 5.49 ms Dopo l'ultima query: 25.35 ms Memoria query: 0.028 MB memoria prima della query: 3.017 MB Righe restituite: 1

SELECT *

  FROM ecw3r_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_languages	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.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	4.84 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.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
12	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
11	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
8	plgSystemK2->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.53 ms Dopo l'ultima query: 57.75 ms Memoria query: 0.032 MB memoria prima della query: 4.040 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.03 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.11 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.05 ms
optimizing	0.02 ms
statistics	0.30 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	1.31 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.14 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_content/models/articles.php:113
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:43
14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.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.71 ms Dopo l'ultima query: 7.02 ms Memoria query: 0.026 MB memoria prima della query: 4.170 MB Righe restituite: 1

SELECT COUNT(*)

  FROM ecw3r_content AS a

  LEFT JOIN ecw3r_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ecw3r_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ecw3r_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ecw3r_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-18 14:25:56') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-18 14:25:56')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	7	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql1009297_1.a.catid	1	100.00	Using index condition; Using where
1	SIMPLE	ua	index	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	index	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	Sql1009297_1.c.parent_id	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	1.31 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.07 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.10 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.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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
15	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
14	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
13	JModelList->getPagination()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.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: 14.26 ms Dopo l'ultima query: 198.97 ms Memoria query: 0.032 MB memoria prima della query: 6.417 MB Righe restituite: 16

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

  FROM ecw3r_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

Explain

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

Profilo

Status	Duration
starting	0.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.13 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.05 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	13.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.19 ms
cleaning up	0.01 ms

Call Stack

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

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

Tempo della query: 6.90 ms Dopo l'ultima query: 349.47 ms Memoria query: 0.058 MB memoria prima della query: 16.469 MB Righe restituite: 6

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

  FROM ecw3r_content as ct

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

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

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

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

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.02 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 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.09 ms
preparing	0.07 ms
Creating tmp table	0.22 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	4.47 ms
Creating sort index	0.19 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.18 ms
end	0.12 ms
removing tmp table	0.45 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.05 ms
cleaning up	0.01 ms

Call Stack

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

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

Tempo della query: 1.74 ms Dopo l'ultima query: 22.25 ms Memoria query: 0.036 MB memoria prima della query: 17.148 MB Righe restituite: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM ecw3r_categories as c

  LEFT JOIN ecw3r_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=8

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

Profilo

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

Call Stack

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

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

Tempo della query: 9.30 ms Dopo l'ultima query: 392.41 ms Memoria query: 0.028 MB memoria prima della query: 19.805 MB Righe restituite: 1

select * 
  from ecw3r_revslider_sliders 
  where id=6

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	8.42 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.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.22 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:223
16	UniteDBRev->fetchSingle()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:76
15	RevSlider->initByID()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:119
14	RevSlider->initByMixed()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:1943
13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 7.94 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.067 MB memoria prima della query: 19.829 MB Righe restituite: 5

select * 
  from ecw3r_revslider_slides 
  where slider_id=6 
  order by slide_order

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_revslider_slides	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	24	100.00	Using where; Using filesort

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.04 ms
checking permissions	0.01 ms
Opening tables	6.53 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.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.09 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Creating sort index	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.01 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.13 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
19	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
18	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1579
17	RevSlider->getSlidesFromGallery()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1472
16	RevSlider->getSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1658
15	RevSlider->getSlidesForOutput()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:260
14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 7.13 ms Dopo l'ultima query: 2.97 ms Memoria query: 0.028 MB memoria prima della query: 19.847 MB Righe restituite: 6

Query duplicate: #23 #24 #25

select * 
  from ecw3r_revslider_layer_animations

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	6.46 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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.02 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.05 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:710
15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.45 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.028 MB memoria prima della query: 19.857 MB Righe restituite: 6

Query duplicate: #22 #24 #25

select * 
  from ecw3r_revslider_layer_animations

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 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_uniterevolution2/inc_php/framework/db.class.php:178
18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:711
15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.42 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.028 MB memoria prima della query: 19.865 MB Righe restituite: 6

Query duplicate: #22 #23 #25

select * 
  from ecw3r_revslider_layer_animations

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_revslider_layer_animations	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	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.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_uniterevolution2/inc_php/framework/db.class.php:178
18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:710
15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.44 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 19.875 MB Righe restituite: 6

Query duplicate: #22 #23 #24

select * 
  from ecw3r_revslider_layer_animations

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.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_uniterevolution2/inc_php/framework/db.class.php:178
18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
16	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:711
15	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:678
14	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2200
13	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
12	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:620
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
1	JApplicationCms->execute()	JROOT/index.php:49

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

21 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

4 × select * 
  from ecw3r_revslider_layer_animation

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `ecw3r_extensions`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ecw3r_assets`

1 × select * 
  from ecw3r_revslider_slides

1 × select * 
  from ecw3r_revslider_sliders

1 × 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)

1 × SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.* 
  FROM ecw3r_content as ct 
  LEFT JOIN ecw3r_categories as cat 
  on cat.id = ct.catid 
  LEFT JOIN ecw3r_users as us 
  on us.id = ct.created_by 
  LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
  on tz_xc.contentid = ct.id

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ecw3r_modules AS m 
  LEFT JOIN ecw3r_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ecw3r_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT COUNT(*) 
  FROM ecw3r_content AS a 
  LEFT JOIN ecw3r_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ecw3r_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ecw3r_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ecw3r_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT `data` 
  FROM `ecw3r_session`

1 × SELECT `session_id` 
  FROM `ecw3r_session`

1 × SELECT * 
  FROM `ecw3r_jcomments_settings`

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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM ecw3r_menu AS m 
  LEFT JOIN ecw3r_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM ecw3r_extensions

1 × SELECT id, rules 
  FROM `ecw3r_viewlevels

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

```
1 × SELECT * 
  FROM ecw3r_languages
```

ALTRE tabelle:

```
1 × DELETE  
  FROM `ecw3r_session`
```

1 × INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('925h06bh3e0pvqhefl7605o14j', 1, '1726669555', 0, '', 0

1 × UPDATE `ecw3r_extensions` 
  SET `params` = '{\"mediaversion\":\"3947297f947a48e325fb1a1f12f9fe78\"}'

Sandrini Impianti, soluzioni integrate per vivere meglio.

Seguici su Facebook

Cosa fa Sandrini?

Resta aggiornato

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

25 query eseguite 103.61 ms

Trovati 4 duplicati!

21 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: