SOLO
  • Contact
  • Home
  • Statistics
    • Economic Statistics
      • Balance of Payments
      • Consumer Price Index
      • Government Finance
      • International Trade
      • National Accounts
        • GDP by Economic Activity
        • Gross Domestic Product (GDP) and per capita GDP
    • Demographic Statistics
      • Census
      • HIES
      • DHS
    • Social Statistics
      • Social General
      • Population
      • Health
      • Education
      • Labour Force
    • Visitor Arrivals
    • Millennium Development Goals
    • Mapping
  • About
  • Links
  • SINSO Documents
  • Press Releases
  • Census 2019
  • Home
  • Statistics
  • Demographic Statistics

Demographic Statistics

Census

Household Income and Expenditure Surveys

Demographic and Health Surveys

Statistics Menu

  • Economic Statistics
    • Balance of Payments
    • Consumer Price Index
    • Government Finance
    • International Trade
    • National Accounts
      • GDP by Economic Activity
      • Gross Domestic Product (GDP) and per capita GDP
  • Demographic Statistics
    • Census
    • HIES
    • DHS
  • Social Statistics
    • Social General
    • Population
    • Health
    • Education
    • Labour Force
  • Visitor Arrivals
  • Millennium Development Goals
  • Mapping

PopGIS3 Solomon Islands

Government Links

  • National Parliament
  • Ministry of Commerce
  • Ministry of Finance and Treasury
  • Ministry of Education

Organisation Links

  • NZ Statistics
  • Australian Statistics
  • DFAT - Solomon Is.
  • ADB Solomon Is.
  • UNICEF Solomon Is.
  • WHO Solomon Is.
  • World Bank Solomon Is.
  • JICA Solomon Is.

Quick Links

  • About Us
  • Contact
  • Document Library

Pacific Community

  • SPC Prism
  • SPC Statistics for Development Division
  • PopGIS2 Regional Mapping
  • Pacific CRVS
  • NMDI
  • Privacy Policy
  • Terms of Use
  • Disclaimer
Copyright © 2023 Solomon Islands National Statistics Office
Back to top

    Joomla! Debug Console

    Session

    {
        "__default": {
            "session": {
                "counter": 1,
                "timer": {
                    "start": 1685525831,
                    "last": 1685525831,
                    "now": 1685525831
                },
                "client": {
                    "forwarded": "3.230.152.133"
                },
                "token": "ifR3ceNVBV47g5QOT7pQJSU10FHUlswQ"
            },
            "registry": {},
            "user": {
                "id": 0,
                "name": null,
                "username": null,
                "email": null,
                "password": null,
                "password_clear": "",
                "block": null,
                "sendEmail": 0,
                "registerDate": null,
                "lastvisitDate": null,
                "activation": null,
                "params": null,
                "groups": [],
                "guest": 1,
                "lastResetTime": null,
                "resetCount": null,
                "requireReset": null,
                "aid": 0
            }
        }
    }

    Profile Information

    Time

    Memory

    Time: 6.11 ms / 6.11 ms Memory: 0.410 MB / 0.76 MB Application: afterLoad
    Time: 24.50 ms / 30.60 ms Memory: 0.977 MB / 1.73 MB Application: afterInitialise
    Time: 8.49 ms / 39.10 ms Memory: 0.462 MB / 2.19 MB Application: afterRoute
    Time: 1.53 ms / 40.63 ms Memory: 0.113 MB / 2.31 MB Application: beforeRenderComponent com_content
    Time: 1.56 ms / 42.19 ms Memory: 0.151 MB / 2.46 MB Application: Before Access::preloadComponents (all components)
    Time: 0.76 ms / 42.95 ms Memory: 0.056 MB / 2.51 MB Application: After Access::preloadComponents (all components)
    Time: 0.02 ms / 42.97 ms Memory: -0.003 MB / 2.51 MB Application: Before Access::preloadPermissions (com_content)
    Time: 0.84 ms / 43.81 ms Memory: 0.160 MB / 2.67 MB Application: After Access::preloadPermissions (com_content)
    Time: 0.03 ms / 43.84 ms Memory: -0.011 MB / 2.66 MB Application: Before Access::getAssetRules (id:40 name:com_content.category.92)
    Time: 0.26 ms / 44.10 ms Memory: 0.009 MB / 2.67 MB Application: After Access::getAssetRules (id:40 name:com_content.category.92)
    Time: 1.82 ms / 45.91 ms Memory: 0.121 MB / 2.79 MB Application: Before Access::getAssetRules (id:8 name:com_content)
    Time: 0.06 ms / 45.98 ms Memory: 0.007 MB / 2.80 MB Application: After Access::getAssetRules (id:8 name:com_content)
    Time: 7.70 ms / 53.68 ms Memory: 0.152 MB / 2.95 MB Application: afterRenderComponent com_content
    Time: 1.35 ms / 55.03 ms Memory: 0.017 MB / 2.97 MB Application: afterDispatch
    Time: 3.93 ms / 58.96 ms Memory: 0.139 MB / 3.10 MB Application: beforeRenderModule mod_jextboxfooter (Copyright Footer)
    Time: 0.49 ms / 59.45 ms Memory: 0.017 MB / 3.12 MB Application: afterRenderModule mod_jextboxfooter (Copyright Footer)
    Time: 0.05 ms / 59.50 ms Memory: -0.010 MB / 3.11 MB Application: beforeRenderModule mod_menu (Site Policy)
    Time: 0.88 ms / 60.38 ms Memory: 0.027 MB / 3.14 MB Application: afterRenderModule mod_menu (Site Policy)
    Time: 0.05 ms / 60.44 ms Memory: -0.003 MB / 3.14 MB Application: beforeRenderModule mod_menu (Pacific Community)
    Time: 0.70 ms / 61.13 ms Memory: 0.015 MB / 3.15 MB Application: afterRenderModule mod_menu (Pacific Community)
    Time: 0.05 ms / 61.19 ms Memory: -0.003 MB / 3.15 MB Application: beforeRenderModule mod_menu (Quick Links)
    Time: 0.62 ms / 61.81 ms Memory: 0.013 MB / 3.16 MB Application: afterRenderModule mod_menu (Quick Links)
    Time: 0.05 ms / 61.86 ms Memory: -0.002 MB / 3.16 MB Application: beforeRenderModule mod_menu (Organisation Links)
    Time: 0.65 ms / 62.51 ms Memory: 0.019 MB / 3.18 MB Application: afterRenderModule mod_menu (Organisation Links)
    Time: 0.05 ms / 62.56 ms Memory: -0.003 MB / 3.18 MB Application: beforeRenderModule mod_menu (Government Links)
    Time: 0.45 ms / 63.01 ms Memory: 0.012 MB / 3.19 MB Application: afterRenderModule mod_menu (Government Links)
    Time: 0.05 ms / 63.06 ms Memory: 0.001 MB / 3.19 MB Application: beforeRenderModule mod_ap_accordion_menu (Statistics Menu)
    Time: 3.17 ms / 66.23 ms Memory: 0.117 MB / 3.31 MB Application: afterRenderModule mod_ap_accordion_menu (Statistics Menu)
    Time: 0.03 ms / 66.26 ms Memory: -0.011 MB / 3.29 MB Application: beforeRenderModule mod_custom (PopGIS3 Solomon Islands)
    Time: 0.32 ms / 66.57 ms Memory: 0.006 MB / 3.30 MB Application: afterRenderModule mod_custom (PopGIS3 Solomon Islands)
    Time: 0.05 ms / 66.63 ms Memory: 0.003 MB / 3.30 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
    Time: 0.50 ms / 67.13 ms Memory: 0.014 MB / 3.32 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
    Time: 0.05 ms / 67.18 ms Memory: -0.004 MB / 3.31 MB Application: beforeRenderModule mod_menu (Main Menu)
    Time: 2.43 ms / 69.61 ms Memory: 0.064 MB / 3.38 MB Application: afterRenderModule mod_menu (Main Menu)
    Time: 0.06 ms / 69.67 ms Memory: -0.004 MB / 3.37 MB Application: beforeRenderModule mod_search (Search)
    Time: 0.43 ms / 70.09 ms Memory: 0.015 MB / 3.39 MB Application: afterRenderModule mod_search (Search)
    Time: 0.05 ms / 70.14 ms Memory: -0.005 MB / 3.38 MB Application: beforeRenderModule mod_custom (Logo)
    Time: 0.12 ms / 70.26 ms Memory: 0.003 MB / 3.39 MB Application: afterRenderModule mod_custom (Logo)
    Time: 15.62 ms / 85.88 ms Memory: 0.111 MB / 3.50 MB Application: afterRender

    Database queries total: 17.50 ms

    Memory Usage

    3.89 MB (4,077,848 Bytes)

    Database Queries

    27 Queries Logged 17.50 ms


    1. Query Time: 0.30 ms Query memory: 0.023 MB Memory before query: 1.036 MB Rows returned: 0
      SELECT `data`
      
        FROM `sol1_session`
        WHERE `session_id` = X'346968696b6467736e69626861397476636272746c6965637271'
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_sessionconstPRIMARYPRIMARY194const1
      Profile
      StatusDuration
      Starting0.04 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.01 ms
      Statistics0.04 ms
      Preparing0.01 ms
      Executing0.01 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.01 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.01 ms
      Reset for next command0.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:826
      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:386
      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.39 ms Query memory: 0.020 MB Memory before query: 1.051 MB Rows returned: 0
      SELECT `session_id`
      
        FROM `sol1_session`
        WHERE `session_id` = X'346968696b6467736e69626861397476636272746c6965637271'
        LIMIT 1
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_sessionconstPRIMARYPRIMARY194const1Using index
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.01 ms
      Optimizing0.01 ms
      Statistics0.02 ms
      Preparing0.01 ms
      Executing0.01 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.04 ms
      Reset for next command0.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:828
      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:386
      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: 3.96 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.056 MB
      INSERT INTO `sol1_session`
      (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES (X'346968696b6467736e69626861397476636272746c6965637271', 1, 1685525831, 0, '', 0)
      Explain
      EXPLAIN not possible on query: INSERT INTO `sol1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'346968696b6467736e69626861397476636272746c6965637271', 1, 1685525831, 0, '', 0)
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.00 ms
      Init for update0.01 ms
      Update0.07 ms
      Waiting for query cache lock0.01 ms
      Update0.01 ms
      End of update loop0.00 ms
      Query end0.00 ms
      Commit3.73 ms
      Closing tables0.01 ms
      Unlocking tables0.01 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.01 ms
      Reset for next command0.00 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:828
      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:386
      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.50 ms After last query: 0.52 ms Query memory: 0.024 MB Memory before query: 1.088 MB Rows returned: 39
      SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
      
        FROM `sol1_extensions`
        WHERE `type` = 'component'
        AND `state` = 0
        AND `enabled` = 1
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_extensionsrefextensionextension82const42Using index condition; Using where
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.01 ms
      System lock0.01 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.02 ms
      Statistics0.05 ms
      Preparing0.03 ms
      Executing0.00 ms
      Sending data0.15 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 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.23 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 1.114 MB Rows returned: 3
      SELECT id, rules
      
        FROM `sol1_viewlevels`
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL3
      Profile
      StatusDuration
      Starting0.02 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.01 ms
      Optimizing0.01 ms
      Statistics0.01 ms
      Preparing0.01 ms
      Executing0.00 ms
      Sending data0.03 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
      9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
      8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
      7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
      6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
      5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
      4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
      3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    6. Query Time: 0.31 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.125 MB Rows returned: 1
      SELECT b.id
      
        FROM sol1_usergroups AS a
        LEFT JOIN sol1_usergroups AS b
        ON b.lft <= a.lft
        AND b.rgt >= a.rgt
        WHERE a.id = 1
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEaconstPRIMARYPRIMARY4const1
      1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL1Using where; Using index
      Profile
      StatusDuration
      Starting0.04 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.01 ms
      Optimizing0.01 ms
      Statistics0.05 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.02 ms
      Executing0.00 ms
      Sending data0.02 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 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: 0.82 ms After last query: 0.17 ms Query memory: 0.030 MB Memory before query: 1.147 MB Rows returned: 85
      SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
      
        FROM sol1_extensions
        WHERE enabled = 1
        AND type = 'plugin'
        AND state IN (0,1)
        AND access IN (1,1)
        ORDER BY ordering
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_extensionsrefextensionextension82const135Using index condition; Using where; Using filesort
      Profile
      StatusDuration
      Starting0.04 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.02 ms
      Statistics0.04 ms
      Preparing0.02 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.01 ms
      Creating sort index0.48 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 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.25 ms After last query: 10.35 ms Query memory: 0.020 MB Memory before query: 1.719 MB Rows returned: 1
      SELECT count(*)
      
        FROM `sol1_cwgears_schedule`
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_cwgears_scheduleindexNULLPRIMARY4NULL1Using index
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.01 ms
      Optimizing0.01 ms
      Statistics0.01 ms
      Preparing0.01 ms
      Executing0.00 ms
      Sending data0.03 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
      9JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:85
      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:668
      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: 0.24 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.726 MB Rows returned: 1
      SELECT count(*)
      
        FROM `sol1_cwgears_schedule`
        WHERE time + '86400'<'1685525831'
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_cwgears_scheduleALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.01 ms
      Statistics0.01 ms
      Preparing0.01 ms
      Executing0.00 ms
      Sending data0.02 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
      9JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:128
      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:668
      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: 1.03 ms After last query: 0.86 ms Query memory: 0.092 MB Memory before query: 1.761 MB Rows returned: 63
      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 sol1_menu AS m
        LEFT JOIN sol1_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_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const75Using index condition; Using where; Using filesort
      1SIMPLEeeq_refPRIMARYPRIMARY4zbsqaxnbat.m.component_id1Using where
      Profile
      StatusDuration
      Starting0.05 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.02 ms
      Statistics0.04 ms
      Preparing0.03 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.01 ms
      Creating sort index0.55 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.03 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
      17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{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/Menu/SiteMenu.php:101
      14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
      13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
      12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
      11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
      10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
      9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
      8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
      7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:533
      6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
      5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1141
      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.]

    11. Query Time: 0.33 ms After last query: 3.06 ms Query memory: 0.024 MB Memory before query: 2.159 MB Rows returned: 1
      SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
      
        FROM `sol1_extensions`
        WHERE `type` = 'library'
        AND `element` = 'joomla'
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.01 ms
      Statistics0.06 ms
      Preparing0.02 ms
      Executing0.01 ms
      Sending data0.04 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.01 ms
      Reset for next command0.00 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/plugins/system/zenshortcodes/zenshortcodes.php:30
      8plgSystemzenshortcodes->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:1190
      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.]

    12. Query Time: 2.11 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 2.151 MB
      UPDATE `sol1_extensions`
      
        SET `params` = '{\"mediaversion\":\"fc3f793a351d7facc5a8facee5671240\"}'
        WHERE `type` = 'library'
        AND `element` = 'joomla'
      Explain
      EXPLAIN not possible on query: UPDATE `sol1_extensions` SET `params` = '{\"mediaversion\":\"fc3f793a351d7facc5a8facee5671240\"}' WHERE `type` = 'library' AND `element` = 'joomla'
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.00 ms
      Init for update0.06 ms
      Updating0.05 ms
      End of update loop0.01 ms
      Waiting for query cache lock0.00 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit1.85 ms
      Closing tables0.01 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 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/plugins/system/zenshortcodes/zenshortcodes.php:30
      8plgSystemzenshortcodes->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:1190
      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.]

    13. Query Time: 0.24 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 2.171 MB Rows returned: 1
      SELECT count(*)
      
        FROM `sol1_extensions`
        WHERE `element` = 'cwgears'
        AND `extension_id` = ''
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.01 ms
      Statistics0.02 ms
      Preparing0.01 ms
      Executing0.01 ms
      End of update loop0.00 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
      10JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/cwgears.php:971
      9plgSystemCwgears->updateDownloadKeySub()JROOT/plugins/system/cwgears/cwgears.php:188
      8plgSystemCwgears->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:1190
      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.]

    14. Query Time: 0.31 ms After last query: 0.85 ms Query memory: 0.019 MB Memory before query: 2.207 MB Rows returned: 1
      SELECT *
      
        FROM sol1_languages
        WHERE published=1
        ORDER BY ordering ASC
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where; Using filesort
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.01 ms
      Statistics0.01 ms
      Preparing0.01 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.01 ms
      Creating sort index0.04 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 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.]

    15. Query Time: 0.41 ms After last query: 0.20 ms Query memory: 0.019 MB Memory before query: 2.219 MB Rows returned: 2
      SELECT id, home, template, s.params
      
        FROM sol1_template_styles as s
        LEFT JOIN sol1_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_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsALLidx_template,idx_client_id,idx_client_id_homeNO INDEX KEY COULD BE USEDNULLNULL8Using where
      1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403zbsqaxnbat.s.template,const1Using index condition; Using where
      Profile
      StatusDuration
      Starting0.06 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.02 ms
      Statistics0.06 ms
      Preparing0.03 ms
      Executing0.01 ms
      Sending data0.06 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
      4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
      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.]

    16. Query Time: 0.58 ms After last query: 2.08 ms Query memory: 0.028 MB Memory before query: 2.463 MB Rows returned: 39
      SELECT `id`,`name`,`rules`,`parent_id`
      
        FROM `sol1_assets`
        WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advlisting','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_files','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tabulizer','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_assetsALLidx_asset_nameNO INDEX KEY COULD BE USEDNULLNULL243Using where
      Profile
      StatusDuration
      Starting0.05 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.01 ms
      Statistics0.08 ms
      Preparing0.01 ms
      Executing0.00 ms
      Sending data0.23 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
      18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
      17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
      16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
      15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
      14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
      13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
      12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
      11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    17. Query Time: 0.52 ms After last query: 0.19 ms Query memory: 0.040 MB Memory before query: 2.515 MB Rows returned: 162
      SELECT `id`,`name`,`rules`,`parent_id`
      
        FROM `sol1_assets`
        WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_assetsALLidx_asset_name,idx_parent_idNO INDEX KEY COULD BE USEDNULLNULL243Using where
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.01 ms
      Statistics0.04 ms
      Preparing0.02 ms
      Executing0.00 ms
      Sending data0.20 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
      18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
      17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
      16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
      15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
      14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
      13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
      12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
      11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    18. Query Time: 0.83 ms After last query: 0.98 ms Query memory: 0.028 MB Memory before query: 2.675 MB Rows returned: 7
      SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
      				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
      				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
      				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
        FROM `sol1_content` AS `i`
        WHERE i.`catid` = c.id
        AND i.state = 1) AS numitems
        FROM `sol1_categories` AS `s`
        INNER JOIN `sol1_categories` AS `c`
        ON (s.lft <= c.lft
        AND c.lft < s.rgt) OR (c.lft < s.lft
        AND s.rgt < c.rgt)
        WHERE (c.extension='com_content' OR c.extension='system')
        AND c.published = 1
        AND s.id = 92
        ORDER BY c.lft
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1
      1PRIMARYcrangecat_idx,idx_left_rightidx_left_right4NULL8Using index condition; Using where
      2DEPENDENT SUBQUERYirefidx_state,idx_catididx_catid4zbsqaxnbat.c.id1Using index condition; Using where
      Profile
      StatusDuration
      Starting0.11 ms
      Checking permissions0.01 ms
      Opening tables0.03 ms
      After opening tables0.01 ms
      System lock0.01 ms
      Table lock0.01 ms
      Init0.05 ms
      Optimizing0.02 ms
      Statistics0.08 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.02 ms
      Optimizing0.01 ms
      Statistics0.03 ms
      Preparing0.03 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.07 ms
      Executing0.01 ms
      Sending data0.04 ms
      Executing0.00 ms
      Sending data0.02 ms
      Executing0.00 ms
      Sending data0.02 ms
      Executing0.00 ms
      Sending data0.01 ms
      Executing0.00 ms
      Sending data0.03 ms
      Executing0.01 ms
      Sending data0.02 ms
      Executing0.00 ms
      Sending data0.02 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Removing tmp table0.01 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
      15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
      14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
      13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
      12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
      11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    19. Query Time: 0.69 ms After last query: 0.67 ms Query memory: 0.024 MB Memory before query: 2.797 MB Rows returned: 0
      SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
        CASE WHEN c.published = 2
        AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
        CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
        CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
        CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
        FROM sol1_content AS a
        LEFT JOIN sol1_categories AS c
        ON c.id = a.catid
        LEFT JOIN sol1_users AS ua
        ON ua.id = a.created_by
        LEFT JOIN sol1_users AS uam
        ON uam.id = a.modified_by
        LEFT JOIN sol1_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN sol1_content_rating AS v
        ON a.id = v.content_id
        WHERE a.access IN (1,1)
        AND c.access IN (1,1)
        AND c.published = 1
        AND a.state = 1
        AND a.catid = 92
        AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-31 09:37:11')
        AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-31 09:37:11')
        ORDER BY
        CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
        LIMIT 108
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
      1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const1Using where; Using filesort
      1SIMPLEuaeq_refPRIMARYPRIMARY4zbsqaxnbat.a.created_by1Using where
      1SIMPLEuameq_refPRIMARYPRIMARY4zbsqaxnbat.a.modified_by1Using where
      1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
      1SIMPLEveq_refPRIMARYPRIMARY4zbsqaxnbat.a.id1Using where
      Profile
      StatusDuration
      Starting0.15 ms
      Checking permissions0.01 ms
      Opening tables0.03 ms
      After opening tables0.01 ms
      System lock0.01 ms
      Table lock0.01 ms
      Init0.07 ms
      Optimizing0.04 ms
      Statistics0.09 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.03 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.02 ms
      Creating sort index0.03 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
      16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
      15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
      14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
      13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
      12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
      11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    20. Query Time: 0.44 ms After last query: 0.27 ms Query memory: 0.024 MB Memory before query: 2.819 MB Rows returned: 1
      SELECT COUNT(*)
      
        FROM sol1_content AS a
        LEFT JOIN sol1_categories AS c
        ON c.id = a.catid
        LEFT JOIN sol1_users AS ua
        ON ua.id = a.created_by
        LEFT JOIN sol1_users AS uam
        ON uam.id = a.modified_by
        LEFT JOIN sol1_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN sol1_content_rating AS v
        ON a.id = v.content_id
        WHERE a.access IN (1,1)
        AND c.access IN (1,1)
        AND c.published = 1
        AND a.state = 1
        AND a.catid = 92
        AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-31 09:37:11')
        AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-31 09:37:11')
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
      1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const1Using where
      Profile
      StatusDuration
      Starting0.06 ms
      Checking permissions0.01 ms
      Opening tables0.03 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.03 ms
      Statistics0.09 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.03 ms
      Executing0.00 ms
      Sending data0.02 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
      17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
      16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
      15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
      14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
      13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
      12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
      11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    21. Query Time: 0.39 ms After last query: 0.35 ms Query memory: 0.022 MB Memory before query: 2.828 MB Rows returned: 0
      SELECT `m`.`tag_id`,`t`.*
      
        FROM `sol1_contentitem_tag_map` AS m
        INNER JOIN `sol1_tags` AS t
        ON `m`.`tag_id` = `t`.`id`
        WHERE `m`.`type_alias` = 'com_content.category'
        AND `m`.`content_item_id` = 92
        AND `t`.`published` = 1
        AND t.access IN (1,1)
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
      1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4zbsqaxnbat.m.tag_id1Using where
      Profile
      StatusDuration
      Starting0.07 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.02 ms
      Statistics0.05 ms
      Preparing0.02 ms
      Executing0.00 ms
      Sending data0.03 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
      12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
      11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    22. Query Time: 0.54 ms After last query: 3.35 ms Query memory: 0.031 MB Memory before query: 2.929 MB Rows returned: 4
      SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
      				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
      				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
      				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
        FROM `sol1_categories` AS `s`
        INNER JOIN `sol1_categories` AS `c`
        ON (s.lft <= c.lft
        AND c.lft < s.rgt) OR (c.lft < s.lft
        AND s.rgt < c.rgt)
        WHERE (c.extension='com_content' OR c.extension='system')
        AND c.access IN (1,1)
        AND c.published = 1
        AND s.id = 111
        ORDER BY c.lft
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
      1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL6Using index condition; Using where
      Profile
      StatusDuration
      Starting0.08 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.02 ms
      Statistics0.08 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.05 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.07 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      30JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      29JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
      28Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
      27Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
      26ContentRouter->getCategorySegment()Same as call in the line below.
      25call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
      24Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
      23Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
      22Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
      21Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
      20Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
      19Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
      18Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
      17Joomla\CMS\Router\Route::_()JROOT/templates/ascent2/html/com_content/category/blog_children.php:42
      16include JROOT/templates/ascent2/html/com_content/category/blog_children.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
      15Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/templates/ascent2/html/com_content/category/blog.php:107
      14include JROOT/templates/ascent2/html/com_content/category/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
      13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
      12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
      11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    23. Query Time: 0.50 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 2.962 MB Rows returned: 4
      SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
      				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
      				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
      				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
        FROM `sol1_categories` AS `s`
        INNER JOIN `sol1_categories` AS `c`
        ON (s.lft <= c.lft
        AND c.lft < s.rgt) OR (c.lft < s.lft
        AND s.rgt < c.rgt)
        WHERE (c.extension='com_content' OR c.extension='system')
        AND c.access IN (1,1)
        AND c.published = 1
        AND s.id = 112
        ORDER BY c.lft
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
      1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL7Using index condition; Using where
      Profile
      StatusDuration
      Starting0.08 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.02 ms
      Statistics0.07 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.02 ms
      Sorting result0.02 ms
      Executing0.00 ms
      Sending data0.07 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      30JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      29JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
      28Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
      27Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
      26ContentRouter->getCategorySegment()Same as call in the line below.
      25call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
      24Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
      23Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
      22Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
      21Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
      20Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
      19Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
      18Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
      17Joomla\CMS\Router\Route::_()JROOT/templates/ascent2/html/com_content/category/blog_children.php:42
      16include JROOT/templates/ascent2/html/com_content/category/blog_children.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
      15Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/templates/ascent2/html/com_content/category/blog.php:107
      14include JROOT/templates/ascent2/html/com_content/category/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
      13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
      12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
      11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    24. Query Time: 0.48 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 2.981 MB Rows returned: 4
      SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
      				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
      				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
      				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
        FROM `sol1_categories` AS `s`
        INNER JOIN `sol1_categories` AS `c`
        ON (s.lft <= c.lft
        AND c.lft < s.rgt) OR (c.lft < s.lft
        AND s.rgt < c.rgt)
        WHERE (c.extension='com_content' OR c.extension='system')
        AND c.access IN (1,1)
        AND c.published = 1
        AND s.id = 113
        ORDER BY c.lft
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
      1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL8Using index condition; Using where
      Profile
      StatusDuration
      Starting0.07 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.02 ms
      Statistics0.07 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.02 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.07 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      30JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      29JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
      28Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
      27Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/router.php:72
      26ContentRouter->getCategorySegment()Same as call in the line below.
      25call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
      24Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
      23Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
      22Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
      21Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
      20Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
      19Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
      18Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
      17Joomla\CMS\Router\Route::_()JROOT/templates/ascent2/html/com_content/category/blog_children.php:42
      16include JROOT/templates/ascent2/html/com_content/category/blog_children.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
      15Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/templates/ascent2/html/com_content/category/blog.php:107
      14include JROOT/templates/ascent2/html/com_content/category/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
      13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
      12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
      11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
      10ContentViewCategory->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
      9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
      8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
      7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
      6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
      5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
      4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
      3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
      2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    25. Query Time: 0.76 ms After last query: 2.13 ms Query memory: 0.026 MB Memory before query: 3.051 MB Rows returned: 12
      SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      
        FROM sol1_modules AS m
        LEFT JOIN sol1_modules_menu AS mm
        ON mm.moduleid = m.id
        LEFT JOIN sol1_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 <= '2023-05-31 09:37:11')
        AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 09:37:11')
        AND m.access IN (1,1)
        AND m.client_id = 0
        AND (mm.menuid = 283 OR mm.menuid <= 0)
        ORDER BY m.position, m.ordering
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEmrefPRIMARY,published,newsfeedspublished1const23Using index condition; Using where; Using filesort
      1SIMPLEmmrefPRIMARYPRIMARY4zbsqaxnbat.m.id1Using where; Using index
      1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403zbsqaxnbat.m.module,const1Using index condition; Using where
      Profile
      StatusDuration
      Starting0.06 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.06 ms
      Statistics0.05 ms
      Preparing0.04 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.01 ms
      Creating sort index0.30 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.01 ms
      Updating status0.01 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      17JDatabaseDriver->loadObjectList()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/ModuleHelper.php:441
      14Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
      13Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
      12Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
      11Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/ascent2/zengrid/zen.php:1016
      10Zen4->getMainLayout()JROOT/templates/ascent2/zengrid/zen.php:591
      9Zen4->bodyclass()JROOT/templates/ascent2/tpls/default.php:12
      8include JROOT/templates/ascent2/tpls/default.phpJROOT/templates/ascent2/index.php:37
      7require JROOT/templates/ascent2/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
      6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
      5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
      4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
      3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
      2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    26. Query Time: 0.24 ms After last query: 14.09 ms Query memory: 0.022 MB Memory before query: 3.387 MB Rows returned: 0
      SELECT uikit
      
        FROM `sol1_cwgears`
        WHERE url = 'https://www.statistics.gov.sb/statistics/demographic-statistics'
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_cwgearsALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.01 ms
      Optimizing0.01 ms
      Statistics0.01 ms
      Preparing0.01 ms
      Executing0.00 ms
      Sending data0.02 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.01 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
      14JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/helpers/loadcount.php:65
      13CwGearsHelperLoadcount::getCounts()JROOT/plugins/system/cwgears/cwgears.php:398
      12plgSystemCwgears->onBeforeCompileHead()JROOT/libraries/joomla/event/event.php:70
      11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
      10JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
      9Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
      8Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
      7Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
      6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
      5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
      4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
      3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
      2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    27. Query Time: 0.21 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 3.394 MB Rows returned: 0
      SELECT uikit_plus
      
        FROM `sol1_cwgears`
        WHERE url = 'https://www.statistics.gov.sb/statistics/demographic-statistics'
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_cwgearsALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
      Profile
      StatusDuration
      Starting0.02 ms
      Checking permissions0.01 ms
      Opening tables0.01 ms
      After opening tables0.00 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.01 ms
      Optimizing0.01 ms
      Statistics0.01 ms
      Preparing0.01 ms
      Executing0.00 ms
      Sending data0.02 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Unlocking tables0.00 ms
      Closing tables0.01 ms
      Starting cleanup0.00 ms
      Freeing items0.00 ms
      Updating status0.01 ms
      Reset for next command0.00 ms
      Call Stack
      #CallerFile and line number
      15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
      14JDatabaseDriver->loadResult()JROOT/plugins/system/cwgears/helpers/loadcount.php:65
      13CwGearsHelperLoadcount::getCounts()JROOT/plugins/system/cwgears/cwgears.php:407
      12plgSystemCwgears->onBeforeCompileHead()JROOT/libraries/joomla/event/event.php:70
      11JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
      10JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
      9Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
      8Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
      7Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:511
      6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
      5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
      4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
      3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
      2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
      1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
      [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    23 Query Types Logged, Sorted by Occurrences.

    SELECT Tables:
    1. 3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
        FROM `sol1_categories` AS `s`
        INNER JOIN `sol1_categories` AS `c`
        ON (s.lft <= c.lft
        AND c.lft < s.rgt) OR (c.lft < s.lft
        AND s.rgt < c.rgt)
    2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
        FROM `sol1_assets`
    3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
        FROM `sol1_extensions`
    4. 1 × SELECT `data` 
        FROM `sol1_session`
    5. 1 × SELECT uikit 
        FROM `sol1_cwgears`
    6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
        FROM sol1_modules AS m
        LEFT JOIN sol1_modules_menu AS mm
        ON mm.moduleid = m.id
        LEFT JOIN sol1_extensions AS e
        ON e.element = m.module
        AND e.client_id = m.client_id
    7. 1 × SELECT `m`.`tag_id`,`t`.* 
        FROM `sol1_contentitem_tag_map` AS m
        INNER JOIN `sol1_tags` AS t
        ON `m`.`tag_id` = `t`.`id`
    8. 1 × SELECT COUNT(*) 
        FROM sol1_content AS a
        LEFT JOIN sol1_categories AS c
        ON c.id = a.catid
        LEFT JOIN sol1_users AS ua
        ON ua.id = a.created_by
        LEFT JOIN sol1_users AS uam
        ON uam.id = a.modified_by
        LEFT JOIN sol1_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN sol1_content_rating AS v
        ON a.id = v.content_id
    9. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
        CASE WHEN c.published = 2
        AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
        CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
        CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
        CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
        FROM sol1_content AS a
        LEFT JOIN sol1_categories AS c
        ON c.id = a.catid
        LEFT JOIN sol1_users AS ua
        ON ua.id = a.created_by
        LEFT JOIN sol1_users AS uam
        ON uam.id = a.modified_by
        LEFT JOIN sol1_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN sol1_content_rating AS v
        ON a.id = v.content_id
    10. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
        FROM `sol1_content` AS `i`
    11. 1 × SELECT * 
        FROM sol1_languages
    12. 1 × SELECT id, home, template, s.params 
        FROM sol1_template_styles as s
        LEFT JOIN sol1_extensions as e
        ON e.element=s.template
        AND e.type='template'
        AND e.client_id=s.client_id
    13. 1 × SELECT `session_id` 
        FROM `sol1_session`
    14. 1 × SELECT count(*) 
        FROM `sol1_extensions`
    15. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
        FROM sol1_menu AS m
        LEFT JOIN sol1_extensions AS e
        ON m.component_id = e.extension_id
    16. 1 × SELECT count(*) 
        FROM `sol1_cwgears_schedule`
    17. 1 × SELECT count(*) 
        FROM `sol1_cwgears_schedule
    18. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
        FROM sol1_extensions
    19. 1 × SELECT b.id 
        FROM sol1_usergroups AS a
        LEFT JOIN sol1_usergroups AS b
        ON b.lft <= a.lft
        AND b.rgt >= a.rgt
    20. 1 × SELECT id, rules 
        FROM `sol1_viewlevels
    21. 1 × SELECT uikit_plus 
        FROM `sol1_cwgears`
    OTHER Tables:
    1. 1 × INSERT INTO `sol1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
        VALUES (X'346968696b6467736e69626861397476636272746c6965637271', 1, 1685525831, 0, '', 0
    2. 1 × UPDATE `sol1_extensions` 
        SET `params` = '{\"mediaversion\":\"fc3f793a351d7facc5a8facee5671240\"}'