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
Home
Total images in all categories: 1,653
Total number of hits on all images: 2,258,134
TOP 12: Top Rated - Last Added - Last Commented - Most Viewed
There are 3 categories in gallery
Citadel Events
  • Citadel Events
Citadel Link Photo Competition
  • Citadel Link Photo Competition
Citadel General
  • Citadel General
TOP 12: Top Rated - Last Added - Last Commented - Most Viewed
You are not allowed to access this category Restricted Categories
Total images in all categories: 1,653
Powered by JoomGallery
  • You are here:  
  • Home
  • Community
  • Photo Gallery

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, 14.9°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": 1653324807,
                "last": 1653324807,
                "now": 1653324807
            },
            "token": "Hh2hIgTdHnXL3cc2AmSlhnf2BI83ie56"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 5.84 ms / 5.84 ms Memory: 2.136 MB / 2.51 MB Application: afterLoad
Time: 30.96 ms / 36.79 ms Memory: 6.687 MB / 9.19 MB Application: Before Access::preloadComponents (all components)
Time: 1.56 ms / 38.36 ms Memory: 0.105 MB / 9.30 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 38.38 ms Memory: -0.015 MB / 9.28 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.25 ms / 38.63 ms Memory: 0.010 MB / 9.29 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 4.49 ms / 43.13 ms Memory: 0.683 MB / 9.98 MB Application: afterInitialise
Time: 13.77 ms / 56.90 ms Memory: 2.400 MB / 12.38 MB Application: afterRoute
Time: 1.16 ms / 58.05 ms Memory: 0.015 MB / 12.39 MB Application: beforeRenderComponent com_joomgallery
Time: 81.85 ms / 139.90 ms Memory: 2.804 MB / 15.20 MB Application: afterRenderComponent com_joomgallery
Time: 2.57 ms / 142.47 ms Memory: 0.018 MB / 15.21 MB Application: afterDispatch
Time: 1.87 ms / 144.34 ms Memory: 0.032 MB / 15.25 MB Application: beforeRenderModule mod_cblogin (Member Login)
Time: 30.53 ms / 174.86 ms Memory: 8.545 MB / 23.79 MB Application: afterRenderModule mod_cblogin (Member Login)
Time: 0.06 ms / 174.92 ms Memory: -0.014 MB / 23.78 MB Application: beforeRenderModule mod_custom (Citadel Highlights)
Time: 8.71 ms / 183.63 ms Memory: 2.605 MB / 26.38 MB Application: afterRenderModule mod_custom (Citadel Highlights)
Time: 0.06 ms / 183.69 ms Memory: 0.023 MB / 26.40 MB Application: beforeRenderModule mod_thick_rss (City of Calgary)
Time: 31.88 ms / 215.57 ms Memory: 2.957 MB / 29.36 MB Application: afterRenderModule mod_thick_rss (City of Calgary)
Time: 0.10 ms / 215.68 ms Memory: -0.006 MB / 29.35 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 2.83 ms / 218.50 ms Memory: 0.017 MB / 29.37 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.11 ms / 218.61 ms Memory: -0.003 MB / 29.37 MB Application: beforeRenderModule mod_custom (Image)
Time: 0.32 ms / 218.92 ms Memory: 0.003 MB / 29.37 MB Application: afterRenderModule mod_custom (Image)
Time: 0.02 ms / 218.95 ms Memory: -0.000 MB / 29.37 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 9.13 ms / 228.08 ms Memory: 1.609 MB / 30.98 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.10 ms / 228.17 ms Memory: 0.001 MB / 30.98 MB Application: beforeRenderModule mod_search (Search)
Time: 0.90 ms / 229.07 ms Memory: 0.012 MB / 30.99 MB Application: afterRenderModule mod_search (Search)
Time: 198.90 ms / 427.97 ms Memory: 1.573 MB / 32.57 MB Application: afterRender

Database queries total: 71.39 ms

Memory Usage

33.74 MB (35,380,088 Bytes)

Database Queries

99 Queries Logged 71.39 ms


  1. Query Time: 0.41 ms Query memory: 0.023 MB Memory before query: 4.487 MB Rows returned: 0
    SELECT `data`
    
      FROM `cca_session`
      WHERE `session_id` = X'3766616335656539323463333039646139656166383864373533346661656533'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    Opening tables0.12 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:854
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:414
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.27 ms After last query: 0.48 ms Query memory: 0.020 MB Memory before query: 4.502 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `cca_session`
      WHERE `session_id` = X'3766616335656539323463333039646139656166383864373533346661656533'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.03 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.32 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 4.508 MB
    INSERT INTO `cca_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3766616335656539323463333039646139656166383864373533346661656533', 1, 1653324807, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `cca_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3766616335656539323463333039646139656166383864373533346661656533', 1, 1653324807, 0, '', 0)
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.10 ms
    end0.00 ms
    query end0.08 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.64 ms After last query: 0.98 ms Query memory: 0.046 MB Memory before query: 4.845 MB Rows returned: 66
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `cca_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_extensionsNULLrefextensionextension82const701.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.26 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    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.27 ms After last query: 0.87 ms Query memory: 0.021 MB Memory before query: 5.216 MB Rows returned: 4
    SELECT id, rules
    
      FROM `cca_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_viewlevelsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL4100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.38 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 5.228 MB Rows returned: 2
    SELECT b.id
    
      FROM cca_usergroups AS a
      LEFT JOIN cca_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.14 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.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.01 ms After last query: 0.20 ms Query memory: 0.051 MB Memory before query: 5.250 MB Rows returned: 131
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM cca_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_extensionsNULLrefextensionextension82const2450.60Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.03 ms
    statistics0.04 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.66 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
    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: 4.02 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.12 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.15 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/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.35 ms After last query: 13.55 ms Query memory: 0.032 MB Memory before query: 9.207 MB Rows returned: 66
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `cca_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_adsmanager','com_ajax','com_associations','com_autotweet','com_banners','com_booking','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_comprofiler','com_config','com_content','com_contenthistory','com_cpanel','com_digistore','com_djleague','com_ecwid','com_edocman','com_eshop','com_fields','com_finder','com_formmaker','com_formtomail','com_installer','com_jce','com_jevents','com_jgrid','com_joomgallery','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mshahfrontendusermanager','com_osmembership','com_pfcomments','com_pffields','com_pfforum','com_pfmilestones','com_pfprojects','com_pfrepo','com_pftasks','com_pftime','com_pfusers','com_plugins','com_postinstall','com_privacy','com_profiler','com_profiles','com_projectfork','com_redirect','com_search','com_swmenufree','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zweather')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_assetsNULLrangeidx_asset_nameidx_asset_name202NULL67100.00Using index condition
    Profile
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    Opening tables0.12 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.19 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.60 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    13Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    12Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    11Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    10Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    9Joomla\CMS\User\User->authorise()JROOT/plugins/system/osmembershipurls/osmembershipurls.php:191
    8plgSystemOSMembershipUrls->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.32 ms After last query: 0.46 ms Query memory: 0.021 MB Memory before query: 9.292 MB Rows returned: 0
    SELECT plan_id
    
      FROM cca_osmembership_urls
      WHERE `url` = 'https://citadelca.ab.ca/CCA/index.php/community/photo-gallery'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_osmembership_urlsNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00Using where
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/plugins/system/osmembershipurls/osmembershipurls.php:322
    9plgSystemOSMembershipUrls->getRequiredPlanIds()JROOT/plugins/system/osmembershipurls/osmembershipurls.php:209
    8plgSystemOSMembershipUrls->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.30 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 9.297 MB Rows returned: 0
    SELECT id
    
      FROM cca_osmembership_plans
      WHERE published = 0
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_osmembership_plansNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL333.33Using where
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.11 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.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.03 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.08 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.58 ms
    end0.01 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: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.30 ms After last query: 0.93 ms Query memory: 0.020 MB Memory before query: 9.966 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwgears_schedule`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLENULLNULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLNULLSelect tables optimized away
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.14 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:102
    8plgSystemCwgears->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 0.15 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 9.971 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwgears_schedule`
      WHERE time + '3600'<'1653324807'
    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.01 ms
    preparing0.01 ms
    executing0.00 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:145
    8plgSystemCwgears->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:696
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.53 ms After last query: 2.78 ms Query memory: 0.022 MB Memory before query: 10.733 MB Rows returned: 4
    SELECT id, home, template, s.params
    
      FROM cca_template_styles as s
      LEFT JOIN cca_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const61.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202citadel4_CCA.e.element166.67Using index condition; Using where
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.11 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.41 ms After last query: 0.13 ms Query memory: 0.041 MB Memory before query: 10.738 MB Rows returned: 1
    SELECT * 
      FROM cca_adsmanager_config
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_adsmanager_configNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL1100.00NULL
    Profile
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.07 ms
    init0.03 ms
    System lock0.00 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.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    9JDatabaseDriver->loadObject()JROOT/components/com_adsmanager/lib/core.php:86
    8require_once JROOT/components/com_adsmanager/lib/core.phpJROOT/components/com_adsmanager/router.php:13
    7require_once JROOT/components/com_adsmanager/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  18. Query Time: 0.31 ms After last query: 0.11 ms Query memory: 0.007 MB Memory before query: 10.775 MB
    UPDATE `cca_extensions`
    
      SET `params` = '{\"mediaversion\":\"48abc06e20de2003684702b7c6b21174\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEcca_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.04 ms
    updating0.07 ms
    end0.01 ms
    query end0.06 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    13Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    12Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    11Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    10Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    9Joomla\CMS\Factory::getDocument()JROOT/components/com_adsmanager/lib/core.php:119
    8require_once JROOT/components/com_adsmanager/lib/core.phpJROOT/components/com_adsmanager/router.php:13
    7require_once JROOT/components/com_adsmanager/router.phpJROOT/libraries/src/Router/SiteRouter.php:779
    6Joomla\CMS\Router\SiteRouter->getComponentRouter()JROOT/libraries/src/Router/SiteRouter.php:131
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1170
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  20. Query Time: 0.14 ms After last query: 0.06 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.44 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 12.373 MB Rows returned: 1
    SELECT count(*)
    
      FROM `cca_cwtraffic`
      WHERE iphash = UNHEX(SHA1('100.24.115.215'))
      AND tm + '3600'>'1653324807'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_cwtrafficNULLrefidx_iphash,idx_iphashtmidx_iphashtm21const3100.00Using where; Using index
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.12 ms
    init0.03 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.09 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.41 ms After last query: 0.93 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.10 ms
    init0.02 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.08 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 3.36 ms After last query: 3.81 ms Query memory: 0.091 MB Memory before query: 12.938 MB Rows returned: 296
    SHOW FULL COLUMNS 
      FROM `cca_joomgallery_config`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cca_joomgallery_config`
    Profile
    StatusDuration
    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.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.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.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.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.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.02 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.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.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.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.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.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.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.02 ms
    Sending data0.32 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.04 ms
    closing tables0.00 ms
    freeing items0.02 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_joomgallery/tables/joomgalleryconfig.php:334
    14TableJoomgalleryConfig->__construct()JROOT/libraries/src/Table/Table.php:328
    13Joomla\CMS\Table\Table::getInstance()JROOT/administrator/components/com_joomgallery/helpers/config.php:374
    12JoomConfig->__construct()JROOT/administrator/components/com_joomgallery/helpers/config.php:437
    11JoomConfig::getInstance()JROOT/components/com_joomgallery/helpers/ambit.php:147
    10JoomAmbit->__construct()JROOT/components/com_joomgallery/helpers/ambit.php:220
    9JoomAmbit::getInstance()JROOT/components/com_joomgallery/controller.php:71
    8JoomGalleryController->__construct()JROOT/libraries/src/MVC/Controller/BaseController.php:313
    7Joomla\CMS\MVC\Controller\BaseController::getInstance()JROOT/components/com_joomgallery/joomgallery.php:38
    6require_once JROOT/components/com_joomgallery/joomgallery.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.72 ms After last query: 1.44 ms Query memory: 0.137 MB Memory before query: 13.266 MB Rows returned: 1
    SELECT *
    
      FROM cca_joomgallery_config
      WHERE `id` = '1'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_configNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.08 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.13 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.14 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    14JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:747
    13Joomla\CMS\Table\Table->load()JROOT/administrator/components/com_joomgallery/helpers/config.php:375
    12JoomConfig->__construct()JROOT/administrator/components/com_joomgallery/helpers/config.php:437
    11JoomConfig::getInstance()JROOT/components/com_joomgallery/helpers/ambit.php:147
    10JoomAmbit->__construct()JROOT/components/com_joomgallery/helpers/ambit.php:220
    9JoomAmbit::getInstance()JROOT/components/com_joomgallery/controller.php:71
    8JoomGalleryController->__construct()JROOT/libraries/src/MVC/Controller/BaseController.php:313
    7Joomla\CMS\MVC\Controller\BaseController::getInstance()JROOT/components/com_joomgallery/joomgallery.php:38
    6require_once JROOT/components/com_joomgallery/joomgallery.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.62 ms After last query: 8.96 ms Query memory: 0.073 MB Memory before query: 13.656 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 16:53:27')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-23 16:53:27')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 435 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.20 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    init0.08 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.11 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.71 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.05 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    15Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    14Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    13Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/components/com_joomgallery/helpers/helper.php:499
    12JoomHelper::getModules()JROOT/components/com_joomgallery/helpers/helper.php:535
    11JoomHelper::getRenderedModules()JROOT/components/com_joomgallery/views/gallery/view.html.php:40
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 2.01 ms After last query: 0.22 ms Query memory: 0.026 MB Memory before query: 13.676 MB Rows returned: 24
    SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
    
      FROM cca_joomgallery_catg AS c
      WHERE lft > 0
      AND c.published = 1
      AND c.access IN (1,1,5)
      AND (c.password = '' OR c.cid IN (0))
      ORDER BY c.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL254.00Using where; Using filesort
    Profile
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables1.47 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.15 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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/helpers/ambit.php:492
    12JoomAmbit->getCategoryStructure()JROOT/components/com_joomgallery/helpers/helper.php:786
    11JoomHelper::getNumberOfImgHits()JROOT/components/com_joomgallery/views/gallery/view.html.php:58
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 4.63 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 13.695 MB Rows returned: 21
    SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
    
      FROM cca_joomgallery
      WHERE approved = 1
      AND published = 1
      AND hidden = 0
      AND access IN (1,1,5)
      GROUP BY catid
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgalleryNULLindexidx_catididx_catid4NULL16730.06Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables1.03 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data3.25 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/helpers/ambit.php:508
    12JoomAmbit->getCategoryStructure()JROOT/components/com_joomgallery/helpers/helper.php:786
    11JoomHelper::getNumberOfImgHits()JROOT/components/com_joomgallery/views/gallery/view.html.php:58
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.36 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 13.714 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM cca_joomgallery_catg AS c
      WHERE c.published = 1
      AND c.hidden = 0
      AND c.parent_id = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLrefidx_parent_ididx_parent_id4const34.00Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 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
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    14JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    13Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/components/com_joomgallery/models/gallery.php:80
    12JoomGalleryModelGallery->getTotal()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_joomgallery/views/gallery/view.html.php:67
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.75 ms After last query: 4.85 ms Query memory: 0.025 MB Memory before query: 14.078 MB Rows returned: 3
    SELECT c.*
    
      FROM cca_joomgallery_catg AS c
      WHERE c.published = 1
      AND c.hidden = 0
      AND c.parent_id = 1
      ORDER BY c.lft
      LIMIT 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLrefidx_parent_ididx_parent_id4const34.00Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.12 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/components/com_joomgallery/models/gallery.php:188
    13JoomGalleryModelGallery->_loadCategories()JROOT/components/com_joomgallery/models/gallery.php:60
    12JoomGalleryModelGallery->getCategories()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_joomgallery/views/gallery/view.html.php:173
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 4.01 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 14.092 MB Rows returned: 1
    SELECT MAX(imgdate)
    
      FROM cca_joomgallery AS a
      LEFT JOIN cca_joomgallery_catg AS c
      ON c.cid = a.catid
      WHERE a.catid IN (24,23,22,21,20,19,18,17,16,15,13,12,11,9,4,8,2)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLALLidx_catidNO INDEX KEY COULD BE USEDNULLNULL167396.11Using where
    1SIMPLEcNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.catid1100.00Using index
    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.12 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data3.41 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.05 ms
    freeing items0.06 ms
    cleaning up0.03 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:213
    11JoomHelper::checkNewCatg()JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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: 2.45 ms After last query: 0.32 ms Query memory: 0.248 MB Memory before query: 14.099 MB Rows returned: 186
    SELECT *, c.access
    
      FROM cca_joomgallery AS p
      LEFT JOIN cca_joomgallery_catg AS c
      ON c.cid = p.catid
      WHERE p.catid = 9
      AND p.access IN (1,1,5)
      AND p.published = 1
      AND p.approved = 1
      AND p.hidden != 1
      AND c.access IN (1,1,5)
      AND c.published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEpNULLrefidx_catididx_catid4const1860.27Using where
    Profile
    StatusDuration
    starting0.12 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.13 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data1.65 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.06 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/models/gallery.php:161
    11JoomGalleryModelGallery->getRandomImage()JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.50 ms After last query: 2.17 ms Query memory: 0.022 MB Memory before query: 14.116 MB Rows returned: 1
    SELECT catpath
    
      FROM cca_joomgallery_catg
      WHERE cid = 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.10 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:141
    12JoomHelper::getCatPath()JROOT/components/com_joomgallery/helpers/ambit.php:338
    11JoomAmbit->getImg()JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.33 ms After last query: 0.64 ms Query memory: 0.026 MB Memory before query: 14.132 MB Rows returned: 1
    SELECT alias
    
      FROM cca_joomgallery_catg
      WHERE cid = 7
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 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.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    19JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    18JoomGalleryBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:532
    16Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    15Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    12Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    11Joomla\CMS\Router\Route::_()JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.66 ms After last query: 0.27 ms Query memory: 0.022 MB Memory before query: 14.146 MB Rows returned: 1
    SELECT MAX(imgdate)
    
      FROM cca_joomgallery AS a
      LEFT JOIN cca_joomgallery_catg AS c
      ON c.cid = a.catid
      WHERE a.catid IN (10,6)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrangeidx_catididx_catid4NULL31100.00Using index condition
    1SIMPLEcNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.catid1100.00Using index
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.21 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
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:213
    11JoomHelper::checkNewCatg()JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.78 ms After last query: 0.21 ms Query memory: 0.053 MB Memory before query: 14.151 MB Rows returned: 19
    SELECT *, c.access
    
      FROM cca_joomgallery AS p
      LEFT JOIN cca_joomgallery_catg AS c
      ON c.cid = p.catid
      WHERE p.catid = 6
      AND p.access IN (1,1,5)
      AND p.published = 1
      AND p.approved = 1
      AND p.hidden != 1
      AND c.access IN (1,1,5)
      AND c.published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEpNULLrefidx_catididx_catid4const190.27Using where
    Profile
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.22 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
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/models/gallery.php:161
    11JoomGalleryModelGallery->getRandomImage()JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.27 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 14.157 MB Rows returned: 1
    SELECT catpath
    
      FROM cca_joomgallery_catg
      WHERE cid = 6
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:141
    12JoomHelper::getCatPath()JROOT/components/com_joomgallery/helpers/ambit.php:338
    11JoomAmbit->getImg()JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.26 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 14.164 MB Rows returned: 1
    SELECT alias
    
      FROM cca_joomgallery_catg
      WHERE cid = 5
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    19JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    18JoomGalleryBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:532
    16Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    15Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    12Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    11Joomla\CMS\Router\Route::_()JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  38. Query Time: 0.48 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 14.177 MB Rows returned: 1
    SELECT MAX(imgdate)
    
      FROM cca_joomgallery AS a
      LEFT JOIN cca_joomgallery_catg AS c
      ON c.cid = a.catid
      WHERE a.catid IN (14,3)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrangeidx_catididx_catid4NULL14100.00Using index condition
    1SIMPLEcNULLeq_refPRIMARYPRIMARY4citadel4_CCA.a.catid1100.00Using index
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.12 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
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    12JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:213
    11JoomHelper::checkNewCatg()JROOT/components/com_joomgallery/views/gallery/view.html.php:183
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  39. Query Time: 0.65 ms After last query: 0.20 ms Query memory: 0.049 MB Memory before query: 14.183 MB Rows returned: 13
    SELECT *, c.access
    
      FROM cca_joomgallery AS p
      LEFT JOIN cca_joomgallery_catg AS c
      ON c.cid = p.catid
      WHERE p.catid = 14
      AND p.access IN (1,1,5)
      AND p.published = 1
      AND p.approved = 1
      AND p.hidden != 1
      AND c.access IN (1,1,5)
      AND c.published = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEpNULLrefidx_catididx_catid4const130.38Using where
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.16 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/models/gallery.php:161
    11JoomGalleryModelGallery->getRandomImage()JROOT/components/com_joomgallery/views/gallery/view.html.php:261
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  40. Query Time: 0.25 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 14.188 MB Rows returned: 1
    SELECT catpath
    
      FROM cca_joomgallery_catg
      WHERE cid = 14
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:141
    12JoomHelper::getCatPath()JROOT/components/com_joomgallery/helpers/ambit.php:338
    11JoomAmbit->getImg()JROOT/components/com_joomgallery/views/gallery/view.html.php:272
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.]

  41. Query Time: 0.28 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 14.195 MB Rows returned: 1
    SELECT alias
    
      FROM cca_joomgallery_catg
      WHERE cid = 3
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    19JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    18JoomGalleryBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:532
    16Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    15Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    14Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    13Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    12Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    11Joomla\CMS\Router\Route::_()JROOT/components/com_joomgallery/views/gallery/view.html.php:410
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.]

  42. Query Time: 0.84 ms After last query: 6.87 ms Query memory: 0.029 MB Memory before query: 14.660 MB Rows returned: 24
    SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner,(
      CASE WHEN c.password != ''
      AND c.cid NOT IN (0) THEN 1 ELSE 0 END) AS protected
      FROM cca_joomgallery_catg AS c
      WHERE lft > 0
      ORDER BY c.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcNULLALLNULLNO INDEX KEY COULD BE USEDNULLNULL2533.33Using where; Using filesort
    Profile
    StatusDuration
    starting0.17 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.21 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/helpers/ambit.php:492
    19JoomAmbit->getCategoryStructure()JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:720
    18JHtmlJoomGallery::categoryTree()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    16Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    15Joomla\CMS\HTML\HTMLHelper::_()JROOT/components/com_joomgallery/views/gallery/tmpl/default.php:115
    14include JROOT/components/com_joomgallery/views/gallery/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/gallery/view.html.php:456
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.]

  43. Query Time: 3.63 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 14.681 MB Rows returned: 21
    SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
    
      FROM cca_joomgallery
      GROUP BY catid
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgalleryNULLindexidx_catididx_catid4NULL1673100.00NULL
    Profile
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.02 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data3.21 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
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/components/com_joomgallery/helpers/ambit.php:508
    19JoomAmbit->getCategoryStructure()JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:720
    18JHtmlJoomGallery::categoryTree()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    16Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    15Joomla\CMS\HTML\HTMLHelper::_()JROOT/components/com_joomgallery/views/gallery/tmpl/default.php:115
    14include JROOT/components/com_joomgallery/views/gallery/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/gallery/view.html.php:456
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.]

  44. Query Time: 0.36 ms After last query: 0.53 ms Query memory: 0.028 MB Memory before query: 14.705 MB Rows returned: 1
    SELECT alias
    
      FROM cca_joomgallery_catg
      WHERE cid = 25
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.02 ms
    query end0.01 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/components/com_joomgallery/router.php:310
    26JoomGalleryBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    25Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:532
    24Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    23Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    22Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    21Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    20Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    19Joomla\CMS\Router\Route::_()JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:914
    18JHtmlJoomGallery::categoryTree()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    16Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    15Joomla\CMS\HTML\HTMLHelper::_()JROOT/components/com_joomgallery/views/gallery/tmpl/default.php:115
    14include JROOT/components/com_joomgallery/views/gallery/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/gallery/view.html.php:456
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.]

  45. Query Time: 0.26 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 14.718 MB Rows returned: 1
    SELECT alias
    
      FROM cca_joomgallery_catg
      WHERE cid = 24
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEcca_joomgallery_catgNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profile
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    27JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/router.php:310
    26JoomGalleryBuildRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    25Joomla\CMS\Component\Router\RouterLegacy->build()JROOT/libraries/src/Router/SiteRouter.php:532
    24Joomla\CMS\Router\SiteRouter->buildSefRoute()JROOT/libraries/src/Router/SiteRouter.php:502
    23Joomla\CMS\Router\SiteRouter->_buildSefRoute()JROOT/libraries/src/Router/Router.php:281
    22Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    21Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    20Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    19Joomla\CMS\Router\Route::_()JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:914
    18JHtmlJoomGallery::categoryTree()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    16Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    15Joomla\CMS\HTML\HTMLHelper::_()JROOT/components/com_joomgallery/views/gallery/tmpl/default.php:115
    14include JROOT/components/com_joomgallery/views/gallery/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_joomgallery/view.php:171
    11JoomGalleryView->display()JROOT/components/com_joomgallery/views/gallery/view.html.php:456
    10JoomGalleryViewGallery->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_joomgallery/controller.php:100
    8JoomGalleryController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_joomgallery/joomgallery.php:41
    6require_once JROOT/components/com_joomgallery/joomgallery.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.]

  46. Query Time: 0.72 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 14.732 MB Rows returned: 1
    SELECT MAX(imgdate)
    
      FROM cca_joomgallery AS a
      LEFT JOIN cca_joomgallery_catg AS c
      ON c.cid = a.catid
      WHERE a.catid IN (24)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_catididx_catid4const131100.00NULL
    1SIMPLEcNULLconstPRIMARYPRIMARY4const1100.00Using index
    Profile
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.33 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    20JDatabaseDriver->loadResult()JROOT/components/com_joomgallery/helpers/helper.php:213
    19JoomHelper::checkNewCatg()JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:938
    18JHtmlJoomGallery::categoryTree()Same as call in the line belo