{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713269974,
                "last": 1713269974,
                "now": 1713269974
            },
            "token": "eDaJ5DjbvDopLadP5sOjGu9gpxGGq2cu"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            },
            "com_visforms": {
                "form2": null,
                "messages": {
                    "form2": null
                }
            }
        },
        "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
        }
    }
}

Tempo

Memoria

27 query eseguite 33.13 ms

1. Tempo della query: 1.09 ms Memoria query: 0.007 MB memoria prima della query: 4.119 MB Righe restituite: 0

   SELECT `data`
   
     FROM `jospl_session`
   
     WHERE `session_id` = X'6534383564376662616361336134313566333139333062396466336238336235'

   Explain

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

   Profilo

   Status	Duration
   starting	0.18 ms
   checking permissions	0.01 ms
   Opening tables	0.43 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.05 ms
   freeing items	0.10 ms
   cleaning up	0.03 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: 0.70 ms Dopo l'ultima query: 2.03 ms Memoria query: 0.004 MB memoria prima della query: 4.214 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `jospl_session`
   
     WHERE `session_id` = X'6534383564376662616361336134313566333139333062396466336238336235' 
     LIMIT 1

   Explain

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

   Profilo

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

   Call Stack

   #	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

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

   ---

3. Tempo della query: 0.72 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.004 MB memoria prima della query: 4.220 MB

   INSERT INTO `jospl_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6534383564376662616361336134313566333139333062396466336238336235', 1, 1713269974, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `jospl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6534383564376662616361336134313566333139333062396466336238336235', 1, 1713269974, 0, '', 0)

   Profilo

   Status	Duration
   starting	0.18 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.02 ms
   update	0.14 ms
   end	0.02 ms
   query end	0.07 ms
   closing tables	0.05 ms
   freeing items	0.10 ms
   cleaning up	0.03 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]

   ---

4. Tempo della query: 1.51 ms Dopo l'ultima query: 3.84 ms Memoria query: 0.006 MB memoria prima della query: 4.471 MB Righe restituite: 44

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jospl_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	jospl_extensions	NULL	ref	extension	extension	82	const	44	1.00	Using where

   Profilo

   Status	Duration
   starting	0.17 ms
   checking permissions	0.01 ms
   Opening tables	0.44 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.10 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.31 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.05 ms
   freeing items	0.11 ms
   cleaning up	0.03 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]

   ---

5. Tempo della query: 1.32 ms Dopo l'ultima query: 3.80 ms Memoria query: 0.005 MB memoria prima della query: 4.672 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `jospl_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   starting	0.46 ms
   checking permissions	0.02 ms
   Opening tables	0.45 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.05 ms
   freeing items	0.07 ms
   cleaning up	0.02 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]

   ---

6. Tempo della query: 1.11 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.005 MB memoria prima della query: 4.684 MB Righe restituite: 2

   SELECT b.id
   
     FROM jospl_usergroups AS a
   
     LEFT JOIN jospl_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.17 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.38 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.04 ms
   statistics	0.11 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.05 ms
   freeing items	0.10 ms
   cleaning up	0.03 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]

   ---

7. Tempo della query: 1.53 ms Dopo l'ultima query: 1.09 ms Memoria query: 0.005 MB memoria prima della query: 4.752 MB Righe restituite: 98

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jospl_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	jospl_extensions	NULL	ref	extension	extension	82	const	122	0.60	Using index condition; Using where; Using filesort

   Profilo

   Status	Duration
   starting	0.14 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.03 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.03 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.87 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.04 ms
   freeing items	0.10 ms
   cleaning up	0.03 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]

   ---

8. Tempo della query: 1.15 ms Dopo l'ultima query: 156.95 ms Memoria query: 0.006 MB memoria prima della query: 29.539 MB Righe restituite: 1

   select email 
     from jospl_users 
     where id=672 
     LIMIT 1

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:307
   12	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:320
   11	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:23
   10	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:197
   9	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:369
   8	plgSystembfstop->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.75 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.006 MB memoria prima della query: 29.548 MB Righe restituite: 0

   SELECT id, ipaddress 
     from jospl_bfstop_allowlist 
     WHERE (ipaddress='3.17.150.163' 
     AND LOCATE('/', ipaddress) = 0)

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
   10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:224
   9	BFStopDBHelper->isIPOnAllowList()	JROOT/plugins/system/bfstop/bfstop.php:388
   8	plgSystembfstop->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]

   ---

10. Tempo della query: 0.71 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.006 MB memoria prima della query: 29.554 MB Righe restituite: 0

    SELECT id, ipaddress 
      from jospl_bfstop_allowlist 
      WHERE ((LOCATE('/', ipaddress) != 0 
      AND LOCATE('.', ipaddress) != 0 
      AND (INET_ATON('3.17.150.163') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
    10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:225
    9	BFStopDBHelper->isIPOnAllowList()	JROOT/plugins/system/bfstop/bfstop.php:388
    8	plgSystembfstop->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]

    ---

11. Tempo della query: 1.18 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.006 MB memoria prima della query: 29.560 MB Righe restituite: 0

    SELECT id, ipaddress, crdate, duration 
      FROM jospl_bfstop_bannedip b 
      WHERE (ipaddress='3.17.150.163' 
      AND LOCATE('/', ipaddress) = 0) 
      AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-04-16 12:19:34') 
      AND NOT EXISTS (SELECT 1 
      FROM jospl_bfstop_unblock u 
      WHERE b.id = u.block_id)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	b	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	82	10.00	Using where
    2	DEPENDENT SUBQUERY	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
    10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:214
    9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:392
    8	plgSystembfstop->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]

    ---

12. Tempo della query: 1.05 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.006 MB memoria prima della query: 29.566 MB Righe restituite: 0

    SELECT id, ipaddress, crdate, duration 
      FROM jospl_bfstop_bannedip b 
      WHERE ((LOCATE('/', ipaddress) != 0 
      AND LOCATE('.', ipaddress) != 0 
      AND (INET_ATON('3.17.150.163') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) 
      AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-04-16 12:19:34') 
      AND NOT EXISTS (SELECT 1 
      FROM jospl_bfstop_unblock u 
      WHERE b.id = u.block_id)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	b	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	82	100.00	Using where
    2	DEPENDENT SUBQUERY	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:188
    10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:215
    9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:392
    8	plgSystembfstop->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]

    ---

13. Tempo della query: 1.09 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.005 MB memoria prima della query: 29.572 MB Righe restituite: 1

    SELECT `template`
    
      FROM `jospl_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jospl_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	14.29	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
    9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
    8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

14. Tempo della query: 1.71 ms Dopo l'ultima query: 5.98 ms Memoria query: 0.009 MB memoria prima della query: 29.928 MB Righe restituite: 17

    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 jospl_menu AS m
    
      LEFT JOIN jospl_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	43	3.33	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	tz2j9snu_joom944.m.component_id	1	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
    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]

    ---

15. Tempo della query: 0.87 ms Dopo l'ultima query: 12.51 ms Memoria query: 0.007 MB memoria prima della query: 30.631 MB Righe restituite: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jospl_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	jospl_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.53 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.005 MB memoria prima della query: 30.622 MB

    UPDATE `jospl_extensions`
    
      SET `params` = '{\"mediaversion\":\"3a911bbe243c371165229196870432e3\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.07 ms
    updating	0.08 ms
    end	0.01 ms
    query end	0.05 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 1.38 ms Dopo l'ultima query: 2.13 ms Memoria query: 0.004 MB memoria prima della query: 30.883 MB Righe restituite: 2

    SELECT *
    
      FROM jospl_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	jospl_languages	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.21 ms
    checking permissions	0.02 ms
    Opening tables	0.51 ms
    init	0.05 ms
    System lock	0.05 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.03 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.11 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.06 ms
    freeing items	0.10 ms
    cleaning up	0.03 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]

    ---

18. Tempo della query: 0.79 ms Dopo l'ultima query: 0.43 ms Memoria query: 0.003 MB memoria prima della query: 30.896 MB Righe restituite: 5

    SELECT id, home, template, s.params
    
      FROM jospl_template_styles as s
    
      LEFT JOIN jospl_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	8	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	tz2j9snu_joom944.e.element	1	71.43	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 1.20 ms Dopo l'ultima query: 19.41 ms Memoria query: 0.006 MB memoria prima della query: 31.849 MB Righe restituite: 1

    SELECT *
    
      FROM `jospl_visforms`
    
      WHERE `id` = 2

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_visforms/models/visforms.php:279
    10	VisformsModelVisforms->getForm()	JROOT/components/com_visforms/models/visforms.php:605
    9	VisformsModelVisforms->addHits()	JROOT/components/com_visforms/controller.php:41
    8	VisformsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_visforms/visforms.php:19
    6	require_once JROOT/components/com_visforms/visforms.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]

    ---

20. Tempo della query: 0.74 ms Dopo l'ultima query: 2.38 ms Memoria query: 0.005 MB memoria prima della query: 32.003 MB

    UPDATE `jospl_visforms`
    
      SET `hits` = 21311
    
      WHERE `id` = 2

    Explain

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

    Profilo

    Status	Duration
    starting	0.18 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.06 ms
    updating	0.12 ms
    end	0.02 ms
    query end	0.06 ms
    closing tables	0.04 ms
    freeing items	0.09 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/components/com_visforms/models/visforms.php:613
    9	VisformsModelVisforms->addHits()	JROOT/components/com_visforms/controller.php:41
    8	VisformsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_visforms/visforms.php:19
    6	require_once JROOT/components/com_visforms/visforms.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]

    ---

21. Tempo della query: 2.37 ms Dopo l'ultima query: 5.80 ms Memoria query: 0.009 MB memoria prima della query: 32.230 MB Righe restituite: 44

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jospl_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_aimysitemap','com_ajax','com_akeeba','com_associations','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cookiesck','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_visforms','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jospl_assets	NULL	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	127	35.43	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_visforms/helpers/visforms.php:97
    11	VisformsHelper::getActions()	JROOT/components/com_visforms/views/visforms/view.html.php:72
    10	VisformsViewVisforms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_visforms/controller.php:70
    8	VisformsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_visforms/visforms.php:19
    6	require_once JROOT/components/com_visforms/visforms.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]

    ---

22. Tempo della query: 0.92 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.009 MB memoria prima della query: 32.290 MB Righe restituite: 7

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jospl_assets`
    
      WHERE `name` LIKE 'com_visforms.%' OR `name` = 'com_visforms' OR `parent_id` = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jospl_assets	NULL	ALL	idx_asset_name,idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	127	24.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_visforms/helpers/visforms.php:97
    11	VisformsHelper::getActions()	JROOT/components/com_visforms/views/visforms/view.html.php:72
    10	VisformsViewVisforms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_visforms/controller.php:70
    8	VisformsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_visforms/visforms.php:19
    6	require_once JROOT/components/com_visforms/visforms.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]

    ---

23. Tempo della query: 1.59 ms Dopo l'ultima query: 1.33 ms Memoria query: 0.008 MB memoria prima della query: 32.324 MB Righe restituite: 4

    SELECT *
    
      FROM `jospl_visfields`
    
      WHERE `fid` = 2 
      AND `published` = 1 
      AND not `editonlyfield` = 1 
      AND `typefield` in ('text','password','email','date','number','url','hidden','checkbox','multicheckbox','radio','select','file','image','submit','reset','fieldsep','textarea')
    
      ORDER BY `ordering` asc

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_visforms/models/visforms.php:418
    14	VisformsModelVisforms->getItems()	JROOT/components/com_visforms/models/visforms.php:440
    13	VisformsModelVisforms->getValidatedFields()	JROOT/components/com_visforms/models/visforms.php:583
    12	VisformsModelVisforms->getFields()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_visforms/views/visforms/view.html.php:95
    10	VisformsViewVisforms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_visforms/controller.php:70
    8	VisformsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_visforms/visforms.php:19
    6	require_once JROOT/components/com_visforms/visforms.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]

    ---

24. Tempo della query: 0.90 ms Dopo l'ultima query: 72.42 ms Memoria query: 0.007 MB memoria prima della query: 33.892 MB Righe restituite: 35

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jospl_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jospl_assets	NULL	ALL	idx_asset_name,idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	127	24.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    13	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    9	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:128
    8	ContentModelArticle->getItem()	JROOT/plugins/system/cookiesck/cookiesck.php:164
    7	plgSystemCookiesck->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]

    ---

25. Tempo della query: 2.04 ms Dopo l'ultima query: 0.54 ms Memoria query: 0.005 MB memoria prima della query: 33.943 MB Righe restituite: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM jospl_content AS a
    
      INNER JOIN jospl_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN jospl_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN jospl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jospl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 23 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-16 12:19:34') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-16 12:19:34')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,idx_catid	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    9	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    8	ContentModelArticle->getItem()	JROOT/plugins/system/cookiesck/cookiesck.php:164
    7	plgSystemCookiesck->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]

    ---

26. Tempo della query: 1.54 ms Dopo l'ultima query: 2.28 ms Memoria query: 0.009 MB memoria prima della query: 34.029 MB Righe restituite: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jospl_categories` AS `s`
    
      INNER JOIN `jospl_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 2
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	3	73.33	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    17	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/cookiesck/cookiesck.php:168
    7	plgSystemCookiesck->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]

    ---

27. Tempo della query: 2.63 ms Dopo l'ultima query: 5.20 ms Memoria query: 0.008 MB memoria prima della query: 34.317 MB Righe restituite: 13

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jospl_modules AS m
    
      LEFT JOIN jospl_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jospl_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-04-16 12:19:34') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-16 12:19:34') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 131 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	range	PRIMARY,published,newsfeeds	published	5	NULL	18	2.94	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	tz2j9snu_joom944.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	tz2j9snu_joom944.m.id	1	40.00	Using where; Using index

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/j51_classic/php/config.php:6
    8	require JROOT/templates/j51_classic/php/config.php	JROOT/templates/j51_classic/index.php:12
    7	require JROOT/templates/j51_classic/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]

    ---

22 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 3 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `jospl_assets`

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

3. 2 × SELECT id, ipaddress 
     from jospl_bfstop_allowlist

4. 2 × SELECT id, ipaddress, crdate, duration 
     FROM jospl_bfstop_bannedip b

5. 1 × SELECT `data` 
     FROM `jospl_session`

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

7. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM `jospl_categories` AS `s` 
     INNER JOIN `jospl_categories` AS `c` 
     ON (s.lft <= c.lft 
     AND c.lft < s.rgt) OR (c.lft < s.lft 
     AND s.rgt < c.rgt)

8. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
     FROM jospl_content AS a 
     INNER JOIN jospl_categories AS c 
     on c.id = a.catid 
     LEFT JOIN jospl_users AS u 
     on u.id = a.created_by 
     LEFT JOIN jospl_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN jospl_content_rating AS v 
     ON a.id = v.content_id

9. 1 × SELECT * 
     FROM `jospl_visfields`

10. 1 × SELECT * 
      FROM `jospl_visforms`

11. 1 × SELECT `template` 
      FROM `jospl_template_styles`

12. 1 × SELECT * 
      FROM jospl_languages

13. 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 jospl_menu AS m 
      LEFT JOIN jospl_extensions AS e 
      ON m.component_id = e.extension_id

14. 1 × SELECT `session_id` 
      FROM `jospl_session`

15. 1 × select email 
      from jospl_users

16. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM jospl_extensions

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

18. 1 × SELECT id, rules 
      FROM `jospl_viewlevels

19. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM jospl_modules AS m 
      LEFT JOIN jospl_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN jospl_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

ALTRE tabelle:

1. 1 × INSERT INTO `jospl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'6534383564376662616361336134313566333139333062396466336238336235', 1, 1713269974, 0, '', 0

2. 1 × UPDATE `jospl_extensions` 
     SET `params` = '{\"mediaversion\":\"3a911bbe243c371165229196870432e3\"}'

3. 1 × UPDATE `jospl_visforms` 
     SET `hits` = 21311