Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1632856776,
                "last": 1632856776,
                "now": 1632856776
            },
            "token": "vr3epttW1I0lsHxOVE3NPfihnO1gybK0"
        },
        "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
        },
        "fabrik": {
            "js": {
                "scripts": null,
                "head": {
                    "scripts": null
                },
                "config": null,
                "shim": null
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 18.05 ms / 18.05 ms Memoria: 0.322 MB / 0.56 MB Application: afterLoad

Tempo: 361.55 ms / 379.60 ms Memoria: 2.417 MB / 2.97 MB Application: afterInitialise

Tempo: 21.68 ms / 401.28 ms Memoria: 1.161 MB / 4.13 MB Application: afterRoute

Tempo: 2.89 ms / 404.17 ms Memoria: 0.063 MB / 4.20 MB Application: beforeRenderComponent com_contact

Tempo: 8.55 ms / 412.71 ms Memoria: 0.335 MB / 4.53 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 1.14 ms / 413.86 ms Memoria: 0.040 MB / 4.57 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.07 ms / 413.93 ms Memoria: 0.000 MB / 4.57 MB Application: Start JAccess::preload(components)

Tempo: 3.88 ms / 417.81 ms Memoria: 0.301 MB / 4.87 MB Application: Finish JAccess::preload(components)

Tempo: 78.35 ms / 496.16 ms Memoria: 1.242 MB / 6.11 MB Application: afterRenderComponent com_contact

Tempo: 3.18 ms / 499.34 ms Memoria: 0.007 MB / 6.12 MB Application: afterDispatch

Tempo: 26.41 ms / 525.75 ms Memoria: 0.485 MB / 6.60 MB Application: beforeRenderModule mod_custom (Contact Info)

Tempo: 2.39 ms / 528.14 ms Memoria: 0.019 MB / 6.62 MB Application: afterRenderModule mod_custom (Contact Info)

Tempo: 2.56 ms / 530.70 ms Memoria: 0.000 MB / 6.61 MB Application: beforeRenderModule mod_menu (Termini e condizioni)

Tempo: 3.67 ms / 534.37 ms Memoria: 0.059 MB / 6.66 MB Application: afterRenderModule mod_menu (Termini e condizioni)

Tempo: 0.07 ms / 534.44 ms Memoria: 0.000 MB / 6.66 MB Application: beforeRenderModule mod_menu (Area Privata)

Tempo: 1.44 ms / 535.87 ms Memoria: 0.020 MB / 6.68 MB Application: afterRenderModule mod_menu (Area Privata)

Tempo: 0.06 ms / 535.93 ms Memoria: 0.000 MB / 6.67 MB Application: beforeRenderModule mod_custom (Copyrights)

Tempo: 4.15 ms / 540.08 ms Memoria: 0.748 MB / 7.42 MB Application: afterRenderModule mod_custom (Copyrights)

Tempo: 0.14 ms / 540.22 ms Memoria: 0.001 MB / 7.42 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu)

Tempo: 9.16 ms / 549.38 ms Memoria: 0.107 MB / 7.52 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu)

Tempo: 6.20 ms / 555.58 ms Memoria: 0.052 MB / 7.57 MB Application: afterRender

Query totali del database: 334.74 ms

Utilizzo memoria

Query Database

31 query eseguite 334.74 ms

Trovati 5 duplicati!

3 duplicati: #19 #23 #26

2 duplicati: #30 #31

Tempo della query: 0.31 ms Memoria query: 0.018 MB memoria prima della query: 1.173 MB Righe restituite: 0

SELECT `data`

  FROM `noiqz_session`

  WHERE `session_id` = 'tphti3lr1ldlr4sqpko59h3gq1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_session	const	PRIMARY	PRIMARY	766	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
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.24 ms Dopo l'ultima query: 2.57 ms Memoria query: 0.012 MB memoria prima della query: 1.248 MB Righe restituite: 0

SELECT `session_id`

  FROM `noiqz_session`

  WHERE `session_id` = 'tphti3lr1ldlr4sqpko59h3gq1' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
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: 306.42 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.009 MB memoria prima della query: 1.263 MB

