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

Upcoming Events

Filters
List of articles in category Upcoming Events
Title Author Hits
Bottle Drive Jan 29 2022 Written by Stephanie Christensen Hits: 76
CCA Fitness & Yoga - Jan 2022 Written by Stephanie Christensen Hits: 115
Movie in the Park 2021 Written by Stephanie Christensen Hits: 456
CCA Book Sale Aug 13-14, 2021 Written by Stephanie Christensen Hits: 264
CCA Fitness & Yoga Jan - Mar 2022 Written by Stephanie Christensen Hits: 504
Citadel Cleanup June 27 2021 Written by Stephanie Christensen Hits: 923
2015 - Parade of Garage Sales Written by CCA Web Director Hits: 8794
  • You are here:  
  • Home
  • Events
  • CCA Events

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

  • Current Conditions: Partly Cloudy, 16.3°C
  • Sunday: Periods of rain. High 11.
  • Saturday night: Periods of rain. Low 7.
  • Saturday: Periods of rain. High 14.
  • Friday night: Chance of showers. Low 9. POP 60%
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": 1653331338,
                "last": 1653331338,
                "now": 1653331338
            },
            "token": "ugEMX8CaZ57neOcWZGCeXrRoIlVabtn9"
        },
        "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.70 ms / 5.70 ms Memory: 2.136 MB / 2.51 MB Application: afterLoad
Time: 30.97 ms / 36.67 ms Memory: 6.687 MB / 9.19 MB Application: Before Access::preloadComponents (all components)
Time: 1.49 ms / 38.16 ms Memory: 0.105 MB / 9.30 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 38.19 ms Memory: -0.015 MB / 9.28 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.23 ms / 38.42 ms Memory: 0.010 MB / 9.29 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 3.96 ms / 42.38 ms Memory: 0.683 MB / 9.98 MB Application: afterInitialise
Time: 12.62 ms / 55.00 ms Memory: 2.400 MB / 12.38 MB Application: afterRoute
Time: 0.90 ms / 55.90 ms Memory: 0.029 MB / 12.41 MB Application: beforeRenderComponent com_content
Time: 1.48 ms / 57.39 ms Memory: 0.432 MB / 12.84 MB Application: Before Access::preloadPermissions (com_content)
Time: 1.60 ms / 58.98 ms Memory: 0.152 MB / 12.99 MB Application: After Access::preloadPermissions (com_content)
Time: 0.03 ms / 59.01 ms Memory: -0.011 MB / 12.98 MB Application: Before Access::getAssetRules (id:438 name:com_content.category.20)
Time: 0.04 ms / 59.05 ms Memory: 0.007 MB / 12.99 MB Application: After Access::getAssetRules (id:438 name:com_content.category.20)
Time: 2.42 ms / 61.47 ms Memory: 0.046 MB / 13.03 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.04 ms / 61.51 ms Memory: 0.007 MB / 13.04 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 28.40 ms / 89.91 ms Memory: 4.910 MB / 17.95 MB Application: afterRenderComponent com_content
Time: 0.58 ms / 90.48 ms Memory: 0.005 MB / 17.95 MB Application: afterDispatch
Time: 2.92 ms / 93.40 ms Memory: 0.076 MB / 18.03 MB Application: beforeRenderModule mod_cblogin (Member Login)
Time: 22.96 ms / 116.36 ms Memory: 7.257 MB / 25.29 MB Application: afterRenderModule mod_cblogin (Member Login)
Time: 0.05 ms / 116.41 ms Memory: -0.014 MB / 25.27 MB Application: beforeRenderModule mod_custom (Citadel Highlights)
Time: 1.62 ms / 118.02 ms Memory: 0.017 MB / 25.29 MB Application: afterRenderModule mod_custom (Citadel Highlights)
Time: 0.04 ms / 118.06 ms Memory: 0.023 MB / 25.31 MB Application: beforeRenderModule mod_thick_rss (City of Calgary)
Time: 31.83 ms / 149.89 ms Memory: 2.962 MB / 28.27 MB Application: afterRenderModule mod_thick_rss (City of Calgary)
Time: 0.09 ms / 149.98 ms Memory: -0.006 MB / 28.27 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.87 ms / 150.85 ms Memory: 0.013 MB / 28.28 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.08 ms / 150.93 ms Memory: -0.003 MB / 28.28 MB Application: beforeRenderModule mod_custom (Image)
Time: 0.28 ms / 151.21 ms Memory: 0.003 MB / 28.28 MB Application: afterRenderModule mod_custom (Image)
Time: 0.03 ms / 151.23 ms Memory: 0.002 MB / 28.28 MB Application: beforeRenderModule mod_bgmax (BgMax)
Time: 0.50 ms / 151.74 ms Memory: 0.026 MB / 28.31 MB Application: afterRenderModule mod_bgmax (BgMax)
Time: 0.03 ms / 151.77 ms Memory: -0.008 MB / 28.30 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 8.30 ms / 160.07 ms Memory: 2.857 MB / 31.16 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.09 ms / 160.15 ms Memory: 0.001 MB / 31.16 MB Application: beforeRenderModule mod_search (Search)
Time: 0.63 ms / 160.79 ms Memory: 0.012 MB / 31.17 MB Application: afterRenderModule mod_search (Search)
Time: 175.37 ms / 336.16 ms Memory: 1.566 MB / 32.74 MB Application: afterRender

Database queries total: 34.05 ms

Memory Usage

33.35 MB (34,970,016 Bytes)

Database Queries

55 Queries Logged 34.05 ms


  1. Query Time: 0.32 ms Query memory: 0.023 MB Memory before query: 4.487 MB Rows returned: 0
    SELECT `data`
    
      FROM `cca_session`
      WHERE `session_id` = X'6265666464643034333335336464653264363536343439613332643038396165'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 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.19 ms After last query: 0.48 ms Query memory: 0.020 MB Memory before query: 4.502 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `cca_session`
      WHERE `session_id` = X'6265666464643034333335336464653264363536343439613332643038396165'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 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.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.34 ms After last query: 0.07 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'6265666464643034333335336464653264363536343439613332643038396165', 1, 1653331338, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6265666464643034333335336464653264363536343439613332643038396165', 1, 1653331338, 0, '', 0)
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.12 ms
    end0.00 ms
    query end0.07 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.63 ms After last query: 0.95 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.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.30 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
    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.24 ms After last query: 1.01 ms Query memory: 0.021 MB Memory before query: 5.216 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.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 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.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.30 ms After last query: 0.10 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.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 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: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.11 ms After last query: 0.22 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.01 ms
    Creating sort index0.75 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.59 ms After last query: 4.07 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.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.27 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/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.26 ms After last query: 13.40 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.09 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.21 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.54 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
    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.22 ms After last query: 0.46 ms Query memory: 0.021 MB Memory before query: 9.292 MB Rows returned: 0
    SELECT plan_id
    
      FROM cca_osmembership_urls
      WHERE `url` = 'https://citadelca.ab.ca/CCA/index.php/events/upcoming-events'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_osmembership_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    Profile
    StatusDuration
    starting0.03 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.01 ms
    closing tables0.01 ms
    freeing items0.03 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.22 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.01 ms
    executing0.00 ms
    Sending data0.06 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: 1.00 ms After last query: 0.87 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.07 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.62 ms
    end0.01 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.84 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.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 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.16 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'<'1653331338'
    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.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 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.52 ms After last query: 2.74 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.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.02 ms
    Sending data0.11 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
    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.37 ms After last query: 0.13 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.03 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.09 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.04 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.29 ms After last query: 0.25 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.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 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.32 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 10.775 MB
    UPDATE `cca_extensions`
    
      SET `params` = '{\"mediaversion\":\"c26764436377fc202d5206f614dc63f9\"}'
      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.07 ms
    end0.01 ms
    query end0.06 ms
    closing tables0.01 ms
    freeing items0.02 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.27 ms After last query: 6.91 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.06 ms
    checking permissions0.01 ms
    Opening tables0.02 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.03 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.14 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.01 ms
    statistics0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 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: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.34 ms After last query: 0.05 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'>'1653331338'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_cwtrafficNULLrefidx_iphash,idx_iphashtmidx_iphashtm21const7100.00Using where; Using index
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.11 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.02 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
    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.31 ms After last query: 0.75 ms Query memory: 0.020 MB Memory before query: 12.391 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.01 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.08 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
    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.33 ms After last query: 1.87 ms Query memory: 0.039 MB Memory before query: 12.839 MB Rows returned: 158
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `cca_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_assetsNULLALLidx_asset_name,idx_parent_idNO INDEX KEY COULD BE USEDNULLNULL216021.07Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.97 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  24. Query Time: 1.14 ms After last query: 0.91 ms Query memory: 0.025 MB Memory before query: 12.999 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `cca_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `cca_categories` AS `s`
      INNER JOIN `cca_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id = 20
      ORDER BY c.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using filesort
    1PRIMARYcNULLALLcat_idx,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL2525.60Using where
    2DEPENDENT SUBQUERYiNULLrefidx_state,idx_catididx_catid4citadel4_CCA.c.id18100.00Using index condition; Using where
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.30 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.02 ms
    Sorting result0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.09 ms
    executing0.00 ms
    Sending data0.03 ms
    executing0.00 ms
    Sending data0.11 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 2.70 ms After last query: 0.73 ms Query memory: 0.080 MB Memory before query: 13.038 MB Rows returned: 7
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM cca_content AS a
      LEFT JOIN cca_categories AS c
      ON c.id = a.catid
      LEFT JOIN cca_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN cca_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN cca_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN cca_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 20
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-23 18:42:18')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-23 18:42:18')
      ORDER BY
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 10
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00Using temporary; Using filesort
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const1316.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.modified_by1100.00Using where
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00Using where
    1SIMPLEvNULLALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using join buffer (Block Nested Loop)
    Profile
    StatusDuration
    starting0.18 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.22 ms
    init0.09 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.04 ms
    Creating tmp table0.09 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data1.51 ms
    Creating sort index0.15 ms
    end0.00 ms
    query end0.02 ms
    removing tmp table0.09 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  26. Query Time: 0.73 ms After last query: 0.66 ms Query memory: 0.024 MB Memory before query: 13.481 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 142
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.23 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.03 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [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.20 ms Query memory: 0.024 MB Memory before query: 13.498 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 140
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.13 ms
    preparing0.04 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  28. Query Time: 0.39 ms After last query: 0.18 ms Query memory: 0.024 MB Memory before query: 13.516 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 126
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  29. Query Time: 0.42 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 13.533 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 125
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  30. Query Time: 0.38 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 13.551 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 122
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  31. Query Time: 0.28 ms After last query: 0.13 ms Query memory: 0.024 MB Memory before query: 13.568 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 113
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  32. Query Time: 0.23 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 13.583 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 47
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  33. Query Time: 0.57 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 13.608 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM cca_content AS a
      LEFT JOIN cca_categories AS c
      ON c.id = a.catid
      LEFT JOIN cca_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN cca_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN cca_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN cca_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 20
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-23 18:42:18')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-23 18:42:18')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00NULL
    1SIMPLEaNULLrefidx_access,idx_state,idx_catididx_catid4const1316.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.created_by1100.00Using where; Using index
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.modified_by1100.00Using where; Using index
    1SIMPLEparentNULLconstPRIMARYPRIMARY4const1100.00Using where; Using index
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.id1100.00Using where; Using index
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.11 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.12 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  34. Query Time: 0.28 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 13.612 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 20
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4citadel4_CCA.m.tag_id1100.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  35. Query Time: 0.71 ms After last query: 5.35 ms Query memory: 0.026 MB Memory before query: 16.551 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `cca_categories` AS `s`
      INNER JOIN `cca_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 20
      ORDER BY c.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using filesort
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL2532.00Using where
    Profile
    StatusDuration
    starting0.14 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.13 ms
    preparing0.02 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.11 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
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  36. Query Time: 1.10 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 16.567 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
      LEFT JOIN `cca_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.article'
      AND (fc.category_id IS NULL OR fc.category_id IN (20,0))
      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
    1SIMPLEfcNULLrefPRIMARYPRIMARY4citadel4_CCA.a.id1100.00Using where; Using index; Distinct
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.31 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.02 ms
    Creating tmp table0.05 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.19 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.06 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  37. Query Time: 1.00 ms After last query: 7.17 ms Query memory: 0.028 MB Memory before query: 17.922 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 = 'com_content.categories'
      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.17 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.03 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.02 ms
    Creating tmp table0.07 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.22 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.04 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    25JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    24Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    23FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    22Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    21FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    20PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    19JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    18JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:25
    17include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    16Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    15Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    14include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  38. Query Time: 0.72 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 17.937 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
      LEFT JOIN `cca_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.categories'
      AND (fc.category_id IS NULL OR fc.category_id IN (20,0))
      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
    1SIMPLEfcNULLrefPRIMARYPRIMARY4citadel4_CCA.a.id1100.00Using where; Using index; Distinct
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.11 ms
    preparing0.02 ms
    Creating tmp table0.04 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.16 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    26JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    25Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    24FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    23Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    22FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    21PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:324
    20PlgSystemFields->onContentAfterTitle()JROOT/libraries/joomla/event/event.php:70
    19JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    18JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:28
    17include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    16Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    15Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    14include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  39. Query Time: 0.63 ms After last query: 0.34 ms Query memory: 0.029 MB Memory before query: 17.952 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 = 'com_content.category.title'
      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.08 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.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    Creating tmp table0.03 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.15 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    30JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    29JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    28Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    27FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    26Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    25FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    24PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    23JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    22JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    21JHtmlContent::prepare()Same as call in the line below.
    20call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    19Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    18Joomla\CMS\HTML\HTMLHelper::_()JROOT/layouts/joomla/content/category_default.php:57
    17include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    16Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    15Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    14include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  40. Query Time: 1.14 ms After last query: 4.14 ms Query memory: 0.071 MB Memory before query: 18.001 MB Rows returned: 8
    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 18:42:18')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-23 18:42:18')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 298 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.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.17 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.02 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.57 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php: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.]

  41. Query Time: 0.41 ms After last query: 5.82 ms Query memory: 0.028 MB Memory before query: 19.476 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.03 ms
    checking permissions0.00 ms
    Opening tables0.16 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    27JDatabaseDriver->loadResult()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
    26CBLib\Database\Driver\CmsDatabaseDriver->loadResult()JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
    25CB\Application\CBConfig::getConfig()JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
    24CB\Application\CBApplication::CB\Application\{closure}()Same as call in the line below.
    23call_user_func_array()JROOT/libraries/CBLib/CBLib/Application/Config.php:38
    22CBLib\Application\Config::setMainConfig()JROOT/libraries/CBLib/CBLib/Core/CBLib.php: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.]

  42. Query Time: 0.66 ms After last query: 3.86 ms Query memory: 0.029 MB Memory before query: 22.079 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.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.18 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.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Sending data0.06 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.04 ms
    closing tables0.00 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/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.]

  43. Query Time: 1.12 ms After last query: 0.90 ms Query memory: 0.038 MB Memory before query: 22.120 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.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.26 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    Creating tmp table0.05 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.25 ms
    Creating sort index0.19 ms
    end0.00 ms
    query end0.00 ms
    removing tmp table0.03 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    19JDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
    18CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
    17CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()JROOT/libraries/CBLib/CB/Legacy/cbTabs.php: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.]

  44. Query Time: 0.37 ms After last query: 0.34 ms Query memory: 0.027 MB Memory before query: 22.228 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.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.06 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
    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.]

  45. Query Time: 0.93 ms After last query: 4.78 ms Query memory: 0.023 MB Memory before query: 25.240 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.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.52 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: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.]

  46. Query Time: 0.67 ms After last query: 1.77 ms Query memory: 0.023 MB Memory before query: 25.272 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.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.39 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
    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.]

  47. Query Time: 0.64 ms After last query: 0.52 ms Query memory: 0.023 MB Memory before query: 25.283 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.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.38 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
    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.]

  48. Query Time: 0.55 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 25.292 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.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.32 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
    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.]

  49. Query Time: 0.85 ms After last query: 0.76 ms Query memory: 0.026 MB Memory before query: 25.297 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.11 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.03 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    Creating tmp table0.07 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.18 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.04 ms
    query end0.00 ms
    closing tables0.01 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/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:111
    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.]

  50. Query Time: 0.51 ms After last query: 43.52 ms Query memory: 0.022 MB Memory before query: 31.173 MB Rows returned: 0
    SELECT uikit
    
      FROM `cca_cwgears`
      WHERE url = 'https://www.citadelca.ab.ca/CCA/index.php/events/upcoming-events'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLno matching row in const table
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.18 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.02 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.]

  51. Query Time: 0.12 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 31.180 MB Rows returned: 0
    SELECT uikit_plus
    
      FROM `cca_cwgears`
      WHERE url = 'https://www.citadelca.ab.ca/CCA/index.php/events/upcoming-events'
    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
    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.]

  52. Query Time: 2.69 ms After last query: 5.21 ms Query memory: 0.038 MB Memory before query: 32.566 MB Rows returned: 483
    SHOW TABLES
    Explain
    EXPLAIN not possible on query: SHOW TABLES
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.06 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    checking permissions2.06 ms
    Sending data0.12 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.02 ms
    closing tables0.00 ms
    freeing items0.04 ms
    cleaning up0.01 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.]

  53. Query Time: 0.59 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 32.616 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.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.18 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.09 ms
    checking permissions0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.04 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.]

  54. Query Time: 0.23 ms After last query: 0.68 ms Query memory: 0.021 MB Memory before query: 32.666 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.03 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.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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.]

  55. Query Time: 0.15 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 32.672 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.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.00 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
    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.]

39 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 8 × SELECT `m`.`tag_id`,`t`.* 
      FROM `cca_contentitem_tag_map` AS m
      INNER JOIN `cca_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 4 × SELECT `id`  
      FROM `cca_menu`
  3. 3 × 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
  4. 2 × SELECT cca_autotweet_automator.* 
      FROM cca_autotweet_automator
  5. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `cca_extensions`
  6. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `cca_assets`
  7. 2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM 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
      LEFT JOIN `cca_fields_categories` AS fc
      ON fc.field_id = a.id
  8. 1 × SELECT COUNT(*) 
      FROM cca_content AS a
      LEFT JOIN cca_categories AS c
      ON c.id = a.catid
      LEFT JOIN cca_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN cca_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN cca_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN cca_content_rating AS v
      ON a.id = v.content_id
  9. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `cca_categories` AS `s`
      INNER JOIN `cca_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  10. 1 × SELECT f.* 
      FROM cca_comprofiler_fields f
      INNER JOIN cca_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
  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 `params`  
      FROM `cca_comprofiler_plugin`
  13. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `cca_content` AS `i`
  14. 1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
      FROM `cca_comprofiler_plugin`
  15. 1 × SELECT uikit 
      FROM `cca_cwgears`
  16. 1 × SELECT uikit_plus 
      FROM `cca_cwgears`
  17. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM cca_content AS a
      LEFT JOIN cca_categories AS c
      ON c.id = a.catid
      LEFT JOIN cca_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN cca_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN cca_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN cca_content_rating AS v
      ON a.id = v.content_id
  18. 1 × SELECT `data` 
      FROM `cca_session`
  19. 1 × SELECT * 
      FROM cca_languages
  20. 1 × SELECT `session_id` 
      FROM `cca_session`
  21. 1 × SELECT botname 
      FROM `cca_cwtraffic_knownips`
  22. 1 × SELECT ip 
      FROM `cca_cwtraffic_knownips`
  23. 1 × SELECT * 
      FROM cca_adsmanager_confi
  24. 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
  25. 1 × SELECT count(*) 
      FROM `cca_cwgears_schedule`
  26. 1 × SELECT count(*) 
      FROM `cca_cwgears_schedule
  27. 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
  28. 1 × SELECT id 
      FROM cca_osmembership_plans
  29. 1 × SELECT plan_id 
      FROM cca_osmembership_urls
  30. 1 × SELECT `config_key`,`config_value` 
      FROM cca_osmembership_config
  31. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM cca_extensions
  32. 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
  33. 1 × SELECT id, rules 
      FROM `cca_viewlevels
  34. 1 × SELECT count(*) 
      FROM `cca_cwtraffic`
OTHER Tables:
  1. 1 × INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6265666464643034333335336464653264363536343439613332643038396165', 1, 1653331338, 0, '', 0
  2. 1 × UPDATE `cca_extensions` 
      SET `params` = '{\"mediaversion\":\"c26764436377fc202d5206f614dc63f9\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `cca_users
  4. 1 × SHOW TABLE
  5. 1 × SHOW FULL COLUMNS 
      FROM `cca_autotweet_automator