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
Fitness
Fitness
Yoga
Yoga
  • You are here:  
  • Home
  • Store

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": 1653330637,
                "last": 1653330637,
                "now": 1653330637
            },
            "token": "G0jmGBJxWPOx5LVJ557VhHfxH1VHN8FS"
        },
        "registry": {
            "limit": "15"
        },
        "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
        },
        "continue_shopping_url": "https://www.citadelca.ab.ca/CCA/index.php/store"
    }
}

Profile Information

Time

Memory

Time: 5.89 ms / 5.89 ms Memory: 2.136 MB / 2.51 MB Application: afterLoad
Time: 39.44 ms / 45.33 ms Memory: 6.687 MB / 9.19 MB Application: Before Access::preloadComponents (all components)
Time: 1.64 ms / 46.97 ms Memory: 0.105 MB / 9.30 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 47.00 ms Memory: -0.015 MB / 9.28 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.28 ms / 47.28 ms Memory: 0.010 MB / 9.29 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 4.39 ms / 51.67 ms Memory: 0.683 MB / 9.98 MB Application: afterInitialise
Time: 12.87 ms / 64.54 ms Memory: 2.400 MB / 12.38 MB Application: afterRoute
Time: 0.79 ms / 65.32 ms Memory: 0.015 MB / 12.39 MB Application: beforeRenderComponent com_eshop
Time: 15.26 ms / 80.59 ms Memory: 1.763 MB / 14.15 MB Application: afterRenderComponent com_eshop
Time: 0.92 ms / 81.51 ms Memory: 0.671 MB / 14.83 MB Application: afterDispatch
Time: 2.71 ms / 84.22 ms Memory: 0.074 MB / 14.90 MB Application: beforeRenderModule mod_cblogin (Member Login)
Time: 22.01 ms / 106.23 ms Memory: 7.771 MB / 22.67 MB Application: afterRenderModule mod_cblogin (Member Login)
Time: 0.05 ms / 106.28 ms Memory: -0.014 MB / 22.66 MB Application: beforeRenderModule mod_custom (Citadel Highlights)
Time: 6.83 ms / 113.11 ms Memory: 2.603 MB / 25.26 MB Application: afterRenderModule mod_custom (Citadel Highlights)
Time: 0.06 ms / 113.17 ms Memory: 0.023 MB / 25.28 MB Application: beforeRenderModule mod_thick_rss (City of Calgary)
Time: 29.29 ms / 142.46 ms Memory: 2.966 MB / 28.25 MB Application: afterRenderModule mod_thick_rss (City of Calgary)
Time: 0.08 ms / 142.55 ms Memory: -0.006 MB / 28.24 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.13 ms / 143.68 ms Memory: 0.014 MB / 28.25 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.07 ms / 143.75 ms Memory: -0.002 MB / 28.25 MB Application: beforeRenderModule mod_custom (Image)
Time: 0.22 ms / 143.97 ms Memory: 0.003 MB / 28.26 MB Application: afterRenderModule mod_custom (Image)
Time: 0.02 ms / 143.99 ms Memory: -0.000 MB / 28.26 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 7.55 ms / 151.54 ms Memory: 1.589 MB / 29.84 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.08 ms / 151.62 ms Memory: 0.001 MB / 29.85 MB Application: beforeRenderModule mod_search (Search)
Time: 0.77 ms / 152.39 ms Memory: 0.013 MB / 29.86 MB Application: afterRenderModule mod_search (Search)
Time: 189.36 ms / 341.75 ms Memory: 1.545 MB / 31.40 MB Application: afterRender

Database queries total: 27.54 ms

Memory Usage

31.92 MB (33,467,520 Bytes)

Database Queries

52 Queries Logged 27.54 ms


4 duplicate found!

4 duplicates: #29  #30  #33  #34
  1. Query Time: 0.28 ms Query memory: 0.023 MB Memory before query: 4.487 MB Rows returned: 0
    SELECT `data`
    
      FROM `cca_session`
      WHERE `session_id` = X'6230306237373433363536663865396336366165376665356661316436386663'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php: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.54 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'6230306237373433363536663865396336366165376665356661316436386663'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php: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.29 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 4.507 MB
    INSERT INTO `cca_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6230306237373433363536663865396336366165376665356661316436386663', 1, 1653330637, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6230306237373433363536663865396336366165376665356661316436386663', 1, 1653330637, 0, '', 0)
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.09 ms
    end0.00 ms
    query end0.05 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.59 ms After last query: 1.03 ms Query memory: 0.046 MB Memory before query: 4.844 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.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.30 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php: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.33 ms After last query: 1.45 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.04 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.05 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: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.31 ms After last query: 0.13 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.01 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.31 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.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.00 ms
    Creating sort index0.72 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
    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.49 ms After last query: 5.20 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.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.00 ms
    executing0.00 ms
    Sending data0.16 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/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.34 ms After last query: 19.93 ms Query memory: 0.032 MB Memory before query: 9.206 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.15 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.25 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.54 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    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.33 ms After last query: 0.51 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/store'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_osmembership_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.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.31 ms After last query: 0.10 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.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.06 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.03 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/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.95 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.09 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.58 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.03 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.21 ms After last query: 0.88 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.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:102
    8plgSystemCwgears->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 9.971 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwgears_schedule`
      WHERE time + '3600'<'1653330637'
    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.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php: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.49 ms After last query: 2.82 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.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.09 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
    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.34 ms After last query: 0.14 ms Query memory: 0.041 MB Memory before query: 10.737 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.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.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
    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.35 ms After last query: 0.26 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.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 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
    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.41 ms After last query: 0.10 ms Query memory: 0.007 MB Memory before query: 10.775 MB
    UPDATE `cca_extensions`
    
      SET `params` = '{\"mediaversion\":\"4d441eb90826c1f8bada3277494bdd90\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEcca_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.07 ms
    updating0.08 ms
    end0.01 ms
    query end0.08 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    13Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    12Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/components/com_adsmanager/lib/core.php:119
    8require_once JROOT/components/com_adsmanager/lib/core.phpJROOT/components/com_adsmanager/router.php:13
    7require_once JROOT/components/com_adsmanager/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  21. Query Time: 0.31 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 12.373 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwtraffic`
      WHERE iphash = UNHEX(SHA1('100.24.115.215'))
      AND tm + '3600'>'1653330637'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_cwtrafficNULLrefidx_iphash,idx_iphashtmidx_iphashtm21const5100.00Using where; Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 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.29 ms After last query: 0.66 ms Query memory: 0.020 MB Memory before query: 12.380 MB Rows returned: 1
    SELECT *
    
      FROM cca_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_languagesNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.07 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php: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: 0.87 ms After last query: 2.50 ms Query memory: 0.041 MB Memory before query: 13.809 MB Rows returned: 273
    SELECT config_key, config_value
    
      FROM cca_eshop_configs
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_eshop_configsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL273100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.34 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.23 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/components/com_eshop/helpers/helper.php:32
    9EshopHelper::getConfig()JROOT/components/com_eshop/helpers/helper.php:144
    8EshopHelper::getConfigValue()JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php:8
    7require_once JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.phpJROOT/components/com_eshop/eshop.php:27
    6require_once JROOT/components/com_eshop/eshop.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: 0.93 ms After last query: 3.33 ms Query memory: 0.027 MB Memory before query: 13.906 MB Rows returned: 11
    SHOW FULL COLUMNS 
      FROM `cca_eshop_categorydetails`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cca_eshop_categorydetails`
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.16 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.00 ms
    executing0.01 ms
    Opening tables0.41 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.02 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.03 ms
    closing tables0.00 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:261
    16Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:180
    15Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:110
    14RADModelList->__construct()JROOT/components/com_eshop/models/categories.php:29
    13EshopModelCategories->__construct()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
    12Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
    11Joomla\CMS\MVC\Factory\LegacyFactory->createModel()JROOT/libraries/src/MVC/Controller/BaseController.php:559
    10Joomla\CMS\MVC\Controller\BaseController->createModel()JROOT/libraries/src/MVC/Controller/BaseController.php:728
    9Joomla\CMS\MVC\Controller\BaseController->getModel()JROOT/libraries/src/MVC/Controller/BaseController.php:616
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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: 1.28 ms After last query: 0.48 ms Query memory: 0.094 MB Memory before query: 13.933 MB Rows returned: 2
    SELECT a.*,category_name,category_alias,category_page_title,category_page_heading,category_alt_image,category_desc,meta_key,meta_desc
    
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON a.id = b.category_id
      WHERE a.published = 1
      AND b.language='en-GB'
      AND a.category_parent_id=0
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "0") OR (a.category_customergroups LIKE "0,%") OR (a.category_customergroups LIKE "%,0,%") OR (a.category_customergroups LIKE "%,0"))
      ORDER BY b.category_name ASC
      LIMIT 15
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefPRIMARY,category_parent_id,publishedpublished2const428.47Using where; Using temporary; Using filesort
    1SIMPLEbNULLrefcategory_idcategory_id5citadel4_CCA.a.id110.00Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.19 ms
    init0.04 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.23 ms
    Creating sort index0.33 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.00 ms
    closing tables0.05 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:153
    11RADModelList->getData()JROOT/components/com_eshop/models/categories.php:62
    10EshopModelCategories->getData()JROOT/components/com_eshop/views/categories/view.html.php:68
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.32 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 13.987 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON a.id = b.category_id
      WHERE a.published = 1
      AND b.language='en-GB'
      AND a.category_parent_id=0
      AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "0") OR (a.category_customergroups LIKE "0,%") OR (a.category_customergroups LIKE "%,0,%") OR (a.category_customergroups LIKE "%,0"))
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefPRIMARY,category_parent_id,publishedpublished2const428.47Using where
    1SIMPLEbNULLrefcategory_idcategory_id5citadel4_CCA.a.id110.00Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:176
    11RADModelList->getTotal()JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:193
    10RADModelList->getPagination()JROOT/components/com_eshop/views/categories/view.html.php:70
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.73 ms After last query: 0.47 ms Query memory: 0.023 MB Memory before query: 14.013 MB Rows returned: 1
    SELECT a.message_value
    
      FROM cca_eshop_messagedetails AS a
      INNER JOIN cca_eshop_messages AS b
      ON a.message_id = b.id
      WHERE a.language = 'en-GB'
      AND b.message_name = 'shop_introduction'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4310.00Using where
    1SIMPLEbNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.message_id110.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.35 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.13 ms
    end0.00 ms
    query end0.00 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:1740
    14JDatabaseDriver->loadResult()JROOT/components/com_eshop/helpers/helper.php:3883
    13EshopHelper::getMessageValue()JROOT/components/com_eshop/themes/default/views/categories/default.php:20
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.29 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 14.020 MB Rows returned: 1
    SELECT a.message_value
    
      FROM cca_eshop_messagedetails AS a
      INNER JOIN cca_eshop_messages AS b
      ON a.message_id = b.id
      WHERE a.language = "en-GB"
      AND b.message_name = 'shop_introduction'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4310.00Using where
    1SIMPLEbNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.message_id110.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 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.10 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    14JDatabaseDriver->loadResult()JROOT/components/com_eshop/helpers/helper.php:3894
    13EshopHelper::getMessageValue()JROOT/components/com_eshop/themes/default/views/categories/default.php:20
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.29 ms After last query: 0.47 ms Query memory: 0.026 MB Memory before query: 14.047 MB Rows returned: 12
    Duplicate queries: #30  #33  #34
    SELECT a.id, a.category_parent_id, b.category_alias
    
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON (a.id = b.category_id)
      WHERE b.language = 'en-GB'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEbNULLALLcategory_idNO INDEX KEY COULD BE USEDNULLNULL1110.00Using where
    1SIMPLEaNULLeq_refPRIMARYPRIMARY4citadel4_CCA.b.category_id1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 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.08 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/components/com_eshop/helpers/helper.php:4939
    16EshopHelper::getCategoryPath()JROOT/components/com_eshop/helpers/route.php:78
    15EshopRoute::getCategoryRoute()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.22 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 14.059 MB Rows returned: 12
    Duplicate queries: #29  #33  #34
    SELECT a.id, a.category_parent_id, b.category_alias
    
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON (a.id = b.category_id)
      WHERE b.language = 'en-GB'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEbNULLALLcategory_idNO INDEX KEY COULD BE USEDNULLNULL1110.00Using where
    1SIMPLEaNULLeq_refPRIMARYPRIMARY4citadel4_CCA.b.category_id1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 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.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
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/components/com_eshop/helpers/helper.php:4939
    22EshopHelper::getCategoryPath()JROOT/components/com_eshop/router.php:153
    21EshopRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    20Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    19Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.42 ms After last query: 0.87 ms Query memory: 0.027 MB Memory before query: 14.133 MB Rows returned: 1
    SELECT id
    
      FROM cca_eshop_urls
      WHERE md5_key="31db504ef095675f8bc7ba8f06882f4e"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_eshop_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4710.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.20 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 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
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    22JDatabaseDriver->loadResult()JROOT/components/com_eshop/router.php:471
    21EshopRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    20Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    19Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.33 ms After last query: 0.04 ms Query memory: 0.011 MB Memory before query: 14.145 MB
    UPDATE cca_eshop_urls
    
      SET query="view=category&id=6"
      WHERE md5_key="31db504ef095675f8bc7ba8f06882f4e"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEcca_eshop_urlsNULLindexNULLPRIMARY4NULL47100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    updating0.11 ms
    end0.01 ms
    query end0.08 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/components/com_eshop/router.php:489
    21EshopRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    20Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    19Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.24 ms After last query: 0.12 ms Query memory: 0.027 MB Memory before query: 14.162 MB Rows returned: 12
    Duplicate queries: #29  #30  #34
    SELECT a.id, a.category_parent_id, b.category_alias
    
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON (a.id = b.category_id)
      WHERE b.language = 'en-GB'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEbNULLALLcategory_idNO INDEX KEY COULD BE USEDNULLNULL1110.00Using where
    1SIMPLEaNULLeq_refPRIMARYPRIMARY4citadel4_CCA.b.category_id1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 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.05 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/components/com_eshop/helpers/helper.php:4939
    16EshopHelper::getCategoryPath()JROOT/components/com_eshop/helpers/route.php:78
    15EshopRoute::getCategoryRoute()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.21 ms After last query: 0.12 ms Query memory: 0.028 MB Memory before query: 14.174 MB Rows returned: 12
    Duplicate queries: #29  #30  #33
    SELECT a.id, a.category_parent_id, b.category_alias
    
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON (a.id = b.category_id)
      WHERE b.language = 'en-GB'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEbNULLALLcategory_idNO INDEX KEY COULD BE USEDNULLNULL1110.00Using where
    1SIMPLEaNULLeq_refPRIMARYPRIMARY4citadel4_CCA.b.category_id1100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 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.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
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/components/com_eshop/helpers/helper.php:4939
    22EshopHelper::getCategoryPath()JROOT/components/com_eshop/router.php:153
    21EshopRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    20Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    19Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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.21 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 14.185 MB Rows returned: 1
    SELECT id
    
      FROM cca_eshop_urls
      WHERE md5_key="807659cd883fc0a63f6ce615893b3558"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_eshop_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4710.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.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
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    22JDatabaseDriver->loadResult()JROOT/components/com_eshop/router.php:471
    21EshopRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    20Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    19Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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: 0.21 ms After last query: 0.03 ms Query memory: 0.011 MB Memory before query: 14.196 MB
    UPDATE cca_eshop_urls
    
      SET query="view=category&id=5"
      WHERE md5_key="807659cd883fc0a63f6ce615893b3558"
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEcca_eshop_urlsNULLindexNULLPRIMARY4NULL47100.00Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    updating0.07 ms
    end0.00 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/components/com_eshop/router.php:489
    21EshopRouter->build()JROOT/libraries/src/Router/SiteRouter.php:532
    20Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    19Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    18Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    17Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    16Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    15Joomla\CMS\Router\Route::_()JROOT/components/com_eshop/themes/default/views/common/categories.php:22
    14include JROOT/components/com_eshop/themes/default/views/common/categories.phpJROOT/components/com_eshop/helpers/html.php:190
    13EshopHtmlHelper::loadCommonLayout()JROOT/components/com_eshop/themes/default/views/categories/default.php:35
    12include JROOT/components/com_eshop/themes/default/views/categories/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    11Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/administrator/components/com_eshop/libraries/mvc/view.php:88
    10EShopView->display()JROOT/components/com_eshop/views/categories/view.html.php:93
    9EShopViewCategories->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_eshop/eshop.php:109
    6require_once JROOT/components/com_eshop/eshop.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: 0.98 ms After last query: 1.97 ms Query memory: 0.071 MB Memory before query: 14.873 MB Rows returned: 7
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cca_modules AS m
      LEFT JOIN cca_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN cca_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-23 18:30:37')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-23 18:30:37')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 1375 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.04 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.53 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.]

  38. Query Time: 0.30 ms After last query: 5.37 ms Query memory: 0.028 MB Memory before query: 16.396 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.04 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 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.]

  39. Query Time: 0.61 ms After last query: 3.52 ms Query memory: 0.029 MB Memory before query: 18.471 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.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.16 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.03 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 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.03 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.]

  40. Query Time: 0.83 ms After last query: 0.64 ms Query memory: 0.038 MB Memory before query: 18.510 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.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.08 ms
    preparing0.01 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.24 ms
    Creating sort index0.13 ms
    end0.00 ms
    query end0.00 ms
    removing tmp table0.02 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.04 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.]

  41. Query Time: 0.37 ms After last query: 0.31 ms Query memory: 0.027 MB Memory before query: 18.618 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.05 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.]

  42. Query Time: 0.91 ms After last query: 4.62 ms Query memory: 0.023 MB Memory before query: 21.450 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.06 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.54 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.]

  43. Query Time: 0.66 ms After last query: 2.49 ms Query memory: 0.023 MB Memory before query: 21.491 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.05 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.37 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.]

  44. Query Time: 0.61 ms After last query: 0.57 ms Query memory: 0.023 MB Memory before query: 22.667 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.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.37 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.]

  45. Query Time: 0.54 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 22.676 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.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.33 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.]

  46. Query Time: 0.98 ms After last query: 5.71 ms Query memory: 0.027 MB Memory before query: 25.265 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.14 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.14 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.19 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.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    21Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    20FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    19Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    18FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    17PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    16JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    15JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    14JHtmlContent::prepare()Same as call in the line below.
    13call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    12Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    11Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_custom/mod_custom.php:15
    10include JROOT/modules/mod_custom/mod_custom.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1140
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  48. Query Time: 0.15 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 29.868 MB Rows returned: 0
    SELECT uikit_plus
    
      FROM `cca_cwgears`
      WHERE url = 'https://www.citadelca.ab.ca/CCA/index.php/store'
    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.]

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

  50. Query Time: 0.46 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 30.052 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.17 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.02 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.03 ms
    closing tables0.00 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    14JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/fof/database/driver/joomla.php:230
    13FOFDatabaseDriverJoomla->getTableColumns()JROOT/libraries/fof/table/table.php:2170
    12FOFTable->getTableFields()JROOT/libraries/fof/table/table.php:536
    11FOFTable->__construct()JROOT/administrator/components/com_autotweet/tables/automator.php:33
    10AutotweetTableAutomator->__construct()JROOT/libraries/fof/table/table.php:433
    9FOFTable::getAnInstance()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:106
    8PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
    7PlgSystemAutotweetAutomator->onAfterRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1146
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  51. Query Time: 0.24 ms After last query: 0.57 ms Query memory: 0.021 MB Memory before query: 30.083 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.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    11JDatabaseDriver->loadAssoc()JROOT/libraries/fof/database/driver/joomla.php:292
    10FOFDatabaseDriverJoomla->loadAssoc()JROOT/libraries/fof/table/table.php:949
    9FOFTable->load()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:112
    8PlgSystemAutotweetAutomator->_onAfterRender()JROOT/plugins/system/autotweetautomator/autotweetautomator.php:232
    7PlgSystemAutotweetAutomator->onAfterRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1146
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  52. Query Time: 0.18 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 30.089 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.03 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.]

42 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 4 × SELECT `id`  
      FROM `cca_menu`
  2. 4 × SELECT a.id, a.category_parent_id, b.category_alias 
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON (a.id = b.category_id)
  3. 2 × SELECT cca_autotweet_automator.* 
      FROM cca_autotweet_automator
  4. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `cca_extensions`
  5. 2 × SELECT a.message_value 
      FROM cca_eshop_messagedetails AS a
      INNER JOIN cca_eshop_messages AS b
      ON a.message_id = b.id
  6. 2 × SELECT id 
      FROM cca_eshop_urls
  7. 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
  8. 1 × SELECT a.*,category_name,category_alias,category_page_title,category_page_heading,category_alt_image,category_desc,meta_key,meta_desc 
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON a.id = b.category_id
  9. 1 × SELECT COUNT(*) 
      FROM cca_eshop_categories AS a
      INNER JOIN cca_eshop_categorydetails AS b
      ON a.id = b.category_id
  10. 1 × SELECT f.* 
      FROM cca_comprofiler_fields f
      INNER JOIN cca_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
  11. 1 × SELECT `params`  
      FROM `cca_comprofiler_plugin`
  12. 1 × SELECT * 
      FROM cca_languages
  13. 1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
      FROM `cca_comprofiler_plugin`
  14. 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
      FROM cca_fields AS a
      LEFT JOIN `cca_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN cca_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN cca_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN cca_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN cca_fields_groups AS g
      ON g.id = a.group_id
  15. 1 × SELECT uikit 
      FROM `cca_cwgears`
  16. 1 × SELECT uikit_plus 
      FROM `cca_cwgears`
  17. 1 × SELECT config_key, config_value 
      FROM cca_eshop_config
  18. 1 × SELECT `data` 
      FROM `cca_session`
  19. 1 × SELECT `session_id` 
      FROM `cca_session`
  20. 1 × SELECT botname 
      FROM `cca_cwtraffic_knownips`
  21. 1 × SELECT ip 
      FROM `cca_cwtraffic_knownips`
  22. 1 × SELECT * 
      FROM cca_adsmanager_confi
  23. 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
  24. 1 × SELECT count(*) 
      FROM `cca_cwgears_schedule`
  25. 1 × SELECT count(*) 
      FROM `cca_cwgears_schedule
  26. 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
  27. 1 × SELECT id 
      FROM cca_osmembership_plans
  28. 1 × SELECT plan_id 
      FROM cca_osmembership_urls
  29. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `cca_assets`
  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'6230306237373433363536663865396336366165376665356661316436386663', 1, 1653330637, 0, '', 0
  2. 1 × UPDATE `cca_extensions` 
      SET `params` = '{\"mediaversion\":\"4d441eb90826c1f8bada3277494bdd90\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `cca_eshop_categorydetails
  4. 1 × UPDATE cca_eshop_urls 
      SET query="view=category&id=6"
  5. 1 × UPDATE cca_eshop_urls 
      SET query="view=category&id=5"
  6. 1 × SHOW FULL COLUMNS 
      FROM `cca_users
  7. 1 × SHOW TABLE
  8. 1 × SHOW FULL COLUMNS 
      FROM `cca_autotweet_automator