istitutocomprensivotaurisano
A SCUOLA SI CRESCE

{
    "__default": {
        "session": {
            "counter": 13,
            "timer": {
                "start": 1716018296,
                "last": 1716018321,
                "now": 1716018325
            },
            "token": "2Ab8CyQY6theCewbGMX3AgHy1shCaMZ7"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaXN0aXR1dG9jb21wcmVuc2l2b3RhdXJpc2Fuby5lZHUuaXQvaW5kZXgucGhwL2RpZGF0dGljYS9idW9uZS1wcmF0aWNoZS9tYXRlcmlhbGUtZGlkYXR0aWNvLWNvbWkvY2F0ZWdvcnkvNTYtYXR0aXZpdGEtNS1kaWNlbmJyZT8%3D"
            },
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "c9ef18b7c4649203db8da82446fbf2bd7a004811",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "9c97da9f7de83139fb23c0fad1602b7d28d36578": {
                    "link": "https://www.istitutocomprensivotaurisano.edu.it/index.php/scuola/informazioni-generali/le-scuole-dell-infanzia",
                    "expiry": 1716018303
                },
                "7ac55a00a488bb5e2c4b5f69fc57a408d920c0e9": {
                    "link": "https://www.istitutocomprensivotaurisano.edu.it/index.php/pubblicita-e-anticorruzione/pon/1448-10-2-2a-ponfse-pu-2024-65-competenti-verso-il-futuro-graduatoria-di-merito",
                    "expiry": 1716018312
                }
            }
        },
        "theme": "italia",
        "event_id": 7,
        "event_date": "",
        "session_date": ""
    }
}

Tempo

Memoria

19 query eseguite 23.65 ms

1. Tempo della query: 0.66 ms Memoria query: 0.023 MB memoria prima della query: 1.044 MB Righe restituite: 1

   SELECT `data`
   
     FROM `bj2r0_session`
   
     WHERE `session_id` = X'613275363469677630756f6e33716c3069736b73356d6570306c'

   Explain

   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

   Profilo

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 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
   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

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

   ---

2. Tempo della query: 1.78 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.079 MB memoria prima della query: 1.097 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.05 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.55 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]

   ---

3. Tempo della query: 0.46 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.021 MB memoria prima della query: 1.171 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.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.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
   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]

   ---

4. Tempo della query: 0.55 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.021 MB memoria prima della query: 1.185 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.05 ms
   checking permissions	0.00 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.08 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.02 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]

   ---

5. Tempo della query: 2.10 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.035 MB memoria prima della query: 1.207 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.00 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.39 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.06 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]

   ---

6. Tempo della query: 0.55 ms Dopo l'ultima query: 12.58 ms Memoria query: 0.021 MB memoria prima della query: 1.818 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.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.02 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]

   ---

7. Tempo della query: 4.54 ms Dopo l'ultima query: 11.15 ms Memoria query: 0.268 MB memoria prima della query: 2.110 MB Righe restituite: 222

   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.72	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.10 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.05 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   Creating sort index	3.60 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.05 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]

   ---

8. Tempo della query: 1.16 ms Dopo l'ultima query: 2.91 ms Memoria query: 0.020 MB memoria prima della query: 2.910 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-18 07:45:25' 
     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	81.56	Using where

   Profilo

   Status	Duration
   starting	0.08 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.02 ms
   statistics	0.14 ms
   preparing	0.05 ms
   executing	0.00 ms
   Sending data	0.29 ms
   end	0.00 ms
   query end	0.11 ms
   closing tables	0.03 ms
   freeing items	0.05 ms
   cleaning up	0.00 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]

   ---

9. Tempo della query: 0.68 ms Dopo l'ultima query: 3.94 ms Memoria query: 0.025 MB memoria prima della query: 3.112 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.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.15 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.06 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
   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]

   ---

10. Tempo della query: 0.75 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.006 MB memoria prima della query: 3.105 MB

    UPDATE `bj2r0_extensions`
    
      SET `params` = '{\"mediaversion\":\"3ed2ff7f1f6cf4e64938a2d8f097b47b\"}'
    
      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.05 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.09 ms
    updating	0.16 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.09 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]

    ---

11. Tempo della query: 0.85 ms Dopo l'ultima query: 0.60 ms Memoria query: 0.021 MB memoria prima della query: 3.129 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.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.17 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
    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]

    ---

12. Tempo della query: 0.58 ms Dopo l'ultima query: 0.40 ms Memoria query: 0.019 MB memoria prima della query: 3.245 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.08 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
    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]

    ---

13. Tempo della query: 0.75 ms Dopo l'ultima query: 3.01 ms Memoria query: 0.022 MB memoria prima della query: 3.434 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= 56 
      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	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.10 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.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 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
    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]

    ---

14. Tempo della query: 1.18 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 3.442 MB Righe restituite: 0

    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 = 56 
      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	73	1.37	Using where; Using temporary; Using filesort
    1	SIMPLE	c	NULL	ref	catid	catid	5	Sql1466330_1.cc.id,const	6	100.00	Using where

    Profilo

    Status	Duration
    starting	0.10 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
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.39 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.05 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.00 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]

    ---

15. Tempo della query: 2.08 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.039 MB memoria prima della query: 3.450 MB Righe restituite: 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 
      WHERE  c.catid= 56 
      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 <= '2024-05-18 07:45:25' ) 
      AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-05-18 07:45:25' ) 
      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	1	5.00	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.15 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.12 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.13 ms
    preparing	0.07 ms
    Creating tmp table	0.14 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.48 ms
    Creating sort index	0.10 ms
    end	0.00 ms
    query end	0.16 ms
    removing tmp table	0.05 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.10 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]

    ---

16. Tempo della query: 0.86 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.022 MB memoria prima della query: 3.462 MB Righe restituite: 1

    SELECT c.id 
      FROM bj2r0_phocadownload AS c 
      LEFT JOIN bj2r0_phocadownload_categories AS cc 
      ON cc.id = c.catid 
      WHERE  c.catid= 56 
      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 <= '2024-05-18 07:45:25' ) 
      AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2024-05-18 07:45:25' ) 
      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	1	5.00	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.08 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
    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]

    ---

17. Tempo della query: 0.55 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 3.470 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.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 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.01 ms
    Creating sort index	0.07 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: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]

    ---

18. Tempo della query: 0.50 ms Dopo l'ultima query: 5.09 ms Memoria query: 0.020 MB memoria prima della query: 3.589 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.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.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.00 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]

    ---

19. Tempo della query: 3.09 ms Dopo l'ultima query: 46.56 ms Memoria query: 0.024 MB memoria prima della query: 3.841 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-18 07:45:25') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-18 07:45:25') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 570 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.16 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	1.89 ms
    end	0.01 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
    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]

    ---

18 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

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

2. 1 × SELECT `data` 
     FROM `bj2r0_session`

3. 1 × SELECT id, rules 
     FROM `bj2r0_viewlevels

4. 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

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

6. 1 × SELECT `extension` 
     FROM `bj2r0_action_logs_extensions`

7. 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

8. 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

9. 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

10. 1 × SELECT * 
      FROM bj2r0_languages

11. 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

12. 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

13. 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

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

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

16. 1 × SELECT id,placeholder 
      FROM `bj2r0_gdpr_checkbox

17. 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. 1 × UPDATE `bj2r0_extensions` 
     SET `params` = '{\"mediaversion\":\"3ed2ff7f1f6cf4e64938a2d8f097b47b\"}'