Convocazione Commissione Regolamento d'Istituto

Eventi

Data: Giovedì 16 Gennaio 2020 16:00

Luogo: Auditorium

Si comunica che giovedì 16 gennaio 2020, alle ore 16.00 presso la sede di via Negrelli 3, sono convocati i componenti della Commissione regolamento di Istituto.

Cordiali saluti.

Altre date

Giovedì 16 Gennaio 2020 16:00

Torna su

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714660169,
                "last": 1714660169,
                "now": 1714660169
            },
            "token": "zuUL2kiyjeenbu2KDlzoCP93Oe5WVvQv"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaXN0aXR1dG9jb21wcmVuc2l2b3RhdXJpc2Fuby5lZHUuaXQvaW5kZXgucGhwL3NlcnZpemkvY2FsZW5kYXJpby1ldmVudGkvY2FsZW5kYXJpby1ldmVudGkvMy1jb252b2NhemlvbmUtY29tbWlzc2lvbmUtcmVnb2xhbWVudG8tZC1pc3RpdHV0by8yMDIwLTAxLTE2LTE2LTAwPw%3D%3D"
            }
        },
        "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
        },
        "event_id": 3,
        "event_date": "2020-01-16 16:00:00",
        "session_date": "2020-01-16 16:00:00",
        "theme": "italia"
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 48.59 ms / 48.59 ms Memoria: 0.424 MB / 0.76 MB Application: afterLoad

Tempo: 204.78 ms / 253.36 ms Memoria: 2.156 MB / 2.91 MB Application: afterInitialise

Tempo: 48.18 ms / 301.54 ms Memoria: 0.368 MB / 3.28 MB Application: afterRoute

Tempo: 5.70 ms / 307.24 ms Memoria: 0.041 MB / 3.32 MB Application: beforeRenderComponent com_icagenda

Tempo: 54.37 ms / 361.61 ms Memoria: 0.088 MB / 3.41 MB Application: Before Access::preloadComponents (all components)

Tempo: 2.57 ms / 364.18 ms Memoria: 0.064 MB / 3.47 MB Application: After Access::preloadComponents (all components)

Tempo: 0.04 ms / 364.22 ms Memoria: -0.004 MB / 3.47 MB Application: Before Access::getAssetRules (id:1100 name:com_icagenda)

Tempo: 0.88 ms / 365.10 ms Memoria: 0.015 MB / 3.49 MB Application: After Access::getAssetRules (id:1100 name:com_icagenda)

Tempo: 158.40 ms / 523.50 ms Memoria: 0.490 MB / 3.98 MB Application: afterRenderComponent com_icagenda

Tempo: 1.95 ms / 525.45 ms Memoria: 0.008 MB / 3.98 MB Application: afterDispatch

Tempo: 308.06 ms / 833.52 ms Memoria: 0.159 MB / 4.14 MB Application: beforeRenderModule mod_menu (Info portale)

Tempo: 11.83 ms / 845.35 ms Memoria: 0.034 MB / 4.18 MB Application: afterRenderModule mod_menu (Info portale)

Tempo: 0.06 ms / 845.41 ms Memoria: -0.004 MB / 4.17 MB Application: beforeRenderModule mod_menu (Sitemap)

Tempo: 0.47 ms / 845.87 ms Memoria: 0.008 MB / 4.18 MB Application: afterRenderModule mod_menu (Sitemap)

Tempo: 0.09 ms / 845.97 ms Memoria: 0.000 MB / 4.18 MB Application: beforeRenderModule mod_schemaorg (Sede Amministrativa)

Tempo: 7.51 ms / 853.48 ms Memoria: 0.016 MB / 4.20 MB Application: afterRenderModule mod_schemaorg (Sede Amministrativa)

Tempo: 0.04 ms / 853.52 ms Memoria: -0.006 MB / 4.19 MB Application: beforeRenderModule mod_schemaorg (Recapiti Telefonici)

Tempo: 1.13 ms / 854.65 ms Memoria: 0.007 MB / 4.20 MB Application: afterRenderModule mod_schemaorg (Recapiti Telefonici)

Tempo: 0.03 ms / 854.69 ms Memoria: -0.002 MB / 4.20 MB Application: beforeRenderModule mod_schemaorg (Contatti)

Tempo: 10.20 ms / 864.88 ms Memoria: 0.009 MB / 4.21 MB Application: afterRenderModule mod_schemaorg (Contatti)

Tempo: 0.04 ms / 864.92 ms Memoria: -0.003 MB / 4.20 MB Application: beforeRenderModule mod_custom (Codici Istituzionali)

Tempo: 4.54 ms / 869.47 ms Memoria: 0.006 MB / 4.21 MB Application: afterRenderModule mod_custom (Codici Istituzionali)

Tempo: 0.08 ms / 869.55 ms Memoria: -0.001 MB / 4.21 MB Application: beforeRenderModule mod_menu (ORARIO LEZIONI SINCRONE)

Tempo: 0.18 ms / 869.73 ms Memoria: 0.004 MB / 4.21 MB Application: afterRenderModule mod_menu (ORARIO LEZIONI SINCRONE)

Tempo: 0.04 ms / 869.77 ms Memoria: -0.002 MB / 4.21 MB Application: beforeRenderModule mod_menu (Burger Menu)

Tempo: 9.28 ms / 879.05 ms Memoria: 0.508 MB / 4.72 MB Application: afterRenderModule mod_menu (Burger Menu)

Tempo: 0.08 ms / 879.13 ms Memoria: -0.012 MB / 4.71 MB Application: beforeRenderModule mod_menu (Mega Menu)

Tempo: 5.27 ms / 884.40 ms Memoria: 0.161 MB / 4.87 MB Application: afterRenderModule mod_menu (Mega Menu)

Tempo: 0.07 ms / 884.47 ms Memoria: -0.020 MB / 4.85 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 5.88 ms / 890.36 ms Memoria: 0.015 MB / 4.86 MB Application: afterRenderModule mod_search (Cerca)

Tempo: 0.06 ms / 890.42 ms Memoria: -0.004 MB / 4.86 MB Application: beforeRenderModule mod_menu (Joomla per la scuola)

Tempo: 0.90 ms / 891.32 ms Memoria: 0.011 MB / 4.87 MB Application: afterRenderModule mod_menu (Joomla per la scuola)

Tempo: 19.72 ms / 911.04 ms Memoria: 0.393 MB / 5.26 MB Application: afterRender

Query totali del database: 38.97 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN non possibile sulla query: INSERT INTO `bj2r0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'35723270637539626f7431397637377638656331686971343572', 1, 1714660169, 0, '', 0)

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
update	0.10 ms
Waiting for query cache lock	0.00 ms
update	0.00 ms
end	0.00 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.04 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.72 ms Dopo l'ultima query: 5.41 ms Memoria query: 0.079 MB memoria prima della query: 1.093 MB Righe restituite: 46

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

  FROM `bj2r0_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_extensions	NULL	ref	extension	extension	82	const	47	1.00	Using where

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.54 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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.56 ms Dopo l'ultima query: 4.01 ms Memoria query: 0.021 MB memoria prima della query: 1.168 MB Righe restituite: 11

SELECT id, rules

  FROM `bj2r0_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_viewlevels	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	11	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
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:318
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:225
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: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 1.244 MB Righe restituite: 2

SELECT b.id

  FROM bj2r0_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
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:318
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:225
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: 2.09 ms Dopo l'ultima query: 0.44 ms Memoria query: 0.035 MB memoria prima della query: 1.266 MB Righe restituite: 129

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

  FROM bj2r0_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_extensions	NULL	ref	extension	extension	82	const	152	0.60	Using index condition; Using where; Using filesort

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.38 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
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:225
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.51 ms Dopo l'ultima query: 74.17 ms Memoria query: 0.021 MB memoria prima della query: 1.815 MB Righe restituite: 1

SELECT `extension`

  FROM `bj2r0_action_logs_extensions`

  WHERE `extension` = 'com_icagenda'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_action_logs_extensions	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	19	10.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/actionlog/icagenda/icagenda.php:111
10	PlgActionlogIcagenda->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
9	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
8	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/actionlogs/actionlogs.php:64
7	PlgSystemActionLogs->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
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:225
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: 4.56 ms Dopo l'ultima query: 53.52 ms Memoria query: 0.268 MB memoria prima della query: 2.108 MB Righe restituite: 221

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

  LEFT JOIN bj2r0_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	384	8.70	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1466330_1.m.component_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	3.56 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:37
8	PlgSystemDropfiles->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:668
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:225
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.27 ms Dopo l'ultima query: 4.99 ms Memoria query: 0.020 MB memoria prima della query: 2.902 MB Righe restituite: 0

SELECT `v`.`item_id`

  FROM `bj2r0_fields` f

  INNER JOIN `bj2r0_fields_values` v 
  ON f.id = v.field_id

  INNER JOIN `bj2r0_content` a 
  ON v.item_id = a.id

  WHERE `f`.`context` = 'com_content.article' 
  AND `f`.`name` = 'plg-system-autoarchive-date' 
  AND `v`.`value` 
  AND `v`.`value` <= '2024-05-02 14:29:30' 
  AND `a`.`state` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ALL	PRIMARY,idx_context	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7	14.29	Using where
1	SIMPLE	v	NULL	ALL	idx_field_id,idx_item_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	90	30.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	Sql1466330_1.v.item_id	1	80.83	Using where

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.30 ms
end	0.00 ms
query end	0.13 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/autoarchive/autoarchive.php:77
8	plgSystemAutoarchive->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:668
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:225
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.59 ms Dopo l'ultima query: 43.75 ms Memoria query: 0.021 MB memoria prima della query: 3.152 MB Righe restituite: 0

SELECT `id`

  FROM `bj2r0_icagenda_events`

  WHERE `alias` = '3-convocazione-commissione-regolamento-d-istituto'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_icagenda_events	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	11.11	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_icagenda/router.php:356
11	iCagendaRouter->getEventId()	JROOT/components/com_icagenda/router.php:332
10	iCagendaRouter->fixSegmentID()	JROOT/components/com_icagenda/router.php:220
9	iCagendaRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.58 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.024 MB memoria prima della query: 3.176 MB Righe restituite: 1

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

  FROM `bj2r0_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1381
8	plgSystemGdpr->onAfterRoute()	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:1190
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:225
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.66 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.006 MB memoria prima della query: 3.168 MB

UPDATE `bj2r0_extensions`

  SET `params` = '{\"mediaversion\":\"c01a188a379e387a0741111e40c032c4\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	bj2r0_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.10 ms
updating	0.09 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.07 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1381
8	plgSystemGdpr->onAfterRoute()	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:1190
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:225
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.89 ms Dopo l'ultima query: 3.84 ms Memoria query: 0.021 MB memoria prima della query: 3.255 MB Righe restituite: 6

SELECT id, home, template, s.params

  FROM bj2r0_template_styles as s

  LEFT JOIN bj2r0_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	Sql1466330_1.e.element	1	75.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
9	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/italiapa/italiapa.php:165
8	PlgSystemItaliaPA->onAfterRoute()	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:1190
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:225
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.51 ms Memoria query: 0.019 MB memoria prima della query: 3.302 MB Righe restituite: 2

SELECT *

  FROM bj2r0_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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: 2.24 ms Dopo l'ultima query: 59.21 ms Memoria query: 0.029 MB memoria prima della query: 3.415 MB Righe restituite: 46

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

  FROM `bj2r0_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_albopretorio_online','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_chronoconnectivity5','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dropfiles','com_fields','com_finder','com_icagenda','com_installer','com_j2xml','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_oziogallery3','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_rebuilder','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	47	100.00	Using index condition

Profilo

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.38 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_icagenda/models/event.php:64
14	iCagendaModelEvent->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_icagenda/models/event.php:88
12	iCagendaModelEvent->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_icagenda/views/event/view.html.php:53
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.56 ms Dopo l'ultima query: 3.26 ms Memoria query: 0.023 MB memoria prima della query: 3.494 MB Righe restituite: 1

Query duplicate: #20

SELECT e.params

  FROM `bj2r0_icagenda_events` AS `e`

  WHERE `e`.`id` = 3

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:358
13	icagendaEvent::getParams()	JROOT/components/com_icagenda/models/event.php:133
12	iCagendaModelEvent->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_icagenda/views/event/view.html.php:53
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.26 ms Dopo l'ultima query: 2.33 ms Memoria query: 0.023 MB memoria prima della query: 3.503 MB Righe restituite: 1

SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features,`r`.`count` AS `registered`

  FROM bj2r0_icagenda_events AS e

  LEFT JOIN bj2r0_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count

  FROM bj2r0_icagenda_feature_xref AS fx

  INNER JOIN bj2r0_icagenda_feature AS f 
  ON fx.feature_id = f.id 
  AND f.state = 1 
  AND f.icon <> '-1'

  GROUP BY fx.event_id) AS feat 
  ON e.id = feat.event_id

  LEFT JOIN (
SELECT `r`.`eventid`,sum(`r`.`people`) AS count

  FROM `bj2r0_icagenda_registration` AS `r`

  WHERE `r`.`status` = 1 
  AND `r`.`state` = 1 
  AND (r.date = '2020-01-16 16:00:00' OR (r.date = "" 
  AND r.period = 1))

  GROUP BY r.eventid) AS r 
  ON e.id = r.eventid

  WHERE e.state = 1 
  AND c.state = 1 
  AND e.id = 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	e	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	NULL
1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	NULL
3	DERIVED	r	NULL	ref	idx_state,idx_eventid,idx_status	idx_state	1	const	2	40.74	Using index condition; Using where; Using temporary; Using filesort
2	DERIVED	fx	NULL	ALL	idx_event_id,idx_feature_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using temporary; Using filesort
2	DERIVED	f	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	Sql1466330_1.fx.feature_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.18 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.97 ms
init	0.18 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.53 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
optimizing	0.02 ms
statistics	0.72 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.44 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.26 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_icagenda/models/event.php:219
12	iCagendaModelEvent->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_icagenda/views/event/view.html.php:53
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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: 14.06 ms Memoria query: 0.006 MB memoria prima della query: 3.594 MB

UPDATE bj2r0_icagenda_events 
  SET hits = hits + 1 
  WHERE id = 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	bj2r0_icagenda_events	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_icagenda/models/event.php:304
11	iCagendaModelEvent->hit()	JROOT/components/com_icagenda/views/event/view.html.php:135
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.39 ms Dopo l'ultima query: 36.83 ms Memoria query: 0.025 MB memoria prima della query: 3.684 MB Righe restituite: 1

Query duplicate: #17

SELECT e.params

  FROM `bj2r0_icagenda_events` AS `e`

  WHERE `e`.`id` = 3

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 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.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:358
17	icagendaEvent::getParams()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:451
16	icagendaEvent::backArrow()	JROOT/components/com_icagenda/views/event/tmpl/default_top.php:28
15	include JROOT/components/com_icagenda/views/event/tmpl/default_top.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_icagenda/views/event/tmpl/default.php:28
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.76 ms Dopo l'ultima query: 12.02 ms Memoria query: 0.028 MB memoria prima della query: 3.717 MB Righe restituite: 0

SELECT DISTINCT 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 bj2r0_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_icagenda.event' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profilo

Status	Duration
starting	0.22 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.26 ms
preparing	0.06 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.28 ms
Creating sort index	0.05 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Chiamata uguale alla linea sottostante.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:34
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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: 4.05 ms Dopo l'ultima query: 15.02 ms Memoria query: 0.025 MB memoria prima della query: 3.750 MB Righe restituite: 0

SELECT cfd.*, cf.*

  FROM `bj2r0_icagenda_customfields_data` AS cfd

  LEFT JOIN bj2r0_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 3 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cfd	NULL	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
1	SIMPLE	cf	NULL	ref	idx_state,idx_parent_form	idx_state	1	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.46 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	1.76 ms
preparing	0.01 ms
Creating tmp table	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.09 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
16	icagendaEventData::loadEventCustomFields()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:1420
15	icagendaEvent::getCustomFields()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:39
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.64 ms Dopo l'ultima query: 13.70 ms Memoria query: 0.026 MB memoria prima della query: 3.831 MB Righe restituite: 1

Query duplicate: #24 #26

SELECT sum(`r`.`people`) AS total

  FROM `bj2r0_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 3 
  AND `r`.`status` = 1 
  AND `r`.`state` = 1 
  AND (r.date = '2020-01-16 16:00:00' OR (r.date = "" 
  AND r.period = 1))

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ref	idx_state,idx_eventid,idx_status	idx_eventid	4	const	1	33.33	Using where

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.21 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.00 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:65
20	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:103
19	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:138
18	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:290
17	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:882
16	icagendaRegistration::upcomingDatesBooking()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:522
15	icagendaRegistration::registerButton()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:342
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.19 ms Memoria query: 0.025 MB memoria prima della query: 3.842 MB Righe restituite: 1

Query duplicate: #23 #26

SELECT sum(`r`.`people`) AS total

  FROM `bj2r0_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 3 
  AND `r`.`status` = 1 
  AND `r`.`state` = 1 
  AND (r.date = '2020-01-16 16:00:00' OR (r.date = "" 
  AND r.period = 1))

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ref	idx_state,idx_eventid,idx_status	idx_eventid	4	const	1	33.33	Using where

Profilo

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 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.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:65
17	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:945
16	icagendaRegistration::ticketsCouldBeBooked()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:523
15	icagendaRegistration::registerButton()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:342
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.59 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.025 MB memoria prima della query: 3.850 MB Righe restituite: 1

SELECT sum(`r`.`people`) AS total

  FROM `bj2r0_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 3 
  AND `r`.`status` = 1 
  AND `r`.`state` = 1 
  AND (r.date = '2020-01-16-16-00' OR (r.date = "" 
  AND r.period = 1))

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ref	idx_state,idx_eventid,idx_status	idx_eventid	4	const	1	33.33	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:65
16	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:551
15	icagendaRegistration::registerButton()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:342
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.31 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.026 MB memoria prima della query: 3.862 MB Righe restituite: 1

Query duplicate: #23 #24

SELECT sum(`r`.`people`) AS total

  FROM `bj2r0_icagenda_registration` AS `r`

  WHERE `r`.`eventid` = 3 
  AND `r`.`status` = 1 
  AND `r`.`state` = 1 
  AND (r.date = '2020-01-16 16:00:00' OR (r.date = "" 
  AND r.period = 1))

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ref	idx_state,idx_eventid,idx_status	idx_eventid	4	const	1	33.33	Using where

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 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.00 ms
freeing items	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:1740
20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:65
19	icagendaRegistration::getRegisteredTotal()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:103
18	icagendaRegistration::getTicketsAvailable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:138
17	icagendaRegistration::getTicketsBookable()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:290
16	icagendaRegistration::formDatesList()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:638
15	icagendaRegistration::registerButton()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:342
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.10 ms Dopo l'ultima query: 2.25 ms Memoria query: 0.025 MB memoria prima della query: 3.870 MB Righe restituite: 2

SELECT m.title, m.published, m.id, m.params, m.language, m.client_id

  FROM bj2r0_menu AS m

  WHERE (m.link = 'index.php?option=com_icagenda&view=list') 
  AND (m.published = 1) 
  AND (m.client_id = 0)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	384	0.87	Using where

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.57 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:56
16	icagendaMenus::iClistMenuItemsInfo()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:646
15	icagendaRegistration::registerButton()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:342
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.31 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.028 MB memoria prima della query: 3.886 MB Righe restituite: 1

SELECT `alias`

  FROM `bj2r0_icagenda_events`

  WHERE `id` = 3

Explain

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

Profilo

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_icagenda/router.php:275
23	iCagendaRouter->getEventSegment()	JROOT/components/com_icagenda/router.php:126
22	iCagendaRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_icagenda/utilities/registration/registration.php:805
15	icagendaRegistration::registerButton()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:342
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.91 ms Dopo l'ultima query: 24.32 ms Memoria query: 0.025 MB memoria prima della query: 3.908 MB Righe restituite: 0

SELECT  r.id AS regID, r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail,
						u.name AS name, u.username AS username, GROUP_CONCAT(ua.user_action) AS user_action

  FROM bj2r0_icagenda_registration AS r

  LEFT JOIN bj2r0_users as u 
  ON u.id = r.userid

  LEFT JOIN bj2r0_icagenda_user_actions as ua 
  ON ua.parent_id = r.id

  WHERE r.eventid = 3 
  AND r.status = 1 
  AND r.state = 1 
  AND (r.date = '2020-01-16 16:00:00' OR (r.date = "" 
  AND r.period = 1))

  GROUP BY r.id, ua.parent_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ref	idx_state,idx_eventid,idx_status	idx_eventid	4	const	1	33.33	Using where; Using temporary; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1466330_1.r.userid	1	100.00	NULL
1	SIMPLE	ua	NULL	ref	idx_parent_id	idx_parent_id	4	Sql1466330_1.r.id	1	100.00	Using where

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.82 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.16 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.03 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
removing tmp table	0.02 ms
freeing items	0.06 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/registration/participants.php:151
15	icagendaRegistrationParticipants::registeredUsers()	JROOT/components/com_icagenda/add/elements/icevent_vars.php:376
14	require_once JROOT/components/com_icagenda/add/elements/icevent_vars.php	JROOT/components/com_icagenda/views/event/tmpl/default.php:36
13	include JROOT/components/com_icagenda/views/event/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/event/view.html.php:177
10	iCagendaViewEvent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.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:225
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.57 ms Dopo l'ultima query: 17.67 ms Memoria query: 0.020 MB memoria prima della query: 3.977 MB Righe restituite: 0

