Indagini Settore industriale - Studio D.E.P. srl - Diagnostica Edilizia Progettazione

Dettagli: Visite: 4107

Questo sito utilizza cookie per migliorare la tua esperienza e offrire servizi in linea con le tue preferenze. Chiudendo questo banner, scorrendo questa pagina o cliccando qualunque suo elemento acconsenti all’uso dei cookie. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie visita la Cookie Policy.
Accetto i cookie di questo sito Accetto

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1696133905,
                "last": 1696133905,
                "now": 1696133905
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 79.75 ms / 79.75 ms Memoria: 0.422 MB / 0.76 MB Application: afterLoad

Tempo: 196.67 ms / 276.42 ms Memoria: 0.995 MB / 1.75 MB Application: afterInitialise

Tempo: 45.75 ms / 322.16 ms Memoria: 0.286 MB / 2.04 MB Application: afterRoute

Tempo: 26.53 ms / 348.69 ms Memoria: 0.061 MB / 2.10 MB Application: beforeRenderComponent com_content

Tempo: 20.18 ms / 368.87 ms Memoria: 0.117 MB / 2.21 MB Application: Before Access::preloadComponents (all components)

Tempo: 2.48 ms / 371.36 ms Memoria: 0.055 MB / 2.27 MB Application: After Access::preloadComponents (all components)

Tempo: 0.04 ms / 371.39 ms Memoria: -0.003 MB / 2.27 MB Application: Before Access::preloadPermissions (com_content)

Tempo: 1.37 ms / 372.77 ms Memoria: 0.048 MB / 2.31 MB Application: After Access::preloadPermissions (com_content)

Tempo: 0.02 ms / 372.79 ms Memoria: -0.001 MB / 2.31 MB Application: Before Access::getAssetRules (id:85 name:com_content.article.29)

Tempo: 0.67 ms / 373.46 ms Memoria: 0.010 MB / 2.32 MB Application: After Access::getAssetRules (id:85 name:com_content.article.29)

Tempo: 85.00 ms / 458.46 ms Memoria: 0.224 MB / 2.55 MB Application: afterRenderComponent com_content

Tempo: 10.44 ms / 468.89 ms Memoria: 0.007 MB / 2.55 MB Application: afterDispatch

Tempo: 45.47 ms / 514.36 ms Memoria: 0.073 MB / 2.63 MB Application: beforeRenderModule mod_custom (Footer)

Tempo: 9.28 ms / 523.64 ms Memoria: 0.005 MB / 2.63 MB Application: afterRenderModule mod_custom (Footer)

Tempo: 0.81 ms / 524.45 ms Memoria: -0.020 MB / 2.61 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Tempo: 12.07 ms / 536.52 ms Memoria: 0.011 MB / 2.62 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Tempo: 3.28 ms / 539.80 ms Memoria: 0.020 MB / 2.64 MB Application: beforeRenderModule mod_search (Search)

Tempo: 4.66 ms / 544.46 ms Memoria: 0.018 MB / 2.66 MB Application: afterRenderModule mod_search (Search)

Tempo: 4.51 ms / 548.97 ms Memoria: -0.002 MB / 2.66 MB Application: beforeRenderModule mod_menu (SERVIZI)

Tempo: 14.87 ms / 563.84 ms Memoria: 0.103 MB / 2.76 MB Application: afterRenderModule mod_menu (SERVIZI)

Tempo: 3.95 ms / 567.79 ms Memoria: 0.001 MB / 2.76 MB Application: beforeRenderModule mod_custom_advanced (Facebook)

Tempo: 5.74 ms / 573.53 ms Memoria: 0.009 MB / 2.77 MB Application: afterRenderModule mod_custom_advanced (Facebook)

Tempo: 2.88 ms / 576.42 ms Memoria: -0.003 MB / 2.77 MB Application: beforeRenderModule mod_custom (Brochure)

Tempo: 0.10 ms / 576.52 ms Memoria: 0.004 MB / 2.77 MB Application: afterRenderModule mod_custom (Brochure)

Tempo: 2.12 ms / 578.63 ms Memoria: 0.000 MB / 2.77 MB Application: beforeRenderModule mod_menu (Main Menu)

Tempo: 3.34 ms / 581.98 ms Memoria: 0.043 MB / 2.82 MB Application: afterRenderModule mod_menu (Main Menu)

Tempo: 4.12 ms / 586.10 ms Memoria: 0.011 MB / 2.83 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Tempo: 3.50 ms / 589.60 ms Memoria: 0.037 MB / 2.86 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Tempo: 256.15 ms / 845.75 ms Memoria: 0.322 MB / 3.19 MB Application: afterRender

Query totali del database: 73.31 ms

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

Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

EXPLAIN non possibile sulla query: INSERT INTO `r7a9s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3861346239356b64656734636830763539627562616561753163', 1, 1696133905, 0, '', 0)

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tempo della query: 2.43 ms Dopo l'ultima query: 8.83 ms Memoria query: 0.024 MB memoria prima della query: 1.162 MB Righe restituite: 36

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

  FROM `r7a9s_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_extensions	ref	extension	extension	62	const	45	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.13 ms Dopo l'ultima query: 5.76 ms Memoria query: 0.021 MB memoria prima della query: 1.187 MB Righe restituite: 5

SELECT id, rules

  FROM `r7a9s_viewlevels`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

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

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

Tempo della query: 1.51 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 1.199 MB Righe restituite: 2

SELECT b.id

  FROM r7a9s_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

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

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

Tempo della query: 3.73 ms Dopo l'ultima query: 3.26 ms Memoria query: 0.030 MB memoria prima della query: 1.224 MB Righe restituite: 67

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

  FROM r7a9s_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_extensions	ref	extension	extension	62	const	100	Using where; Using filesort

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.36 ms Dopo l'ultima query: 63.25 ms Memoria query: 0.022 MB memoria prima della query: 1.629 MB Righe restituite: 1

SELECT `value`

  FROM `r7a9s_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_admintools_storage	const	PRIMARY	PRIMARY	302	const	1

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.30 ms Dopo l'ultima query: 1.06 ms Memoria query: 0.021 MB memoria prima della query: 1.637 MB Righe restituite: 0

SELECT *

  FROM `r7a9s_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:549
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.53 ms Dopo l'ultima query: 24.75 ms Memoria query: 0.022 MB memoria prima della query: 1.735 MB Righe restituite: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN non possibile sulla query: SHOW VARIABLES LIKE "collation_database"

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:345
11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.44 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 1.745 MB Righe restituite: 0

SELECT `source`,`keepurlparams`

  FROM `r7a9s_admintools_redirects`

  WHERE ((`dest` = 'indagini-settore-industriale.html') OR (`dest` = 'indagini-settore-industriale.html') OR ('indagini-settore-industriale.html' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 3.81 ms Dopo l'ultima query: 8.61 ms Memoria query: 0.068 MB memoria prima della query: 1.843 MB Righe restituite: 33

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

  LEFT JOIN r7a9s_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	35	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql373622_1.m.component_id	1

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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]

Tempo della query: 2.66 ms Dopo l'ultima query: 37.74 ms Memoria query: 0.022 MB memoria prima della query: 2.055 MB Righe restituite: 1

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

  FROM `r7a9s_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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]

Tempo della query: 2.60 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.005 MB memoria prima della query: 2.045 MB

UPDATE `r7a9s_extensions`

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

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

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_extensions` SET `params` = '{\"mediaversion\":\"db6e37385037c4936815bbeefc7a943a\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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]

Tempo della query: 1.58 ms Dopo l'ultima query: 5.12 ms Memoria query: 0.019 MB memoria prima della query: 2.076 MB Righe restituite: 1

SELECT *

  FROM r7a9s_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_languages	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.68 ms Dopo l'ultima query: 3.56 ms Memoria query: 0.019 MB memoria prima della query: 2.088 MB Righe restituite: 2

SELECT id, home, template, s.params

  FROM r7a9s_template_styles as s

  LEFT JOIN r7a9s_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	Sql373622_1.s.template,const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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]

Tempo della query: 2.27 ms Dopo l'ultima query: 25.10 ms Memoria query: 0.028 MB memoria prima della query: 2.219 MB Righe restituite: 36

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

  FROM `r7a9s_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_assets	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	107	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.23 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.027 MB memoria prima della query: 2.267 MB Righe restituite: 38

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

  FROM `r7a9s_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_assets	ALL	idx_asset_name,idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	107	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 3.49 ms Dopo l'ultima query: 2.42 ms Memoria query: 0.031 MB memoria prima della query: 2.326 MB Righe restituite: 31

SHOW FULL COLUMNS 
  FROM `r7a9s_content`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.04 ms Dopo l'ultima query: 7.78 ms Memoria query: 0.005 MB memoria prima della query: 2.374 MB

UPDATE r7a9s_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '29'

Explain

EXPLAIN non possibile sulla query: UPDATE r7a9s_content SET `hits` = (`hits` + 1) WHERE `id` = '29'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 4.09 ms Dopo l'ultima query: 10.84 ms Memoria query: 0.023 MB memoria prima della query: 2.485 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 r7a9s_content AS a

  INNER JOIN r7a9s_categories AS c 
  on c.id = a.catid

  LEFT JOIN r7a9s_users AS u 
  on u.id = a.created_by

  LEFT JOIN r7a9s_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN r7a9s_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 29 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-01 04:18:25') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-01 04:18:25') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v	system	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	const row not found
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	system	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 2.27 ms Dopo l'ultima query: 8.76 ms Memoria query: 0.022 MB memoria prima della query: 2.532 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `r7a9s_contentitem_tag_map` AS m 

  INNER JOIN `r7a9s_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 29 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 2.96 ms Dopo l'ultima query: 88.56 ms Memoria query: 0.024 MB memoria prima della query: 2.602 MB Righe restituite: 8

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

  FROM r7a9s_modules AS m

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

  LEFT JOIN r7a9s_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-10-01 04:18:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-01 04:18:25') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 34 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	4	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql373622_1.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	Sql373622_1.m.module,const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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/protostar/index.php:91
7	require JROOT/templates/protostar/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]

Tempo della query: 0.28 ms Dopo l'ultima query: 92.55 ms Memoria query: 0.004 MB memoria prima della query: 2.931 MB

LOCK TABLES `r7a9s_extensions` WRITE

Explain

EXPLAIN non possibile sulla query: LOCK TABLES `r7a9s_extensions` WRITE

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:551
8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:78
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 1.11 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.004 MB memoria prima della query: 2.935 MB

UPDATE `r7a9s_extensions`

  SET `params` = '{\"email\":\"\",\"language_override\":\"\",\"lastrun\":1696133905}'

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'updatenotification'

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_extensions` SET `params` = '{\"email\":\"\",\"language_override\":\"\",\"lastrun\":1696133905}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:89
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.29 ms Dopo l'ultima query: 5.03 ms Memoria query: 0.004 MB memoria prima della query: 2.942 MB

UNLOCK TABLES

Explain

EXPLAIN non possibile sulla query: UNLOCK TABLES

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:926
8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:103
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 5.97 ms Dopo l'ultima query: 7.25 ms Memoria query: 0.021 MB memoria prima della query: 2.954 MB Righe restituite: 2

SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query

  FROM `r7a9s_update_sites` AS `a`

  INNER JOIN r7a9s_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

  WHERE a.enabled = 1 
  AND b.extension_id IN (700)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	index	PRIMARY	PRIMARY	8	NULL	13	Using where; Using index; Using temporary
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	Sql373622_1.b.update_site_id	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Updater/Updater.php:248
9	Joomla\CMS\Updater\Updater->getUpdateSites()	JROOT/libraries/src/Updater/Updater.php:127
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 3.18 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 2.961 MB Righe restituite: 2

SELECT DISTINCT update_site_id

  FROM r7a9s_updates

  WHERE `update_site_id` IN (
SELECT update_site_id

  FROM r7a9s_update_sites

  WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1696112305')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	r7a9s_updates	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	77	Using where; Using temporary
2	DEPENDENT SUBQUERY	r7a9s_update_sites	unique_subquery	PRIMARY	PRIMARY	4	func	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Updater/Updater.php:426
9	Joomla\CMS\Updater\Updater->getSitesWithUpdates()	JROOT/libraries/src/Updater/Updater.php:140
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.55 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.004 MB memoria prima della query: 2.965 MB

DELETE 

  FROM `r7a9s_updates`

  WHERE `update_site_id` = '1'

Explain

EXPLAIN non possibile sulla query: DELETE FROM `r7a9s_updates` WHERE `update_site_id` = '1'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/Updater.php:165
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.43 ms Dopo l'ultima query: 2.84 ms Memoria query: 0.022 MB memoria prima della query: 2.977 MB Righe restituite: 1

SELECT `name`

  FROM `r7a9s_update_sites`

  WHERE `update_site_id` = '1'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/src/Updater/UpdateAdapter.php:195
12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName()	JROOT/libraries/src/Updater/UpdateAdapter.php:222
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.35 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.006 MB memoria prima della query: 2.984 MB

UPDATE `r7a9s_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '1'

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '1'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:245
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 2.17 ms Dopo l'ultima query: 71.46 ms Memoria query: 0.006 MB memoria prima della query: 2.999 MB

UPDATE `r7a9s_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '1'

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '1'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:265
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 3.51 ms Dopo l'ultima query: 1.55 ms Memoria query: 0.028 MB memoria prima della query: 3.014 MB Righe restituite: 14

SHOW FULL COLUMNS 
  FROM `r7a9s_updates`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Update.php:32
14	Joomla\CMS\Table\Update->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126
12	Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement()	Chiamata uguale alla linea sottostante.
11	xml_parse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 2.33 ms Dopo l'ultima query: 1.58 ms Memoria query: 0.026 MB memoria prima della query: 3.041 MB Righe restituite: 18

SHOW FULL COLUMNS 
  FROM `r7a9s_extensions`

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Updater.php:330
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.60 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.021 MB memoria prima della query: 3.070 MB Righe restituite: 0

Query duplicate: #38

SELECT `update_id`

  FROM `r7a9s_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_updates	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	77	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Update.php:114
10	Joomla\CMS\Table\Update->find()	JROOT/libraries/src/Updater/Updater.php:338
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.63 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.021 MB memoria prima della query: 3.075 MB Righe restituite: 1

Query duplicate: #39

SELECT `extension_id`

  FROM `r7a9s_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_extensions	ref	element_clientid,element_folder_clientid,extension	extension	667	const,const,const,const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT/libraries/src/Updater/Updater.php:348
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.021 MB memoria prima della query: 3.081 MB Righe restituite: 1

Query duplicate: #40

SELECT *

  FROM r7a9s_extensions

  WHERE `extension_id` = '700'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Updater/Updater.php:358
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.40 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 3.087 MB Righe restituite: 0

Query duplicate: #35

SELECT `update_id`

  FROM `r7a9s_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_updates	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	77	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Update.php:114
10	Joomla\CMS\Table\Update->find()	JROOT/libraries/src/Updater/Updater.php:338
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.56 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.021 MB memoria prima della query: 3.092 MB Righe restituite: 1

Query duplicate: #36

SELECT `extension_id`

  FROM `r7a9s_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r7a9s_extensions	ref	element_clientid,element_folder_clientid,extension	extension	667	const,const,const,const	1	Using where

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT/libraries/src/Updater/Updater.php:348
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.26 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.021 MB memoria prima della query: 3.099 MB Righe restituite: 1

Query duplicate: #37

SELECT *

  FROM r7a9s_extensions

  WHERE `extension_id` = '700'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Updater/Updater.php:358
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.22 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.005 MB memoria prima della query: 3.096 MB

UPDATE `r7a9s_update_sites`

  SET `last_check_timestamp` = '1696133905'

  WHERE `update_site_id` = '1'

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_update_sites` SET `last_check_timestamp` = '1696133905' WHERE `update_site_id` = '1'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/Updater.php:455
9	Joomla\CMS\Updater\Updater->updateLastCheckTimestamp()	JROOT/libraries/src/Updater/Updater.php:182
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.20 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.004 MB memoria prima della query: 3.099 MB

DELETE 

  FROM `r7a9s_updates`

  WHERE `update_site_id` = '2'

Explain

EXPLAIN non possibile sulla query: DELETE FROM `r7a9s_updates` WHERE `update_site_id` = '2'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/Updater.php:165
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.20 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 3.106 MB Righe restituite: 1

SELECT `name`

  FROM `r7a9s_update_sites`

  WHERE `update_site_id` = '2'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/src/Updater/UpdateAdapter.php:195
12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName()	JROOT/libraries/src/Updater/UpdateAdapter.php:222
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.18 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.006 MB memoria prima della query: 3.113 MB

UPDATE `r7a9s_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '2'

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '2'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:245
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.53 ms Dopo l'ultima query: 124.68 ms Memoria query: 0.006 MB memoria prima della query: 3.123 MB

UPDATE `r7a9s_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '2'

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '2'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:265
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.56 ms Memoria query: 0.005 MB memoria prima della query: 3.124 MB

UPDATE `r7a9s_update_sites`

  SET `last_check_timestamp` = '1696133905'

  WHERE `update_site_id` = '2'

Explain

EXPLAIN non possibile sulla query: UPDATE `r7a9s_update_sites` SET `last_check_timestamp` = '1696133905' WHERE `update_site_id` = '2'

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/Updater.php:455
9	Joomla\CMS\Updater\Updater->updateLastCheckTimestamp()	JROOT/libraries/src/Updater/Updater.php:182
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.46 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.024 MB memoria prima della query: 3.147 MB Righe restituite: 1

SELECT `alias`

  FROM `r7a9s_content`

  WHERE id = '31'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	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/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.56 ms Dopo l'ultima query: 3.51 ms Memoria query: 0.025 MB memoria prima della query: 3.163 MB Righe restituite: 0

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

  INNER JOIN `r7a9s_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 = 31

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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:124
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/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.31 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.024 MB memoria prima della query: 3.171 MB Righe restituite: 1

SELECT `alias`

  FROM `r7a9s_content`

  WHERE id = '32'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	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/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.64 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.025 MB memoria prima della query: 3.182 MB Righe restituite: 0

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

  INNER JOIN `r7a9s_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 = 32

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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:124
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/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.25 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.024 MB memoria prima della query: 3.190 MB Righe restituite: 1

SELECT `alias`

  FROM `r7a9s_content`

  WHERE id = '33'

Explain

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

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	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/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

Tempo della query: 0.46 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.025 MB memoria prima della query: 3.201 MB Righe restituite: 0

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

  INNER JOIN `r7a9s_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 = 33

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profilo

Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

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:124
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/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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]

38 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

3 × SELECT `alias` 
  FROM `r7a9s_content`

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

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

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `r7a9s_assets`

2 × SELECT `name` 
  FROM `r7a9s_update_sites`

2 × SELECT `update_id` 
  FROM `r7a9s_updates`

2 × SELECT `extension_id` 
  FROM `r7a9s_extensions`

```
2 × SELECT * 
  FROM r7a9s_extensions
```

1 × SELECT `data` 
  FROM `r7a9s_session`

1 × SELECT `session_id` 
  FROM `r7a9s_session`

1 × SELECT id, rules 
  FROM `r7a9s_viewlevels

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

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

1 × SELECT `value` 
  FROM `r7a9s_admintools_storage`

1 × SELECT * 
  FROM `r7a9s_admintools_wafexceptions`

1 × SELECT `source`,`keepurlparams` 
  FROM `r7a9s_admintools_redirects`

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

```
1 × SELECT * 
  FROM r7a9s_languages
```

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

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 r7a9s_content AS a 
  INNER JOIN r7a9s_categories AS c 
  on c.id = a.catid 
  LEFT JOIN r7a9s_users AS u 
  on u.id = a.created_by 
  LEFT JOIN r7a9s_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN r7a9s_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `r7a9s_contentitem_tag_map` AS m  
  INNER JOIN `r7a9s_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query 
  FROM `r7a9s_update_sites` AS `a` 
  INNER JOIN r7a9s_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

1 × SELECT DISTINCT update_site_id 
  FROM r7a9s_updates

ALTRE tabelle:

```
2 × DELETE  
  FROM `r7a9s_updates`
```

2 × UPDATE `r7a9s_update_sites` 
  SET `enabled` = '0'

2 × UPDATE `r7a9s_update_sites` 
  SET `enabled` = '1'

2 × UPDATE `r7a9s_update_sites` 
  SET `last_check_timestamp` = '1696133905'

1 × INSERT INTO `r7a9s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3861346239356b64656734636830763539627562616561753163', 1, 1696133905, 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

1 × UPDATE `r7a9s_extensions` 
  SET `params` = '{\"mediaversion\":\"db6e37385037c4936815bbeefc7a943a\"}'

1 × SHOW FULL COLUMNS 
  FROM `r7a9s_content

1 × UPDATE r7a9s_content 
  SET `hits` = (`hits` + 1)

1 × LOCK TABLES `r7a9s_extensions` WRIT

1 × UPDATE `r7a9s_extensions` 
  SET `params` = '{\"email\":\"\",\"language_override\":\"\",\"lastrun\":1696133905}'

```
1 × UNLOCK TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `r7a9s_updates

1 × SHOW FULL COLUMNS 
  FROM `r7a9s_extensions

SERVIZI

Brochure

Sezione Indagini Settore industriale

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

52 query eseguite 73.31 ms

Trovati 6 duplicati!

38 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: