Grupo Serigy

Home


Rodovia BR 101, Km 99- S/N - Zona Rural - São Cristovão / SE +55 79 2106.6363 ou sac@serigy.com.br

Voltar ao Topo

© 2026 Grupo Serigy

Console de depuração do Joomla!

Sessão

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1779317682,
                "last": 1779317682,
                "now": 1779317682
            }
        },
        "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
        }
    }
}

Informação do perfil

Tempo

Memória

Tempo: 0.01 ms / 0.01 ms Memória: 0.555 MB / 0.55 MB Application: afterLoad
Tempo: 52.73 ms / 52.74 ms Memória: 2.807 MB / 3.36 MB Application: afterInitialise
Tempo: 14.53 ms / 67.27 ms Memória: 0.360 MB / 3.72 MB Application: afterRoute
Tempo: 1.63 ms / 68.90 ms Memória: 0.039 MB / 3.76 MB Application: beforeRenderComponent com_content
Tempo: 9.26 ms / 78.16 ms Memória: 0.426 MB / 4.19 MB Application: Start JAccess::getAssetRules Old (1)
Tempo: 0.97 ms / 79.14 ms Memória: 0.042 MB / 4.23 MB Application: Finish JAccess::getAssetRules Old (1)
Tempo: 0.08 ms / 79.22 ms Memória: 0.000 MB / 4.23 MB Application: Start JAccess::preload(components)
Tempo: 4.18 ms / 83.40 ms Memória: 0.311 MB / 4.54 MB Application: Finish JAccess::preload(components)
Tempo: 9.73 ms / 93.12 ms Memória: 0.113 MB / 4.65 MB Application: afterRenderComponent com_content
Tempo: 13.16 ms / 106.28 ms Memória: 0.148 MB / 4.80 MB Application: afterDispatch
Tempo: 7.61 ms / 113.88 ms Memória: 0.172 MB / 4.97 MB Application: beforeRenderModule mod_custom (rodape)
Tempo: 1.85 ms / 115.73 ms Memória: 0.014 MB / 4.98 MB Application: afterRenderModule mod_custom (rodape)
Tempo: 11.84 ms / 127.57 ms Memória: 0.148 MB / 5.13 MB Application: afterRender

Total de consultas ao banco de dados: 18.56 ms

Memória Utilizada

5.63 MB (5.898.760 Bytes)

Consultas ao banco

24 Queries Registradas 18.56 ms


  1. Tempo da consulta: 0.56 ms Memória de consulta: 0.018 MB de memória antes da consulta: 1.171 MB Linhas retornadas: 0
    SELECT `data`
    
      FROM `site_session`
      WHERE `session_id` = '68dg0bkp3692ljiippaqanmut5'
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_sessionALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL281Using where
    Perfil
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.23 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:44
    12JSessionStorageDatabase->read()Same as call in the line below.
    11session_start()JROOT/libraries/joomla/session/handler/native.php:258
    10JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:49
    9JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:81
    8JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:636
    7JSession->_start()JROOT/libraries/joomla/session/session.php:596
    6JSession->start()JROOT/libraries/cms/application/cms.php:748
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:404
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:37
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  2. Tempo da consulta: 0.42 ms Após última consulta: 2.14 ms Memória de consulta: 0.012 MB de memória antes da consulta: 1.245 MB Linhas retornadas: 0
    SELECT `session_id`
    
      FROM `site_session`
      WHERE `session_id` = '68dg0bkp3692ljiippaqanmut5'
      LIMIT 1
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_sessionALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL281Using where
    Perfil
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.16 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:774
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:404
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:37
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  3. Tempo da consulta: 0.59 ms Após última consulta: 0.22 ms Memória de consulta: 0.009 MB de memória antes da consulta: 1.258 MB
    INSERT INTO `site_session`
    (`session_id`, `client_id`, `time`) 
      VALUES ('68dg0bkp3692ljiippaqanmut5', 0, '1779317682')
    Explicar
    EXPLAIN não é possível na consulta: INSERT INTO `site_session` (`session_id`, `client_id`, `time`) VALUES ('68dg0bkp3692ljiippaqanmut5', 0, '1779317682')
    Perfil
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.00 ms
    init0.01 ms
    update0.07 ms
    end0.01 ms
    query end0.32 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:208
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:774
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:404
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:37
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  4. Tempo da consulta: 0.49 ms Após última consulta: 2.36 ms Memória de consulta: 0.025 MB de memória antes da consulta: 1.360 MB Linhas retornadas: 36
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM site_extensions
      WHERE `type` = 'component'
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_extensionsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.21 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:584
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  5. Tempo da consulta: 0.28 ms Após última consulta: 1.18 ms Memória de consulta: 0.014 MB de memória antes da consulta: 1.450 MB Linhas retornadas: 2
    SELECT b.id
    
      FROM site_usergroups AS a
      LEFT JOIN site_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL9Using where
    1SIMPLEbALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL9Using where; Using join buffer (flat, BNL join)
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    9JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:852
    8JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:921
    7JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    6JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    5JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:163
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  6. Tempo da consulta: 0.20 ms Após última consulta: 0.33 ms Memória de consulta: 0.013 MB de memória antes da consulta: 1.473 MB Linhas retornadas: 5
    SELECT id, rules
    
      FROM `site_viewlevels`
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_viewlevelsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL5
    Perfil
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.00 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    8JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:938
    7JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:453
    6JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    5JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:163
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  7. Tempo da consulta: 0.63 ms Após última consulta: 0.25 ms Memória de consulta: 0.013 MB de memória antes da consulta: 1.493 MB Linhas retornadas: 77
    SELECT folder AS type, element AS name, params
    
      FROM site_extensions
      WHERE enabled = 1
      AND type ='plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_extensionsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where; Usando filesort
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.14 ms
    Sending data0.15 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    6JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:310
    5JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:163
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  8. Tempo da consulta: 0.27 ms Após última consulta: 1.80 ms Memória de consulta: 0.016 MB de memória antes da consulta: 1.617 MB Linhas retornadas: 2
    SELECT *
    
      FROM site_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_languagesALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL2Using where; Usando filesort
    Perfil
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.00 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.03 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    8JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:164
    7JLanguageHelper::getLanguages()JROOT/plugins/system/languagefilter/languagefilter.php:61
    6PlgSystemLanguageFilter->__construct()JROOT/libraries/cms/plugin/helper.php:255
    5JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  9. Tempo da consulta: 0.32 ms Após última consulta: 0.40 ms Memória de consulta: 0.013 MB de memória antes da consulta: 1.640 MB Linhas retornadas: 2
    SELECT element
    
      FROM site_extensions
      WHERE type = 'language'
      AND client_id = 0
      AND enabled = 1
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_extensionsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where
    Perfil
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.11 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    8JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/multilang.php:90
    7JLanguageMultilang::getSiteLangs()JROOT/plugins/system/languagefilter/languagefilter.php:72
    6PlgSystemLanguageFilter->__construct()JROOT/libraries/cms/plugin/helper.php:255
    5JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    4JPluginHelper::importPlugin()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  10. Tempo da consulta: 0.37 ms Após última consulta: 6.55 ms Memória de consulta: 0.022 MB de memória antes da consulta: 1.928 MB Linhas retornadas: 1
    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM site_extensions
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_extensionsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.00 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.16 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    16JDatabaseDriver->loadObject()Same as call in the line below.
    15call_user_func_array()JROOT/libraries/joomla/cache/controller/callback.php:152
    14JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:156
    13JLibraryHelper::_load()JROOT/libraries/cms/library/helper.php:47
    12JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:90
    11JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:274
    10JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    9JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    8JFactory::getDocument()JROOT/plugins/system/ytshortcodes/ytshortcodes.php:32
    7plgSystemYtshortcodes->__construct()JROOT/libraries/cms/plugin/helper.php:255
    6JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    5JPluginHelper::importPlugin()JROOT/libraries/cms/application/cms.php:662
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:663
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  11. Tempo da consulta: 0.72 ms Após última consulta: 0.30 ms Memória de consulta: 0.016 MB de memória antes da consulta: 1.934 MB
    UPDATE `site_extensions`
    
      SET `params` = '{\"mediaversion\":\"c53bffa086523265b5417c189f502737\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explicar
    EXPLAIN não é possível na consulta: UPDATE `site_extensions` SET `params` = '{\"mediaversion\":\"c53bffa086523265b5417c189f502737\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Perfil
    StatusDuration
    starting0.02 ms
    checking permissions0.02 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.00 ms
    init0.02 ms
    Updating0.26 ms
    end0.01 ms
    query end0.29 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:119
    12JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:325
    11JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:284
    10JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    9JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    8JFactory::getDocument()JROOT/plugins/system/ytshortcodes/ytshortcodes.php:32
    7plgSystemYtshortcodes->__construct()JROOT/libraries/cms/plugin/helper.php:255
    6JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    5JPluginHelper::importPlugin()JROOT/libraries/cms/application/cms.php:662
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:663
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  12. Tempo da consulta: 4.28 ms Após última consulta: 6.05 ms Memória de consulta: 0.037 MB de memória antes da consulta: 2.292 MB Linhas retornadas: 47
    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 site_menu AS m
      LEFT JOIN site_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
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL110Using where; Using temporary; Usando filesort
    1SIMPLEeALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where; Using join buffer (flat, BNL join)
    Perfil
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.00 ms
    Creating tmp table0.80 ms
    Copying to tmp table2.89 ms
    Sorting result0.05 ms
    Sending data0.12 ms
    end0.01 ms
    removing tmp table0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    20JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:86
    19JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    18JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    17JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:133
    16JMenu::getInstance()JROOT/libraries/cms/application/cms.php:435
    15JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    14JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:57
    13JRouterSite->__construct()JROOT/libraries/cms/router/router.php:196
    12JRouter::getInstance()JROOT/libraries/cms/application/cms.php:531
    11JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:407
    10JApplicationSite::getRouter()JROOT/plugins/system/languagefilter/languagefilter.php:99
    9PlgSystemLanguageFilter->onAfterInitialise()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:663
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:663
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  13. Tempo da consulta: 0.58 ms Após última consulta: 15.50 ms Memória de consulta: 0.027 MB de memória antes da consulta: 3.524 MB Linhas retornadas: 3
    SELECT id, home, template, s.params
    
      FROM site_template_styles as s
      LEFT JOIN site_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
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL5Using where
    1SIMPLEeALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where; Using join buffer (flat, BNL join)
    Perfil
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.17 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    21JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:484
    20JApplicationSite->getTemplate()JROOT/libraries/cms/html/html.php:334
    19JHtml::includeRelativeFiles()JROOT/libraries/cms/html/html.php:679
    18JHtml::script()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/cms/html/html.php:236
    16JHtml::call()JROOT/libraries/cms/html/html.php:138
    15JHtml::_()JROOT/libraries/cms/html/behavior.php:61
    14JHtmlBehavior::framework()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/cms/html/html.php:236
    12JHtml::call()JROOT/libraries/cms/html/html.php:138
    11JHtml::_()JROOT/administrator/components/com_k2/helpers/html.php:76
    10K2HelperHTML::loadjQuery()JROOT/plugins/system/k2/k2.php:55
    9plgSystemK2->onAfterRoute()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1107
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:763
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  14. Tempo da consulta: 1.16 ms Após última consulta: 17.06 ms Memória de consulta: 0.033 MB de memória antes da consulta: 4.104 MB Linhas retornadas: 8
    SHOW FULL COLUMNS 
      FROM `site_assets`
    Explicar
    EXPLAIN não é possível na consulta: SHOW FULL COLUMNS FROM `site_assets`
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.47 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    Filling schema table0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    checking permissions0.05 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.09 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    23JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    22JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    21JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    20JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    19JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:304
    18JTable::getInstance()JROOT/libraries/joomla/access/access.php:714
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:576
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    15JUser->authorise()JROOT/components/com_content/models/articles.php:111
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:439
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:46
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  15. Tempo da consulta: 0.36 ms Após última consulta: 1.33 ms Memória de consulta: 0.028 MB de memória antes da consulta: 4.168 MB Linhas retornadas: 1
    SELECT *
    
      FROM site_assets
      WHERE `id` = '1'
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_assetsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL97Using where
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    19JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:715
    18JTable->load()JROOT/libraries/joomla/access/access.php:715
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:576
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    15JUser->authorise()JROOT/components/com_content/models/articles.php:111
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:439
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:46
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  16. Tempo da consulta: 0.29 ms Após última consulta: 0.30 ms Memória de consulta: 0.024 MB de memória antes da consulta: 4.190 MB Linhas retornadas: 1
    SELECT a.rules
    
      FROM site_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL97Using where
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    17JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:670
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:384
    15JUser->authorise()JROOT/components/com_content/models/articles.php:111
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:439
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:46
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  17. Tempo da consulta: 0.37 ms Após última consulta: 0.75 ms Memória de consulta: 0.027 MB de memória antes da consulta: 4.228 MB Linhas retornadas: 36
    SELECT element
    
      FROM site_extensions
      WHERE type = 'component'
      AND enabled = '1'
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_extensionsALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where
    Perfil
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.13 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    19JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:412
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/articles.php:111
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:439
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:46
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  18. Tempo da consulta: 0.65 ms Após última consulta: 0.26 ms Memória de consulta: 0.027 MB de memória antes da consulta: 4.261 MB Linhas retornadas: 36
    SELECT a.name, a.rules
    
      FROM site_assets AS a
      WHERE (a.name IN ('com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_search','com_templates','com_weblinks','com_content','com_config','com_redirect','com_users','com_finder','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_k2','com_uniterevolution2','com_sigpro','com_acymailing','com_chronoforms') OR a.name = 'root.1')
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL97Using where
    Perfil
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.32 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    19JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:439
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:393
    15JUser->authorise()JROOT/components/com_content/models/articles.php:111
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:439
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:46
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  19. Tempo da consulta: 1.73 ms Após última consulta: 3.89 ms Memória de consulta: 0.032 MB de memória antes da consulta: 4.566 MB Linhas retornadas: 0
    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM site_content AS a
      INNER JOIN site_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN site_categories AS c
      ON c.id = a.catid
      LEFT JOIN site_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN site_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN site_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN site_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM site_categories AS cat JOIN site_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-20 22:54:42')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-20 22:54:42')
      AND a.language in ('pt-BR','*')
      ORDER BY c.lft, 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 4
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where; Using temporary; Usando filesort
    1PRIMARYfpALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where; Using join buffer (flat, BNL join)
    1PRIMARYcALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using where; Using join buffer (incremental, BNL join)
    1PRIMARYuaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL21Using where; Using join buffer (incremental, BNL join)
    1PRIMARYuamALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL21Using where; Using join buffer (incremental, BNL join)
    1PRIMARYparentALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using where; Using join buffer (incremental, BNL join)
    1PRIMARYvALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where; Using join buffer (incremental, BNL join)
    1PRIMARY<derived2>refkey0key05serigy_site.c.id10Using where
    2DERIVEDcatALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using temporary; Usando filesort
    2DERIVEDparentALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using where; Using join buffer (flat, BNL join)
    Perfil
    StatusDuration
    starting0.22 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After table lock0.01 ms
    init0.11 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.06 ms
    statistics0.03 ms
    preparing0.06 ms
    executing0.01 ms
    Creating tmp table0.61 ms
    Copying to tmp table0.07 ms
    Sorting result0.04 ms
    Sending data0.04 ms
    end0.01 ms
    removing tmp table0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    updating status0.03 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:312
    15JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:185
    14JModelList->getItems()JROOT/components/com_content/models/articles.php:566
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:90
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:47
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  20. Tempo da consulta: 0.81 ms Após última consulta: 1.13 ms Memória de consulta: 0.021 MB de memória antes da consulta: 4.611 MB Linhas retornadas: 1
    SELECT COUNT(*)
    
      FROM site_content AS a
      INNER JOIN site_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN site_categories AS c
      ON c.id = a.catid
      LEFT JOIN site_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN site_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN site_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN site_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM site_categories AS cat JOIN site_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-20 22:54:42')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-20 22:54:42')
      AND a.language in ('pt-BR','*')
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where
    1PRIMARYfpALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where; Using join buffer (flat, BNL join)
    1PRIMARYcALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using where; Using join buffer (incremental, BNL join)
    1PRIMARYuaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL21Using where; Using join buffer (incremental, BNL join)
    1PRIMARYuamALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL21Using where; Using join buffer (incremental, BNL join)
    1PRIMARYparentALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using where; Using join buffer (incremental, BNL join)
    1PRIMARYvALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where; Using join buffer (incremental, BNL join)
    1PRIMARY<derived2>refkey0key05serigy_site.c.id10Using where
    2DERIVEDcatALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using temporary; Usando filesort
    2DERIVEDparentALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL14Using where; Using join buffer (flat, BNL join)
    Perfil
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    After table lock0.01 ms
    init0.08 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.06 ms
    statistics0.05 ms
    preparing0.06 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    15JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:341
    14JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:290
    13JModelList->getTotal()JROOT/libraries/legacy/model/list.php:235
    12JModelList->getPagination()JROOT/libraries/legacy/view/legacy.php:401
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:48
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:690
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:728
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  21. Tempo da consulta: 0.41 ms Após última consulta: 5.14 ms Memória de consulta: 0.015 MB de memória antes da consulta: 4.641 MB Linhas retornadas: 3
    SELECT language,id
    
      FROM `site_menu`
      WHERE home = 1
      AND published = 1
      AND client_id = 0
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_menuALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL110Using where
    Perfil
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    10JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/multilang.php:121
    9JLanguageMultilang::getSiteHomePages()JROOT/plugins/system/languagefilter/languagefilter.php:647
    8PlgSystemLanguageFilter->onAfterDispatch()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/site.php:196
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  22. Tempo da consulta: 0.30 ms Após última consulta: 0.80 ms Memória de consulta: 0.016 MB de memória antes da consulta: 4.672 MB Linhas retornadas: 0
    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `site_menu` AS `c`
      INNER JOIN `site_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `site_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `site_menu` AS `c2`
      ON a2.id = c2.`id`
      WHERE c.id = 243
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where
    1SIMPLEa2ALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL1Using where; Using join buffer (flat, BNL join)
    1SIMPLEcALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL110Using where; Using join buffer (incremental, BNL join)
    1SIMPLEc2ALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL110Using where; Using join buffer (incremental, BNL join)
    Perfil
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.02 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    11JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/associations.php:101
    10JLanguageAssociations::getAssociations()JROOT/administrator/components/com_menus/helpers/menus.php:285
    9MenusHelper::getAssociations()JROOT/plugins/system/languagefilter/languagefilter.php:663
    8PlgSystemLanguageFilter->onAfterDispatch()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/site.php:196
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:257
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  23. Tempo da consulta: 2.50 ms Após última consulta: 12.67 ms Memória de consulta: 0.020 MB de memória antes da consulta: 4.836 MB Linhas retornadas: 12
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM site_modules AS m
      LEFT JOIN site_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN site_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 <= '2026-05-20 22:54:42')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-20 22:54:42')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 243 OR mm.menuid <= 0)
      AND m.language IN ('pt-BR','*')
      ORDER BY m.position, m.ordering
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL54Using where; Using temporary; Usando filesort
    1SIMPLEmmALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL90Using where; Using join buffer (flat, BNL join)
    1SIMPLEeALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL214Using where; Using join buffer (incremental, BNL join)
    Perfil
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After table lock0.01 ms
    init0.06 ms
    optimizing0.05 ms
    statistics0.04 ms
    preparing0.06 ms
    executing0.01 ms
    Creating tmp table0.45 ms
    Copying to tmp table1.20 ms
    Sorting result0.04 ms
    Sending data0.04 ms
    end0.01 ms
    removing tmp table0.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    Pilha de chamadas
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    12JDatabaseDriver->loadObjectList()JROOT/libraries/cms/module/helper.php:409
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:352
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    8JDocumentHtml->countModules()JROOT/templates/protostar/index.php:94
    7require JROOT/templates/protostar/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:640
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1054
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

  24. Tempo da consulta: 0.28 ms Após última consulta: 1.36 ms Memória de consulta: 0.015 MB de memória antes da consulta: 4.891 MB Linhas retornadas: 1
    SELECT template
    
      FROM site_template_styles
      WHERE home = 1
      AND client_id = 0
    Explicar
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsite_template_stylesALLNULLNENHUMA CHAVE DE ÍNDICE PÔDE SER USADANULLNULL5Using where
    Perfil
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After table lock0.01 ms
    init0.01 ms
    optimizing0.03 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    updating status0.01 ms
    cleaning up0.00 ms
    Pilha de chamadas
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    10JDatabaseDriver->loadResult()JROOT/plugins/system/yt/yt.php:237
    9plgSystemYt->nameOfSJTemplate()JROOT/plugins/system/yt/yt.php:141
    8plgSystemYt->onBeforeRender()Same as call in the line below.
    7call_user_func_array()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:1058
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:745
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:263
    1JApplicationCms->execute()JROOT/index.php:40
    [Adicionar a diretiva xdebug.file_link_format no seu arquivo php.ini para ter links para arquivos]

22 tipos de query registradas, sorteadas por ocorrências DESC

SELECT Tables:
  1. 2 × SELECT element 
      FROM site_extensions
  2. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
      FROM site_extensions
  3. 1 × SELECT a.name, a.rules 
      FROM site_assets AS a
  4. 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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM site_content AS a
      INNER JOIN site_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN site_categories AS c
      ON c.id = a.catid
      LEFT JOIN site_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN site_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN site_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN site_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM site_categories AS cat JOIN site_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  5. 1 × SELECT COUNT(*) 
      FROM site_content AS a
      INNER JOIN site_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN site_categories AS c
      ON c.id = a.catid
      LEFT JOIN site_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN site_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN site_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN site_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM site_categories AS cat JOIN site_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  6. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `site_menu` AS `c`
      INNER JOIN `site_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `site_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `site_menu` AS `c2`
      ON a2.id = c2.`id`
  7. 1 × SELECT template 
      FROM site_template_styles
  8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM site_modules AS m
      LEFT JOIN site_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN site_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  9. 1 × SELECT a.rules 
      FROM site_assets AS a
  10. 1 × SELECT language,id 
      FROM `site_menu`
  11. 1 × SELECT id, home, template, s.params 
      FROM site_template_styles as s
      LEFT JOIN site_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  12. 1 × SELECT id, rules 
      FROM `site_viewlevels
  13. 1 × SELECT b.id 
      FROM site_usergroups AS a
      LEFT JOIN site_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  14. 1 × SELECT `session_id` 
      FROM `site_session`
  15. 1 × SELECT folder AS type, element AS name, params 
      FROM site_extensions
  16. 1 × SELECT * 
      FROM site_languages
  17. 1 × SELECT `data` 
      FROM `site_session`
  18. 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 site_menu AS m
      LEFT JOIN site_extensions AS e
      ON m.component_id = e.extension_id
  19. 1 × SELECT * 
      FROM site_assets
Outras Tabelas:
  1. 1 × SHOW FULL COLUMNS 
      FROM `site_assets
  2. 1 × UPDATE `site_extensions` 
      SET `params` = '{\"mediaversion\":\"c53bffa086523265b5417c189f502737\"}'
  3. 1 × INSERT INTO `site_session` (`session_id`, `client_id`, `time`) 
      VALUES ('68dg0bkp3692ljiippaqanmut5', 0, '1779317682'