INSERT INTO `noiqz_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('tphti3lr1ldlr4sqpko59h3gq1', 0, 1, '1632856776', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `noiqz_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('tphti3lr1ldlr4sqpko59h3gq1', 0, 1, '1632856776', 0, '')

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
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.69 ms Dopo l'ultima query: 2.11 ms Memoria query: 0.024 MB memoria prima della query: 1.335 MB Righe restituite: 45

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

  FROM `noiqz_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_extensions	ref	extension	extension	82	const	45	Using index condition

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.32 ms Dopo l'ultima query: 1.36 ms Memoria query: 0.015 MB memoria prima della query: 1.430 MB Righe restituite: 2

SELECT b.id

  FROM noiqz_usergroups AS a

  LEFT JOIN noiqz_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	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.23 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.014 MB memoria prima della query: 1.454 MB Righe restituite: 5

SELECT id, rules

  FROM `noiqz_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_viewlevels	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.30 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.015 MB memoria prima della query: 1.473 MB Righe restituite: 91

SELECT folder AS type, element AS name, params

  FROM noiqz_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	Extra
1	SIMPLE	noiqz_extensions	ref	extension	extension	82	const	182	Using index condition; Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.46 ms Dopo l'ultima query: 16.48 ms Memoria query: 0.024 MB memoria prima della query: 2.215 MB Righe restituite: 1

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

  FROM `noiqz_extensions`

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	Chiamata uguale alla linea sottostante.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/fmalertcookies/fmalertcookies.php:35
9	plgSystemFmAlertCookies->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 3.51 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.018 MB memoria prima della query: 2.223 MB

UPDATE `noiqz_extensions`

  SET `params` = '{\"mediaversion\":\"4e29346ea0f63f9f8934360b1d2765a9\"}'

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

Explain

EXPLAIN non possibile sulla query: UPDATE `noiqz_extensions` SET `params` = '{\"mediaversion\":\"4e29346ea0f63f9f8934360b1d2765a9\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.05 ms
Updating	0.06 ms
end	0.02 ms
query end	3.23 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/fmalertcookies/fmalertcookies.php:35
9	plgSystemFmAlertCookies->onAfterInitialise()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.55 ms Dopo l'ultima query: 12.42 ms Memoria query: 0.034 MB memoria prima della query: 3.041 MB Righe restituite: 61

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 noiqz_menu AS m

  LEFT JOIN noiqz_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	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	108	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	admin_db.m.component_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
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:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.57 ms Dopo l'ultima query: 12.60 ms Memoria query: 0.018 MB memoria prima della query: 4.013 MB Righe restituite: 6

SELECT id, home, template, s.params

  FROM noiqz_template_styles as s

  LEFT JOIN noiqz_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	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	8	Using where; Using join buffer (flat, BNL join)

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
11	JApplicationSite->getTemplate()	JROOT/plugins/system/jmframework/jmframework.php:138
10	plgSystemJMFramework->getTemplateName()	JROOT/plugins/system/jmframework/jmframework.php:86
9	plgSystemJMFramework->onAfterRoute()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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: 6.38 ms Memoria query: 0.014 MB memoria prima della query: 4.171 MB Righe restituite: 2

SELECT *

  FROM noiqz_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_languages	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.16 ms Dopo l'ultima query: 7.22 ms Memoria query: 0.032 MB memoria prima della query: 4.450 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `noiqz_assets`

Explain

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

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.39 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
18	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.29 ms Dopo l'ultima query: 1.66 ms Memoria query: 0.027 MB memoria prima della query: 4.513 MB Righe restituite: 1

SELECT *

  FROM noiqz_assets

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_assets	const	PRIMARY	PRIMARY	4	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
17	JTable->load()	JROOT/libraries/joomla/access/access.php:697
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.26 ms Memoria query: 0.023 MB memoria prima della query: 4.534 MB Righe restituite: 1

SELECT a.rules

  FROM noiqz_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.85 ms Memoria query: 0.026 MB memoria prima della query: 4.570 MB Righe restituite: 45

SELECT element

  FROM noiqz_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_extensions	ref	extension	extension	82	const	45	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.84 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.026 MB memoria prima della query: 4.605 MB Righe restituite: 37

