Citadel Community Association
Toggle Navigation

 

  • Home
  • About CCA
    • The Association
    • Strategic Plan
    • Association By-Laws
    • Board of Directors
    • Board Meeting Minutes
    • Financials
    • Contacts
  • Community
    • Volunteers
    • Community News
    • Map of Citadel
    • Landscape Levy
    • Crime Stats
    • Area Security
    • Photo Gallery
    • Construction Update
  • Membership
    • New / Renew Membership
    • New / Renew Seniors Membership
    • My Membership History
    • My Profile
    • Membership and Benefits
  • Events
    • CCA Events
    • Photo Gallery
    • Events Calendar
    • Events Retrospective
    • CCA Annual Events
  • Rentals
    • Rental Inquiry
    • Rentals Availability Calendar
    • Rental and Hall Information
  • Store
  • Sport
    • Badminton
    • CCA Sport Affiliations
  • Newsletter
    • Citadel Link
    • Link Classified Ad's
  • Programs
  • City
    • City News
    • Ward 2 Profile
  • You are here:  
  • Home
  • Newsletter
  • Link Classified Ad's

Member Login

  • Forgot Login?
  • Sign up
____________________________
 Upcoming Events
June 11 - Annual Used Book Sale
June 25/26 - Parade of Garage Sales
July 6 & 7 - Casino Fundraiser
July 10 - Stampede BBQ
Aug. 13 - Movie in the Park
August 27 - Community Clean-up
________________________
Social Media:

 Facebook logo and symbol, meaning, history, PNG

Instagram Logo transparent PNG - StickPNG

Logo Twitter PNG, Logo Twitter Transparent Background - FreeIconsPNG

City of Calgary

Alberta Emergency Alert - Current

  • Information Alert - Traffic Hazard - May 22, 2022 at 10:19AM

Calgary - Weather - Environment Canada

  • Saturday night: Periods of rain. Low 7.
  • Sunday: Periods of rain. High 11.
  • Friday night: Chance of showers. Low 9. POP 60%
  • Saturday: Periods of rain. High 14.
  • Thursday night: Cloudy periods. Low 10.
City of Calgary Newsroom

City of Calgary Newsroom

  • Seeking assistance to locate wanted man – OMAR-CARR
  • Suspect charged with sexual assault against youth
  • New building code requirements designed to prevent window falls adopted into the National Building Code of Canada 2020
  • City of Calgary Hours of Operation for Victoria Day 2022
  • Police make quick arrest in random stabbing on CTrain
City of Calgary Newsroom

City of Calgary Newsroom

  • City Services: Holiday Season 2021
  • Recreation hosts adaptive golf classes
  • Communauto launches new carsharing service in Calgary
  • Keeping Calgarians on the move: 20 projects in 2020
  • Bow Trail S.W. closures planned for the weekend

Back to Top

© 2022 Citadel Community Association

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653327851,
                "last": 1653327851,
                "now": 1653327851
            },
            "token": "EaviIhO3bppRhnrG5KsowIeVM3vOtC6f"
        },
        "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: 5.87 ms / 5.87 ms Memory: 2.136 MB / 2.51 MB Application: afterLoad
Time: 31.51 ms / 37.38 ms Memory: 6.687 MB / 9.19 MB Application: Before Access::preloadComponents (all components)
Time: 1.55 ms / 38.93 ms Memory: 0.105 MB / 9.30 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 38.95 ms Memory: -0.015 MB / 9.28 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.24 ms / 39.19 ms Memory: 0.010 MB / 9.29 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 3.86 ms / 43.05 ms Memory: 0.683 MB / 9.98 MB Application: afterInitialise
Time: 12.73 ms / 55.78 ms Memory: 2.400 MB / 12.38 MB Application: afterRoute
Time: 0.81 ms / 56.58 ms Memory: 0.017 MB / 12.39 MB Application: beforeRenderComponent com_ecwid
Time: 218.31 ms / 274.89 ms Memory: 0.398 MB / 12.79 MB Application: afterRenderComponent com_ecwid
Time: 2.51 ms / 277.40 ms Memory: 0.382 MB / 13.17 MB Application: afterDispatch
Time: 3.46 ms / 280.86 ms Memory: 0.073 MB / 13.25 MB Application: beforeRenderModule mod_cblogin (Member Login)
Time: 28.13 ms / 308.99 ms Memory: 8.192 MB / 21.44 MB Application: afterRenderModule mod_cblogin (Member Login)
Time: 0.06 ms / 309.05 ms Memory: -0.014 MB / 21.42 MB Application: beforeRenderModule mod_custom (Citadel Highlights)
Time: 8.57 ms / 317.62 ms Memory: 2.596 MB / 24.02 MB Application: afterRenderModule mod_custom (Citadel Highlights)
Time: 0.05 ms / 317.67 ms Memory: 0.023 MB / 24.04 MB Application: beforeRenderModule mod_thick_rss (City of Calgary)
Time: 31.06 ms / 348.74 ms Memory: 2.966 MB / 27.01 MB Application: afterRenderModule mod_thick_rss (City of Calgary)
Time: 0.10 ms / 348.84 ms Memory: -0.006 MB / 27.00 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.59 ms / 350.44 ms Memory: 0.016 MB / 27.02 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.10 ms / 350.53 ms Memory: -0.003 MB / 27.02 MB Application: beforeRenderModule mod_custom (Image)
Time: 0.27 ms / 350.80 ms Memory: 0.003 MB / 27.02 MB Application: afterRenderModule mod_custom (Image)
Time: 0.02 ms / 350.82 ms Memory: -0.000 MB / 27.02 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 8.50 ms / 359.32 ms Memory: 1.614 MB / 28.63 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.09 ms / 359.41 ms Memory: 0.001 MB / 28.63 MB Application: beforeRenderModule mod_search (Search)
Time: 0.67 ms / 360.08 ms Memory: 0.012 MB / 28.65 MB Application: afterRenderModule mod_search (Search)
Time: 175.98 ms / 536.06 ms Memory: 1.551 MB / 30.20 MB Application: afterRender

Database queries total: 23.20 ms

Memory Usage

30.57 MB (32,052,288 Bytes)

Database Queries

38 Queries Logged 23.20 ms


  1. Query Time: 0.33 ms Query memory: 0.023 MB Memory before query: 4.487 MB Rows returned: 0
    SELECT `data`
    
      FROM `cca_session`
      WHERE `session_id` = X'3933623435336533343332383936643836653934336564643339653533313633'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 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:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:854
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    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.20 ms After last query: 0.49 ms Query memory: 0.020 MB Memory before query: 4.503 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `cca_session`
      WHERE `session_id` = X'3933623435336533343332383936643836653934336564643339653533313633'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 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.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:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:856
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    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.27 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 4.508 MB
    INSERT INTO `cca_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3933623435336533343332383936643836653934336564643339653533313633', 1, 1653327851, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3933623435336533343332383936643836653934336564643339653533313633', 1, 1653327851, 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:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:856
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    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: 0.96 ms Query memory: 0.046 MB Memory before query: 4.845 MB Rows returned: 66
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `cca_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_extensionsNULLrefextensionextension82const701.00Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.35 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.02 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:225
    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.22 ms After last query: 1.00 ms Query memory: 0.021 MB Memory before query: 5.217 MB Rows returned: 4
    SELECT id, rules
    
      FROM `cca_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_viewlevelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.25 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 5.228 MB Rows returned: 2
    SELECT b.id
    
      FROM cca_usergroups AS a
      LEFT JOIN cca_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.01 ms
    init0.01 ms
    System lock0.01 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.01 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:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 1.08 ms After last query: 0.21 ms Query memory: 0.051 MB Memory before query: 5.250 MB Rows returned: 131
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM cca_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
    1SIMPLEcca_extensionsNULLrefextensionextension82const2450.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.04 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.00 ms
    Creating sort index0.73 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 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:351
    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:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  8. Query Time: 0.58 ms After last query: 4.71 ms Query memory: 0.032 MB Memory before query: 6.892 MB Rows returned: 129
    SELECT `config_key`,`config_value`
    
      FROM cca_osmembership_configs
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_osmembership_configsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL129100.00NULL
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.18 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:39
    10MPFConfig->__construct()JROOT/components/com_osmembership/helper/helper.php:44
    9OSMembershipHelper::getConfig()JROOT/administrator/components/com_osmembership/loader.php:76
    8require_once JROOT/administrator/components/com_osmembership/loader.phpJROOT/plugins/system/membershippro/membershippro.php:43
    7plgSystemMembershipPro->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:695
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 1.32 ms After last query: 13.70 ms Query memory: 0.032 MB Memory before query: 9.207 MB Rows returned: 66
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `cca_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_adsmanager','com_ajax','com_associations','com_autotweet','com_banners','com_booking','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_comprofiler','com_config','com_content','com_contenthistory','com_cpanel','com_digistore','com_djleague','com_ecwid','com_edocman','com_eshop','com_fields','com_finder','com_formmaker','com_formtomail','com_installer','com_jce','com_jevents','com_jgrid','com_joomgallery','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mshahfrontendusermanager','com_osmembership','com_pfcomments','com_pffields','com_pfforum','com_pfmilestones','com_pfprojects','com_pfrepo','com_pftasks','com_pftime','com_pfusers','com_plugins','com_postinstall','com_privacy','com_profiler','com_profiles','com_projectfork','com_redirect','com_search','com_swmenufree','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zweather')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_assetsNULLrangeidx_asset_nameidx_asset_name202NULL67100.00Using index condition
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.26 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.56 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    13Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    12Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    11Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    10Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    9Joomla\CMS\User\User->authorise()JROOT/plugins/system/osmembershipurls/osmembershipurls.php:191
    8plgSystemOSMembershipUrls->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:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.23 ms After last query: 0.45 ms Query memory: 0.021 MB Memory before query: 9.293 MB Rows returned: 0
    SELECT plan_id
    
      FROM cca_osmembership_urls
      WHERE `url` = 'https://citadelca.ab.ca/CCA/index.php/newsletter/link-classified-ad-s'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_osmembership_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 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.00 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/plugins/system/osmembershipurls/osmembershipurls.php:322
    9plgSystemOSMembershipUrls->getRequiredPlanIds()JROOT/plugins/system/osmembershipurls/osmembershipurls.php:209
    8plgSystemOSMembershipUrls->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:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.19 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 9.297 MB Rows returned: 0
    SELECT id
    
      FROM cca_osmembership_plans
      WHERE published = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_osmembership_plansNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL333.33Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.00 ms
    executing0.00 ms
    Sending data0.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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    9JDatabaseDriver->loadColumn()JROOT/plugins/system/osmembershipurls/osmembershipurls.php:217
    8plgSystemOSMembershipUrls->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:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.94 ms After last query: 0.86 ms Query memory: 0.098 MB Memory before query: 9.688 MB Rows returned: 79
    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 cca_menu AS m
      LEFT JOIN cca_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 USEDNULLNULL3314.80Using where; Using filesort
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4citadel4_CCA.m.component_id1100.00Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 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.59 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 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:78
    17Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    16Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    15Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:445
    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:561
    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:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 0.17 ms After last query: 0.86 ms Query memory: 0.020 MB Memory before query: 9.966 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwgears_schedule`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLSelect tables optimized away
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:102
    8plgSystemCwgears->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:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.15 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 9.971 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwgears_schedule`
      WHERE time + '3600'<'1653327851'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.00 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 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:1740
    9JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:145
    8plgSystemCwgears->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:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.46 ms After last query: 2.79 ms Query memory: 0.022 MB Memory before query: 10.733 MB Rows returned: 4
    SELECT id, home, template, s.params
    
      FROM cca_template_styles as s
      LEFT JOIN cca_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,extensionextension82const61.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202citadel4_CCA.e.element166.67Using index condition; Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.09 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 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/Application/SiteApplication.php:486
    9Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/components/com_adsmanager/lib/core.php:76
    8require_once JROOT/components/com_adsmanager/lib/core.phpJROOT/components/com_adsmanager/router.php:13
    7require_once JROOT/components/com_adsmanager/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.38 ms After last query: 0.12 ms Query memory: 0.041 MB Memory before query: 10.738 MB Rows returned: 1
    SELECT * 
      FROM cca_adsmanager_config
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_adsmanager_configNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.11 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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    9JDatabaseDriver->loadObject()JROOT/components/com_adsmanager/lib/core.php:86
    8require_once JROOT/components/com_adsmanager/lib/core.phpJROOT/components/com_adsmanager/router.php:13
    7require_once JROOT/components/com_adsmanager/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.24 ms After last query: 0.24 ms Query memory: 0.026 MB Memory before query: 10.781 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `cca_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 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.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    18JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    17Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    14Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    13Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    12Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/components/com_adsmanager/lib/core.php:119
    8require_once JROOT/components/com_adsmanager/lib/core.phpJROOT/components/com_adsmanager/router.php:13
    7require_once JROOT/components/com_adsmanager/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.007 MB Memory before query: 10.775 MB
    UPDATE `cca_extensions`
    
      SET `params` = '{\"mediaversion\":\"9170e1281098a69dccbc99933cc786b3\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEcca_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.09 ms
    end0.01 ms
    query end0.09 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    13Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    12Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/components/com_adsmanager/lib/core.php:119
    8require_once JROOT/components/com_adsmanager/lib/core.phpJROOT/components/com_adsmanager/router.php:13
    7require_once JROOT/components/com_adsmanager/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.31 ms After last query: 7.05 ms Query memory: 0.020 MB Memory before query: 12.364 MB Rows returned: 0
    SELECT ip
    
      FROM `cca_cwtraffic_knownips`
      WHERE state = 1
      AND count = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLno matching row in const table
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    9JDatabaseDriver->loadColumn()JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:180
    8plgSystemCwtrafficCount->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:1218
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 12.368 MB Rows returned: 0
    SELECT botname
    
      FROM `cca_cwtraffic_knownips`
      WHERE state = 1
      AND count = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLno matching row in const table
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    executing0.00 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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    9JDatabaseDriver->loadColumn()JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:208
    8plgSystemCwtrafficCount->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:1218
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 0.32 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 12.373 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwtraffic`
      WHERE iphash = UNHEX(SHA1('100.24.115.215'))
      AND tm + '3600'>'1653327851'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_cwtrafficNULLrefidx_iphash,idx_iphashtmidx_iphashtm21const5100.00Using where; Using index
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:264
    8plgSystemCwtrafficCount->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:1218
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.30 ms After last query: 0.66 ms Query memory: 0.020 MB Memory before query: 12.381 MB Rows returned: 1
    SELECT *
    
      FROM cca_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_languagesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.07 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
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 1.24 ms After last query: 222.39 ms Query memory: 0.071 MB Memory before query: 13.221 MB Rows returned: 7
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cca_modules AS m
      LEFT JOIN cca_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN cca_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 <= '2022-05-23 17:44:11')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-23 17:44:11')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 736 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLPRIMARY,published,newsfeedsNO INDEX KEY COULD BE USEDNULLNULL871.15Using where; Using filesort
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403citadel4_CCA.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4citadel4_CCA.m.id340.00Using where; Using index
    Profile
    StatusDuration
    starting0.16 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.56 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.04 ms
    cleaning up0.02 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:441
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:91
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1126
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 0.55 ms After last query: 6.26 ms Query memory: 0.028 MB Memory before query: 15.200 MB Rows returned: 1
    SELECT `params`
     
      FROM `cca_comprofiler_plugin`
      WHERE `id` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_comprofiler_pluginNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.05 ms
    cleaning up0.02 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:78
    21CBLib\Core\CBLib::CBLib\Core\{closure}()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:607
    20CBLib\DependencyInjection\Container->build()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
    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:645
    14CBLib\DependencyInjection\Container->build()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
    13CBLib\DependencyInjection\Container->make()JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:134
    12CBLib\DependencyInjection\Container->get()JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
    11include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.phpJROOT/modules/mod_cblogin/mod_cblogin.php:22
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.87 ms After last query: 4.21 ms Query memory: 0.029 MB Memory before query: 16.826 MB Rows returned: 16
    SHOW FULL COLUMNS 
      FROM `cca_users`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cca_users`
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.23 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.02 ms
    checking permissions0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Sending data0.07 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.05 ms
    closing tables0.00 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    21JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:261
    20Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:180
    19Joomla\CMS\Table\Table->__construct()JROOT/libraries/src/Table/User.php:41
    18Joomla\CMS\Table\User->__construct()JROOT/libraries/src/Table/Table.php:328
    17Joomla\CMS\Table\Table::getInstance()JROOT/libraries/src/User/User.php:603
    16Joomla\CMS\User\User::getTable()JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:181
    15CB\Database\Table\UserTable->_reinitNonComprofileVars()JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:121
    14CB\Database\Table\UserTable->__construct()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194
    13CBuser::_getOrSetInstance()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
    12CBuser::getInstance()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:68
    11CBuser::getMyInstance()JROOT/modules/mod_cblogin/mod_cblogin.php:68
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 1.44 ms After last query: 1.38 ms Query memory: 0.038 MB Memory before query: 17.278 MB Rows returned: 23
    SELECT f.* 
      FROM cca_comprofiler_fields f
      INNER JOIN cca_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
    1SIMPLEfNULLreftabid_pub_prof_order,published_orderingpublished_ordering1const22100.00Using where; Using temporary; Using filesort
    1SIMPLEtNULLeq_refPRIMARYPRIMARY4citadel4_CCA.f.tabid1100.00NULL
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.03 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.39 ms
    Creating sort index0.37 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.05 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.05 ms
    cleaning up0.02 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:1037
    16cbTabs->_getTabFieldsDb()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
    15CBuser->getField()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1123
    14CBuser->{closure}()Same as call in the line below.
    13preg_replace_callback()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1174
    12CBuser->evaluateFields()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:650
    11CBuser->replaceUserVars()JROOT/modules/mod_cblogin/mod_cblogin.php:133
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  27. Query Time: 0.52 ms After last query: 0.41 ms Query memory: 0.027 MB Memory before query: 17.386 MB Rows returned: 6
    SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
     
      FROM `cca_comprofiler_plugin`
      WHERE `published` = 1
      AND `viewaccesslevel` IN (1,5)
      AND `type` = 'user'
      ORDER BY `ordering`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_comprofiler_pluginNULLreftype_pub_order,idx_folder,published_orderingtype_pub_order304const,const522.22Using index condition; Using where
    Profile
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.07 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
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    20JDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
    19CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
    18CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
    17cbPluginHandler->loadPluginGroup()JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1083
    16cbTabs->_getTabFieldsDb()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
    15CBuser->getField()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1123
    14CBuser->{closure}()Same as call in the line below.
    13preg_replace_callback()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1174
    12CBuser->evaluateFields()JROOT/libraries/CBLib/CB/Legacy/CBuser.php:650
    11CBuser->replaceUserVars()JROOT/modules/mod_cblogin/mod_cblogin.php:133
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 1.16 ms After last query: 5.26 ms Query memory: 0.023 MB Memory before query: 20.219 MB Rows returned: 1
    SELECT `id`
     
      FROM `cca_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-GB', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1600.54Using index condition; Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.61 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.02 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:995
    12CBframework->viewUrl()JROOT/libraries/CBLib/CB/Legacy/CBframework.php:854
    11CBframework->userProfileUrl()JROOT/modules/mod_cblogin/mod_cblogin.php:207
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 1.02 ms After last query: 3.11 ms Query memory: 0.023 MB Memory before query: 20.260 MB Rows returned: 1
    SELECT `id`
     
      FROM `cca_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-GB', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1600.42Using index condition; Using where
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.48 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.03 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:995
    12CBframework->viewUrl()JROOT/modules/mod_cblogin/tmpl/bootstrap.php:15
    11require JROOT/modules/mod_cblogin/tmpl/bootstrap.phpJROOT/modules/mod_cblogin/mod_cblogin.php:232
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.86 ms After last query: 0.79 ms Query memory: 0.023 MB Memory before query: 21.435 MB Rows returned: 1
    SELECT `id`
     
      FROM `cca_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-GB', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1600.42Using index condition; Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.45 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.02 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:995
    12CBframework->viewUrl()JROOT/modules/mod_cblogin/tmpl/bootstrap.php:154
    11require JROOT/modules/mod_cblogin/tmpl/bootstrap.phpJROOT/modules/mod_cblogin/mod_cblogin.php:232
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.73 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 21.444 MB Rows returned: 1
    SELECT `id`
     
      FROM `cca_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-GB', '*', '' )
      AND `client_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_menuNULLrefidx_client_id_parent_id_alias_language,idx_languageidx_client_id_parent_id_alias_language1const1600.42Using index condition; Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.41 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 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:995
    12CBframework->viewUrl()JROOT/modules/mod_cblogin/tmpl/bootstrap.php:168
    11require JROOT/modules/mod_cblogin/tmpl/bootstrap.phpJROOT/modules/mod_cblogin/mod_cblogin.php:232
    10include JROOT/modules/mod_cblogin/mod_cblogin.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 1.16 ms After last query: 7.20 ms Query memory: 0.027 MB Memory before query: 24.026 MB Rows returned: 0
    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM cca_fields AS a
      LEFT JOIN `cca_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN cca_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN cca_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN cca_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN cca_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'mod_custom.content'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using index condition; Using where; Using temporary; Using filesort
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28citadel4_CCA.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.group_id1100.00Using where
    Profile
    StatusDuration
    starting0.16 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.04 ms
    statistics0.14 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.20 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.05 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/MVC/Model/BaseDatabaseModel.php:322
    21Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    20FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    19Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    18FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    17PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    16JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    15JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    14JHtmlContent::prepare()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    12Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    11Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_custom/mod_custom.php:15
    10include JROOT/modules/mod_custom/mod_custom.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.29 ms After last query: 43.59 ms Query memory: 0.023 MB Memory before query: 28.655 MB Rows returned: 0
    SELECT uikit
    
      FROM `cca_cwgears`
      WHERE url = 'https://www.citadelca.ab.ca/CCA/index.php/newsletter/link-classified-ad-s'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLno matching row in const table
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 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:1740
    14JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13CwGearsHelperLoadcount::getCounts()JROOT/plugins/system/cwgears/cwgears.php:337
    12plgSystemCwgears->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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 0.12 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 28.663 MB Rows returned: 0
    SELECT uikit_plus
    
      FROM `cca_cwgears`
      WHERE url = 'https://www.citadelca.ab.ca/CCA/index.php/newsletter/link-classified-ad-s'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLno matching row in const table
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.00 ms
    executing0.00 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    14JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13CwGearsHelperLoadcount::getCounts()JROOT/plugins/system/cwgears/cwgears.php:346
    12plgSystemCwgears->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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  35. Query Time: 3.03 ms After last query: 5.72 ms Query memory: 0.038 MB Memory before query: 30.052 MB Rows returned: 483
    SHOW TABLES
    Explain
    EXPLAIN not possible on query: SHOW TABLES
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.01 ms
    checking permissions2.30 ms
    Sending data0.18 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.00 ms
    freeing items0.06 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    15JDatabaseDriver->loadColumn()JROOT/libraries/joomla/database/driver/mysqli.php:505
    14JDatabaseDriverMysqli->getTableList()JROOT/libraries/fof/database/driver/joomla.php:252
    13FOFDatabaseDriverJoomla->getTableList()JROOT/libraries/fof/table/table.php:2085
    12FOFTable->getTableFields()JROOT/libraries/fof/table/table.php:536
    11FOFTable->__construct()JROOT/administrator/components/com_autotweet/tables/automator.php:33
    10AutotweetTableAutomator->__construct()JROOT/libraries/fof/table/table.php:433
    9FOFTable::getAnInstance()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:106
    8PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
    7PlgSystemAutotweetAutomator->onAfterRender()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:1146
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  36. Query Time: 0.53 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 30.101 MB Rows returned: 3
    SHOW FULL COLUMNS 
      FROM `cca_autotweet_automator`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cca_autotweet_automator`
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.19 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.02 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.03 ms
    closing tables0.00 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    14JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/fof/database/driver/joomla.php:230
    13FOFDatabaseDriverJoomla->getTableColumns()JROOT/libraries/fof/table/table.php:2170
    12FOFTable->getTableFields()JROOT/libraries/fof/table/table.php:536
    11FOFTable->__construct()JROOT/administrator/components/com_autotweet/tables/automator.php:33
    10AutotweetTableAutomator->__construct()JROOT/libraries/fof/table/table.php:433
    9FOFTable::getAnInstance()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:106
    8PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
    7PlgSystemAutotweetAutomator->onAfterRender()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:1146
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  37. Query Time: 0.29 ms After last query: 0.66 ms Query memory: 0.021 MB Memory before query: 30.132 MB Rows returned: 1
    SELECT cca_autotweet_automator.*
    
      FROM cca_autotweet_automator
      WHERE `cca_autotweet_automator`.`plugin` = 'automator'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_autotweet_automatorNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL250.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 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:1465
    11JDatabaseDriver->loadAssoc()JROOT/libraries/fof/database/driver/joomla.php:292
    10FOFDatabaseDriverJoomla->loadAssoc()JROOT/libraries/fof/table/table.php:949
    9FOFTable->load()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:112
    8PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
    7PlgSystemAutotweetAutomator->onAfterRender()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:1146
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  38. Query Time: 0.26 ms After last query: 0.21 ms Query memory: 0.022 MB Memory before query: 30.138 MB Rows returned: 1
    SELECT cca_autotweet_automator.*
    
      FROM cca_autotweet_automator
      WHERE `cca_autotweet_automator`.`plugin` = 'content'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_autotweet_automatorNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL250.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 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
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    12JDatabaseDriver->loadAssoc()JROOT/libraries/fof/database/driver/joomla.php:292
    11FOFDatabaseDriverJoomla->loadAssoc()JROOT/libraries/fof/table/table.php:949
    10FOFTable->load()JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:521
    9PlgAutotweetBase->executeContentPolling()JROOT/plugins/system/autotweetcontent/autotweetcontent.php:137
    8PlgSystemAutotweetContent->onContentPolling()JROOT/plugins/system/autotweetcontent/autotweetcontent.php:472
    7PlgSystemAutotweetContent->onAfterRender()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:1146
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT `id`  
      FROM `cca_menu`
  2. 2 × SELECT cca_autotweet_automator.* 
      FROM cca_autotweet_automator
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `cca_extensions`
  4. 1 × SELECT ip 
      FROM `cca_cwtraffic_knownips`
  5. 1 × SELECT uikit_plus 
      FROM `cca_cwgears`
  6. 1 × SELECT uikit 
      FROM `cca_cwgears`
  7. 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM cca_fields AS a
      LEFT JOIN `cca_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN cca_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN cca_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN cca_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN cca_fields_groups AS g
      ON g.id = a.group_id
  8. 1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
      FROM `cca_comprofiler_plugin`
  9. 1 × SELECT f.* 
      FROM cca_comprofiler_fields f
      INNER JOIN cca_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
  10. 1 × SELECT `params`  
      FROM `cca_comprofiler_plugin`
  11. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM cca_modules AS m
      LEFT JOIN cca_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN cca_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  12. 1 × SELECT * 
      FROM cca_languages
  13. 1 × SELECT count(*) 
      FROM `cca_cwtraffic`
  14. 1 × SELECT botname 
      FROM `cca_cwtraffic_knownips`
  15. 1 × SELECT `data` 
      FROM `cca_session`
  16. 1 × SELECT `session_id` 
      FROM `cca_session`
  17. 1 × SELECT id, home, template, s.params 
      FROM cca_template_styles as s
      LEFT JOIN cca_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  18. 1 × SELECT count(*) 
      FROM `cca_cwgears_schedule`
  19. 1 × SELECT count(*) 
      FROM `cca_cwgears_schedule
  20. 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 cca_menu AS m
      LEFT JOIN cca_extensions AS e
      ON m.component_id = e.extension_id
  21. 1 × SELECT id 
      FROM cca_osmembership_plans
  22. 1 × SELECT plan_id 
      FROM cca_osmembership_urls
  23. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `cca_assets`
  24. 1 × SELECT `config_key`,`config_value` 
      FROM cca_osmembership_config
  25. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM cca_extensions
  26. 1 × SELECT b.id 
      FROM cca_usergroups AS a
      LEFT JOIN cca_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  27. 1 × SELECT id, rules 
      FROM `cca_viewlevels
  28. 1 × SELECT * 
      FROM cca_adsmanager_confi
OTHER Tables:
  1. 1 × INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3933623435336533343332383936643836653934336564643339653533313633', 1, 1653327851, 0, '', 0
  2. 1 × UPDATE `cca_extensions` 
      SET `params` = '{\"mediaversion\":\"9170e1281098a69dccbc99933cc786b3\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `cca_users
  4. 1 × SHOW TABLE
  5. 1 × SHOW FULL COLUMNS 
      FROM `cca_autotweet_automator