ASHRAE Northeast Chapter
Toggle Navigation
  • Home
  • Society Membership
  • About Us
    • Current Officers
    • Committees
      • Research Promotion
    • Chapter History
    • Past Presidents
    • Chapter Constitution & By-laws
    • Contact Us
  • Events
    • Event Calendar
    • Event Photos
  • Scholarship
  • Members
    • Site Registration
    • Forgot Login
    • Member Spotlight
    • Chapter Dues
  • Newsletters
  • Links
    • ASHRAE Society
    • ASHRAE Region 1
    • ASHRAE Foundation
    • AHR Expo
    • ASPE - Capital Region New York
    • AEE - Capital Region
    • ASHRAE Jobs
    • Local Job Opportunities
  • Login
  • Forgot Login?
  • Sign up

 

This web site describes the activities of Northeast Chapter of the American Society of Heating, Refrigerating, and Air-Conditioning Engineers, Inc. (ASHRAE). It does not present official positions of the Society nor reflect Society policy. ASHRAE is not responsible for this site's content. To learn more about ASHRAE activities on an international level, contact the ASHRAE home page at http://www.ashrae.org/.

 

Back to Top

© 2021 ASHRAE Northeast Chapter

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 6.86 ms / 6.86 ms Memory: 0.507 MB / 0.88 MB Application: afterLoad
Time: 46.79 ms / 53.65 ms Memory: 2.020 MB / 2.90 MB Application: afterInitialise
Time: 29.45 ms / 83.10 ms Memory: 0.923 MB / 3.82 MB Application: afterRoute
Time: 1.00 ms / 84.10 ms Memory: 0.012 MB / 3.84 MB Application: beforeRenderComponent com_comprofiler
Time: 27.84 ms / 111.94 ms Memory: 2.025 MB / 5.86 MB Application: beforeRenderModule mod_cblogin (ASHRAE Northeast Login)
Time: 11.31 ms / 123.25 ms Memory: 0.462 MB / 6.32 MB Application: afterRenderModule mod_cblogin (ASHRAE Northeast Login)
Time: 0.21 ms / 123.46 ms Memory: -0.043 MB / 6.28 MB Application: afterRenderComponent com_comprofiler
Time: 4.30 ms / 127.76 ms Memory: 0.107 MB / 6.39 MB Application: afterDispatch
Time: 5.90 ms / 133.66 ms Memory: 0.158 MB / 6.55 MB Application: beforeRenderModule mod_custom (Footer)
Time: 0.77 ms / 134.42 ms Memory: 0.006 MB / 6.55 MB Application: afterRenderModule mod_custom (Footer)
Time: 0.07 ms / 134.50 ms Memory: -0.000 MB / 6.55 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 15.59 ms / 150.08 ms Memory: 0.610 MB / 7.16 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.07 ms / 150.16 ms Memory: -0.005 MB / 7.16 MB Application: beforeRenderModule mod_finder (Smart Search)
Time: 9.04 ms / 159.19 ms Memory: 0.472 MB / 7.63 MB Application: afterRenderModule mod_finder (Smart Search)
Time: 7.00 ms / 166.20 ms Memory: 0.278 MB / 7.91 MB Application: afterRender

Database queries total: 20.38 ms

Memory Usage

8.25 MB (8,653,576 Bytes)

Database Queries

35 Queries Logged 20.38 ms


  1. Query Time: 0.47 ms Query memory: 0.023 MB Memory before query: 1.248 MB Rows returned: 0
    SELECT `data`
    
      FROM `j745_session`
      WHERE `session_id` = X'3865383165663038336337623033313534633831666164633634643938663436'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.28 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.15 ms After last query: 0.72 ms Query memory: 0.020 MB Memory before query: 1.264 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `j745_session`
      WHERE `session_id` = X'3865383165663038336337623033313534633831666164633634643938663436'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 1.269 MB
    INSERT INTO `j745_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3865383165663038336337623033313534633831666164633634643938663436', 1, 1611648883, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `j745_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3865383165663038336337623033313534633831666164633634643938663436', 1, 1611648883, 0, '', 0)
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.09 ms
    end0.00 ms
    query end0.04 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 0.72 ms After last query: 1.42 ms Query memory: 0.057 MB Memory before query: 1.306 MB Rows returned: 53
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j745_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_extensionsNULLrefextensionextension82const541.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.24 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.24 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Same as call in the line below.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.37 ms After last query: 1.24 ms Query memory: 0.021 MB Memory before query: 1.368 MB Rows returned: 5
    SELECT id, rules
    
      FROM `j745_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_viewlevelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL5100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.21 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.47 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.380 MB Rows returned: 2
    SELECT b.id
    
      FROM j745_usergroups AS a
      LEFT JOIN j745_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.24 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 1.00 ms After last query: 0.31 ms Query memory: 0.051 MB Memory before query: 1.403 MB Rows returned: 164
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM j745_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_extensionsNULLrefextensionextension82const2470.60Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.00 ms
    Creating sort index0.75 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:354
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Same as call in the line below.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:359
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.54 ms After last query: 12.26 ms Query memory: 0.022 MB Memory before query: 2.050 MB Rows returned: 1
    SELECT *
    
      FROM j745_ea_configs
      WHERE `name` = 'config'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_ea_configsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL333.33Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.28 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    13JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    12Joomla\CMS\Table\Table->load()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:87
    11EA::config()JROOT/administrator/components/com_easyarticles/includes/utils.php:52
    10EasyArticles->__construct()JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23
    9EAAcl->__construct()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:59
    8EA::acl()JROOT/plugins/system/easyarticles/easyarticles.php:40
    7PlgSystemEasyArticles->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:283
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:625
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.28 ms After last query: 0.51 ms Query memory: 0.025 MB Memory before query: 2.092 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j745_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    20JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    19Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    18call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    16Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    15Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    14Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    13Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    12Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    11Joomla\CMS\Factory::getDocument()JROOT/administrator/components/com_easyarticles/includes/utils.php:55
    10EasyArticles->__construct()JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23
    9EAAcl->__construct()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:59
    8EA::acl()JROOT/plugins/system/easyarticles/easyarticles.php:40
    7PlgSystemEasyArticles->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:283
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:625
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.26 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 2.085 MB
    UPDATE `j745_extensions`
    
      SET `params` = '{\"mediaversion\":\"acd4fadbd7be10cc7f2db5ff67124dbe\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEj745_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.04 ms
    updating0.06 ms
    end0.00 ms
    query end0.04 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    15Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    14Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    13Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    12Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    11Joomla\CMS\Factory::getDocument()JROOT/administrator/components/com_easyarticles/includes/utils.php:55
    10EasyArticles->__construct()JROOT/administrator/components/com_easyarticles/includes/acl/acl.php:23
    9EAAcl->__construct()JROOT/administrator/components/com_easyarticles/includes/easyarticles.php:59
    8EA::acl()JROOT/plugins/system/easyarticles/easyarticles.php:40
    7PlgSystemEasyArticles->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:283
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:625
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 1.32 ms After last query: 11.52 ms Query memory: 0.101 MB Memory before query: 2.516 MB Rows returned: 84
    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 j745_menu AS m
      LEFT JOIN j745_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_client_id_parent_id_alias_languageNO INDEX KEY COULD BE USEDNULLNULL2584.38Using where; Using filesort
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4toddt208_jm.m.component_id1100.00Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.33 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.63 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    21Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Same as call in the line below.
    20call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    18Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    17Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    16Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    15Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    14Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    13Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    12Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    11Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    10Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    9Joomla\CMS\Application\SiteApplication::getRouter()JROOT/plugins/system/communitybuilder/communitybuilder.php:300
    8plgSystemCommunityBuilder->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:626
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.55 ms After last query: 26.81 ms Query memory: 0.028 MB Memory before query: 3.741 MB Rows returned: 1
    SELECT `params`
     
      FROM `j745_comprofiler_plugin`
      WHERE `id` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_comprofiler_pluginNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.30 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    27JDatabaseDriver->loadResult()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    26CBLib\Database\Driver\CmsDatabaseDriver->loadResult()JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
    25CB\Application\CBConfig::getConfig()JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
    24CB\Application\CBApplication::CB\Application\{closure}()Same as call in the line below.
    23call_user_func_array()JROOT/libraries/CBLib/CBLib/Application/Config.php:38
    22CBLib\Application\Config::setMainConfig()JROOT/libraries/CBLib/CBLib/Core/CBLib.php:71
    21CBLib\Core\CBLib::CBLib\Core\{closure}()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605
    20CBLib\DependencyInjection\Container->build()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
    19CBLib\DependencyInjection\Container->make()JROOT/libraries/CBLib/CBLib/Application/Application.php:212
    18CBLib\Application\Application::__callStatic()JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
    17CB\Application\CBConfig::loadLegacyCBueConfig()JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
    16CB\Legacy\LegacyFoundationFunctions->__construct()Same as call in the line below.
    15ReflectionClass->newInstanceArgs()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643
    14CBLib\DependencyInjection\Container->build()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
    13CBLib\DependencyInjection\Container->make()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132
    12CBLib\DependencyInjection\Container->get()JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
    11include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.phpJROOT/components/com_comprofiler/router.php:75
    10ComprofilerRouter->loadCB()JROOT/components/com_comprofiler/router.php:319
    9ComprofilerRouter->parse()JROOT/libraries/src/Router/SiteRouter.php:438
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:139
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1074
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.69 ms After last query: 4.74 ms Query memory: 0.022 MB Memory before query: 3.817 MB Rows returned: 13
    SELECT id, home, template, s.params
    
      FROM j745_template_styles as s
      LEFT JOIN j745_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const111.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202toddt208_jm.e.element186.67Using index condition; Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.24 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.15 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    10Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/plugins/system/gantry5/gantry5.php:195
    9plgSystemGantry5->onAfterRouteSite()JROOT/plugins/system/gantry5/gantry5.php:57
    8plgSystemGantry5->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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.41 ms After last query: 0.82 ms Query memory: 0.019 MB Memory before query: 3.828 MB Rows returned: 1
    SELECT *
    
      FROM j745_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_languagesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.20 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.63 ms After last query: 3.90 ms Query memory: 0.028 MB Memory before query: 3.960 MB Rows returned: 16
    SHOW FULL COLUMNS 
      FROM `j745_users`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j745_users`
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.11 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.20 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.03 ms
    closing tables0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:445
    20JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    19Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    18Joomla\CMS\Table\Table->__construct()JROOT/libraries/src/Table/User.php:41
    17Joomla\CMS\Table\User->__construct()JROOT/libraries/src/Table/Table.php:312
    16Joomla\CMS\Table\Table::getInstance()JROOT/libraries/src/User/User.php:603
    15Joomla\CMS\User\User::getTable()JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:181
    14CB\Database\Table\UserTable->_reinitNonComprofileVars()JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:121
    13CB\Database\Table\UserTable->__construct()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194
    12CBuser::_getOrSetInstance()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
    11CBuser::getInstance()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:115
    10CBuser::getUserDataInstance()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:103
    9CBuser::getMyUserDataInstance()JROOT/components/com_comprofiler/comprofiler.php:2299
    8checkCBPostIsHTTPS()JROOT/components/com_comprofiler/comprofiler.php:1231
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.51 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 3.984 MB Rows returned: 1
    SELECT `params`
     
      FROM `j745_modules`
      WHERE `module` = 'mod_cblogin'
      AND `published` = 1
      AND `access` IN (1, 5)
      AND `language` IN ( 'en-US', '*', '' )
      ORDER BY `position`, `ordering`
      LIMIT 0, 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_modulesNULLrefpublished,newsfeeds,idx_languagenewsfeeds204const,const120.00Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.19 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.00 ms
    Creating sort index0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    10JDatabaseDriver->loadResult()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    9CBLib\Database\Driver\CmsDatabaseDriver->loadResult()JROOT/components/com_comprofiler/comprofiler.php:2313
    8checkCBPostIsHTTPS()JROOT/components/com_comprofiler/comprofiler.php:1231
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.35 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 3.994 MB Rows returned: 16
    SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
     
      FROM `j745_comprofiler_plugin`
      WHERE `published` = 1
      AND `viewaccesslevel` IN (1,5)
      AND `type` = 'user'
      ORDER BY `ordering`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_comprofiler_pluginNULLrefidx_folder,type_pub_ordertype_pub_order304const,const1620.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.13 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    11JDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
    10CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
    9CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
    8cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/comprofiler.php:1232
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 1.51 ms After last query: 9.37 ms Query memory: 0.045 MB Memory before query: 4.711 MB Rows returned: 345
    SHOW TABLES
    Explain
    EXPLAIN not possible on query: SHOW TABLES
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    checking permissions1.04 ms
    Sending data0.09 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.05 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    26JDatabaseDriver->loadColumn()JROOT/libraries/joomla/database/driver/mysqli.php:502
    25JDatabaseDriverMysqli->getTableList()JROOT/administrator/components/com_acymailing/compat/joomla.php:552
    24acymailing_getTableList()JROOT/administrator/components/com_acymailing/classes/cpanel.php:18
    23cpanelClass->load()JROOT/administrator/components/com_acymailing/helpers/helper.php:523
    22acymailing_config()JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    21include_once JROOT/administrator/components/com_acymailing/compat/joomla.phpJROOT/administrator/components/com_acymailing/helpers/helper.php:25
    20include_once JROOT/administrator/components/com_acymailing/helpers/helper.phpJROOT/components/com_comprofiler/plugin/user/plug_acymailingcbplugin/acymailing.php:8
    19require_once JROOT/components/com_comprofiler/plugin/user/plug_acymailingcbplugin/acymailing.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    18cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    17cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:22
    16require_once JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    15cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    14cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:20
    13require_once JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    12cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    11cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22
    10require_once JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    9cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    8cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/comprofiler.php:1232
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.62 ms After last query: 0.16 ms Query memory: 0.041 MB Memory before query: 4.761 MB Rows returned: 201
    SELECT * 
      FROM j745_acymailing_config
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_acymailing_configNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL201100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.24 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.17 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    25JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acymailing/compat/joomla.php:478
    24acymailing_loadObjectList()JROOT/administrator/components/com_acymailing/classes/cpanel.php:23
    23cpanelClass->load()JROOT/administrator/components/com_acymailing/helpers/helper.php:523
    22acymailing_config()JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    21include_once JROOT/administrator/components/com_acymailing/compat/joomla.phpJROOT/administrator/components/com_acymailing/helpers/helper.php:25
    20include_once JROOT/administrator/components/com_acymailing/helpers/helper.phpJROOT/components/com_comprofiler/plugin/user/plug_acymailingcbplugin/acymailing.php:8
    19require_once JROOT/components/com_comprofiler/plugin/user/plug_acymailingcbplugin/acymailing.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    18cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    17cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:22
    16require_once JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    15cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    14cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:20
    13require_once JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    12cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    11cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22
    10require_once JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    9cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    8cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/comprofiler.php:1232
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.60 ms After last query: 7.47 ms Query memory: 0.058 MB Memory before query: 5.536 MB Rows returned: 31
    SELECT *
     
      FROM `j745_comprofiler_plugin_autoactions`
      WHERE `trigger` != ''
      AND `published` = 1
      ORDER BY `ordering` ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_comprofiler_plugin_autoactionsNULLrefpublishedpublished4const3190.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.22 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.18 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    35JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    34JDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
    33CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
    32CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.php:143
    31require_once JROOT/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    30cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    29cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.php:24
    28require_once JROOT/components/com_comprofiler/plugin/user/plug_cbinvites/cbinvites.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    27cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    26cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbconditional/cbconditional.php:14
    25require_once JROOT/components/com_comprofiler/plugin/user/plug_cbconditional/cbconditional.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    24cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    23cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:22
    22require_once JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    21cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    20cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbprofileupdatelogger/cb.pulog.php:23
    19require_once JROOT/components/com_comprofiler/plugin/user/plug_cbprofileupdatelogger/cb.pulog.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    18cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    17cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.php:22
    16require_once JROOT/components/com_comprofiler/plugin/user/plug_cbblogs/cbblogs.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    15cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    14cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.php:20
    13require_once JROOT/components/com_comprofiler/plugin/user/plug_cbforums/cbforums.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    12cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    11cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22
    10require_once JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.phpJROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:397
    9cbPluginHandler->_loadPluginFile()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:233
    8cbPluginHandler->loadPluginGroup()JROOT/components/com_comprofiler/comprofiler.php:1232
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.40 ms After last query: 2.03 ms Query memory: 0.022 MB Memory before query: 5.853 MB Rows returned: 1
    SELECT *
     
      FROM `j745_modules`
      WHERE `module` = 'mod_cblogin'
      AND `published` = 1
      AND `access` IN (1, 5)
      AND `language` IN ( 'en-US', '*', '' )
      ORDER BY `position`, `ordering`
      LIMIT 0, 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_modulesNULLrefpublished,newsfeeds,idx_languagenewsfeeds204const,const120.00Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    10JDatabaseDriver->loadObject()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:418
    9CBLib\Database\Driver\CmsDatabaseDriver->loadObject()JROOT/components/com_comprofiler/comprofiler.html.php:886
    8HTML_comprofiler::loginForm()JROOT/components/com_comprofiler/comprofiler.php:1235
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 1.47 ms After last query: 1.90 ms Query memory: 0.085 MB Memory before query: 5.913 MB Rows returned: 64
    SELECT f.* 
      FROM j745_comprofiler_fields f
      INNER JOIN j745_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
      WHERE f.published = 1
      ORDER BY t.position, t.ordering, f.ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEfNULLALLtabid_pub_prof_orderNO INDEX KEY COULD BE USEDNULLNULL7210.00Using where; Using temporary; Using filesort
    1SIMPLEtNULLeq_refPRIMARYPRIMARY4toddt208_jm.f.tabid1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.38 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Creating tmp table0.03 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.46 ms
    Creating sort index0.34 ms
    end0.00 ms
    query end0.00 ms
    removing tmp table0.03 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    19JDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
    18CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
    17CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:993
    16cbTabs->_getTabFieldsDb()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
    15CBuser->getField()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1121
    14CBuser->{closure}()Same as call in the line below.
    13preg_replace_callback()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1172
    12CBuser->evaluateFields()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:648
    11CBuser->replaceUserVars()JROOT/modules/mod_cblogin/mod_cblogin.php:134
    10include JROOT/modules/mod_cblogin/mod_cblogin.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/components/com_comprofiler/comprofiler.html.php:889
    8HTML_comprofiler::loginForm()JROOT/components/com_comprofiler/comprofiler.php:1235
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 0.63 ms After last query: 1.24 ms Query memory: 0.023 MB Memory before query: 6.183 MB Rows returned: 0
    SELECT `id`
     
      FROM `j745_menu`
      WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
      AND `published` = 1
      AND `access` IN ( 1,5 )
      AND `language` IN ( 'en-US', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1140.54Using index condition; Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.36 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    14CBLib\Database\Driver\CmsDatabaseDriver->loadResult()JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:235
    13getCBprofileItemid()JROOT/libraries/CBLib/CB/Legacy/CBframework.php:994
    12CBframework->viewUrl()JROOT/libraries/CBLib/CB/Legacy/CBframework.php:853
    11CBframework->userProfileUrl()JROOT/modules/mod_cblogin/mod_cblogin.php:208
    10include JROOT/modules/mod_cblogin/mod_cblogin.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/components/com_comprofiler/comprofiler.html.php:889
    8HTML_comprofiler::loginForm()JROOT/components/com_comprofiler/comprofiler.php:1235
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.53 ms After last query: 3.46 ms Query memory: 0.024 MB Memory before query: 6.309 MB Rows returned: 0
    SELECT `id`
     
      FROM `j745_menu`
      WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
      AND `published` = 1
      AND `access` IN ( 1,5 )
      AND `language` IN ( 'en-US', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1140.42Using index condition; Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.28 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    14CBLib\Database\Driver\CmsDatabaseDriver->loadResult()JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
    13getCBprofileItemid()JROOT/libraries/CBLib/CB/Legacy/CBframework.php:994
    12CBframework->viewUrl()JROOT/templates/protostar/html/mod_cblogin/bootstrap.php:15
    11require JROOT/templates/protostar/html/mod_cblogin/bootstrap.phpJROOT/modules/mod_cblogin/mod_cblogin.php:233
    10include JROOT/modules/mod_cblogin/mod_cblogin.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/components/com_comprofiler/comprofiler.html.php:889
    8HTML_comprofiler::loginForm()JROOT/components/com_comprofiler/comprofiler.php:1235
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.47 ms After last query: 0.89 ms Query memory: 0.024 MB Memory before query: 6.321 MB Rows returned: 1
    SELECT `id`
     
      FROM `j745_menu`
      WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
      AND `published` = 1
      AND `access` IN ( 1,5 )
      AND `language` IN ( 'en-US', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1140.42Using index condition; Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.26 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    14CBLib\Database\Driver\CmsDatabaseDriver->loadResult()JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
    13getCBprofileItemid()JROOT/libraries/CBLib/CB/Legacy/CBframework.php:994
    12CBframework->viewUrl()JROOT/templates/protostar/html/mod_cblogin/bootstrap.php:151
    11require JROOT/templates/protostar/html/mod_cblogin/bootstrap.phpJROOT/modules/mod_cblogin/mod_cblogin.php:233
    10include JROOT/modules/mod_cblogin/mod_cblogin.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/components/com_comprofiler/comprofiler.html.php:889
    8HTML_comprofiler::loginForm()JROOT/components/com_comprofiler/comprofiler.php:1235
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.46 ms After last query: 0.20 ms Query memory: 0.024 MB Memory before query: 6.330 MB Rows returned: 1
    SELECT `id`
     
      FROM `j745_menu`
      WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
      AND `published` = 1
      AND `access` IN ( 1,5 )
      AND `language` IN ( 'en-US', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1140.42Using index condition; Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.25 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    14CBLib\Database\Driver\CmsDatabaseDriver->loadResult()JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
    13getCBprofileItemid()JROOT/libraries/CBLib/CB/Legacy/CBframework.php:994
    12CBframework->viewUrl()JROOT/templates/protostar/html/mod_cblogin/bootstrap.php:165
    11require JROOT/templates/protostar/html/mod_cblogin/bootstrap.phpJROOT/modules/mod_cblogin/mod_cblogin.php:233
    10include JROOT/modules/mod_cblogin/mod_cblogin.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/components/com_comprofiler/comprofiler.html.php:889
    8HTML_comprofiler::loginForm()JROOT/components/com_comprofiler/comprofiler.php:1235
    7login()JROOT/components/com_comprofiler/comprofiler.php:137
    6require_once JROOT/components/com_comprofiler/comprofiler.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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.63 ms After last query: 1.02 ms Query memory: 0.020 MB Memory before query: 6.289 MB Rows returned: 0
    SELECT folder.*
    
      FROM `j745_eventgallery_folder` AS folder
      LEFT JOIN `j745_eventgallery_file` AS file
      ON folder.folder = file.folder
      and file.published=1
      and file.ismainimage=0
      WHERE file.file IS NULL
      AND (folder.foldertypeid=1 OR folder.foldertypeid=2)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEfolderNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL355.56Using where
    1SIMPLEfileNULLreffile,index_folderfile377toddt208_jm.folder.folder18610.00Using where; Not exists
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.33 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    8JDatabaseDriver->loadObjectList()JROOT/plugins/system/picasaupdater/picasaupdater.php:73
    7plgSystemPicasaupdater->onAfterDispatch()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/SiteApplication.php:199
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 1.13 ms After last query: 4.18 ms Query memory: 0.023 MB Memory before query: 6.435 MB Rows returned: 6
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j745_modules AS m
      LEFT JOIN j745_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j745_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 <= '2021-01-26 08:14:43')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-26 08:14:43')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLPRIMARY,published,newsfeedsNO INDEX KEY COULD BE USEDNULLNULL1340.75Using where; Using filesort
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403toddt208_jm.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4toddt208_jm.m.id140.00Using where; Using index
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.20 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.59 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:100
    7require JROOT/templates/protostar/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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.42 ms After last query: 2.84 ms Query memory: 0.022 MB Memory before query: 6.532 MB Rows returned: 1
    SELECT COUNT(1) 
      FROM `j745_ea_oauth`
      WHERE `system`='1'
      AND `type`='google'
      AND `access_token` !=""
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_ea_oauthNULLrefidx_expiry_notifyidx_expiry_notify767const1100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.20 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/administrator/components/com_easyarticles/includes/utils.php:235
    12EasyArticlesDbJoomla->__call()JROOT/administrator/components/com_easyarticles/models/oauth.php:172
    11EAModelOauth->isAssociated()JROOT/administrator/components/com_easyarticles/includes/oauth/oauth.php:68
    10EAOauth->isSystemAssociated()JROOT/administrator/components/com_easyarticles/includes/analytics/analytics.php:24
    9EAAnalytics->isEnabled()JROOT/plugins/system/easyarticles/easyarticles.php:268
    8PlgSystemEasyArticles->loadAnalytics()JROOT/plugins/system/easyarticles/easyarticles.php:125
    7PlgSystemEasyArticles->onBeforeRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1034
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.37 ms After last query: 18.51 ms Query memory: 0.022 MB Memory before query: 7.196 MB Rows returned: 7
    SELECT `name`,`element`
    
      FROM `j745_extensions`
      WHERE `type` = 'plugin'
      AND `folder` = 'finder'
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_extensionsNULLrefextensionextension82const2471.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.12 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_finder/helpers/language.php:126
    11FinderHelperLanguage::loadPluginLanguage()JROOT/modules/mod_finder/mod_finder.php:51
    10include JROOT/modules/mod_finder/mod_finder.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.56 ms After last query: 4.81 ms Query memory: 0.023 MB Memory before query: 7.603 MB Rows returned: 6
    SELECT `title`
    
      FROM `j745_finder_taxonomy`
      WHERE `parent_id` = 1
      AND `state` = 1
      AND `access` IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_finder_taxonomyNULLrefparent_id,state,access,idx_parent_publishedparent_id4const698.25Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.26 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    15JDatabaseDriver->loadColumn()JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
    14FinderIndexerTaxonomy::getBranchTitles()JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
    13FinderIndexerQuery->processString()JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
    12FinderIndexerQuery->__construct()JROOT/modules/mod_finder/helper.php:84
    11ModFinderHelper::getQuery()JROOT/modules/mod_finder/mod_finder.php:54
    10include JROOT/modules/mod_finder/mod_finder.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.68 ms After last query: 2.91 ms Query memory: 0.044 MB Memory before query: 7.627 MB Rows returned: 279
    SELECT * 
      FROM j745_acym_configuration
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_acym_configurationNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL279100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.20 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.21 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acym/library/joomla.php:494
    19acym_loadObjectList()JROOT/administrator/components/com_acym/classes/configuration.php:13
    18acymconfigurationClass->load()JROOT/administrator/components/com_acym/helpers/global/global.php:35
    17acym_config()JROOT/administrator/components/com_acym/library/object.php:15
    16acymObject->__construct()JROOT/administrator/components/com_acym/helpers/global/global.php:62
    15acym_get()JROOT/administrator/components/com_acym/classes/form.php:38
    14acymformClass->__construct()JROOT/administrator/components/com_acym/helpers/global/global.php:62
    13acym_get()JROOT/plugins/system/acymtriggers/acymtriggers.php:102
    12plgSystemAcymtriggers->onBeforeCompileHead()JROOT/libraries/joomla/event/event.php:70
    11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    10JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    9Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.36 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 7.789 MB Rows returned: 0
    SELECT * 
      FROM j745_acym_form
      WHERE active = 1
      AND type != 'shortcode'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_acym_formNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.16 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acym/library/joomla.php:494
    14acym_loadObjectList()JROOT/administrator/components/com_acym/classes/form.php:108
    13acymformClass->getAllFormsToDisplay()JROOT/plugins/system/acymtriggers/acymtriggers.php:103
    12plgSystemAcymtriggers->onBeforeCompileHead()JROOT/libraries/joomla/event/event.php:70
    11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    10JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    9Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 0.37 ms After last query: 0.29 ms Query memory: 0.026 MB Memory before query: 7.802 MB Rows returned: 6
    SHOW FULL COLUMNS 
      FROM `j745_template_styles`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j745_template_styles`
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.11 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.00 ms
    executing0.01 ms
    Opening tables0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.02 ms
    closing tables0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:445
    19JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:245
    18Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:164
    17Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_templates/tables/style.php:30
    16TemplatesTableStyle->__construct()JROOT/libraries/src/Table/Table.php:312
    15Joomla\CMS\Table\Table::getInstance()JROOT/plugins/system/gantry/gantry.php:194
    14plgSystemGantry->getTable()JROOT/plugins/system/gantry/gantry.php:165
    13plgSystemGantry->isGantryTemplate()JROOT/plugins/system/gantry/gantry.php:234
    12plgSystemGantry->onBeforeCompileHead()JROOT/libraries/joomla/event/event.php:70
    11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    10JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    9Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  35. Query Time: 0.19 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 7.820 MB Rows returned: 1
    SELECT *
    
      FROM j745_template_styles
      WHERE `id` = '7'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEj745_template_stylesNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    15JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:731
    14Joomla\CMS\Table\Table->load()JROOT/plugins/system/gantry/gantry.php:168
    13plgSystemGantry->isGantryTemplate()JROOT/plugins/system/gantry/gantry.php:234
    12plgSystemGantry->onBeforeCompileHead()JROOT/libraries/joomla/event/event.php:70
    11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    10JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    9Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    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
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT `id`  
      FROM `j745_menu`
  2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `j745_extensions`
  3. 1 × SELECT `data` 
      FROM `j745_session`
  4. 1 × SELECT *  
      FROM `j745_comprofiler_plugin_autoactions`
  5. 1 × SELECT * 
      FROM j745_acym_form
  6. 1 × SELECT * 
      FROM j745_acym_configuratio
  7. 1 × SELECT `title` 
      FROM `j745_finder_taxonomy`
  8. 1 × SELECT `name`,`element` 
      FROM `j745_extensions`
  9. 1 × SELECT COUNT(1) 
      FROM `j745_ea_oauth`
  10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM j745_modules AS m
      LEFT JOIN j745_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j745_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  11. 1 × SELECT folder.* 
      FROM `j745_eventgallery_folder` AS folder
      LEFT JOIN `j745_eventgallery_file` AS file
      ON folder.folder = file.folder
      and file.published=1
      and file.ismainimage=0
  12. 1 × SELECT f.* 
      FROM j745_comprofiler_fields f
      INNER JOIN j745_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
  13. 1 × SELECT *  
      FROM `j745_modules`
  14. 1 × SELECT * 
      FROM j745_acymailing_confi
  15. 1 × SELECT `session_id` 
      FROM `j745_session`
  16. 1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
      FROM `j745_comprofiler_plugin`
  17. 1 × SELECT `params`  
      FROM `j745_modules`
  18. 1 × SELECT * 
      FROM j745_languages
  19. 1 × SELECT id, home, template, s.params 
      FROM j745_template_styles as s
      LEFT JOIN j745_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  20. 1 × SELECT `params`  
      FROM `j745_comprofiler_plugin`
  21. 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 j745_menu AS m
      LEFT JOIN j745_extensions AS e
      ON m.component_id = e.extension_id
  22. 1 × SELECT * 
      FROM j745_ea_configs
  23. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM j745_extensions
  24. 1 × SELECT b.id 
      FROM j745_usergroups AS a
      LEFT JOIN j745_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  25. 1 × SELECT id, rules 
      FROM `j745_viewlevels
  26. 1 × SELECT * 
      FROM j745_template_styles
OTHER Tables:
  1. 1 × INSERT INTO `j745_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3865383165663038336337623033313534633831666164633634643938663436', 1, 1611648883, 0, '', 0
  2. 1 × UPDATE `j745_extensions` 
      SET `params` = '{\"mediaversion\":\"acd4fadbd7be10cc7f2db5ff67124dbe\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `j745_users
  4. 1 × SHOW TABLE
  5. 1 × SHOW FULL COLUMNS 
      FROM `j745_template_styles