SELECT a.name, a.rules

  FROM noiqz_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_djflyer','com_djimageslider','com_djmediatools','com_fabrik','com_fields','com_finder','com_gallery_wd','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_speasyimagegallery','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	182	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.92 ms Dopo l'ultima query: 2.59 ms Memoria query: 0.031 MB memoria prima della query: 4.869 MB Righe restituite: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM noiqz_contact_details AS a

  LEFT JOIN noiqz_categories AS c 
  on c.id = a.catid

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

  WHERE a.id = 1 
  AND (a.published = 1 OR a.published =2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-09-28 19:19:37') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-28 19:19:37')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:194
12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 1.13 ms Memoria query: 0.027 MB memoria prima della query: 4.939 MB Righe restituite: 0

Query duplicate: #23 #26

SELECT `m`.`tag_id`,`t`.*

  FROM `noiqz_contentitem_tag_map` AS m 

  INNER JOIN `noiqz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	admin_db.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_contact/models/contact.php:218
12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.94 ms Dopo l'ultima query: 1.95 ms Memoria query: 0.033 MB memoria prima della query: 5.068 MB Righe restituite: 16

SHOW FULL COLUMNS 
  FROM `noiqz_users`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
18	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/administrator/components/com_users/models/user.php:57
16	UsersModelUser->getTable()	JROOT/libraries/legacy/model/admin.php:886
15	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:73
14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:364
13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:254
12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.08 ms Dopo l'ultima query: 14.94 ms Memoria query: 0.032 MB memoria prima della query: 5.398 MB Righe restituite: 4

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `noiqz_contact_details` AS a

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

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

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

  WHERE a.access IN (1,1,5) 
  AND a.catid = 16 
  AND c.access IN (1,1,5) 
  AND a.published = 1

  ORDER BY a.name asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using filesort
1	SIMPLE	a	ALL	idx_access,idx_state,idx_catid	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	admin_db.a.created_by	1	Using where

Profilo

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
12	JModelList->getItems()	JROOT/components/com_contact/models/category.php:91
11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.51 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.025 MB memoria prima della query: 5.474 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `noiqz_contentitem_tag_map` AS m 

  INNER JOIN `noiqz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 9 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	admin_db.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:104
11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.48 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.025 MB memoria prima della query: 5.499 MB Righe restituite: 0

Query duplicate: #19 #26

SELECT `m`.`tag_id`,`t`.*

  FROM `noiqz_contentitem_tag_map` AS m 

  INNER JOIN `noiqz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	admin_db.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:104
11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.50 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.025 MB memoria prima della query: 5.525 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `noiqz_contentitem_tag_map` AS m 

  INNER JOIN `noiqz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 11 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	admin_db.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:104
11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.41 ms Memoria query: 0.025 MB memoria prima della query: 5.550 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `noiqz_contentitem_tag_map` AS m 

  INNER JOIN `noiqz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 10 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	admin_db.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:104
11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 2.68 ms Memoria query: 0.024 MB memoria prima della query: 5.618 MB Righe restituite: 0

Query duplicate: #19 #23

SELECT `m`.`tag_id`,`t`.*

  FROM `noiqz_contentitem_tag_map` AS m 

  INNER JOIN `noiqz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	admin_db.m.tag_id	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
11	JHelperTags->getItemTags()	JROOT/components/com_contact/views/contact/view.html.php:278
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.31 ms Dopo l'ultima query: 0.79 ms Memoria query: 0.029 MB memoria prima della query: 5.659 MB Righe restituite: 43

SHOW FULL COLUMNS 
  FROM `noiqz_contact_details`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.08 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:38
13	ContactTableContact->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/components/com_contact/models/contact.php:591
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:298
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 1.73 ms Memoria query: 0.030 MB memoria prima della query: 5.873 MB Righe restituite: 1

SELECT *

  FROM noiqz_contact_details

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noiqz_contact_details	const	PRIMARY	PRIMARY	4	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_contact/models/contact.php:592
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:298
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.12 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.016 MB memoria prima della query: 5.889 MB

UPDATE noiqz_contact_details

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1'

Explain

EXPLAIN non possibile sulla query: UPDATE noiqz_contact_details SET `hits` = (`hits` + 1) WHERE `id` = '1'

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.04 ms
Updating	0.08 ms
end	0.02 ms
query end	4.82 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
12	JTable->hit()	JROOT/components/com_contact/models/contact.php:593
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:298
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.82 ms Dopo l'ultima query: 53.75 ms Memoria query: 0.026 MB memoria prima della query: 6.255 MB Righe restituite: 20

Query duplicate: #31

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

  FROM noiqz_modules AS m

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

  LEFT JOIN noiqz_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 <= '2021-09-28 19:19:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-09-28 19:19:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 580 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	50	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	admin_db.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	admin_db.m.id	1	Using where; Using index

Profilo

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.26 ms
Sending data	0.84 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
11	JDocumentHtml->countModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:167
10	JMFTemplate->countModules()	JROOT/templates/jm-beauty-center/lib/jm_template.php:20
9	JMTemplateBlank->postSetUp()	JROOT/plugins/system/jmframework/includes/libraries/template.php:58
8	JMFTemplate->__construct()	JROOT/templates/jm-beauty-center/index.php:18
7	require JROOT/templates/jm-beauty-center/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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.52 ms Dopo l'ultima query: 12.31 ms Memoria query: 0.029 MB memoria prima della query: 6.539 MB Righe restituite: 20

Query duplicate: #30

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

  FROM noiqz_modules AS m

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

  LEFT JOIN noiqz_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 <= '2021-09-28 19:19:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-09-28 19:19:37') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 580 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	50	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	admin_db.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	admin_db.m.id	1	Using where; Using index

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.25 ms
Sending data	0.70 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
17	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
16	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
15	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
14	JModuleHelper::getModules()	JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:49
13	DJModuleHelper::renderModules()	JROOT/templates/jm-beauty-center/tpl/blocks/content.php:74
12	include JROOT/templates/jm-beauty-center/tpl/blocks/content.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
11	JMFTemplate->renderBlock()	JROOT/templates/jm-beauty-center/tpl/default.php:41
10	include JROOT/templates/jm-beauty-center/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:204
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:211
8	JMFTemplate->renderScheme()	JROOT/templates/jm-beauty-center/index.php:40
7	require JROOT/templates/jm-beauty-center/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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]

24 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

6 × SELECT `m`.`tag_id`,`t`.* 
  FROM `noiqz_contentitem_tag_map` AS m  
  INNER JOIN `noiqz_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM noiqz_modules AS m 
  LEFT JOIN noiqz_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN noiqz_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.name, a.rules 
  FROM noiqz_assets AS a

1 × SELECT element 
  FROM noiqz_extensions

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM noiqz_contact_details AS a 
  LEFT JOIN noiqz_categories AS c 
  on c.id = a.catid 
  LEFT JOIN noiqz_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `noiqz_contact_details` AS a 
  LEFT JOIN noiqz_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN noiqz_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN noiqz_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT * 
  FROM noiqz_contact_details

1 × SELECT a.rules 
  FROM noiqz_assets AS a

```
1 × SELECT * 
  FROM noiqz_languages
```

1 × SELECT id, rules 
  FROM `noiqz_viewlevels

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

1 × SELECT `session_id` 
  FROM `noiqz_session`

1 × SELECT folder AS type, element AS name, params 
  FROM noiqz_extensions

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 noiqz_menu AS m 
  LEFT JOIN noiqz_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `data` 
  FROM `noiqz_session`

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

```
1 × SELECT * 
  FROM noiqz_assets
```

ALTRE tabelle:

1 × SHOW FULL COLUMNS 
  FROM `noiqz_contact_details

1 × UPDATE noiqz_contact_details 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `noiqz_users

1 × SHOW FULL COLUMNS 
  FROM `noiqz_assets

1 × UPDATE `noiqz_extensions` 
  SET `params` = '{\"mediaversion\":\"4e29346ea0f63f9f8934360b1d2765a9\"}'

1 × INSERT INTO `noiqz_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('tphti3lr1ldlr4sqpko59h3gq1', 0, 1, '1632856776', 0, ''

Informazioni sul contatto

Modulo contatti

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

31 query eseguite 334.74 ms

Trovati 5 duplicati!

24 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: