• +265 1 766 098
  • +265 1 774 766
  • pslands@lands.gov.mw
Ministry of Lands
  • Home
  • About us
    • Our History
    • About the Ministry
    • Top Management
    • Frequently Asked Questions (FAQ`s)
  • Our Projects
  • Departments & Functions
    • Department of Surveys
    • Department of Physical Planning
    • Department of Lands
    • Department of Housing
    • Department of Urban Development
  • Resources
    • Vacancies
    • Downloads
    • Archives
    • Forms
    • Land Registration Process
    • National Land Policy
  • Media Center
    • Public Notices
    • Latest News
    • Press Statements
    • Photo Gallery
  • Contact Us
    • Headquarters
    • Regional Offices
      • Physical Planning
      • Lands
      • Surveys
      • Housing
      • Urban Development

About us

  1. You are here:  
  2. Home
  3. About us
  • Show All
  • Home
  • Office
  • Outdoor
Visualize impactful mindshare
Zoom View

Visualize impactful mindshare

Home
Enable value-added convergence
Zoom View

Enable value-added convergence

Office
Visualize vertical interfaces
Zoom View

Visualize vertical interfaces

Home
Integrate clicks-and-mortar methodologies
Zoom View

Integrate clicks-and-mortar methodologies

Outdoor
Streamline customized models
Zoom View

Streamline customized models

Outdoor
Architect ubiquitous deliverables
Zoom View

Architect ubiquitous deliverables

Home
Repurpose viral metrics
Zoom View

Repurpose viral metrics

Home
Repurpose viral metrics
Zoom View

Repurpose viral metrics

Home

About us

The Ministry was established to administer and manage Land and Housing issues by ensuring equitable access and secure tenure for everyone. Thus, the Ministry is the custodian of the Malawi National Land Policy and Land Laws in the Country.

Our Partners

Word Bank

Food and Agriculture Organization of the United Nations 

United States Agency for International Development

 

 

Useful Links

  • Malawi Government
  • National Planning Commission
  • AGCOM
  • Malawi Revenue Authority

Photos

280317479 122624300401165 7344821954161273636 N
280317479 122624300401165 7344821954161273636 N
Download
Download
279421678 120014133995515 5922973277987555264 N
279421678 120014133995515 5922973277987555264 N
Index5
Index5
279282723 118800830783512 435711921793563889 N
279282723 118800830783512 435711921793563889 N
Img 20210801 Wa0004
Img 20210801 Wa0004
© {2022} Designed and Developed by Department of E-Government.
  • Home
  • About us
    • Our History
    • About the Ministry
    • Top Management
    • Frequently Asked Questions (FAQ`s)
  • Our Projects
  • Departments & Functions
    • Department of Surveys
    • Department of Physical Planning
    • Department of Lands
    • Department of Housing
    • Department of Urban Development
  • Resources
    • Vacancies
    • Downloads
    • Archives
    • Forms
    • Land Registration Process
    • National Land Policy
  • Media Center
    • Public Notices
    • Latest News
    • Press Statements
    • Photo Gallery
  • Contact Us
    • Headquarters
    • Regional Offices
      • Physical Planning
      • Lands
      • Surveys
      • Housing
      • Urban Development

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695770703,
                "last": 1695770703,
                "now": 1695770703
            }
        },
        "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: 57.36 ms / 57.36 ms Memory: 1.369 MB / 1.70 MB Application: afterLoad
Time: 105.08 ms / 162.44 ms Memory: 3.361 MB / 5.07 MB Application: afterInitialise
Time: 39.73 ms / 202.18 ms Memory: 1.100 MB / 6.17 MB Application: afterRoute
Time: 2.93 ms / 205.11 ms Memory: 0.081 MB / 6.25 MB Application: beforeRenderComponent com_spsimpleportfolio
Time: 33.32 ms / 238.43 ms Memory: 1.057 MB / 7.30 MB Application: afterRenderComponent com_spsimpleportfolio
Time: 2.59 ms / 241.02 ms Memory: 0.095 MB / 7.40 MB Application: afterDispatch
Time: 38.75 ms / 279.77 ms Memory: 0.730 MB / 8.13 MB Application: beforeRenderModule mod_menu (Offcanvas)
Time: 9.33 ms / 289.10 ms Memory: 0.188 MB / 8.32 MB Application: afterRenderModule mod_menu (Offcanvas)
Time: 0.07 ms / 289.17 ms Memory: 0.000 MB / 8.31 MB Application: beforeRenderModule mod_speasyimagegallery (Photos)
Time: 6.21 ms / 295.38 ms Memory: 0.062 MB / 8.37 MB Application: afterRenderModule mod_speasyimagegallery (Photos)
Time: 0.06 ms / 295.44 ms Memory: 0.000 MB / 8.35 MB Application: beforeRenderModule mod_menu (Useful Links)
Time: 0.64 ms / 296.08 ms Memory: 0.013 MB / 8.37 MB Application: afterRenderModule mod_menu (Useful Links)
Time: 0.04 ms / 296.12 ms Memory: 0.000 MB / 8.36 MB Application: beforeRenderModule mod_custom (Our Partners)
Time: 2.52 ms / 298.64 ms Memory: 0.005 MB / 8.37 MB Application: afterRenderModule mod_custom (Our Partners)
Time: 0.08 ms / 298.72 ms Memory: 0.000 MB / 8.37 MB Application: beforeRenderModule mod_custom (About us)
Time: 0.13 ms / 298.85 ms Memory: 0.003 MB / 8.37 MB Application: afterRenderModule mod_custom (About us)
Time: 0.03 ms / 298.89 ms Memory: 0.000 MB / 8.37 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 5.33 ms / 304.22 ms Memory: 0.043 MB / 8.41 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 5.12 ms / 309.34 ms Memory: 0.109 MB / 8.52 MB Application: afterRender

Database queries total: 11.79 ms

Memory Usage

8.86 MB (9,285,328 Bytes)

Database Queries

25 Queries Logged 11.79 ms


8 duplicate found!

4 duplicates: #14  #16  #19  #20
2 duplicates: #15  #21
2 duplicates: #17  #18
  1. Query Time: 0.45 ms Query memory: 0.023 MB Memory before query: 3.229 MB Rows returned: 0
    SELECT `data`
    
      FROM `icfs7_session`
      WHERE `session_id` = X'6d6a376174616f68626f6d763633626a6e386c37646262366470'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    Starting0.05 ms
    Checking permissions0.02 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 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.01 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 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:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:758
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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.33 ms After last query: 3.00 ms Query memory: 0.020 MB Memory before query: 3.318 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `icfs7_session`
      WHERE `session_id` = X'6d6a376174616f68626f6d763633626a6e386c37646262366470'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_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.00 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
    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:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 0.35 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 3.323 MB
    INSERT INTO `icfs7_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6d6a376174616f68626f6d763633626a6e386c37646262366470', 1, 1695770703, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `icfs7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6d6a376174616f68626f6d763633626a6e386c37646262366470', 1, 1695770703, 0, '', 0)
    Profile
    StatusDuration
    Starting0.02 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init for update0.01 ms
    Update0.05 ms
    Waiting for query cache lock0.00 ms
    Update0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Waiting for query cache lock0.00 ms
    Unlocking tables0.02 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 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:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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.61 ms After last query: 8.26 ms Query memory: 0.024 MB Memory before query: 3.578 MB Rows returned: 40
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `icfs7_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_extensionsrefextensionextension82const37Using 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.00 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.13 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.02 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:196
    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.35 ms After last query: 6.62 ms Query memory: 0.021 MB Memory before query: 3.756 MB Rows returned: 5
    SELECT id, rules
    
      FROM `icfs7_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    Starting0.02 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 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.02 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:321
    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:196
    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.39 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 3.768 MB Rows returned: 2
    SELECT b.id
    
      FROM icfs7_usergroups AS a
      LEFT JOIN icfs7_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where
    Profile
    StatusDuration
    Starting0.04 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.02 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.02 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:321
    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:196
    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.97 ms After last query: 1.57 ms Query memory: 0.030 MB Memory before query: 3.834 MB Rows returned: 83
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM icfs7_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_extensionsrefextensionextension82const108Using index condition; Using where; Using filesort
    Profile
    StatusDuration
    Starting0.04 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.03 ms
    Optimizing0.01 ms
    Statistics0.08 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.47 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.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:354
    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:359
    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:196
    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: 1.08 ms After last query: 44.93 ms Query memory: 0.068 MB Memory before query: 5.236 MB Rows returned: 37
    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 icfs7_menu AS m
      LEFT JOIN icfs7_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_language1const1Using index condition; Using where; Using filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4lands_dbs.m.component_id1Using where
    Profile
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.40 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/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:76
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:64
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1073
    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:196
    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.66 ms After last query: 29.94 ms Query memory: 0.025 MB Memory before query: 5.950 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `icfs7_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using index condition
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.02 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.16 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.03 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.03 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/helixultimate/helixultimate.php:134
    8plgSystemHelixultimate->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:1122
    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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 0.48 ms After last query: 0.14 ms Query memory: 0.006 MB Memory before query: 5.943 MB
    UPDATE `icfs7_extensions`
    
      SET `params` = '{\"mediaversion\":\"21757af3e48ac5b19ab6222eb8356cdb\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `icfs7_extensions` SET `params` = '{\"mediaversion\":\"21757af3e48ac5b19ab6222eb8356cdb\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.03 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init for update0.12 ms
    Updating0.05 ms
    End of update loop0.00 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.01 ms
    Waiting for query cache lock0.00 ms
    Unlocking tables0.01 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 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/helixultimate/helixultimate.php:134
    8plgSystemHelixultimate->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:1122
    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:196
    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.40 ms After last query: 3.10 ms Query memory: 0.019 MB Memory before query: 6.170 MB Rows returned: 1
    SELECT *
    
      FROM icfs7_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_languagessystemNULLNO INDEX KEY COULD BE USEDNULLNULL1
    Profile
    StatusDuration
    Starting0.03 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.02 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:196
    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: 0.61 ms After last query: 0.18 ms Query memory: 0.019 MB Memory before query: 6.181 MB Rows returned: 3
    SELECT id, home, template, s.params
    
      FROM icfs7_template_styles as s
      LEFT JOIN icfs7_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
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const2
    1SIMPLEerangeelement_clientid,element_folder_clientid,extensionextension82NULL4Using index condition; Using where; Using join buffer (flat, BNL join)
    Profile
    StatusDuration
    Starting0.03 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.09 ms
    Preparing0.07 ms
    Executing0.00 ms
    Sending data0.09 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.02 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:196
    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.66 ms After last query: 16.61 ms Query memory: 0.042 MB Memory before query: 6.771 MB Rows returned: 8
    SELECT a.*, a.id AS spsimpleportfolio_item_id , a.tagids AS spsimpleportfolio_tag_id,c.title AS category_title, c.alias AS category_alias
    
      FROM `icfs7_spsimpleportfolio_items` AS `a`
      LEFT JOIN icfs7_categories AS c
      ON c.id = a.catid
      WHERE a.access IN (1,1,5)
      AND a.language in ('en-GB','*')
      AND a.published = 1
      ORDER BY a.ordering ASC
      LIMIT 12
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL8Using where; Using filesort
    1SIMPLEceq_refPRIMARYPRIMARY4lands_dbs.a.catid1
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.18 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:1701
    14JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    12Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_spsimpleportfolio/models/items.php:68
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.32 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 6.810 MB Rows returned: 1
    Duplicate queries: #16  #19  #20
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (1)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.02 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 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/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.32 ms After last query: 2.55 ms Query memory: 0.022 MB Memory before query: 6.898 MB Rows returned: 1
    Duplicate queries: #21
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (2)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.02 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 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/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.29 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 6.906 MB Rows returned: 1
    Duplicate queries: #14  #19  #20
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (1)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.01 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.02 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/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.29 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 6.916 MB Rows returned: 1
    Duplicate queries: #18
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (3)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.01 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.29 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 6.925 MB Rows returned: 1
    Duplicate queries: #17
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (3)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.01 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.28 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 6.933 MB Rows returned: 1
    Duplicate queries: #14  #16  #20
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (1)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.02 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.29 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 6.941 MB Rows returned: 1
    Duplicate queries: #14  #16  #19
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (1)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.02 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.29 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 6.949 MB Rows returned: 1
    Duplicate queries: #15
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (2)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsconstPRIMARYPRIMARY8const1
    Profile
    StatusDuration
    Starting0.01 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.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.00 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
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/components/com_spsimpleportfolio/models/items.php:180
    12SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:82
    11SpsimpleportfolioModelItems->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:21
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.39 ms After last query: 2.85 ms Query memory: 0.023 MB Memory before query: 7.036 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM `icfs7_spsimpleportfolio_items` AS `a`
      LEFT JOIN icfs7_categories AS c
      ON c.id = a.catid
      WHERE a.access IN (1,1,5)
      AND a.language in ('en-GB','*')
      AND a.published = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL8Using where
    Profile
    StatusDuration
    Starting0.03 ms
    Checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.03 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.02 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/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    13Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    12Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    11Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    10Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:22
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.32 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 7.041 MB Rows returned: 3
    SELECT `id`,`title`,`alias`
    
      FROM `icfs7_spsimpleportfolio_tags`
      WHERE `id` IN (1,2,3)
      ORDER BY id ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEicfs7_spsimpleportfolio_tagsALLPRIMARYNO INDEX KEY COULD BE USEDNULLNULL3Using where; Using filesort
    Profile
    StatusDuration
    Starting0.02 ms
    Checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.00 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
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/components/com_spsimpleportfolio/models/items.php:180
    11SpsimpleportfolioModelItems->getItemTags()JROOT/components/com_spsimpleportfolio/models/items.php:160
    10SpsimpleportfolioModelItems->getTagList()JROOT/components/com_spsimpleportfolio/views/items/view.html.php:23
    9SpsimpleportfolioViewItems->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    8Joomla\CMS\MVC\Controller\BaseController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
    6require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.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:196
    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.84 ms After last query: 39.44 ms Query memory: 0.026 MB Memory before query: 8.128 MB Rows returned: 8
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM icfs7_modules AS m
      LEFT JOIN icfs7_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN icfs7_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-09-26 23:25:03')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-26 23:25:03')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 105 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const3Using index condition; Using where; Using filesort
    1SIMPLEmmrefPRIMARYPRIMARY4lands_dbs.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_folder_clientid402lands_dbs.m.module11Using index condition; Using where
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.04 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.20 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.03 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()Same as call in the line below.
    17call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:432
    15Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    14Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    13Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    12Joomla\CMS\Document\HtmlDocument->countModules()JROOT/plugins/system/helixultimate/core/helixultimate.php:570
    11HelixUltimate->count_modules()JROOT/plugins/system/helixultimate/core/helixultimate.php:374
    10HelixUltimate->get_current_row()JROOT/plugins/system/helixultimate/core/helixultimate.php:306
    9HelixUltimate->get_recursive_layout()JROOT/plugins/system/helixultimate/core/helixultimate.php:274
    8HelixUltimate->render_layout()JROOT/templates/shaper_helixultimate/index.php:143
    7require JROOT/templates/shaper_helixultimate/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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.52 ms After last query: 21.27 ms Query memory: 0.024 MB Memory before query: 8.358 MB Rows returned: 6
    SELECT a.*
    
      FROM `icfs7_speasyimagegallery_images` AS `a`
      WHERE `album_id` = '1'
      AND `state` = '1'
      ORDER BY a.ordering DESC
      LIMIT 6
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL19Using where; Using filesort
    Profile
    StatusDuration
    Starting0.05 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.06 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.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    12JDatabaseDriver->loadObjectList()JROOT/modules/mod_speasyimagegallery/helper.php:83
    11ModSpeasyimagegalleryHelper::getImages()JROOT/modules/mod_speasyimagegallery/mod_speasyimagegallery.php:29
    10include JROOT/modules/mod_speasyimagegallery/mod_speasyimagegallery.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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 Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 9 × SELECT `id`,`title`,`alias` 
      FROM `icfs7_spsimpleportfolio_tags`
  2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `icfs7_extensions`
  3. 1 × SELECT `data` 
      FROM `icfs7_session`
  4. 1 × SELECT `session_id` 
      FROM `icfs7_session`
  5. 1 × SELECT id, rules 
      FROM `icfs7_viewlevels
  6. 1 × SELECT b.id 
      FROM icfs7_usergroups AS a
      LEFT JOIN icfs7_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  7. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM icfs7_extensions
  8. 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 icfs7_menu AS m
      LEFT JOIN icfs7_extensions AS e
      ON m.component_id = e.extension_id
  9. 1 × SELECT * 
      FROM icfs7_languages
  10. 1 × SELECT id, home, template, s.params 
      FROM icfs7_template_styles as s
      LEFT JOIN icfs7_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  11. 1 × SELECT a.*, a.id AS spsimpleportfolio_item_id , a.tagids AS spsimpleportfolio_tag_id,c.title AS category_title, c.alias AS category_alias 
      FROM `icfs7_spsimpleportfolio_items` AS `a`
      LEFT JOIN icfs7_categories AS c
      ON c.id = a.catid
  12. 1 × SELECT COUNT(*) 
      FROM `icfs7_spsimpleportfolio_items` AS `a`
      LEFT JOIN icfs7_categories AS c
      ON c.id = a.catid
  13. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM icfs7_modules AS m
      LEFT JOIN icfs7_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN icfs7_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  14. 1 × SELECT a.* 
      FROM `icfs7_speasyimagegallery_images` AS `a`
OTHER Tables:
  1. 1 × INSERT INTO `icfs7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'6d6a376174616f68626f6d763633626a6e386c37646262366470', 1, 1695770703, 0, '', 0
  2. 1 × UPDATE `icfs7_extensions` 
      SET `params` = '{\"mediaversion\":\"21757af3e48ac5b19ab6222eb8356cdb\"}'