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
  • Economic Statistics
  • National Accounts
  • GDP by Economic Activity

Gross Domestic Product by Economic Activity

  • Current Prices (SI$'000'000)
  • Constant Prices (SI$'000'000)

Current Prices (SI$'000'000)

{tabulizer:data_source[sDyzmPFvgJ5bJZSR4jQ5vgDJ]}

Constant Prices (SI$'000'000)

{tabulizer:data_source[Wd2PGVPoCht1OhVo3JVYtAnd]}

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": 1685524364,
                    "last": 1685524364,
                    "now": 1685524364
                },
                "client": {
                    "forwarded": "3.230.152.133"
                },
                "token": "667iVF4oih04e9qNz7ZIWq49AqdEHkjO"
            },
            "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.21 ms / 6.21 ms Memory: 0.410 MB / 0.76 MB Application: afterLoad
    Time: 23.49 ms / 29.70 ms Memory: 0.977 MB / 1.73 MB Application: afterInitialise
    Time: 8.70 ms / 38.40 ms Memory: 0.462 MB / 2.20 MB Application: afterRoute
    Time: 1.46 ms / 39.86 ms Memory: 0.113 MB / 2.31 MB Application: beforeRenderComponent com_content
    Time: 1.22 ms / 41.09 ms Memory: 0.116 MB / 2.42 MB Application: Before Access::preloadComponents (all components)
    Time: 0.76 ms / 41.84 ms Memory: 0.055 MB / 2.48 MB Application: After Access::preloadComponents (all components)
    Time: 0.02 ms / 41.87 ms Memory: -0.003 MB / 2.48 MB Application: Before Access::preloadPermissions (com_content)
    Time: 0.83 ms / 42.70 ms Memory: 0.159 MB / 2.64 MB Application: After Access::preloadPermissions (com_content)
    Time: 0.03 ms / 42.72 ms Memory: -0.011 MB / 2.63 MB Application: Before Access::getAssetRules (id:107 name:com_content.article.26)
    Time: 0.22 ms / 42.94 ms Memory: 0.009 MB / 2.63 MB Application: After Access::getAssetRules (id:107 name:com_content.article.26)
    Time: 16.55 ms / 59.49 ms Memory: 0.458 MB / 3.09 MB Application: afterRenderComponent com_content
    Time: 1.38 ms / 60.87 ms Memory: 0.010 MB / 3.10 MB Application: afterDispatch
    Time: 3.96 ms / 64.84 ms Memory: 0.142 MB / 3.24 MB Application: beforeRenderModule mod_jextboxfooter (Copyright Footer)
    Time: 0.50 ms / 65.33 ms Memory: 0.017 MB / 3.26 MB Application: afterRenderModule mod_jextboxfooter (Copyright Footer)
    Time: 0.05 ms / 65.39 ms Memory: -0.010 MB / 3.25 MB Application: beforeRenderModule mod_menu (Site Policy)
    Time: 0.90 ms / 66.29 ms Memory: 0.026 MB / 3.28 MB Application: afterRenderModule mod_menu (Site Policy)
    Time: 0.05 ms / 66.34 ms Memory: -0.003 MB / 3.27 MB Application: beforeRenderModule mod_menu (Pacific Community)
    Time: 0.57 ms / 66.92 ms Memory: 0.015 MB / 3.29 MB Application: afterRenderModule mod_menu (Pacific Community)
    Time: 0.05 ms / 66.97 ms Memory: -0.003 MB / 3.29 MB Application: beforeRenderModule mod_menu (Quick Links)
    Time: 0.61 ms / 67.58 ms Memory: 0.013 MB / 3.30 MB Application: afterRenderModule mod_menu (Quick Links)
    Time: 0.05 ms / 67.63 ms Memory: -0.002 MB / 3.30 MB Application: beforeRenderModule mod_menu (Organisation Links)
    Time: 0.70 ms / 68.34 ms Memory: 0.019 MB / 3.32 MB Application: afterRenderModule mod_menu (Organisation Links)
    Time: 0.05 ms / 68.39 ms Memory: -0.003 MB / 3.31 MB Application: beforeRenderModule mod_menu (Government Links)
    Time: 0.43 ms / 68.82 ms Memory: 0.012 MB / 3.33 MB Application: afterRenderModule mod_menu (Government Links)
    Time: 0.06 ms / 68.88 ms Memory: 0.001 MB / 3.33 MB Application: beforeRenderModule mod_ap_accordion_menu (Statistics Menu)
    Time: 3.13 ms / 72.01 ms Memory: 0.118 MB / 3.44 MB Application: afterRenderModule mod_ap_accordion_menu (Statistics Menu)
    Time: 0.03 ms / 72.04 ms Memory: -0.011 MB / 3.43 MB Application: beforeRenderModule mod_custom (PopGIS3 Solomon Islands)
    Time: 0.36 ms / 72.39 ms Memory: 0.006 MB / 3.44 MB Application: afterRenderModule mod_custom (PopGIS3 Solomon Islands)
    Time: 0.06 ms / 72.45 ms Memory: 0.003 MB / 3.44 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
    Time: 0.59 ms / 73.04 ms Memory: 0.017 MB / 3.46 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
    Time: 0.05 ms / 73.09 ms Memory: -0.005 MB / 3.45 MB Application: beforeRenderModule mod_menu (Main Menu)
    Time: 2.51 ms / 75.60 ms Memory: 0.062 MB / 3.52 MB Application: afterRenderModule mod_menu (Main Menu)
    Time: 0.05 ms / 75.65 ms Memory: -0.004 MB / 3.51 MB Application: beforeRenderModule mod_search (Search)
    Time: 0.40 ms / 76.05 ms Memory: 0.017 MB / 3.53 MB Application: afterRenderModule mod_search (Search)
    Time: 0.07 ms / 76.12 ms Memory: -0.005 MB / 3.52 MB Application: beforeRenderModule mod_custom (Logo)
    Time: 0.13 ms / 76.25 ms Memory: 0.003 MB / 3.53 MB Application: afterRenderModule mod_custom (Logo)
    Time: 17.58 ms / 93.84 ms Memory: 0.103 MB / 3.63 MB Application: afterRender

    Database queries total: 17.88 ms

    Memory Usage

    4.00 MB (4,190,296 Bytes)

    Database Queries

    26 Queries Logged 17.88 ms


    1. Query Time: 0.30 ms Query memory: 0.023 MB Memory before query: 1.037 MB Rows returned: 0
      SELECT `data`
      
        FROM `sol1_session`
        WHERE `session_id` = X'65386934703068706569646e383064626f39746665766f316567'
      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.00 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.23 ms After last query: 0.41 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'65386934703068706569646e383064626f39746665766f316567'
        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.03 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.00 ms
      Updating status0.01 ms
      Reset for next command0.00 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: 2.49 ms After last query: 0.08 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'65386934703068706569646e383064626f39746665766f316567', 1, 1685524364, 0, '', 0)
      Explain
      EXPLAIN not possible on query: INSERT INTO `sol1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'65386934703068706569646e383064626f39746665766f316567', 1, 1685524364, 0, '', 0)
      Profile
      StatusDuration
      Starting0.06 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.09 ms
      Waiting for query cache lock0.01 ms
      Update0.00 ms
      End of update loop0.00 ms
      Query end0.00 ms
      Commit2.22 ms
      Closing tables0.01 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
      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.48 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.00 ms
      System lock0.00 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.24 ms After last query: 0.70 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.30 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.126 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.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.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.84 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.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.02 ms
      Optimizing0.02 ms
      Statistics0.03 ms
      Preparing0.02 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.01 ms
      Creating sort index0.49 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.23 ms After last query: 10.66 ms Query memory: 0.020 MB Memory before query: 1.720 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.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
      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.22 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'<'1685524364'
      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.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.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.01 ms After last query: 0.85 ms Query memory: 0.092 MB Memory before query: 1.762 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.56 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
      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.32 ms After last query: 3.16 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.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
      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.25 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 2.152 MB
      UPDATE `sol1_extensions`
      
        SET `params` = '{\"mediaversion\":\"2a33e675c827b50f3602a22cd1dea0ed\"}'
        WHERE `type` = 'library'
        AND `element` = 'joomla'
      Explain
      EXPLAIN not possible on query: UPDATE `sol1_extensions` SET `params` = '{\"mediaversion\":\"2a33e675c827b50f3602a22cd1dea0ed\"}' WHERE `type` = 'library' AND `element` = 'joomla'
      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.05 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
      Commit2.00 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.51 ms Query memory: 0.021 MB Memory before query: 2.172 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.84 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.01 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.37 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.04 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.02 ms
      Executing0.00 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: 1.72 ms Query memory: 0.027 MB Memory before query: 2.428 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.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.01 ms
      Statistics0.09 ms
      Preparing0.01 ms
      Executing0.00 ms
      Sending data0.22 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/Access/Access.php:429
      16Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
      15Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
      14Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
      13Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
      12Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/article.php:58
      11ContentModelArticle->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
      10Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/components/com_content/models/article.php:251
      9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
      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.50 ms After last query: 0.17 ms Query memory: 0.040 MB Memory before query: 2.479 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
      18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      17JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
      16Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
      15Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
      14Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
      13Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
      12Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/article.php:58
      11ContentModelArticle->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
      10Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/components/com_content/models/article.php:251
      9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
      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.70 ms After last query: 0.75 ms Query memory: 0.031 MB Memory before query: 2.637 MB Rows returned: 31
      SHOW FULL COLUMNS 
        FROM `sol1_content`
      Explain
      EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `sol1_content`
      Profile
      StatusDuration
      Starting0.03 ms
      Checking permissions0.01 ms
      Closing tables0.01 ms
      Opening tables0.20 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
      Filling schema table0.01 ms
      Opening tables0.02 ms
      After opening tables0.01 ms
      Checking permissions0.14 ms
      Closing tables0.01 ms
      Executing0.00 ms
      Sending data0.05 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit0.00 ms
      Closing tables0.00 ms
      Removing tmp table0.08 ms
      Closing tables0.01 ms
      Unlocking tables0.00 ms
      Closing tables0.00 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
      16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      15JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
      14JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:261
      13Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:180
      12Joomla\CMS\Table\Table->__construct()JROOT/libraries/src/Table/Content.php:39
      11Joomla\CMS\Table\Content->__construct()JROOT/libraries/src/Table/Table.php:328
      10Joomla\CMS\Table\Table::getInstance()JROOT/components/com_content/models/article.php:253
      9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
      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: 2.54 ms After last query: 0.87 ms Query memory: 0.005 MB Memory before query: 2.690 MB
      UPDATE sol1_content
      
        SET `hits` = (`hits` + 1)
        WHERE `id` = '26'
      Explain
      EXPLAIN not possible on query: UPDATE sol1_content SET `hits` = (`hits` + 1) WHERE `id` = '26'
      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
      Init for update0.04 ms
      Updating0.05 ms
      End of update loop0.01 ms
      Waiting for query cache lock0.01 ms
      End of update loop0.01 ms
      Query end0.00 ms
      Commit2.29 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
      11JDatabaseDriverMysqli->execute()JROOT/libraries/src/Table/Table.php:1264
      10Joomla\CMS\Table\Table->hit()JROOT/components/com_content/models/article.php:254
      9ContentModelArticle->hit()JROOT/components/com_content/controller.php:113
      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.61 ms After last query: 0.46 ms Query memory: 0.023 MB Memory before query: 2.721 MB Rows returned: 1
      SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
        CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
        FROM sol1_content AS a
        INNER JOIN sol1_categories AS c
        on c.id = a.catid
        LEFT JOIN sol1_users AS u
        on u.id = a.created_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.id = 26
        AND c.published > 0
        AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-05-31 09:12:44')
        AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-05-31 09:12:44')
        AND (a.state = 1 OR a.state =2)
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEaconstPRIMARY,idx_state,idx_catidPRIMARY4const1
      1SIMPLEcconstPRIMARYPRIMARY4const1
      1SIMPLEuconstPRIMARYPRIMARY4const1
      1SIMPLEparentconstPRIMARYPRIMARY4const1
      1SIMPLEvconstPRIMARYPRIMARY4const0Unique row not found
      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.06 ms
      Optimizing0.03 ms
      Statistics0.10 ms
      Preparing0.01 ms
      Unlocking tables0.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.02 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
      14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
      13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:151
      12ContentModelArticle->getItem()JROOT/libraries/src/MVC/View/HtmlView.php:425
      11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/article/view.html.php:42
      10ContentViewArticle->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.37 ms After last query: 0.83 ms Query memory: 0.022 MB Memory before query: 2.818 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.article'
        AND `m`.`content_item_id` = 26
        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.04 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.04 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.01 ms
      Call Stack
      #CallerFile and line number
      13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      12JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
      11Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/views/article/view.html.php:184
      10ContentViewArticle->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.58 ms After last query: 4.78 ms Query memory: 0.027 MB Memory before query: 2.965 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 = 47
        ORDER BY c.lft
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
      1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL62Using where; Using filesort
      Profile
      StatusDuration
      Starting0.08 ms
      Checking permissions0.01 ms
      Opening tables0.02 ms
      After opening tables0.01 ms
      System lock0.00 ms
      Table lock0.01 ms
      Init0.04 ms
      Optimizing0.02 ms
      Statistics0.08 ms
      Preparing0.01 ms
      Unlocking tables0.00 ms
      Preparing0.02 ms
      Sorting result0.01 ms
      Executing0.01 ms
      Sending data0.02 ms
      Creating sort index0.10 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
      21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
      19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
      18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
      17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
      16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
      15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
      14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
      13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
      12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
      11JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:193
      10ContentViewArticle->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.91 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 3.058 MB Rows returned: 0
      SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
      
        FROM sol1_fields AS a
        LEFT JOIN `sol1_languages` AS l
        ON l.lang_code = a.language
        LEFT JOIN sol1_users AS uc
        ON uc.id=a.checked_out
        LEFT JOIN sol1_viewlevels AS ag
        ON ag.id = a.access
        LEFT JOIN sol1_users AS ua
        ON ua.id = a.created_user_id
        LEFT JOIN sol1_fields_groups AS g
        ON g.id = a.group_id
        LEFT JOIN `sol1_fields_categories` AS fc
        ON fc.field_id = a.id
        WHERE a.context = 'com_content.article'
        AND (fc.category_id IS NULL OR fc.category_id IN (47,0,88,110))
        AND a.access IN (1,1)
        AND (a.group_id = 0 OR g.access IN (1,1))
        AND a.state = 1
        AND (a.group_id = 0 OR g.state = 1)
        ORDER BY a.ordering ASC
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
      1SIMPLEleq_refidx_langcodeidx_langcode28zbsqaxnbat.a.language1Using where
      1SIMPLEuceq_refPRIMARYPRIMARY4zbsqaxnbat.a.checked_out1
      1SIMPLEageq_refPRIMARYPRIMARY4zbsqaxnbat.a.access1Using where
      1SIMPLEuaeq_refPRIMARYPRIMARY4zbsqaxnbat.a.created_user_id1Using where
      1SIMPLEgeq_refPRIMARYPRIMARY4zbsqaxnbat.a.group_id1Using where
      1SIMPLEfcrefPRIMARYPRIMARY4zbsqaxnbat.a.id1Using where; Using index; Distinct
      Profile
      StatusDuration
      Starting0.09 ms
      Checking permissions0.01 ms
      Opening tables0.04 ms
      After opening tables0.01 ms
      System lock0.01 ms
      Table lock0.01 ms
      Init0.05 ms
      Optimizing0.03 ms
      Statistics0.10 ms
      Preparing0.04 ms
      Creating tmp table0.06 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.22 ms
      Creating sort index0.02 ms
      Removing tmp table0.04 ms
      Creating sort index0.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.01 ms
      Updating status0.02 ms
      Reset for next command0.01 ms
      Call Stack
      #CallerFile and line number
      19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
      18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
      17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
      16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
      15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
      14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
      13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
      12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
      11JEventDispatcher->trigger()JROOT/components/com_content/views/article/view.html.php:193
      10ContentViewArticle->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.76 ms After last query: 5.36 ms Query memory: 0.026 MB Memory before query: 3.190 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:12:44')
        AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 09:12:44')
        AND m.access IN (1,1)
        AND m.client_id = 0
        AND (mm.menuid = 38 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.01 ms
      Table lock0.01 ms
      Init0.03 ms
      Optimizing0.03 ms
      Statistics0.07 ms
      Preparing0.04 ms
      Sorting result0.01 ms
      Executing0.00 ms
      Sending data0.01 ms
      Creating sort index0.31 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.]

    25. Query Time: 0.28 ms After last query: 14.33 ms Query memory: 0.022 MB Memory before query: 3.528 MB Rows returned: 0
      SELECT uikit
      
        FROM `sol1_cwgears`
        WHERE url = 'https://www.statistics.gov.sb/statistics/economic-statistics/national-accounts/gdp-by-economic-activity'
      Explain
      idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
      1SIMPLEsol1_cwgearsALLNULLNO INDEX KEY COULD BE USEDNULLNULL1Using where
      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.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
      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.]

    26. Query Time: 0.22 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 3.535 MB Rows returned: 0
      SELECT uikit_plus
      
        FROM `sol1_cwgears`
        WHERE url = 'https://www.statistics.gov.sb/statistics/economic-statistics/national-accounts/gdp-by-economic-activity'
      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.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.]

    24 Query Types Logged, Sorted by Occurrences.

    SELECT Tables:
    1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
        FROM `sol1_extensions`
    2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
        FROM `sol1_assets`
    3. 1 × SELECT `data` 
        FROM `sol1_session`
    4. 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
    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 DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
        FROM sol1_fields AS a
        LEFT JOIN `sol1_languages` AS l
        ON l.lang_code = a.language
        LEFT JOIN sol1_users AS uc
        ON uc.id=a.checked_out
        LEFT JOIN sol1_viewlevels AS ag
        ON ag.id = a.access
        LEFT JOIN sol1_users AS ua
        ON ua.id = a.created_user_id
        LEFT JOIN sol1_fields_groups AS g
        ON g.id = a.group_id
        LEFT JOIN `sol1_fields_categories` AS fc
        ON fc.field_id = a.id
    8. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
        CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
        FROM `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)
    9. 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`
    10. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
        CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
        FROM sol1_content AS a
        INNER JOIN sol1_categories AS c
        on c.id = a.catid
        LEFT JOIN sol1_users AS u
        on u.id = a.created_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
    11. 1 × SELECT * 
        FROM sol1_languages
    12. 1 × SELECT `session_id` 
        FROM `sol1_session`
    13. 1 × SELECT count(*) 
        FROM `sol1_extensions`
    14. 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
    15. 1 × SELECT count(*) 
        FROM `sol1_cwgears_schedule`
    16. 1 × SELECT count(*) 
        FROM `sol1_cwgears_schedule
    17. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
        FROM sol1_extensions
    18. 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
    19. 1 × SELECT id, rules 
        FROM `sol1_viewlevels
    20. 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'65386934703068706569646e383064626f39746665766f316567', 1, 1685524364, 0, '', 0
    2. 1 × UPDATE `sol1_extensions` 
        SET `params` = '{\"mediaversion\":\"2a33e675c827b50f3602a22cd1dea0ed\"}'
    3. 1 × SHOW FULL COLUMNS 
        FROM `sol1_content
    4. 1 × UPDATE sol1_content 
        SET `hits` = (`hits` + 1)