Materiale didattico Lopez

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1702230259,
                "last": 1702230259,
                "now": 1702230259
            },
            "token": "dykrSjjnwETg9vy2sy5nutv3QTtuWSgu"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaXN0aXR1dG9jb21wcmVuc2l2b3RhdXJpc2Fuby5lZHUuaXQvaW5kZXgucGhwL2RpZGF0dGljYS9idW9uZS1wcmF0aWNoZS9tYXRlcmlhbGUtZGlkYXR0aWNvLWxvcGV6Pw%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
        },
        "theme": "italia"
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 302.14 ms / 347.58 ms Memoria: 2.150 MB / 2.91 MB Application: afterInitialise

Tempo: 73.94 ms / 421.52 ms Memoria: 0.295 MB / 3.20 MB Application: afterRoute

Tempo: 15.03 ms / 436.55 ms Memoria: 0.045 MB / 3.25 MB Application: beforeRenderComponent com_phocadownload

Tempo: 92.92 ms / 529.47 ms Memoria: 0.381 MB / 3.63 MB Application: afterRenderComponent com_phocadownload

Tempo: 17.16 ms / 546.63 ms Memoria: 0.102 MB / 3.73 MB Application: afterDispatch

Tempo: 172.20 ms / 718.82 ms Memoria: 0.167 MB / 3.90 MB Application: beforeRenderModule mod_menu (Info portale)

Tempo: 7.79 ms / 726.61 ms Memoria: 0.035 MB / 3.93 MB Application: afterRenderModule mod_menu (Info portale)

Tempo: 0.03 ms / 726.64 ms Memoria: -0.004 MB / 3.93 MB Application: beforeRenderModule mod_menu (Sitemap)

Tempo: 0.34 ms / 726.98 ms Memoria: 0.009 MB / 3.94 MB Application: afterRenderModule mod_menu (Sitemap)

Tempo: 0.06 ms / 727.04 ms Memoria: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_schemaorg (Sede Amministrativa)

Tempo: 5.20 ms / 732.24 ms Memoria: 0.015 MB / 3.95 MB Application: afterRenderModule mod_schemaorg (Sede Amministrativa)

Tempo: 0.03 ms / 732.28 ms Memoria: -0.006 MB / 3.95 MB Application: beforeRenderModule mod_schemaorg (Recapiti Telefonici)

Tempo: 0.78 ms / 733.06 ms Memoria: 0.006 MB / 3.95 MB Application: afterRenderModule mod_schemaorg (Recapiti Telefonici)

Tempo: 0.03 ms / 733.08 ms Memoria: -0.002 MB / 3.95 MB Application: beforeRenderModule mod_schemaorg (Contatti)

Tempo: 29.38 ms / 762.46 ms Memoria: 0.143 MB / 4.09 MB Application: afterRenderModule mod_schemaorg (Contatti)

Tempo: 0.04 ms / 762.50 ms Memoria: -0.004 MB / 4.09 MB Application: beforeRenderModule mod_custom (Codici Istituzionali)

Tempo: 2.84 ms / 765.34 ms Memoria: 0.007 MB / 4.10 MB Application: afterRenderModule mod_custom (Codici Istituzionali)

Tempo: 0.07 ms / 765.41 ms Memoria: -0.001 MB / 4.09 MB Application: beforeRenderModule mod_menu (ORARIO LEZIONI SINCRONE)

Tempo: 0.17 ms / 765.58 ms Memoria: 0.004 MB / 4.10 MB Application: afterRenderModule mod_menu (ORARIO LEZIONI SINCRONE)

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

Tempo: 8.73 ms / 774.35 ms Memoria: 0.510 MB / 4.61 MB Application: afterRenderModule mod_menu (Burger Menu)

Tempo: 0.06 ms / 774.41 ms Memoria: -0.012 MB / 4.59 MB Application: beforeRenderModule mod_menu (Mega Menu)

Tempo: 5.13 ms / 779.55 ms Memoria: 0.162 MB / 4.76 MB Application: afterRenderModule mod_menu (Mega Menu)

Tempo: 0.06 ms / 779.61 ms Memoria: -0.020 MB / 4.74 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 3.44 ms / 783.04 ms Memoria: 0.014 MB / 4.75 MB Application: afterRenderModule mod_search (Cerca)

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

Tempo: 0.70 ms / 783.80 ms Memoria: 0.011 MB / 4.76 MB Application: afterRenderModule mod_menu (Joomla per la scuola)

Tempo: 12.60 ms / 796.40 ms Memoria: 0.308 MB / 5.06 MB Application: afterRender

Query totali del database: 221.32 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

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

#	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

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.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

#	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'6a346c62707636696f636a6d3263646775376d716b6962306575', 1, 1702230259, 0, '', 0)

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
update	0.07 ms
Waiting for query cache lock	0.00 ms
update	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
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: 6.27 ms Dopo l'ultima query: 3.05 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.03 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.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.95 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.70 ms
cleaning up	0.01 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: 53.07 ms Dopo l'ultima query: 3.12 ms Memoria query: 0.021 MB memoria prima della query: 1.167 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.01 ms
Opening tables	0.01 ms
init	51.46 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.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 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: 1.96 ms Dopo l'ultima query: 0.14 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.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 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: 4.11 ms Dopo l'ultima query: 0.43 ms Memoria query: 0.035 MB memoria prima della query: 1.265 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.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 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: 1.66 ms Dopo l'ultima query: 47.98 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 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: 18.58 ms Dopo l'ultima query: 47.68 ms Memoria query: 0.268 MB memoria prima della query: 2.107 MB Righe restituite: 220

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	364	9.15	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.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	11.54 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 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: 58.68 ms Dopo l'ultima query: 3.80 ms Memoria query: 0.020 MB memoria prima della query: 2.895 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` <= '2023-12-10 17:44:19' 
  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	69	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	79.37	Using where

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	55.95 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.07 ms
executing	0.01 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.09 ms
closing tables	0.08 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: 44.45 ms Dopo l'ultima query: 23.17 ms Memoria query: 0.024 MB memoria prima della query: 3.097 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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	42.54 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.04 ms
cleaning up	0.01 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: 1.55 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.006 MB memoria prima della query: 3.089 MB

UPDATE `bj2r0_extensions`

  SET `params` = '{\"mediaversion\":\"71283c0b892a823f143aa13cb9e4d875\"}'

  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.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.11 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 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: 2.83 ms Dopo l'ultima query: 3.51 ms Memoria query: 0.021 MB memoria prima della query: 3.176 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	100.00	Using index condition; Using where

Profilo

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.27 ms
end	0.26 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 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: 1.97 ms Dopo l'ultima query: 1.42 ms Memoria query: 0.019 MB memoria prima della query: 3.229 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.06 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.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 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.30 ms Dopo l'ultima query: 39.15 ms Memoria query: 0.022 MB memoria prima della query: 3.417 MB Righe restituite: 1

SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias 
  FROM bj2r0_phocadownload_categories AS cc 
  LEFT JOIN bj2r0_phocadownload_categories AS pc 
  ON pc.id = cc.parent_id 
  WHERE  cc.id= 12 
  AND  cc.access IN (1,1,5) 
  AND  cc.published = 1 
  ORDER BY cc.ordering 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	pc	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:88
11	PhocaDownloadModelCategory->getCategory()	JROOT/components/com_phocadownload/views/category/view.html.php:41
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:56
6	require_once JROOT/components/com_phocadownload/phocadownload.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: 3.88 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.023 MB memoria prima della query: 3.425 MB Righe restituite: 7

SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc 
  FROM bj2r0_phocadownload_categories AS cc 
  LEFT JOIN bj2r0_phocadownload AS c 
  ON c.catid = cc.id 
  AND c.published = 1 
  AND c.textonly = 0 
  WHERE  cc.parent_id = 12 
  AND  cc.access IN (1,1,5) 
  AND  cc.published = 1 
  GROUP BY cc.id, cc.title, cc.alias, cc.access, cc.accessuserid 
  ORDER BY cc.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	ALL	idx_access	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	69	1.45	Using where; Using temporary; Using filesort
1	SIMPLE	c	NULL	ref	catid	catid	5	Sql1466330_1.cc.id,const	7	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:96
11	PhocaDownloadModelCategory->getSubcategories()	JROOT/components/com_phocadownload/views/category/view.html.php:42
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:56
6	require_once JROOT/components/com_phocadownload/phocadownload.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.42 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.047 MB memoria prima della query: 3.439 MB Righe restituite: 7

SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
  FROM bj2r0_phocadownload AS c 
  LEFT JOIN bj2r0_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  LEFT JOIN bj2r0_phocadownload_file_votes_statistics AS r 
  ON r.fileid = c.id 
  WHERE  c.catid= 12 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND c.access IN (1,1,5) ) ) 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND cc.access IN (1,1,5) ) ) 
  AND  c.published = 1 
  AND  c.approved = 1 
  AND  cc.published = 1 
  AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-12-10 17:44:19' ) 
  AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-12-10 17:44:19' ) 
  ORDER BY c.ordering ASC 
  LIMIT 0, 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	c	NULL	ref	catid	catid	5	const,const	7	0.71	Using where
1	SIMPLE	r	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profilo

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.16 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.17 ms
preparing	0.10 ms
Creating tmp table	0.19 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.67 ms
Creating sort index	0.28 ms
end	0.01 ms
query end	0.09 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:80
11	PhocaDownloadModelCategory->getFileList()	JROOT/components/com_phocadownload/views/category/view.html.php:43
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:56
6	require_once JROOT/components/com_phocadownload/phocadownload.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: 2.67 ms Dopo l'ultima query: 1.48 ms Memoria query: 0.022 MB memoria prima della query: 3.472 MB Righe restituite: 7

SELECT c.id 
  FROM bj2r0_phocadownload AS c 
  LEFT JOIN bj2r0_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  WHERE  c.catid= 12 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND c.access IN (1,1,5) ) ) 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND cc.access IN (1,1,5) ) ) 
  AND  c.published = 1 
  AND  c.approved = 1 
  AND  cc.published = 1 
  AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-12-10 17:44:19' ) 
  AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-12-10 17:44:19' ) 
  ORDER BY c.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	ref	catid	catid	5	const,const	7	0.71	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_phocadownload/models/category.php:72
12	PhocaDownloadModelCategory->getTotal()	JROOT/components/com_phocadownload/models/category.php:64
11	PhocaDownloadModelCategory->getPagination()	JROOT/components/com_phocadownload/views/category/view.html.php:44
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:56
6	require_once JROOT/components/com_phocadownload/phocadownload.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: 2.14 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.022 MB memoria prima della query: 3.486 MB Righe restituite: 3

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM bj2r0_phocadownload_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Explain

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

Profilo

Status	Duration
starting	0.10 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.02 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:22
11	PhocaDownloadRenderFront::renderAllCSS()	JROOT/components/com_phocadownload/views/category/view.html.php:46
10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:56
6	require_once JROOT/components/com_phocadownload/phocadownload.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.56 ms Dopo l'ultima query: 51.26 ms Memoria query: 0.020 MB memoria prima della query: 3.632 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.02 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.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 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: 4.64 ms Dopo l'ultima query: 177.00 ms Memoria query: 0.024 MB memoria prima della query: 3.884 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 <= '2023-12-10 17:44:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-10 17:44:19') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 569 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	69	1.45	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.17 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.91 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.09 ms
freeing items	0.06 ms
cleaning up	0.01 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]

20 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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

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, 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 cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias 
  FROM bj2r0_phocadownload_categories AS cc 
  LEFT JOIN bj2r0_phocadownload_categories AS pc 
  ON pc.id = cc.parent_id

1 × SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc 
  FROM bj2r0_phocadownload_categories AS cc 
  LEFT JOIN bj2r0_phocadownload AS c 
  ON c.catid = cc.id 
  AND c.published = 1 
  AND c.textonly = 0

1 × SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
  FROM bj2r0_phocadownload AS c 
  LEFT JOIN bj2r0_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  LEFT JOIN bj2r0_phocadownload_file_votes_statistics AS r 
  ON r.fileid = c.id

1 × SELECT c.id 
  FROM bj2r0_phocadownload AS c 
  LEFT JOIN bj2r0_phocadownload_categories AS cc 
  ON cc.id = c.catid

1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM bj2r0_phocadownload_styles AS a

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'6a346c62707636696f636a6d3263646775376d716b6962306575', 1, 1702230259, 0, '', 0

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

istitutocomprensivotaurisano
A SCUOLA SI CRESCE