Ambrósio - Your Digital ConciergeAmbrósio - Your Digital ConciergeAmbrósio - Your Digital Concierge

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/ambrosiodelivery/public_html/plugins/system/vpframework/helpers/menu.php on line 142

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/ambrosiodelivery/public_html/plugins/system/vpframework/helpers/menu.php on line 446
  • Como usar o Ambrósio
  • Para Restaurantes
  • Contactos

Iniciar sessão

Esqueceu-se da senha?

Iniciar sessão

Esqueceu-se da senha?
  • Esqueceu-se do nome de utilizador?

Este site utiliza cookies para garantir que obtem a melhor experiência em nosso site.

Consola de depuração Joomla

Sessão

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1793179499,
                "last": 1793179499,
                "now": 1793179500
            },
            "token": "AEZ9KW6DI29K6SaQssvvx9lx2MbCm1E9"
        },
        "registry": {
            "com_vpadvanceduser": {
                "login": {
                    "form": {
                        "data": []
                    }
                }
            },
            "proopc": {
                "lastvisited": {
                    "url": "https:\/\/www.ambrosiodelivery.com\/index.php\/minha-conta?layout=login"
                }
            }
        },
        "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
        }
    }
}

Dados do perfil

Hora

Memória

Hora: 13.56 ms / 13.56 ms Memória: 1.790 MB / 2.16 MB Application: afterLoad
Hora: 40.89 ms / 54.45 ms Memória: 4.423 MB / 6.58 MB Application: afterInitialise
Hora: 26.30 ms / 80.75 ms Memória: 2.475 MB / 9.06 MB Application: Before Access::preloadComponents (all components)
Hora: 1.29 ms / 82.05 ms Memória: 0.068 MB / 9.13 MB Application: After Access::preloadComponents (all components)
Hora: 0.02 ms / 82.06 ms Memória: 0.000 MB / 9.12 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Hora: 0.39 ms / 82.45 ms Memória: 0.026 MB / 9.15 MB Application: After Access::getAssetRules (id:1 name:root.1)
Hora: 0.02 ms / 82.47 ms Memória: 0.001 MB / 9.15 MB Application: Before Access::getAssetRules (id:61 name:com_virtuemart)
Hora: 0.01 ms / 82.49 ms Memória: 0.002 MB / 9.15 MB Application: After Access::getAssetRules (id:61 name:com_virtuemart)
Hora: 20.31 ms / 102.79 ms Memória: 1.594 MB / 10.74 MB Application: afterRoute
Hora: 0.29 ms / 103.09 ms Memória: 0.018 MB / 10.76 MB Application: beforeRenderComponent com_vpadvanceduser
Hora: 32.62 ms / 135.71 ms Memória: 2.969 MB / 13.73 MB Application: afterRenderComponent com_vpadvanceduser
Hora: 3.11 ms / 138.82 ms Memória: 0.118 MB / 13.85 MB Application: afterDispatch
Hora: 225.36 ms / 364.18 ms Memória: 4.586 MB / 18.43 MB Application: afterRender

Total de consultas à base de dados: 10.66 ms

Utilização de memória

18,75 MB (19 662 360 Bytes)

Pedidos à Base de dados

16 pedidos registados 10.66 ms


  1. Tempo da consulta: 0.41 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 3.843 MB Linhas devolvidas: 1
    SELECT `data`
    
      FROM `sspot_session`
      WHERE `session_id` = X'3066336536366130343633613432303864383936376665373133396533376433'
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_sessionconstPRIMARYPRIMARY194const1
    Perfil
    StatusDuration
    Starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Igual à chamada na linha abaixo.
    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:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:758
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  2. Tempo da consulta: 0.22 ms Após a última consulta: 6.04 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.507 MB Linhas devolvidas: 5
    SELECT id, rules
    
      FROM `sspot_viewlevels`
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_viewlevelsALLNULLNehnuma INDEX KEY pode ser utilizadaNULLNULL5
    Perfil
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    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:321
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  3. Tempo da consulta: 0.28 ms Após a última consulta: 0.06 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 4.519 MB Linhas devolvidas: 2
    SELECT b.id
    
      FROM sspot_usergroups AS a
      LEFT JOIN sspot_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2Using where; Using index
    Perfil
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    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:321
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  4. Tempo da consulta: 0.27 ms Após a última consulta: 29.84 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 7.565 MB
    UPDATE `sspot_extensions`
    
      SET `params` = '{\"mediaversion\":\"6f023fb5f3848b3a4973f74f1b22ca36\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explica
    EXPLAIN não é possível na consulta: UPDATE `sspot_extensions` SET `params` = '{\"mediaversion\":\"6f023fb5f3848b3a4973f74f1b22ca36\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Perfil
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init for update0.07 ms
    Updating0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    14JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    13Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    12Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/plugins/system/vpadvanceduser/vpadvanceduser.php:69
    8plgSystemVPAdvancedUser->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  5. Tempo da consulta: 0.57 ms Após a última consulta: 11.95 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 8.863 MB Linhas devolvidas: 1
    SHOW TABLES LIKE "sspot_virtuemart_configs"
    Explica
    EXPLAIN não é possível na consulta: SHOW TABLES LIKE "sspot_virtuemart_configs"
    Perfil
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Filling schema table0.01 ms
    checking permissions0.36 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Removing tmp table0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    14JDatabaseDriver->loadResult()JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:723
    13VmTable::checkTableExists()JROOT/administrator/components/com_virtuemart/models/config.php:565
    12VirtueMartModelConfig::checkConfigTableExists()JROOT/administrator/components/com_virtuemart/helpers/config.php:406
    11VmConfig::loadConfig()JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
    10VPOPCHelper->__construct()JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
    9VPOPCHelper::getInstance()JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
    8plgSystemVPOnePageCheckout->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  6. Tempo da consulta: 0.22 ms Após a última consulta: 0.46 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 8.908 MB Linhas devolvidas: 1
    SELECT `config` 
      FROM `sspot_virtuemart_configs`
      WHERE `virtuemart_config_id` = "1";
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_virtuemart_configssystemPRIMARYNehnuma INDEX KEY pode ser utilizadaNULLNULL1
    Perfil
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/administrator/components/com_virtuemart/helpers/config.php:446
    11VmConfig::loadConfig()JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
    10VPOPCHelper->__construct()JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
    9VPOPCHelper::getInstance()JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
    8plgSystemVPOnePageCheckout->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  7. Tempo da consulta: 0.53 ms Após a última consulta: 1.12 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.019 MB Linhas devolvidas: 2
    SELECT *
    
      FROM sspot_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_languagesALLNULLNehnuma INDEX KEY pode ser utilizadaNULLNULL2Using where; Filesort em utilização
    Perfil
    StatusDuration
    Starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.30 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    14Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:90
    13vmLanguage::setLanguageByTag()JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:56
    12vmLanguage::initialise()JROOT/administrator/components/com_virtuemart/helpers/config.php:467
    11VmConfig::loadConfig()JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
    10VPOPCHelper->__construct()JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
    9VPOPCHelper::getInstance()JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
    8plgSystemVPOnePageCheckout->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  8. Tempo da consulta: 1.08 ms Após a última consulta: 0.64 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 9.061 MB Linhas devolvidas: 44
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `sspot_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advportfoliopro','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_visforms','com_vpadvanceduser','com_wrapper')
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_assetsALLidx_asset_nameNehnuma INDEX KEY pode ser utilizadaNULLNULL186Using where
    Perfil
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.09 ms
    Optimizing0.03 ms
    Statistics0.11 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.60 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:145
    13vmAccess::manager()JROOT/administrator/components/com_virtuemart/helpers/config.php:85
    12VmConfig::echoAdmin()JROOT/administrator/components/com_virtuemart/helpers/config.php:468
    11VmConfig::loadConfig()JROOT/plugins/system/vponepagecheckout/cart/helper.php:69
    10VPOPCHelper->__construct()JROOT/plugins/system/vponepagecheckout/cart/helper.php:118
    9VPOPCHelper::getInstance()JROOT/plugins/system/vponepagecheckout/vponepagecheckout.php:110
    8plgSystemVPOnePageCheckout->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  9. Tempo da consulta: 0.34 ms Após a última consulta: 10.93 ms Consulta a Memória: 0.007 MB de memória antes da consulta: 9.914 MB Linhas devolvidas: 1
    SELECT *
    
      FROM `sspot_extensions`
      WHERE `type` = 'package'
      AND `element` = 'pkg_vp_smart'
      AND `enabled` = '1'
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Perfil
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.04 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    13JDatabaseDriver->loadObject()JROOT/plugins/system/vpframework/helpers/dlk.php:880
    12VPFrameworkDlk->loadInfo()JROOT/plugins/system/vpframework/helpers/dlk.php:98
    11VPFrameworkDlk->__construct()JROOT/plugins/system/vpframework/helpers/dlk.php:127
    10VPFrameworkDlk::getInstance()JROOT/plugins/system/vpframework/helper.php:204
    9plgSystemVPFrameworkHelper->initialize()JROOT/plugins/system/vpframework/vpframework.php:72
    8plgSystemVPFramework->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  10. Tempo da consulta: 0.26 ms Após a última consulta: 5.36 ms Consulta a Memória: 0.006 MB de memória antes da consulta: 10.454 MB Linhas devolvidas: 1
    SELECT element, folder
    
      FROM sspot_extensions
      WHERE type = 'component'
      AND element = 'com_virtuemart'
      AND enabled = 1
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using 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.01 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    11JDatabaseDriver->loadObject()JROOT/plugins/system/vpframework/helpers/utility.php:258
    10VPFrameworkUtility::hasExtension()JROOT/plugins/system/vpframework/helper.php:731
    9plgSystemVPFrameworkHelper->loadInlineAssets()JROOT/plugins/system/vpframework/vpframework.php:89
    8plgSystemVPFramework->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  11. Tempo da consulta: 0.53 ms Após a última consulta: 3.39 ms Consulta a Memória: 0.005 MB de memória antes da consulta: 10.741 MB Linhas devolvidas: 0
    SELECT title, module AS name
    
      FROM sspot_modules
      WHERE published = 1
      AND module IN ('mod_virtuemart_category','mod_virtuemart_search')
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_modulesrangepublished,newsfeedsnewsfeeds204NULL2Using index condition
    Perfil
    StatusDuration
    Starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.31 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/plugins/system/vpframework/helper.php:657
    9plgSystemVPFrameworkHelper->manageModuleCache()JROOT/plugins/system/vpframework/vpframework.php:92
    8plgSystemVPFramework->onAfterRoute()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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  12. Tempo da consulta: 1.48 ms Após a última consulta: 15.81 ms Consulta a Memória: 0.011 MB de memória antes da consulta: 12.396 MB Linhas devolvidas: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM sspot_fields AS a
      LEFT JOIN `sspot_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sspot_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sspot_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sspot_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sspot_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'com_users.user'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Filesort em utilização
    1SIMPLEleq_refidx_langcodeidx_langcode28ambrosiodelivery_site.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.group_id1Using where
    Perfil
    StatusDuration
    Starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.06 ms
    Optimizing0.05 ms
    Statistics0.59 ms
    Preparing0.05 ms
    Creating tmp table0.07 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.26 ms
    Creating sort index0.03 ms
    Removing tmp table0.06 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    24JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    22FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    21Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    20FieldsHelper::getFields()JROOT/administrator/components/com_fields/helpers/fields.php:286
    19FieldsHelper::prepareForm()JROOT/plugins/system/fields/fields.php:305
    18PlgSystemFields->onContentPrepareForm()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/src/MVC/Model/FormModel.php:321
    15Joomla\CMS\MVC\Model\FormModel->preprocessForm()JROOT/components/com_users/models/registration.php:390
    14UsersModelRegistration->preprocessForm()JROOT/components/com_vpadvanceduser/models/registration.php:254
    13VPAdvancedUserModelRegistration->preprocessForm()JROOT/libraries/src/MVC/Model/FormModel.php:242
    12Joomla\CMS\MVC\Model\FormModel->loadForm()JROOT/components/com_vpadvanceduser/models/registration.php:131
    11VPAdvancedUserModelRegistration->getForm()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_vpadvanceduser/views/login/view.html.php:56
    9VPAdvancedUserViewLogin->display()JROOT/components/com_vpadvanceduser/controller.php:108
    8VPAdvancedUserController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_vpadvanceduser/vpadvanceduser.php:35
    6require_once JROOT/components/com_vpadvanceduser/vpadvanceduser.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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  13. Tempo da consulta: 1.71 ms Após a última consulta: 0.70 ms Consulta a Memória: 0.010 MB de memória antes da consulta: 12.464 MB Linhas devolvidas: 2
    SELECT id, label, name, description, type, show_in_registration, show_in_profile, access, params, ordering, state, language
    
      FROM `sspot_vpadvanceduser_fields`
      WHERE `show_in_registration` = 1
      AND `access` IN (1,1,5)
      AND `state` = 1
      AND (`language` = 'en-GB' OR `language` = '*')
      ORDER BY `ordering`
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsspot_vpadvanceduser_fieldsALLNULLNehnuma INDEX KEY pode ser utilizadaNULLNULL18Using where; Filesort em utilização
    Perfil
    StatusDuration
    Starting0.05 ms
    checking permissions0.01 ms
    Opening tables1.28 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.04 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.01 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.05 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_vpadvanceduser/models/data.php:258
    20VPAdvancedUserModelData->getFields()JROOT/administrator/components/com_vpadvanceduser/models/data.php:36
    19VPAdvancedUserModelData->getForm()JROOT/plugins/user/vpadvanceduser/vpadvanceduser.php:154
    18plgUserVPAdvancedUser->onContentPrepareForm()JROOT/libraries/joomla/event/event.php:70
    17JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    16JEventDispatcher->trigger()JROOT/libraries/src/MVC/Model/FormModel.php:321
    15Joomla\CMS\MVC\Model\FormModel->preprocessForm()JROOT/components/com_users/models/registration.php:390
    14UsersModelRegistration->preprocessForm()JROOT/components/com_vpadvanceduser/models/registration.php:254
    13VPAdvancedUserModelRegistration->preprocessForm()JROOT/libraries/src/MVC/Model/FormModel.php:242
    12Joomla\CMS\MVC\Model\FormModel->loadForm()JROOT/components/com_vpadvanceduser/models/registration.php:131
    11VPAdvancedUserModelRegistration->getForm()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_vpadvanceduser/views/login/view.html.php:56
    9VPAdvancedUserViewLogin->display()JROOT/components/com_vpadvanceduser/controller.php:108
    8VPAdvancedUserController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_vpadvanceduser/vpadvanceduser.php:35
    6require_once JROOT/components/com_vpadvanceduser/vpadvanceduser.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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  14. Tempo da consulta: 0.96 ms Após a última consulta: 1.93 ms Consulta a Memória: 0.011 MB de memória antes da consulta: 12.527 MB Linhas devolvidas: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM sspot_fields AS a
      LEFT JOIN `sspot_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sspot_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sspot_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sspot_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sspot_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'com_users.login'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Filesort em utilização
    1SIMPLEleq_refidx_langcodeidx_langcode28ambrosiodelivery_site.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4ambrosiodelivery_site.a.group_id1Using where
    Perfil
    StatusDuration
    Starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.04 ms
    Statistics0.17 ms
    Preparing0.04 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.23 ms
    Creating sort index0.02 ms
    Removing tmp table0.05 ms
    Creating sort index0.01 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.00 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    25JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    23FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    22Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    21FieldsHelper::getFields()JROOT/administrator/components/com_fields/helpers/fields.php:286
    20FieldsHelper::prepareForm()JROOT/plugins/system/fields/fields.php:305
    19PlgSystemFields->onContentPrepareForm()JROOT/libraries/joomla/event/event.php:70
    18JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    17JEventDispatcher->trigger()JROOT/libraries/src/MVC/Model/FormModel.php:321
    16Joomla\CMS\MVC\Model\FormModel->preprocessForm()JROOT/components/com_users/models/login.php:110
    15UsersModelLogin->preprocessForm()JROOT/components/com_vpadvanceduser/models/login.php:151
    14VPAdvancedUserModelLogin->preprocessForm()JROOT/libraries/src/MVC/Model/FormModel.php:242
    13Joomla\CMS\MVC\Model\FormModel->loadForm()JROOT/components/com_users/models/login.php:35
    12UsersModelLogin->getForm()JROOT/components/com_vpadvanceduser/models/login.php:53
    11VPAdvancedUserModelLogin->getForm()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_vpadvanceduser/views/login/view.html.php:59
    9VPAdvancedUserViewLogin->display()JROOT/components/com_vpadvanceduser/controller.php:108
    8VPAdvancedUserController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_vpadvanceduser/vpadvanceduser.php:35
    6require_once JROOT/components/com_vpadvanceduser/vpadvanceduser.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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  15. Tempo da consulta: 0.26 ms Após a última consulta: 21.39 ms Consulta a Memória: 0.008 MB de memória antes da consulta: 14.351 MB Linhas devolvidas: 3
    SELECT a.id, a.template, a.home, a.params
    
      FROM sspot_template_styles AS a
      WHERE a.client_id = 0
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_client_id,idx_client_id_homeidx_client_id1const3
    Perfil
    StatusDuration
    Starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.01 ms
    Sending data0.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.00 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/plugins/system/vpframework/helper.php:277
    13plgSystemVPFrameworkHelper->getTemplates()JROOT/plugins/system/vpframework/helpers/admin.php:31
    12VPFrameworkAdmin->__construct()JROOT/plugins/system/vpframework/helpers/admin.php:67
    11VPFrameworkAdmin::getInstance()JROOT/plugins/system/vpframework/helpers/template.php:1235
    10VPFrameworkTemplate->getGoogleFontCSS()JROOT/templates/vp_smart/layouts/default/blocks/head.php:118
    9require JROOT/templates/vp_smart/layouts/default/blocks/head.phpJROOT/templates/vp_smart/layouts/default/index.php:24
    8require JROOT/templates/vp_smart/layouts/default/index.phpJROOT/templates/vp_smart/index.php:100
    7require JROOT/templates/vp_smart/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

  16. Tempo da consulta: 1.54 ms Após a última consulta: 7.89 ms Consulta a Memória: 0.009 MB de memória antes da consulta: 16.928 MB Linhas devolvidas: 5
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM sspot_modules AS m
      LEFT JOIN sspot_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN sspot_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-10-28 09:25:00')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-28 09:25:00')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 123 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explica
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrangePRIMARY,published,newsfeedspublished5NULL10Using index condition; Using where; Filesort em utilização
    1SIMPLEmmrefPRIMARYPRIMARY4ambrosiodelivery_site.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403ambrosiodelivery_site.m.module,const1Using index condition; Using where
    Perfil
    StatusDuration
    Starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    table lock0.01 ms
    init0.05 ms
    Optimizing0.05 ms
    Statistics0.07 ms
    Preparing0.06 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.01 ms
    Creating sort index1.03 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Query end0.01 ms
    closing tables0.01 ms
    Unlocking tables0.01 ms
    closing tables0.01 ms
    Query end0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Chamada de dados
    #ChamadorFicheiro e número da linha
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()Igual à chamada na linha abaixo.
    15call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    14Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    13Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    12Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    11Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    10Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/vp_smart/layouts/default/blocks/topbar.php:15
    9require JROOT/templates/vp_smart/layouts/default/blocks/topbar.phpJROOT/templates/vp_smart/layouts/default/index.php:28
    8require JROOT/templates/vp_smart/layouts/default/index.phpJROOT/templates/vp_smart/index.php:100
    7require JROOT/templates/vp_smart/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Adiciona a diretiva xdebug.file_link_format ao teu ficheiro php.ini para ter ligações para ficheiros]

15 tipos de pedidos registados, ordenados por ocorrências.

ESCOLHER tabelas:
  1. 2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM sspot_fields AS a
      LEFT JOIN `sspot_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sspot_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sspot_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sspot_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sspot_fields_groups AS g
      ON g.id = a.group_id
  2. 1 × SELECT `data` 
      FROM `sspot_session`
  3. 1 × SELECT id, rules 
      FROM `sspot_viewlevels
  4. 1 × SELECT b.id 
      FROM sspot_usergroups AS a
      LEFT JOIN sspot_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  5. 1 × SELECT `config` 
      FROM `sspot_virtuemart_configs`
  6. 1 × SELECT * 
      FROM sspot_languages
  7. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `sspot_assets`
  8. 1 × SELECT * 
      FROM `sspot_extensions`
  9. 1 × SELECT element, folder 
      FROM sspot_extensions
  10. 1 × SELECT title, module AS name 
      FROM sspot_modules
  11. 1 × SELECT id, label, name, description, type, show_in_registration, show_in_profile, access, params, ordering, state, language 
      FROM `sspot_vpadvanceduser_fields`
  12. 1 × SELECT a.id, a.template, a.home, a.params 
      FROM sspot_template_styles AS a
  13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM sspot_modules AS m
      LEFT JOIN sspot_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN sspot_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
OUTRAS tabelas:
  1. 1 × UPDATE `sspot_extensions` 
      SET `params` = '{\"mediaversion\":\"6f023fb5f3848b3a4973f74f1b22ca36\"}'
  2. 1 × SHOW TABLES LIKE "sspot_virtuemart_configs