SELECT id,placeholder

  FROM `bj2r0_gdpr_checkbox`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bj2r0_gdpr_checkbox	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1646
7	plgSystemGdpr->onAfterDispatch()	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/SiteApplication.php:199
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:225
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: 2.30 ms Dopo l'ultima query: 303.52 ms Memoria query: 0.024 MB memoria prima della query: 4.140 MB Righe restituite: 13

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

  FROM bj2r0_modules AS m

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

  LEFT JOIN bj2r0_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-05-02 14:29:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-02 14:29:30') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 483 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	72	1.39	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql1466330_1.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	Sql1466330_1.m.id	4	40.00	Using where; Using index

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/italiapa/index.php:114
7	require JROOT/templates/italiapa/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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:

4 × SELECT sum(`r`.`people`) AS total 
  FROM `bj2r0_icagenda_registration` AS `r`

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

2 × SELECT e.params 
  FROM `bj2r0_icagenda_events` AS `e`

1 × SELECT `data` 
  FROM `bj2r0_session`

1 × SELECT `session_id` 
  FROM `bj2r0_session`

1 × SELECT id, rules 
  FROM `bj2r0_viewlevels

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

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

1 × SELECT `extension` 
  FROM `bj2r0_action_logs_extensions`

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

1 × SELECT `v`.`item_id` 
  FROM `bj2r0_fields` f 
  INNER JOIN `bj2r0_fields_values` v 
  ON f.id = v.field_id 
  INNER JOIN `bj2r0_content` a 
  ON v.item_id = a.id

1 × SELECT `id` 
  FROM `bj2r0_icagenda_events`

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

```
1 × SELECT * 
  FROM bj2r0_languages
```

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

1 × SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features,`r`.`count` AS `registered` 
  FROM bj2r0_icagenda_events AS e 
  LEFT JOIN bj2r0_icagenda_category AS c 
  ON c.id = e.catid 
  LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count 
  FROM bj2r0_icagenda_feature_xref AS fx 
  INNER JOIN bj2r0_icagenda_feature AS f 
  ON fx.feature_id = f.id 
  AND f.state = 1 
  AND f.icon <> '-1' 
  GROUP BY fx.event_id) AS feat 
  ON e.id = feat.event_id 
  LEFT JOIN ( SELECT `r`.`eventid`,sum(`r`.`people`) AS count 
  FROM `bj2r0_icagenda_registration` AS `r`

1 × SELECT DISTINCT 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 bj2r0_fields AS a 
  LEFT JOIN `bj2r0_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN bj2r0_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN bj2r0_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN bj2r0_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN bj2r0_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT cfd.*, cf.* 
  FROM `bj2r0_icagenda_customfields_data` AS cfd 
  LEFT JOIN bj2r0_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

1 × SELECT m.title, m.published, m.id, m.params, m.language, m.client_id 
  FROM bj2r0_menu AS m

1 × SELECT `alias` 
  FROM `bj2r0_icagenda_events`

1 × SELECT  r.id AS regID, r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail,       u.name AS name, u.username AS username, GROUP_CONCAT(ua.user_action) AS user_action 
  FROM bj2r0_icagenda_registration AS r 
  LEFT JOIN bj2r0_users as u 
  ON u.id = r.userid 
  LEFT JOIN bj2r0_icagenda_user_actions as ua 
  ON ua.parent_id = r.id

1 × SELECT id,placeholder 
  FROM `bj2r0_gdpr_checkbox

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

ALTRE tabelle:

1 × INSERT INTO `bj2r0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'35723270637539626f7431397637377638656331686971343572', 1, 1714660169, 0, '', 0

1 × UPDATE `bj2r0_extensions` 
  SET `params` = '{\"mediaversion\":\"c01a188a379e387a0741111e40c032c4\"}'

1 × UPDATE bj2r0_icagenda_events 
  SET hits = hits + 1

istitutocomprensivotaurisano
A SCUOLA SI CRESCE

Convocazione Commissione Regolamento d'Istituto

Altre date

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

31 query eseguite 38.97 ms

Trovati 5 duplicati!

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle:

Menu di navigazione

Convocazione Commissione Regolamento d'Istituto

Altre date

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

31 query eseguite 38.97 ms

Trovati 5 duplicati!

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: