Studio D.E.P. srl - Diagnostica Edilizia Progettazione
Cambia navigazione
  • Home
  • Indagini non distruttive
  • Curriculum & Certificazioni
  • Normativa
  • Convegni & Corsi
  • Dove Siamo
  • Contatti

SERVIZI

  • Rilievo
  • Monitoraggio
  • Termografia infrarosso
  • Prove di carico statico sui solai
  • Controllo integrità dei solai
  • Indagini sulle strutture
  • Valutazione vulnerabilità sismica
  • Indagini Settore industriale
Studio Tecnico D.E.P. - ing. Rocco Ferrini

Brochure

Studio D.E.P. srl - Diagnostica Edilizia Progettazione

Lo STUDIO D.E.P. srl (Diagnostica Edilizia Progettazione) nasce dalla volontà dell’ Ing. Rocco FERRINI di creare un valido supporto alle attività di progettazione consulenza a progettisti che devono intervenire sul patrimonio immobiliare costruito, ma anche alle Amministrazioni pubbliche che necessitano di avere un quadro completo ed un censimento del reale “stato di fatto” del proprio patrimonio immobiliare, nonché alle imprese che si trovano ad operare nel settore delle costruzioni che necessitano di informazioni aggiuntive sullo stato materico delle strutture su cui andare ad agire per meglio scegliere l’intervento più performante o verificare la bontà degli interventi effettuati.

 

La modalità del servizio offerto può essere classificata a seconda delle esigenze e della tempestività delle operazioni da svolgere in:

Controllo isolato o controllo tempestivo: per la valutazione delle condizioni energetiche, o di salute strutturale una tantum atta a fornire indicazione degli eventuali interventi necessari, per la sostenibilità energetico ambientale, la manutenzione programmatica e preventiva, (per l’esecuzione di prove di collaudo o, in caso di situazioni di dissesto statico, idrogeologico, ecc.) per stabilire la pericolosità e l’evoluzione del fenomeno in atto e consentire valutazioni sui possibili interventi di consolidamento;

Controllo permanente: su strutture e infrastrutture di importanza strategica (ponti, gallerie, dighe, ospedali,ecc) o laddove il controllo in continuo degli elementi monitorati sia considerato di rilevante importanza o imprescindibilità al fine di raggiungere un adeguato grado di conoscenza o l’evoluzione dei fenomeni analizzati.

Controllo su interventi di consolidamento: per controllare l’effettiva riuscita dell’intervento tramite analisi ante/post.

 

 


2010 - 2023 © Studio D.E.P. srl - Diagnostica Edilizia Progettazione | Tutti i Diritti Riservati | Via Cornole di Ruccia 54, 70026 Modugno (Bari)
P.IVA 08632410729 | PEC: studiodepsrl@pec.it | Sitemap | Privacy Policy

 

 

 

Torna su

© 2023 Studio D.E.P. srl - Diagnostica Edilizia Progettazione

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": 1696140615,
                "last": 1696140615,
                "now": 1696140615
            }
        },
        "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: 41.76 ms / 41.76 ms Memoria: 0.422 MB / 0.75 MB Application: afterLoad
Tempo: 117.11 ms / 158.86 ms Memoria: 0.995 MB / 1.75 MB Application: afterInitialise
Tempo: 29.05 ms / 187.91 ms Memoria: 0.286 MB / 2.04 MB Application: afterRoute
Tempo: 17.28 ms / 205.20 ms Memoria: 0.063 MB / 2.10 MB Application: beforeRenderComponent com_content
Tempo: 19.53 ms / 224.72 ms Memoria: 0.162 MB / 2.26 MB Application: Before Access::preloadComponents (all components)
Tempo: 1.23 ms / 225.95 ms Memoria: 0.057 MB / 2.32 MB Application: After Access::preloadComponents (all components)
Tempo: 0.04 ms / 225.99 ms Memoria: -0.002 MB / 2.31 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Tempo: 1.40 ms / 227.39 ms Memoria: 0.009 MB / 2.32 MB Application: After Access::getAssetRules (id:8 name:com_content)
Tempo: 47.71 ms / 275.10 ms Memoria: 0.226 MB / 2.55 MB Application: afterRenderComponent com_content
Tempo: 2.00 ms / 277.10 ms Memoria: 0.008 MB / 2.56 MB Application: afterDispatch
Tempo: 11.15 ms / 288.25 ms Memoria: 0.135 MB / 2.69 MB Application: beforeRenderModule mod_custom (Footer)
Tempo: 5.36 ms / 293.61 ms Memoria: 0.005 MB / 2.70 MB Application: afterRenderModule mod_custom (Footer)
Tempo: 3.95 ms / 297.56 ms Memoria: 0.004 MB / 2.70 MB Application: beforeRenderModule mod_search (Search)
Tempo: 3.50 ms / 301.06 ms Memoria: 0.017 MB / 2.72 MB Application: afterRenderModule mod_search (Search)
Tempo: 2.54 ms / 303.61 ms Memoria: -0.002 MB / 2.72 MB Application: beforeRenderModule mod_menu (SERVIZI)
Tempo: 11.87 ms / 315.47 ms Memoria: 0.096 MB / 2.81 MB Application: afterRenderModule mod_menu (SERVIZI)
Tempo: 3.30 ms / 318.77 ms Memoria: -0.000 MB / 2.81 MB Application: beforeRenderModule mod_custom_advanced (Facebook)
Tempo: 3.94 ms / 322.72 ms Memoria: 0.010 MB / 2.82 MB Application: afterRenderModule mod_custom_advanced (Facebook)
Tempo: 2.69 ms / 325.40 ms Memoria: -0.003 MB / 2.82 MB Application: beforeRenderModule mod_custom (Brochure)
Tempo: 0.10 ms / 325.51 ms Memoria: 0.004 MB / 2.82 MB Application: afterRenderModule mod_custom (Brochure)
Tempo: 2.60 ms / 328.11 ms Memoria: 0.001 MB / 2.82 MB Application: beforeRenderModule mod_menu (Main Menu)
Tempo: 3.05 ms / 331.16 ms Memoria: 0.040 MB / 2.86 MB Application: afterRenderModule mod_menu (Main Menu)
Tempo: 3.21 ms / 334.36 ms Memoria: 0.011 MB / 2.88 MB Application: beforeRenderModule mod_gtranslate (GTranslate)
Tempo: 2.60 ms / 336.97 ms Memoria: 0.036 MB / 2.91 MB Application: afterRenderModule mod_gtranslate (GTranslate)
Tempo: 6.87 ms / 343.84 ms Memoria: 0.006 MB / 2.92 MB Application: afterRender

Query totali del database: 16.27 ms

Utilizzo memoria

2,95 MB (3.089.952 Bytes)

Query Database

24 query eseguite 16.27 ms


  1. Tempo della query: 0.50 ms Memoria query: 0.023 MB memoria prima della query: 1.041 MB Righe restituite: 0
    SELECT `data`
    
      FROM `r7a9s_session`
      WHERE `session_id` = X'35703939353675326c39626c336464336d61307171616f366f6a'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_sessionconstPRIMARYPRIMARY194const1
    Profilo
    Error
    The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working
    Call Stack
    #CallerFile e numero di linea
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Chiamata uguale alla linea sottostante.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  2. Tempo della query: 0.25 ms Dopo l'ultima query: 1.72 ms Memoria query: 0.020 MB memoria prima della query: 1.055 MB Righe restituite: 0
    SELECT `session_id`
    
      FROM `r7a9s_session`
      WHERE `session_id` = X'35703939353675326c39626c336464336d61307171616f366f6a'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_sessionconstPRIMARYPRIMARY194const1Using index
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  3. Tempo della query: 0.25 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.004 MB memoria prima della query: 1.060 MB
    INSERT INTO `r7a9s_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'35703939353675326c39626c336464336d61307171616f366f6a', 1, 1696140615, 0, '', 0)
    Explain
    EXPLAIN non possibile sulla query: INSERT INTO `r7a9s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'35703939353675326c39626c336464336d61307171616f366f6a', 1, 1696140615, 0, '', 0)
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  4. Tempo della query: 1.04 ms Dopo l'ultima query: 8.71 ms Memoria query: 0.024 MB memoria prima della query: 1.161 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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_extensionsrefextensionextension62const45Using where
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Chiamata uguale alla linea sottostante.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  5. Tempo della query: 0.31 ms Dopo l'ultima query: 6.43 ms Memoria query: 0.021 MB memoria prima della query: 1.187 MB Righe restituite: 5
    SELECT id, rules
    
      FROM `r7a9s_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_viewlevelsALLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL5
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  6. Tempo della query: 0.30 ms Dopo l'ultima query: 0.11 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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  7. Tempo della query: 2.29 ms Dopo l'ultima query: 4.25 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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_extensionsrefextensionextension62const100Using where; Using filesort
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Chiamata uguale alla linea sottostante.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  8. Tempo della query: 0.40 ms Dopo l'ultima query: 36.97 ms Memoria query: 0.022 MB memoria prima della query: 1.628 MB Righe restituite: 1
    SELECT `value`
    
      FROM `r7a9s_admintools_storage`
      WHERE `key` = 'cparams'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_admintools_storageconstPRIMARYPRIMARY302const1
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/administrator/components/com_admintools/Helper/Storage.php:123
    12Akeeba\AdminTools\Admin\Helper\Storage->load()JROOT/administrator/components/com_admintools/Helper/Storage.php:53
    11Akeeba\AdminTools\Admin\Helper\Storage->__construct()JROOT/administrator/components/com_admintools/Helper/Storage.php:41
    10Akeeba\AdminTools\Admin\Helper\Storage::getInstance()JROOT/plugins/system/admintools/admintools/main.php:278
    9plgSystemAdmintools->loadComponentParameters()JROOT/plugins/system/admintools/admintools/main.php:831
    8plgSystemAdmintools->initialize()JROOT/plugins/system/admintools/admintools/main.php:110
    7plgSystemAdmintools->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  9. Tempo della query: 0.22 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.021 MB memoria prima della query: 1.636 MB Righe restituite: 0
    SELECT *
    
      FROM `r7a9s_admintools_wafexceptions`
      WHERE NOT(`option` LIKE 'com_%')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLImpossible WHERE noticed after reading const tables
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    11JDatabaseDriver->loadAssocList()JROOT/plugins/system/admintools/admintools/main.php:549
    10plgSystemAdmintools->loadWAFExceptionsSEF()JROOT/plugins/system/admintools/admintools/main.php:460
    9plgSystemAdmintools->loadWAFExceptions()JROOT/plugins/system/admintools/admintools/main.php:843
    8plgSystemAdmintools->initialize()JROOT/plugins/system/admintools/admintools/main.php:110
    7plgSystemAdmintools->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  10. Tempo della query: 0.36 ms Dopo l'ultima query: 25.72 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
    #CallerFile e numero di linea
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    12JDatabaseDriver->loadObject()JROOT/libraries/joomla/database/driver/mysqli.php:345
    11JDatabaseDriverMysqli->getCollation()JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    10AtsystemFeatureUtf8mb4->onAfterInitialise()JROOT/plugins/system/admintools/admintools/main.php:710
    9plgSystemAdmintools->runFeature()JROOT/plugins/system/admintools/admintools/main.php:135
    8plgSystemAdmintools->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  11. Tempo della query: 0.27 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.021 MB memoria prima della query: 1.744 MB Righe restituite: 0
    SELECT `source`,`keepurlparams`
    
      FROM `r7a9s_admintools_redirects`
      WHERE ((`dest` = '') OR (`dest` = '') OR ('' LIKE `dest`))
      AND `published` = '1'
      ORDER BY `ordering` DESC
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLImpossible WHERE noticed after reading const tables
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1773
    11JDatabaseDriver->loadRow()JROOT/plugins/system/admintools/feature/urlredir.php:89
    10AtsystemFeatureUrlredir->onAfterInitialise()JROOT/plugins/system/admintools/admintools/main.php:710
    9plgSystemAdmintools->runFeature()JROOT/plugins/system/admintools/admintools/main.php:135
    8plgSystemAdmintools->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  12. Tempo della query: 2.44 ms Dopo l'ultima query: 5.89 ms Memoria query: 0.068 MB memoria prima della query: 1.842 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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const35Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4Sql373622_1.m.component_id1
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Chiamata uguale alla linea sottostante.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:533
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1141
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  13. Tempo della query: 0.47 ms Dopo l'ultima query: 24.15 ms Memoria query: 0.022 MB memoria prima della query: 2.054 MB Righe restituite: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `r7a9s_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_extensionsrefelement_clientid,element_folder_clientid,extensionextension364const,const1Using where
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Chiamata uguale alla linea sottostante.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  14. Tempo della query: 0.34 ms Dopo l'ultima query: 1.51 ms Memoria query: 0.005 MB memoria prima della query: 2.044 MB
    UPDATE `r7a9s_extensions`
    
      SET `params` = '{\"mediaversion\":\"940c703a00eed8575dd52b83c3c5c860\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN non possibile sulla query: UPDATE `r7a9s_extensions` SET `params` = '{\"mediaversion\":\"940c703a00eed8575dd52b83c3c5c860\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  15. Tempo della query: 0.34 ms Dopo l'ultima query: 3.63 ms Memoria query: 0.019 MB memoria prima della query: 2.075 MB Righe restituite: 1
    SELECT *
    
      FROM r7a9s_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_languagessystemNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  16. Tempo della query: 0.57 ms Dopo l'ultima query: 3.46 ms Memoria query: 0.019 MB memoria prima della query: 2.090 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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const1
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid303Sql373622_1.s.template,const1Using where
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  17. Tempo della query: 0.89 ms Dopo l'ultima query: 23.93 ms Memoria query: 0.029 MB memoria prima della query: 2.265 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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_assetsALLidx_asset_nameNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL107Using where
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    20Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    19Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    18Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    17Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    16Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:115
    15ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:45
    14ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    13Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:55
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  18. Tempo della query: 2.55 ms Dopo l'ultima query: 2.47 ms Memoria query: 0.025 MB memoria prima della query: 2.351 MB Righe restituite: 1
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM r7a9s_content AS a
      INNER JOIN r7a9s_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN r7a9s_categories AS c
      ON c.id = a.catid
      LEFT JOIN r7a9s_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN r7a9s_users AS uam
      ON uam.id = a.modified_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.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-01 06:10:16')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-01 06:10:16')
      ORDER BY a.featured DESC, fp.ordering,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpsystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1
    1SIMPLEvsystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL0const row not found
    1SIMPLEaconstPRIMARY,idx_access,idx_state,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEuasystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1
    1SIMPLEuamsystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1
    1SIMPLEparentconstPRIMARYPRIMARY4const1
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    13ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  19. Tempo della query: 0.35 ms Dopo l'ultima query: 1.88 ms Memoria query: 0.024 MB memoria prima della query: 2.397 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` = 21
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULLNULLImpossible WHERE noticed after reading const tables
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    13ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  20. Tempo della query: 0.33 ms Dopo l'ultima query: 3.49 ms Memoria query: 0.024 MB memoria prima della query: 2.459 MB Righe restituite: 1
    SELECT COUNT(*)
    
      FROM r7a9s_content AS a
      INNER JOIN r7a9s_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN r7a9s_categories AS c
      ON c.id = a.catid
      LEFT JOIN r7a9s_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN r7a9s_users AS uam
      ON uam.id = a.modified_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.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-01 06:10:16')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-01 06:10:16')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfpsystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1
    1SIMPLEvsystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL0const row not found
    1SIMPLEaconstPRIMARY,idx_access,idx_state,idx_catidPRIMARY4const1
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEuasystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1
    1SIMPLEuamsystemPRIMARYNON È POSSIBILE UTILIZZARE ALCUN INDICENULLNULL1
    1SIMPLEparentconstPRIMARYPRIMARY4const1Using index
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    14Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    13Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:57
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  21. Tempo della query: 0.24 ms Dopo l'ultima query: 7.54 ms Memoria query: 0.028 MB memoria prima della query: 2.485 MB Righe restituite: 1
    SELECT `alias`
    
      FROM `r7a9s_content`
      WHERE id = '21'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_contentconstPRIMARYPRIMARY4const1
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    27JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:125
    26ContentRouter->getArticleSegment()Chiamata uguale alla linea sottostante.
    25call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    24Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    23Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    22Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    21Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    20Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    19Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    18Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    17Joomla\CMS\Router\Route::_()JROOT/plugins/content/addtoany/addtoany.php:315
    16plgContentAddToAny->getArticleUrl()JROOT/plugins/content/addtoany/addtoany.php:108
    15plgContentAddToAny->createAddToAny()JROOT/plugins/content/addtoany/addtoany.php:51
    14plgContentAddToAny->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  22. Tempo della query: 0.51 ms Dopo l'ultima query: 3.83 ms Memoria query: 0.029 MB memoria prima della query: 2.503 MB Righe restituite: 2
    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 = 8
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL3Using where
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    30JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    29JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    28Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    27Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
    26ContentRouter->getCategorySegment()Chiamata uguale alla linea sottostante.
    25call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    24Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    23Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    22Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    21Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    20Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    19Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    18Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    17Joomla\CMS\Router\Route::_()JROOT/plugins/content/addtoany/addtoany.php:315
    16plgContentAddToAny->getArticleUrl()JROOT/plugins/content/addtoany/addtoany.php:108
    15plgContentAddToAny->createAddToAny()JROOT/plugins/content/addtoany/addtoany.php:51
    14plgContentAddToAny->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  23. Tempo della query: 0.23 ms Dopo l'ultima query: 2.61 ms Memoria query: 0.027 MB memoria prima della query: 2.526 MB Righe restituite: 1
    SELECT alias
    
      FROM r7a9s_content
      WHERE id=21
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEr7a9s_contentconstPRIMARYPRIMARY4const1
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    25JDatabaseDriver->loadResult()JROOT/components/com_content/helpers/legacyrouter.php:140
    24ContentRouterRulesLegacy->build()JROOT/libraries/src/Component/Router/RouterView.php:244
    23Joomla\CMS\Component\Router\RouterView->build()JROOT/libraries/src/Router/SiteRouter.php:532
    22Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    21Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    20Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    19Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    18Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    17Joomla\CMS\Router\Route::_()JROOT/plugins/content/addtoany/addtoany.php:315
    16plgContentAddToAny->getArticleUrl()JROOT/plugins/content/addtoany/addtoany.php:108
    15plgContentAddToAny->createAddToAny()JROOT/plugins/content/addtoany/addtoany.php:51
    14plgContentAddToAny->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:102
    11ContentViewFeatured->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

  24. Tempo della query: 0.84 ms Dopo l'ultima query: 28.93 ms Memoria query: 0.024 MB memoria prima della query: 2.606 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 06:10:16')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-01 06:10:16')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 28 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const4Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4Sql373622_1.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid303Sql373622_1.m.module,const1Using where
    Profilo
    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
    Call Stack
    #CallerFile e numero di linea
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Chiamata uguale alla linea sottostante.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:91
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

23 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:
  1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `r7a9s_extensions`
  2. 1 × SELECT `data` 
      FROM `r7a9s_session`
  3. 1 × SELECT `session_id` 
      FROM `r7a9s_session`
  4. 1 × SELECT id, rules 
      FROM `r7a9s_viewlevels
  5. 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
  6. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM r7a9s_extensions
  7. 1 × SELECT `value` 
      FROM `r7a9s_admintools_storage`
  8. 1 × SELECT * 
      FROM `r7a9s_admintools_wafexceptions`
  9. 1 × SELECT `source`,`keepurlparams` 
      FROM `r7a9s_admintools_redirects`
  10. 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
  11. 1 × SELECT * 
      FROM r7a9s_languages
  12. 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
  13. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `r7a9s_assets`
  14. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM r7a9s_content AS a
      INNER JOIN r7a9s_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN r7a9s_categories AS c
      ON c.id = a.catid
      LEFT JOIN r7a9s_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN r7a9s_users AS uam
      ON uam.id = a.modified_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
  15. 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`
  16. 1 × SELECT COUNT(*) 
      FROM r7a9s_content AS a
      INNER JOIN r7a9s_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN r7a9s_categories AS c
      ON c.id = a.catid
      LEFT JOIN r7a9s_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN r7a9s_users AS uam
      ON uam.id = a.modified_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
  17. 1 × SELECT `alias` 
      FROM `r7a9s_content`
  18. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `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)
  19. 1 × SELECT alias 
      FROM r7a9s_content
  20. 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
ALTRE tabelle:
  1. 1 × INSERT INTO `r7a9s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'35703939353675326c39626c336464336d61307171616f366f6a', 1, 1696140615, 0, '', 0
  2. 1 × SHOW VARIABLES LIKE "collation_database
  3. 1 × UPDATE `r7a9s_extensions` 
      SET `params` = '{\"mediaversion\":\"940c703a00eed8575dd52b83c3c5c860\"}'