ASSEMBLEE SINDACALI 2022

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1731733237,
                "last": 1731733237,
                "now": 1731733237
            },
            "token": "X7zSfkvPFB0LZIyrda105jv0CSbefRxU"
        },
        "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: 10.28 ms / 10.28 ms Memoria: 0.398 MB / 0.75 MB Application: afterLoad

Tempo: 31.57 ms / 41.86 ms Memoria: 0.945 MB / 1.69 MB Application: afterInitialise

Tempo: 19.63 ms / 61.49 ms Memoria: 1.268 MB / 2.96 MB Application: afterRoute

Tempo: 5.07 ms / 66.56 ms Memoria: 0.175 MB / 3.13 MB Application: beforeRenderComponent com_anief

Tempo: 56.82 ms / 123.38 ms Memoria: 0.618 MB / 3.75 MB Application: afterRenderComponent com_anief

Tempo: 1.31 ms / 124.69 ms Memoria: 0.005 MB / 3.76 MB Application: afterDispatch

Tempo: 29.39 ms / 154.07 ms Memoria: 0.631 MB / 4.39 MB Application: beforeRenderModule mod_megamenu (MENU MOBILE)

Tempo: 15.33 ms / 169.40 ms Memoria: 0.112 MB / 4.50 MB Application: afterRenderModule mod_megamenu (MENU MOBILE)

Tempo: 0.09 ms / 169.50 ms Memoria: 0.000 MB / 4.49 MB Application: beforeRenderModule mod_custom (social sharing addthis)

Tempo: 0.66 ms / 170.16 ms Memoria: 0.006 MB / 4.49 MB Application: afterRenderModule mod_custom (social sharing addthis)

Tempo: 0.03 ms / 170.19 ms Memoria: 0.000 MB / 4.49 MB Application: beforeRenderModule mod_custom (footer_template2019)

Tempo: 3.23 ms / 173.41 ms Memoria: 0.082 MB / 4.57 MB Application: beforeRenderModule mod_custom (Supporto online (NEW))

Tempo: 0.45 ms / 173.86 ms Memoria: 0.003 MB / 4.58 MB Application: afterRenderModule mod_custom (Supporto online (NEW))

Tempo: 0.31 ms / 174.17 ms Memoria: 0.000 MB / 4.54 MB Application: afterRenderModule mod_custom (footer_template2019)

Tempo: 0.06 ms / 174.24 ms Memoria: 0.002 MB / 4.54 MB Application: beforeRenderModule mod_breadcrumbs (Percorso_template2019)

Tempo: 2.65 ms / 176.89 ms Memoria: 0.007 MB / 4.55 MB Application: afterRenderModule mod_breadcrumbs (Percorso_template2019)

Tempo: 0.11 ms / 176.99 ms Memoria: 0.000 MB / 4.55 MB Application: beforeRenderModule mod_inline_login (Login top)

Tempo: 3.40 ms / 180.40 ms Memoria: 0.029 MB / 4.58 MB Application: afterRenderModule mod_inline_login (Login top)

Tempo: 0.06 ms / 180.46 ms Memoria: 0.000 MB / 4.58 MB Application: beforeRenderModule mod_menu (Menu top)

Tempo: 2.06 ms / 182.52 ms Memoria: 0.031 MB / 4.61 MB Application: afterRenderModule mod_menu (Menu top)

Tempo: 7.95 ms / 190.47 ms Memoria: 0.188 MB / 4.79 MB Application: afterRender

Query totali del database: 40.61 ms

Utilizzo memoria

Query Database

30 query eseguite 40.61 ms

Trovati 2 duplicati!

2 duplicati: #17 #25

Tempo della query: 0.43 ms Memoria query: 0.023 MB memoria prima della query: 1.030 MB Righe restituite: 0

SELECT `data`

  FROM `g4hpn_session`

  WHERE `session_id` = '444o7g93s2sfr07qu67598p6tn'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_session	const	PRIMARY	PRIMARY	194	const	1

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.04 ms
end	0.02 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:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
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:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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.26 ms Dopo l'ultima query: 0.95 ms Memoria query: 0.020 MB memoria prima della query: 1.044 MB Righe restituite: 0

SELECT `session_id`

  FROM `g4hpn_session`

  WHERE `session_id` = '444o7g93s2sfr07qu67598p6tn' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 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
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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.71 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.004 MB memoria prima della query: 1.049 MB

INSERT INTO `g4hpn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('444o7g93s2sfr07qu67598p6tn', 1, 1731733237, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `g4hpn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('444o7g93s2sfr07qu67598p6tn', 1, 1731733237, 0, '', 0)

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.01 ms
update	0.10 ms
end	0.01 ms
query end	1.43 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
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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.66 ms Dopo l'ultima query: 1.73 ms Memoria query: 0.099 MB memoria prima della query: 1.081 MB Righe restituite: 43

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

  FROM `g4hpn_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

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

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.03 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.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.00 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.43 ms Memoria query: 0.031 MB memoria prima della query: 1.160 MB Righe restituite: 142

SELECT id, rules

  FROM `g4hpn_viewlevels`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 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
Sending data	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.32 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.021 MB memoria prima della query: 1.232 MB Righe restituite: 2

SELECT b.id

  FROM g4hpn_usergroups AS a

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

  WHERE a.id = 160

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	2	Using where

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.00 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.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.22 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.030 MB memoria prima della query: 1.254 MB Righe restituite: 98

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

  FROM g4hpn_extensions

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

  ORDER BY ordering

Explain

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

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.00 ms
Table lock	0.01 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.62 ms
Sending data	0.28 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:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 10.65 ms Memoria query: 0.021 MB memoria prima della query: 1.685 MB Righe restituite: 1

SELECT `template`

  FROM `g4hpn_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

Profilo

Status	Duration
starting	0.07 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.00 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.00 ms
Sending data	0.07 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.83 ms Dopo l'ultima query: 2.31 ms Memoria query: 0.392 MB memoria prima della query: 1.719 MB Righe restituite: 265

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

  LEFT JOIN g4hpn_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,published	idx_client_id_parent_id_alias_language	1	const	10	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	admin_test_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.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	3.71 ms
Sending data	1.70 ms
end	0.01 ms
query end	0.00 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.55 ms Dopo l'ultima query: 12.73 ms Memoria query: 0.022 MB memoria prima della query: 2.977 MB Righe restituite: 1

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

  FROM `g4hpn_extensions`

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

Explain

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

Profilo

Status	Duration
starting	0.06 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.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.03 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.16 ms Memoria query: 0.005 MB memoria prima della query: 2.968 MB

UPDATE `g4hpn_extensions`

  SET `params` = '{\"mediaversion\":\"294de3fb1094486c96496101dfea3a2f\"}'

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

Explain

EXPLAIN non possibile sulla query: UPDATE `g4hpn_extensions` SET `params` = '{\"mediaversion\":\"294de3fb1094486c96496101dfea3a2f\"}' 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.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.13 ms
Updating	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Waiting for query cache lock	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1119
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.67 ms Dopo l'ultima query: 1.13 ms Memoria query: 0.019 MB memoria prima della query: 3.043 MB Righe restituite: 2

SELECT *

  FROM g4hpn_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

Status	Duration
starting	0.04 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.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.04 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
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.81 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.035 MB memoria prima della query: 3.056 MB Righe restituite: 5

SELECT id, home, template, s.params

  FROM g4hpn_template_styles as s

  LEFT JOIN g4hpn_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	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	admin_test_db.e.element	2	Using index condition; Using where

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.30 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.02 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
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.38 ms Dopo l'ultima query: 4.18 ms Memoria query: 0.038 MB memoria prima della query: 3.316 MB Righe restituite: 77

SHOW FULL COLUMNS 
  FROM `g4hpn_anief_activities`

Explain

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

Profilo

Status	Duration
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.03 ms
After opening tables	0.02 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.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.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.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
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
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.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
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 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.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_anief/tables/activity.php:27
16	AniefTableActivity->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/components/com_anief/models/dettaglievento.php:42
13	AniefModeldettaglievento->getTable()	JROOT/components/com_anief/models/dettaglievento.php:53
12	AniefModeldettaglievento->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_anief/views/dettaglievento/view.html.php:24
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.53 ms Dopo l'ultima query: 0.85 ms Memoria query: 0.040 MB memoria prima della query: 3.419 MB Righe restituite: 1

SELECT *

  FROM g4hpn_anief_activities

  WHERE `id` = '73957'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_anief_activities	const	PRIMARY	PRIMARY	4	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.00 ms
After table lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 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:1459
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_anief/models/dettaglievento.php:55
12	AniefModeldettaglievento->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_anief/views/dettaglievento/view.html.php:24
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.36 ms Dopo l'ultima query: 2.11 ms Memoria query: 0.026 MB memoria prima della query: 3.494 MB Righe restituite: 61

SELECT id

  FROM g4hpn_anief_asssemblee_scuole

  WHERE id_assemblea = 73957

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_anief_asssemblee_scuole	ref	id_assemblea	id_assemblea	4	const	61	Using index

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 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.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 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.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_anief/helpers/common.php:1281
15	AniefCommon::hasScuoleAsse()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:53
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 9.40 ms Memoria query: 0.025 MB memoria prima della query: 3.584 MB Righe restituite: 1

Query duplicate: #25

SELECT reg_obb

  FROM g4hpn_anief_activities

  WHERE id = 73957

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 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.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 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.00 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/components/com_anief/helpers/common.php:1245
15	AniefCommon::canPartecipate()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:172
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 11.05 ms Memoria query: 0.023 MB memoria prima della query: 3.617 MB Righe restituite: 1

SELECT plugin

  FROM g4hpn_ftc_comparti

  WHERE id = 1

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.11 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.04 ms
preparing	0.02 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.00 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:320
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.62 ms Dopo l'ultima query: 1.08 ms Memoria query: 0.027 MB memoria prima della query: 3.637 MB Righe restituite: 61

SELECT id_scuola

  FROM g4hpn_anief_asssemblee_scuole

  WHERE id_assemblea = 73957

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_anief_asssemblee_scuole	ref	id_assemblea	id_assemblea	4	const	61

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.00 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
19	JDatabaseDriver->loadColumn()	JROOT/components/com_anief/models/fields/scuolelist.php:28
18	JFormFieldScuolelist->getOptions()	JROOT/libraries/joomla/form/fields/list.php:58
17	JFormFieldList->getInput()	JROOT/libraries/src/Form/FormField.php:975
16	Joomla\CMS\Form\FormField->renderField()	JROOT/libraries/src/Form/Form.php:670
15	Joomla\CMS\Form\Form->renderField()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:328
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.44 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.029 MB memoria prima della query: 3.649 MB Righe restituite: 61

SELECT id_scuola,a.id as value, CONCAT_WS(" - ",DES_NOM_SCU, COD_SCU_UT,  DES_TIP_IST) as text

  FROM g4hpn_anief_asssemblee_scuole,g4hpn_anief_scuole as a

  WHERE id_assemblea = 73957 
  AND a.id IN (51837,51914,51899,51817,51822,51831,51897,51898,51907,51915,51917,51921,35689,35687,35795,35829,35468,35697,35474,35676,35485,35712,35733,35695,35681,57333,57313,35796,35896,35686,57235,35701,57229,35527,35723,35702,35665,57838,35418,35694,57298,57282,57337,57307,57334,57326,57776,57777,35715,35798,35860,35884,35887,35545,35550,35557,35714,35827,35704,57312,35566)

  GROUP BY a.id

  ORDER BY text asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_anief_asssemblee_scuole	ref	id_assemblea	id_assemblea	4	const	61	Using temporary; Using filesort
1	SIMPLE	a	range	PRIMARY	PRIMARY	4	NULL	61	Using where; Using join buffer (flat, BNL join)

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.19 ms
Copying to tmp table	12.36 ms
Sorting result	0.10 ms
Sending data	0.17 ms
end	0.01 ms
removing tmp table	0.12 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:1500
19	JDatabaseDriver->loadAssocList()	JROOT/components/com_anief/models/fields/scuolelist.php:37
18	JFormFieldScuolelist->getOptions()	JROOT/libraries/joomla/form/fields/list.php:58
17	JFormFieldList->getInput()	JROOT/libraries/src/Form/FormField.php:975
16	Joomla\CMS\Form\FormField->renderField()	JROOT/libraries/src/Form/Form.php:670
15	Joomla\CMS\Form\Form->renderField()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:328
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 9.20 ms Memoria query: 0.025 MB memoria prima della query: 3.727 MB Righe restituite: 1

SELECT *

  FROM g4hpn_anief_users_collaboratori

  WHERE id=20

Explain

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

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.00 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 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:1656
16	JDatabaseDriver->loadObject()	JROOT/components/com_anief/helpers/common.php:5589
15	AniefCommon::getInfoCollaboratore()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:419
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.80 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.076 MB memoria prima della query: 3.741 MB Righe restituite: 61

SELECT a.*

  FROM g4hpn_anief_scuole as a

  INNER JOIN g4hpn_anief_asssemblee_scuole as b 
  on b.id_scuola = a.id

  WHERE b.id_assemblea = 73957

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	id_assemblea,id_scuola	id_assemblea	4	const	61
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	admin_test_db.b.id_scuola	1

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 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.00 ms
Sending data	0.48 ms
end	0.01 ms
query end	0.00 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:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_anief/helpers/common.php:1549
15	AniefCommon::renderScuoleAssemblea()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:436
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.24 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.025 MB memoria prima della query: 3.951 MB Righe restituite: 1

SELECT nome

  FROM g4hpn_anief_province

  WHERE sigla='TR'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_anief_province	ref	sigla	sigla	768	const	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
17	JDatabaseDriver->loadResult()	JROOT/components/com_anief/helpers/common.php:5656
16	AniefCommon::getProvinciaFromSigla()	JROOT/components/com_anief/helpers/common.php:1556
15	AniefCommon::renderScuoleAssemblea()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:436
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.21 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.025 MB memoria prima della query: 3.962 MB Righe restituite: 1

SELECT nome

  FROM g4hpn_anief_province

  WHERE sigla='PG'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_anief_province	ref	sigla	sigla	768	const	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
17	JDatabaseDriver->loadResult()	JROOT/components/com_anief/helpers/common.php:5656
16	AniefCommon::getProvinciaFromSigla()	JROOT/components/com_anief/helpers/common.php:1556
15	AniefCommon::renderScuoleAssemblea()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:436
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.20 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.024 MB memoria prima della query: 3.767 MB Righe restituite: 1

Query duplicate: #17

SELECT reg_obb

  FROM g4hpn_anief_activities

  WHERE id = 73957

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_anief_activities	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.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 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:1734
16	JDatabaseDriver->loadResult()	JROOT/components/com_anief/helpers/common.php:1245
15	AniefCommon::canPartecipate()	JROOT/components/com_anief/views/dettaglievento/tmpl/default.php:452
14	include JROOT/components/com_anief/views/dettaglievento/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_anief/views/baseview.php:38
11	AniefViewBasicUser->display()	JROOT/components/com_anief/views/dettaglievento/view.html.php:35
10	AniefViewdettaglievento->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_anief/controller.php:5722
8	AniefController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_anief/anief.php:48
6	require_once JROOT/components/com_anief/anief.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.45 ms Dopo l'ultima query: 17.79 ms Memoria query: 0.064 MB memoria prima della query: 4.252 MB Righe restituite: 64

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

  FROM g4hpn_modules AS m

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

  LEFT JOIN g4hpn_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-11-16 05:00:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-16 05:00:37') 
  AND m.access IN (1,1,140) 
  AND m.client_id = 0 
  AND (mm.menuid = 1534 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	range	PRIMARY,published,newsfeeds	published	5	NULL	140	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_folder_clientid	402	admin_test_db.m.module	11	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	admin_test_db.m.id	12	Using where; Using index

Profilo

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.03 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.04 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.03 ms
Sorting result	0.64 ms
Sending data	2.14 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:592
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:539
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:330
8	Helix3::generatelayout()	JROOT/templates/anief2018/index.php:197
7	require JROOT/templates/anief2018/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.71 ms Dopo l'ultima query: 27.94 ms Memoria query: 0.026 MB memoria prima della query: 4.544 MB Righe restituite: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM g4hpn_fields AS a

  LEFT JOIN `g4hpn_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN g4hpn_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN g4hpn_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN g4hpn_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN g4hpn_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,140) 
  AND (a.group_id = 0 OR g.access IN (1,1,140)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	admin_test_db.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	admin_test_db.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	admin_test_db.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	admin_test_db.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	admin_test_db.a.group_id	1	Using where

Profilo

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 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.03 ms
statistics	0.10 ms
preparing	0.04 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.00 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Chiamata uguale alla linea sottostante.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->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: 4.34 ms Memoria query: 0.022 MB memoria prima della query: 4.574 MB Righe restituite: 1

SELECT `link`

  FROM `g4hpn_menu`

  WHERE `published`=1 
  AND `id`='790'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	g4hpn_menu	const	PRIMARY,published	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.06 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.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 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.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:1734
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_inline_login/helper.php:36
11	ModInlineLoginHelper::getReturnURL()	JROOT/modules/mod_inline_login/mod_inline_login.php:18
10	include JROOT/modules/mod_inline_login/mod_inline_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->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.99 ms Dopo l'ultima query: 8.11 ms Memoria query: 0.026 MB memoria prima della query: 4.757 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 `g4hpn_categories` AS `s`

  INNER JOIN `g4hpn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right,rgt	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	ref	cat_idx,idx_access,idx_left_right,extension,published,rgt	published	1	const	432	Using where

Profilo

Status	Duration
starting	0.14 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.05 ms
optimizing	0.04 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	1.24 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->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.46 ms Dopo l'ultima query: 0.53 ms Memoria query: 0.026 MB memoria prima della query: 4.786 MB Righe restituite: 3

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 `g4hpn_categories` AS `s`

  INNER JOIN `g4hpn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right,rgt	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	ref	cat_idx,idx_access,idx_left_right,extension,published,rgt	published	1	const	432	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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 `g4hpn_categories` AS `s` 
  INNER JOIN `g4hpn_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

2 × SELECT reg_obb 
  FROM g4hpn_anief_activities

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

2 × SELECT nome 
  FROM g4hpn_anief_province

1 × SELECT `link` 
  FROM `g4hpn_menu`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM g4hpn_fields AS a 
  LEFT JOIN `g4hpn_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN g4hpn_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN g4hpn_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN g4hpn_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN g4hpn_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM g4hpn_modules AS m 
  LEFT JOIN g4hpn_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN g4hpn_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.* 
  FROM g4hpn_anief_scuole as a 
  INNER JOIN g4hpn_anief_asssemblee_scuole as b 
  on b.id_scuola = a.id

1 × SELECT * 
  FROM g4hpn_anief_users_collaboratori

1 × SELECT id_scuola,a.id as value, CONCAT_WS(" - ",DES_NOM_SCU, COD_SCU_UT,  DES_TIP_IST) as text 
  FROM g4hpn_anief_asssemblee_scuole,g4hpn_anief_scuole as a

1 × SELECT id_scuola 
  FROM g4hpn_anief_asssemblee_scuole

1 × SELECT plugin 
  FROM g4hpn_ftc_comparti

1 × SELECT `data` 
  FROM `g4hpn_session`

1 × SELECT `session_id` 
  FROM `g4hpn_session`

1 × SELECT * 
  FROM g4hpn_anief_activities

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

```
1 × SELECT * 
  FROM g4hpn_languages
```

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

1 × SELECT `template` 
  FROM `g4hpn_template_styles`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM g4hpn_extensions

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

1 × SELECT id, rules 
  FROM `g4hpn_viewlevels

1 × SELECT id 
  FROM g4hpn_anief_asssemblee_scuole

ALTRE tabelle:

1 × INSERT INTO `g4hpn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('444o7g93s2sfr07qu67598p6tn', 1, 1731733237, 0, '', 0

1 × UPDATE `g4hpn_extensions` 
  SET `params` = '{\"mediaversion\":\"294de3fb1094486c96496101dfea3a2f\"}'

1 × SHOW FULL COLUMNS 
  FROM `g4hpn_anief_activities

Argomenti
Relatori	DANIELA ROSANO
Scuola	D.D. AMELIA "J. ORSINI", VIA CINQUE FONTI 94 5022 AMELIA Terni I.O. AMELIA, VIA I MAGGIO 224 5022 AMELIA Terni I.C. ATTIGLIANO - GUARDEA, VIA MONSERRATO 38 5012 ATTIGLIANO Terni D.D. TERNI "G.MAZZINI", VIA CARRARA 5100 TERNI Terni D.D. TERNI S.GIOVANNI, VIA LIUTPRANDO 32 5100 TERNI Terni D.D. TERNI "DON MILANI", VIA VODICE 23 5100 TERNI Terni I.C. TERNI "G.MARCONI", VIALE ROSSINI 87 5100 TERNI Terni I.C. TERNI "G.OBERDAN", VIA TRE VENEZIE 1 5100 TERNI Terni I.C. "FELICE FATATI", VIA DELLE TERRE ARNOLFE N.10 5100 TERNI Terni TERNI I.I.S. PROF.LE E TECN. COMM.LE, L.GO PAOLUCCI 1 5100 TERNI Terni TERNI I.I.S. CLASSICO E ARTISTICO, VIALE ANTONIO FRATTI 12 5100 TERNI Terni TERNI "L. DA VINCI E O. NUCULA", VIA LUIGI LANZI N. 15 5100 TERNI Terni I.C. ASSISI 1, VIA S. ANTONIO 1 6081 ASSISI Perugia I.C. ASSISI 3, VIA CROCE N. 30- FRAZ. PETRIGNANO 6081 ASSISI Perugia LICEO "PROPERZIO", PADRE LUDOVICO DA CASORIA 3 6081 ASSISI Perugia ALBERGHIERO ASSISI, VIA EREMO DELLE CARCERI 19 6081 ASSISI Perugia D.D. "DON BOSCO" BASTIA UMBRA, VIA ROMA 54 6083 BASTIA UMBRA Perugia I.C. BASTIA 1, VIA A. MANZONI 1 6083 BASTIA UMBRA Perugia D.D. "F. RASETTI" - C. LAGO, VIA CARDUCCI 25 6061 CASTIGLIONE DEL LAGO Perugia I.C. "P.VANNUCCI" C. PIEVE, P.ZZA MARCONI 6062 CITTA' DELLA PIEVE Perugia D.D. 2 CIRC.CASTELLO PIEVE ROSE, VIALE SEMPIONE 6012 CITTA' DI CASTELLO Perugia I.I.S. "PATRIZI-BALDELLI-CAVALLOTTI", VIA BOLOGNI 86 6012 CITTA' DI CASTELLO Perugia IST.1^ GR. "ALIGHIERI-PASCOLI", VIA DELLA TINA 12 6012 CITTA' DI CASTELLO Perugia I.C. "B. BONFIGLI" CORCIANO, VIA F. BALLARINI 27 6073 CORCIANO Perugia I.O. "G.MAMELI-A.MAGNINI", VIA TIBERINA 163 6053 DERUTA Perugia I.C. FOLIGNO 2, VIA PIERMARINI 19 6034 FOLIGNO Perugia I.C. FOLIGNO 1, VIA S. CATERINA 6034 FOLIGNO Perugia LICEO "F. FREZZI - B. ANGELA", VIALE MARCONI 12 6034 FOLIGNO Perugia IST.TECN.TECNOLOGICO "L. DA VINCI", VIALE GUGLIELMO MARCONI 6 6034 FOLIGNO Perugia I.O. GIANO-BASTARDO, VIA DON LUIGI STURZO 2 6030 GIANO DELL'UMBRIA Perugia I.C. GUALDO TADINO, VIA LUCANTONI 6023 GUALDO TADINO Perugia I.I.S. "R. CASIMIRI", VIA DON BOSCO 31 6023 GUALDO TADINO Perugia I.I.S. "CASSATA - GATTAPONE", VIA DEL BOTTAGNONE 40 6024 GUBBIO Perugia D.D. MAGIONE, VIA RIPA 1 6063 MAGIONE Perugia I.O. "G. MAZZINI", PIAZZA SIMONCINI 1 6063 MAGIONE Perugia I.O. "SALVATORELLI-MONETA", VIA CARDINALE FRANCESCO SATOLLI 4 6055 MARSCIANO Perugia I.O. NORCIA "A.DE GASPERI-BAT", VIALE LOMBRICI 2 6046 NORCIA Perugia I.C. PANICALE PIEGARO PACIANO, VIA PABLO PICASSO 2 6068 PANICALE Perugia D.D. 2^ CIRCOLO "COMPAROZZI", VIA MAGNO MAGNINI 6127 PERUGIA Perugia I.C. PERUGIA 12, VIA CESTELLINI 3 6135 PERUGIA Perugia I.C. PERUGIA 1 "F. MORLACCHI", VIA M.B. VALENTINI 6123 PERUGIA Perugia I.C. PERUGIA 15, VIA V. HUGO 3 6134 PERUGIA Perugia I.C. PERUGIA 11, VIA ALFREDO COTANI 1 6128 PERUGIA Perugia I.C. PERUGIA 7, STRADA LACUGNANO 6132 PERUGIA Perugia I.C. PERUGIA 9, VIA DEL PAPAVERO 2/4 6132 PERUGIA Perugia I.C. PERUGIA 6, VIA DELL'ARMONIA 77 6132 PERUGIA Perugia I. C. PERUGIA 4, VIA G. P. DA PALESTRINA SNC 6124 PERUGIA Perugia I.C. PERUGIA 5, VIA CHIUSI 6129 PERUGIA Perugia I.I.S. "CAVOUR-MARCONI-PASCAL", VIA ASSISANA 40/D 6135 PERUGIA Perugia LICEO "A. PIERALLI", PIAZZALE ANNA FRANK 11 6124 PERUGIA Perugia I.O. "B. DI BETTO", VIA LUIGI CANALI 27 6124 PERUGIA Perugia ITAS "GIORDANO BRUNO", VIA MARIO ANGELUCCI 1 6132 PERUGIA Perugia IST.TECN.TECNOLOGICO "A.VOLTA", VIA ASSISANA 40/E 6135 PERUGIA Perugia D.D.SAN GIUSTINO F. T. BUFALINI, VIA DE AMICIS 6016 SAN GIUSTINO Perugia D.D. 1 CIRCOLO SPOLETO, P.ZZA XX SETTEMBRE 8 6049 SPOLETO Perugia D.D. II CIRCOLO SPOLETO, VIA CERQUIGLIA 61 6049 SPOLETO Perugia I.I.S. " G. SPAGNA - F.LLI CAMPANI ", VIA VISSO 6049 SPOLETO Perugia "G. DE CAROLIS", VIA SAN PAOLO INTER VINEAS 6049 SPOLETO Perugia I.I.S. "CIUFFELLI - EINAUDI", VIALE MONTECRISTO 3 6059 TODI Perugia I.C. TORGIANO-BETTONA, VIA PASQUALE TIRADOSSI 13 6089 TORGIANO Perugia D.D.2 CIRC.UMBERTIDE DI VITTORI, VIA CAPITINI N.2 6019 UMBERTIDE Perugia
Link	La registrazione a questo evento è obbligatoria. Se ti sei iscritto con il tuo account effettua il login, altrimenti se hai utilizzato una mail non registrata inserisci il codice di accesso in alto nella pagina attuale.
Email per informazioni	umbria@anief.net
Data	28-03-2022 a partire dalle 08:00 / 11:00

ASSEMBLEA SINDACALE ANIEF PERUGIA_TERNI 28/03/2022

VUOI SCOPRIRE SE IL TUO STIPENDIO È CORRETTO?

REGISTRATI

Accedi tramite codice

SUPPORTO ONLINE

> AMMINISTRAZIONE

> PREADESIONE AI RICORSI

> FORMAZIONE

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

30 query eseguite 40.61 ms

Trovati 2 duplicati!

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle:

Accedi ai servizi online

ASSEMBLEA SINDACALE ANIEF PERUGIA_TERNI 28/03/2022

VUOI SCOPRIRE SE IL TUO STIPENDIO È CORRETTO?

REGISTRATI

Accedi tramite codice

SUPPORTO ONLINE

> AMMINISTRAZIONE

> PREADESIONE AI RICORSI

> FORMAZIONE

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

30 query eseguite 40.61 ms

Trovati 2 duplicati!

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: