SELARC
Southeast Louisiana Amateur Radio Club, Inc
Toggle Navigation
  • Home
  • About
    • More About SELARC
    • Membership Application
    • SE Louisiana Repeaters
    • SELARC Hamfest
    • SELARC Constitution and By-Laws
    • History of SELARC
    • Members
      • SELARC Member Listing
      • Silent Keys
    • SELARC Facebook Group
  • ARES
    • Tangi ARES Homepage
    • Region 9 ARES on Facebook
  • News
  • Gallery
  • Resources
    • Informative Links
    • SE Louisiana Repeaters
    • Amateur Radio Clubs
    • Weather and Storms
    • Packet Radio
    • FCC Regulation, Forms and Licensing
    • Classroom Education & Study
    • Radar and Amateur Radio
    • Amateur Radio Satellites
    • Amateur Radio Callsigns and Repeaters
  • Nets
  • Hamfest

Filters
List of articles in category The Hamster
Title
Monthly Newsletter Info
May 2025, Monthly Newsletter Archive
April 2025, Monthly Newsletter Archive
March 2025, Monthly Newsletter Archive
February 2025, Monthly Newsletter Archive
January 2025, Monthly Newsletter Archive
December 2024, Monthly Newsletter Archive
November 2024, Monthly Newsletter Archive
October 2024, Monthly Newsletter Archive
September 2024, Monthly Newsletter Archive

Page 1 of 10

  • 1
  • 2
  • 3
  • 4
  • ...
  • 6
  • 7
  • 8
  • 9
  • 10
  • You are here:  
  • Home
  • News
  • September 2024, Monthly Newsletter Archive

Older Posts

  • Monthly Newsletter Info
  • May 2025, Monthly Newsletter Archive
  • April 2025, Monthly Newsletter Archive
  • March 2025, Monthly Newsletter Archive
  • February 2025, Monthly Newsletter Archive
  • January 2025, Monthly Newsletter Archive

Popular Tags

  • Links

Photo Gallery - Categories

  • Field Day
  • Special Olympics
  • MS Bike Tour
  • Hamfest
  • Memorial
  • Party
  • Featured Ham Station
  • Special Event Station
    • Strawberry Festival
  • Club Meetings

Most Read Posts

  • July 2019, Monthly Newsletter
  • May 2019 Monthly Hamster
  • June 2019 Monthly Newsletter
  • September 2020, Monthly Newsletter
  • April 2019 Monthly Hamster

  • Author Login

Terms of Use |  Privacy Policy | Cookie Policy

Southeast Louisiana Amateur Radio Club, Inc.  (SELARC)

PO BOX 1324, Hammond, LA 70404

Back to Top

© 2025 SELARC

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1748163941,
                "last": 1748163941,
                "now": 1748163941
            },
            "client": {
                "forwarded": "216.73.216.201"
            },
            "token": "vaWekYGsif40JVDAmw7BEPUMpHIwgmcu"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3djbXMuc2VsYXJjLm9yZy9uZXdzPw%3D%3D"
            }
        },
        "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: 8.30 ms / 8.30 ms Memory: 0.403 MB / 0.74 MB Application: afterLoad
Time: 53.61 ms / 61.91 ms Memory: 1.154 MB / 1.89 MB Application: afterInitialise
Time: 12.86 ms / 74.77 ms Memory: 0.437 MB / 2.33 MB Application: Before Access::preloadComponents (all components)
Time: 2.54 ms / 77.31 ms Memory: 0.061 MB / 2.39 MB Application: After Access::preloadComponents (all components)
Time: 0.08 ms / 77.39 ms Memory: -0.002 MB / 2.39 MB Application: Before Access::getAssetRules (id:16 name:com_menus)
Time: 0.80 ms / 78.18 ms Memory: 0.011 MB / 2.40 MB Application: After Access::getAssetRules (id:16 name:com_menus)
Time: 0.13 ms / 78.31 ms Memory: -0.001 MB / 2.40 MB Application: afterRoute
Time: 5.56 ms / 83.87 ms Memory: 0.052 MB / 2.45 MB Application: beforeRenderComponent com_content
Time: 5.50 ms / 89.37 ms Memory: 0.187 MB / 2.64 MB Application: Before Access::preloadPermissions (com_content)
Time: 2.64 ms / 92.01 ms Memory: 0.144 MB / 2.78 MB Application: After Access::preloadPermissions (com_content)
Time: 0.06 ms / 92.06 ms Memory: -0.011 MB / 2.77 MB Application: Before Access::getAssetRules (id:60 name:com_content.category.12)
Time: 0.24 ms / 92.30 ms Memory: 0.009 MB / 2.78 MB Application: After Access::getAssetRules (id:60 name:com_content.category.12)
Time: 7.28 ms / 99.58 ms Memory: 0.044 MB / 2.82 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.04 ms / 99.61 ms Memory: 0.002 MB / 2.83 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 44.06 ms / 143.67 ms Memory: 0.828 MB / 3.65 MB Application: Before Access::getAssetRules (id:977 name:com_content.article.126)
Time: 0.05 ms / 143.72 ms Memory: 0.002 MB / 3.66 MB Application: After Access::getAssetRules (id:977 name:com_content.article.126)
Time: 0.92 ms / 144.64 ms Memory: 0.019 MB / 3.67 MB Application: Before Access::getAssetRules (id:58 name:com_attachments)
Time: 0.13 ms / 144.77 ms Memory: 0.010 MB / 3.68 MB Application: After Access::getAssetRules (id:58 name:com_attachments)
Time: 0.10 ms / 144.87 ms Memory: 0.001 MB / 3.69 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.02 ms / 144.89 ms Memory: 0.002 MB / 3.69 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 7.93 ms / 152.82 ms Memory: 0.036 MB / 3.72 MB Application: Before Access::getAssetRules (id:987 name:com_content.article.136)
Time: 0.08 ms / 152.90 ms Memory: 0.002 MB / 3.72 MB Application: After Access::getAssetRules (id:987 name:com_content.article.136)
Time: 7.47 ms / 160.37 ms Memory: 0.036 MB / 3.76 MB Application: Before Access::getAssetRules (id:986 name:com_content.article.135)
Time: 0.05 ms / 160.42 ms Memory: 0.002 MB / 3.76 MB Application: After Access::getAssetRules (id:986 name:com_content.article.135)
Time: 7.95 ms / 168.37 ms Memory: 0.027 MB / 3.79 MB Application: Before Access::getAssetRules (id:985 name:com_content.article.134)
Time: 0.04 ms / 168.41 ms Memory: 0.002 MB / 3.79 MB Application: After Access::getAssetRules (id:985 name:com_content.article.134)
Time: 8.13 ms / 176.55 ms Memory: 0.028 MB / 3.82 MB Application: Before Access::getAssetRules (id:984 name:com_content.article.133)
Time: 0.04 ms / 176.59 ms Memory: 0.002 MB / 3.82 MB Application: After Access::getAssetRules (id:984 name:com_content.article.133)
Time: 7.21 ms / 183.80 ms Memory: 0.027 MB / 3.85 MB Application: Before Access::getAssetRules (id:983 name:com_content.article.132)
Time: 0.05 ms / 183.85 ms Memory: 0.002 MB / 3.85 MB Application: After Access::getAssetRules (id:983 name:com_content.article.132)
Time: 8.05 ms / 191.90 ms Memory: 0.028 MB / 3.88 MB Application: Before Access::getAssetRules (id:982 name:com_content.article.131)
Time: 0.05 ms / 191.95 ms Memory: 0.002 MB / 3.88 MB Application: After Access::getAssetRules (id:982 name:com_content.article.131)
Time: 7.43 ms / 199.38 ms Memory: 0.028 MB / 3.91 MB Application: Before Access::getAssetRules (id:981 name:com_content.article.130)
Time: 0.04 ms / 199.42 ms Memory: 0.004 MB / 3.91 MB Application: After Access::getAssetRules (id:981 name:com_content.article.130)
Time: 7.05 ms / 206.48 ms Memory: 0.027 MB / 3.94 MB Application: Before Access::getAssetRules (id:979 name:com_content.article.128)
Time: 0.04 ms / 206.52 ms Memory: 0.002 MB / 3.94 MB Application: After Access::getAssetRules (id:979 name:com_content.article.128)
Time: 8.34 ms / 214.86 ms Memory: 0.028 MB / 3.97 MB Application: Before Access::getAssetRules (id:978 name:com_content.article.127)
Time: 0.05 ms / 214.91 ms Memory: 0.002 MB / 3.97 MB Application: After Access::getAssetRules (id:978 name:com_content.article.127)
Time: 16.54 ms / 231.45 ms Memory: 0.113 MB / 4.08 MB Application: Before Access::getAssetRules (id:802 name:com_content.article.12)
Time: 0.11 ms / 231.56 ms Memory: 0.002 MB / 4.08 MB Application: After Access::getAssetRules (id:802 name:com_content.article.12)
Time: 12.84 ms / 244.41 ms Memory: -0.018 MB / 4.07 MB Application: afterRenderComponent com_content
Time: 3.13 ms / 247.54 ms Memory: 0.013 MB / 4.08 MB Application: afterDispatch
Time: 61.18 ms / 308.72 ms Memory: 0.461 MB / 4.54 MB Application: afterRender

Database queries total: 62.15 ms

Memory Usage

5.42 MB (5,687,480 Bytes)

Database Queries

62 Queries Logged 62.15 ms


  1. Query Time: 0.98 ms Query memory: 0.023 MB Memory before query: 1.024 MB Rows returned: 0
    SELECT `data`
    
      FROM `sjla_session`
      WHERE `session_id` = X'3075376c6264753171696b326466657469767365696571646368'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_sessionconstPRIMARYPRIMARY194const1
    Profile
    StatusDuration
    Starting0.17 ms
    Checking permissions0.02 ms
    Opening tables0.13 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.06 ms
    Optimizing0.04 ms
    Statistics0.11 ms
    Preparing0.01 ms
    Executing0.03 ms
    End of update loop0.03 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Same as call in the line below.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.52 ms After last query: 1.04 ms Query memory: 0.020 MB Memory before query: 1.039 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `sjla_session`
      WHERE `session_id` = X'3075376c6264753171696b326466657469767365696571646368'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_sessionconstPRIMARYPRIMARY194const1Using index
    Profile
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.02 ms
    End of update loop0.00 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.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: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: 1.95 ms After last query: 0.28 ms Query memory: 0.004 MB Memory before query: 1.044 MB
    INSERT INTO `sjla_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3075376c6264753171696b326466657469767365696571646368', 1, 1748163941, 0, '', 0)
    Explain
    EXPLAIN not possible on query: INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3075376c6264753171696b326466657469767365696571646368', 1, 1748163941, 0, '', 0)
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init for update0.04 ms
    Update0.30 ms
    Waiting for query cache lock0.01 ms
    Update0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit1.24 ms
    Closing tables0.02 ms
    Unlocking tables0.01 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php: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.66 ms After last query: 2.98 ms Query memory: 0.021 MB Memory before query: 1.187 MB Rows returned: 5
    SELECT id, rules
    
      FROM `sjla_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.21 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 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
    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.]

  5. Query Time: 1.03 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 1.199 MB Rows returned: 2
    SELECT b.id
    
      FROM sjla_usergroups AS a
      LEFT JOIN sjla_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbindexidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup8NULL9Using where; Using index
    Profile
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.07 ms
    Statistics0.28 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.20 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  6. Query Time: 0.89 ms After last query: 13.54 ms Query memory: 0.021 MB Memory before query: 1.827 MB Rows returned: 1
    SELECT `name`
    
      FROM `sjla_extensions`
      WHERE `type` = 'package'
      AND `element` = 'pkg_eventgallery_full'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_extensionsrefelement_clientid,element_folder_clientid,extensionelement_clientid402const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.06 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.20 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.19 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 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
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    9JDatabaseDriver->loadResult()JROOT/administrator/components/com_eventgallery/version.php:24
    8include_once JROOT/administrator/components/com_eventgallery/version.phpJROOT/plugins/system/picasaupdater/picasaupdater.php:32
    7plgSystemPicasaupdater->__construct()JROOT/libraries/src/Plugin/PluginHelper.php:280
    6Joomla\CMS\Plugin\PluginHelper::import()JROOT/libraries/src/Plugin/PluginHelper.php:182
    5Joomla\CMS\Plugin\PluginHelper::importPlugin()JROOT/libraries/src/Application/CMSApplication.php:667
    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.]

  7. Query Time: 1.83 ms After last query: 33.16 ms Query memory: 0.027 MB Memory before query: 2.334 MB Rows returned: 40
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `sjla_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventgallery','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_assetsALLidx_asset_nameNO INDEX KEY COULD BE USEDNULLNULL241Using where
    Profile
    StatusDuration
    Starting0.13 ms
    Checking permissions0.01 ms
    Opening tables0.11 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.08 ms
    Optimizing0.02 ms
    Statistics0.18 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.92 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.04 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    15Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    14Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    13Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    12Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    11Joomla\CMS\User\User->authorise()JROOT/plugins/system/advancedmodules/src/Document.php:30
    10RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()JROOT/plugins/system/advancedmodules/advancedmodules.php:95
    9PlgSystemAdvancedModules->handleOnAfterRoute()JROOT/libraries/regularlabs/src/SystemPlugin.php:191
    8RegularLabs\Library\SystemPlugin->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.]

  8. Query Time: 1.65 ms After last query: 2.07 ms Query memory: 0.005 MB Memory before query: 2.402 MB
    UPDATE `sjla_extensions`
    
      SET `params` = '{\"mediaversion\":\"2e1b617293393d8b99ea13e9243decad\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    EXPLAIN not possible on query: UPDATE `sjla_extensions` SET `params` = '{\"mediaversion\":\"2e1b617293393d8b99ea13e9243decad\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init for update0.15 ms
    Updating0.18 ms
    End of update loop0.01 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.95 ms
    Closing tables0.01 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.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    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.]

  9. Query Time: 1.37 ms After last query: 8.84 ms Query memory: 0.040 MB Memory before query: 2.641 MB Rows returned: 150
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `sjla_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_assetsALLidx_asset_name,idx_parent_idNO INDEX KEY COULD BE USEDNULLNULL241Using where
    Profile
    StatusDuration
    Starting0.11 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics0.17 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.59 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.03 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/Access/Access.php:359
    19Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    14ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    13Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  10. Query Time: 3.30 ms After last query: 3.28 ms Query memory: 0.026 MB Memory before query: 2.783 MB Rows returned: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `sjla_content` AS `i`
      WHERE i.`catid` = c.id
      AND i.state = 1) AS numitems
      FROM `sjla_categories` AS `s`
      INNER JOIN `sjla_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.published = 1
      AND s.id = 12
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1
    1PRIMARYcALLcat_idx,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL28Using where; Using filesort
    2DEPENDENT SUBQUERYirefidx_state,idx_catididx_catid4jdb7971082.c.id5Using index condition; Using where
    Profile
    StatusDuration
    Starting0.32 ms
    Checking permissions0.01 ms
    Opening tables0.23 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.18 ms
    Optimizing0.06 ms
    Statistics0.24 ms
    Preparing0.01 ms
    Unlocking tables0.01 ms
    Preparing0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.06 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.04 ms
    Creating sort index0.27 ms
    Executing0.01 ms
    Sending data0.06 ms
    Executing0.00 ms
    Sending data0.02 ms
    Executing0.00 ms
    Sending data1.24 ms
    End of update loop0.02 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.02 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Removing tmp table0.01 ms
    Freeing items0.02 ms
    Updating status0.03 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/Categories/Categories.php:324
    16Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    15Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    14ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  11. Query Time: 2.77 ms After last query: 2.26 ms Query memory: 0.158 MB Memory before query: 2.825 MB Rows returned: 10
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
      FROM sjla_content AS a
      LEFT JOIN sjla_categories AS c
      ON c.id = a.catid
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN sjla_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN sjla_categories as parent
      ON parent.id = c.parent_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 12
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-25 09:05:41')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-25 09:05:41')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const99Using where; Using filesort
    1SIMPLEuaeq_refPRIMARYPRIMARY4jdb7971082.a.created_by1Using where
    1SIMPLEuameq_refPRIMARYPRIMARY4jdb7971082.a.modified_by1Using where
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using where
    Profile
    StatusDuration
    Starting0.45 ms
    Checking permissions0.01 ms
    Opening tables0.10 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.15 ms
    Optimizing0.08 ms
    Statistics0.19 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.06 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.05 ms
    Creating sort index1.41 ms
    End of update loop0.02 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.02 ms
    Updating status0.03 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/libraries/src/MVC/Model/ListModel.php:194
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  12. Query Time: 1.03 ms After last query: 1.50 ms Query memory: 0.024 MB Memory before query: 2.995 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 126
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.13 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.07 ms
    Optimizing0.04 ms
    Statistics0.12 ms
    Preparing0.04 ms
    Executing0.00 ms
    Sending data0.26 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.02 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
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  13. Query Time: 0.76 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 3.013 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 136
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.07 ms
    Optimizing0.04 ms
    Statistics0.09 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.19 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.01 ms
    Updating status0.02 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/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  14. Query Time: 0.79 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 3.031 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 135
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.09 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.04 ms
    Statistics0.07 ms
    Preparing0.04 ms
    Executing0.01 ms
    Sending data0.22 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.04 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/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  15. Query Time: 0.74 ms After last query: 0.66 ms Query memory: 0.024 MB Memory before query: 3.048 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 134
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_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.06 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.22 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 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
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  16. Query Time: 0.62 ms After last query: 0.66 ms Query memory: 0.024 MB Memory before query: 3.066 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 133
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.07 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.15 ms
    End of update loop0.00 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.01 ms
    Updating status0.02 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/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.59 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 3.086 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 132
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.04 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.14 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
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 0.88 ms After last query: 0.46 ms Query memory: 0.024 MB Memory before query: 3.104 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 131
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.16 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.21 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 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/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  19. Query Time: 0.58 ms After last query: 0.53 ms Query memory: 0.024 MB Memory before query: 3.122 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 130
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.15 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.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/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  20. Query Time: 0.53 ms After last query: 0.42 ms Query memory: 0.024 MB Memory before query: 3.140 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 128
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.05 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.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/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.75 ms After last query: 0.59 ms Query memory: 0.024 MB Memory before query: 3.158 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 127
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.04 ms
    Optimizing0.03 ms
    Statistics0.06 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.23 ms
    End of update loop0.07 ms
    Query end0.01 ms
    Commit0.01 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.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    16Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    15ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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: 1.11 ms After last query: 0.87 ms Query memory: 0.025 MB Memory before query: 3.173 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM sjla_content AS a
      LEFT JOIN sjla_categories AS c
      ON c.id = a.catid
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN sjla_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN sjla_categories as parent
      ON parent.id = c.parent_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND a.catid = 12
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-25 09:05:41')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-25 09:05:41')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const99Using where
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.05 ms
    Optimizing0.05 ms
    Statistics0.12 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Executing0.00 ms
    Sending data0.47 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.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:1740
    18JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    16Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    15Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    14ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    13Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.65 ms After last query: 0.64 ms Query memory: 0.023 MB Memory before query: 3.177 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 12
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeNO INDEX KEY COULD BE USEDNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4jdb7971082.m.tag_id1Using where
    Profile
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.00 ms
    Init0.06 ms
    Optimizing0.03 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.17 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.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    13Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
    12Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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: 1.22 ms After last query: 6.05 ms Query memory: 0.027 MB Memory before query: 3.435 MB Rows returned: 3
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `sjla_categories` AS `s`
      INNER JOIN `sjla_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,5)
      AND c.published = 1
      AND s.id = 12
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightNO INDEX KEY COULD BE USEDNULLNULL28Using where; Using filesort
    Profile
    StatusDuration
    Starting0.20 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.02 ms
    Table lock0.01 ms
    Init0.10 ms
    Optimizing0.05 ms
    Statistics0.20 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.27 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.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    20Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    19Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    18FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    17Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    15FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    14PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 2.61 ms After last query: 0.62 ms Query memory: 0.025 MB Memory before query: 3.456 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 sjla_fields AS a
      LEFT JOIN `sjla_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sjla_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sjla_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sjla_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `sjla_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 (12,0,9))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28jdb7971082.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4jdb7971082.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4jdb7971082.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4jdb7971082.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4jdb7971082.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4jdb7971082.a.id1Using where; Using index; Distinct
    Profile
    StatusDuration
    Starting0.21 ms
    Checking permissions0.01 ms
    Opening tables0.16 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.11 ms
    Optimizing0.10 ms
    Statistics0.35 ms
    Preparing0.06 ms
    Creating tmp table0.21 ms
    Sorting result0.04 ms
    Executing0.01 ms
    Sending data0.67 ms
    Creating sort index0.07 ms
    Removing tmp table0.12 ms
    Creating sort index0.19 ms
    End of update loop0.02 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.03 ms
    Starting cleanup0.00 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    18Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    17FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    16Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    15FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    14PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  26. Query Time: 0.96 ms After last query: 8.53 ms Query memory: 0.024 MB Memory before query: 3.611 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 126
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.33 ms
    Checking permissions0.02 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.06 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.01 ms
    Executing0.12 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.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  27. Query Time: 0.67 ms After last query: 2.92 ms Query memory: 0.024 MB Memory before query: 3.645 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 126
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.09 ms
    Preparing0.01 ms
    Unlocking tables0.15 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  28. Query Time: 1.07 ms After last query: 1.75 ms Query memory: 0.025 MB Memory before query: 3.686 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=126
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.13 ms
    Checking permissions0.01 ms
    Opening tables0.10 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.09 ms
    Optimizing0.04 ms
    Statistics0.04 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.30 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  29. Query Time: 0.58 ms After last query: 2.86 ms Query memory: 0.024 MB Memory before query: 3.692 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 136
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.18 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  30. Query Time: 0.65 ms After last query: 2.24 ms Query memory: 0.024 MB Memory before query: 3.715 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 136
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.00 ms
    Unlocking tables0.18 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  31. Query Time: 0.80 ms After last query: 1.10 ms Query memory: 0.025 MB Memory before query: 3.731 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=136
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    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.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.23 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.02 ms
    Closing tables0.01 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  32. Query Time: 0.62 ms After last query: 2.28 ms Query memory: 0.024 MB Memory before query: 3.736 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 135
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.01 ms
    Executing0.15 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.02 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  33. Query Time: 0.75 ms After last query: 2.02 ms Query memory: 0.025 MB Memory before query: 3.751 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 135
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.06 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.01 ms
    Unlocking tables0.14 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  34. Query Time: 1.20 ms After last query: 1.04 ms Query memory: 0.025 MB Memory before query: 3.768 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=135
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.11 ms
    Checking permissions0.02 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.04 ms
    Init0.16 ms
    Optimizing0.04 ms
    Statistics0.04 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.28 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.02 ms
    Unlocking tables0.00 ms
    Closing tables0.10 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.08 ms
    Reset for next command0.04 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  35. Query Time: 0.52 ms After last query: 2.81 ms Query memory: 0.024 MB Memory before query: 3.773 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 134
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.13 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.02 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  36. Query Time: 0.49 ms After last query: 2.01 ms Query memory: 0.024 MB Memory before query: 3.782 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 134
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.06 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.02 ms
    Statistics0.05 ms
    Preparing0.00 ms
    Unlocking tables0.12 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 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.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  37. Query Time: 0.96 ms After last query: 0.95 ms Query memory: 0.025 MB Memory before query: 3.798 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=134
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.11 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.07 ms
    Optimizing0.04 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.30 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  38. Query Time: 0.53 ms After last query: 2.95 ms Query memory: 0.024 MB Memory before query: 3.802 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 133
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.02 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.04 ms
    Preparing0.01 ms
    Executing0.12 ms
    End of update loop0.00 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.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  39. Query Time: 0.60 ms After last query: 2.12 ms Query memory: 0.024 MB Memory before query: 3.811 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 133
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.00 ms
    Unlocking tables0.14 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  40. Query Time: 0.76 ms After last query: 1.05 ms Query memory: 0.025 MB Memory before query: 3.827 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=133
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.09 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.07 ms
    Optimizing0.04 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.23 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.02 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  41. Query Time: 0.47 ms After last query: 2.59 ms Query memory: 0.024 MB Memory before query: 3.831 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 132
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.12 ms
    End of update loop0.00 ms
    Query end0.02 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  42. Query Time: 0.58 ms After last query: 1.88 ms Query memory: 0.024 MB Memory before query: 3.840 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 132
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.03 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.00 ms
    Unlocking tables0.14 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.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.02 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  43. Query Time: 0.86 ms After last query: 1.09 ms Query memory: 0.025 MB Memory before query: 3.856 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=132
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.10 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.07 ms
    Optimizing0.08 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.22 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.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  44. Query Time: 0.57 ms After last query: 2.59 ms Query memory: 0.024 MB Memory before query: 3.861 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 131
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.05 ms
    After opening tables0.02 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.01 ms
    Executing0.12 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  45. Query Time: 0.68 ms After last query: 2.22 ms Query memory: 0.024 MB Memory before query: 3.870 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 131
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.04 ms
    Optimizing0.04 ms
    Statistics0.05 ms
    Preparing0.00 ms
    Unlocking tables0.13 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.02 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.01 ms
    Updating status0.02 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  46. Query Time: 0.81 ms After last query: 1.16 ms Query memory: 0.025 MB Memory before query: 3.885 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=131
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.08 ms
    Optimizing0.04 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.04 ms
    Creating sort index0.20 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.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  47. Query Time: 0.83 ms After last query: 2.03 ms Query memory: 0.024 MB Memory before query: 3.890 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 130
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.31 ms
    End of update loop0.09 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.07 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  48. Query Time: 0.66 ms After last query: 1.97 ms Query memory: 0.024 MB Memory before query: 3.899 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 130
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Unlocking tables0.13 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.05 ms
    Updating status0.04 ms
    Reset for next command0.00 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  49. Query Time: 0.86 ms After last query: 1.12 ms Query memory: 0.025 MB Memory before query: 3.917 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=130
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.20 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.07 ms
    Optimizing0.04 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.22 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  50. Query Time: 0.49 ms After last query: 2.16 ms Query memory: 0.024 MB Memory before query: 3.922 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 128
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.04 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.12 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  51. Query Time: 0.50 ms After last query: 2.09 ms Query memory: 0.024 MB Memory before query: 3.930 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 128
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.00 ms
    Unlocking tables0.11 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.02 ms
    Commit0.01 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  52. Query Time: 0.82 ms After last query: 1.07 ms Query memory: 0.025 MB Memory before query: 3.946 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=128
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.10 ms
    Checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.08 ms
    Optimizing0.04 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.22 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  53. Query Time: 0.65 ms After last query: 2.51 ms Query memory: 0.024 MB Memory before query: 3.951 MB Rows returned: 0
    SELECT id
    
      FROM sjla_categories
      WHERE id = 127
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profile
    StatusDuration
    Starting0.07 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.01 ms
    Executing0.16 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.02 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.01 ms
    Starting cleanup0.01 ms
    Freeing items0.01 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:202
    14plgContentAttachments->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:113
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  54. Query Time: 0.82 ms After last query: 2.35 ms Query memory: 0.024 MB Memory before query: 3.959 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 127
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.08 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.03 ms
    Optimizing0.02 ms
    Statistics0.06 ms
    Preparing0.01 ms
    Unlocking tables0.15 ms
    Preparing0.03 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.12 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.00 ms
    Unlocking tables0.00 ms
    Closing tables0.02 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
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    15AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  55. Query Time: 1.02 ms After last query: 1.22 ms Query memory: 0.025 MB Memory before query: 3.976 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=127
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.07 ms
    Optimizing0.03 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    Creating sort index0.28 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 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
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    18AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    17AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    16AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    15AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    14plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    13JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    12JEventDispatcher->trigger()JROOT/components/com_content/views/category/view.html.php:121
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  56. Query Time: 2.31 ms After last query: 5.70 ms Query memory: 0.028 MB Memory before query: 4.027 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 sjla_fields AS a
      LEFT JOIN `sjla_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sjla_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sjla_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sjla_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'com_content.categories'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28jdb7971082.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4jdb7971082.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4jdb7971082.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4jdb7971082.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4jdb7971082.a.group_id1Using where
    Profile
    StatusDuration
    Starting0.19 ms
    Checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.02 ms
    Init0.09 ms
    Optimizing0.05 ms
    Statistics0.25 ms
    Preparing0.14 ms
    Creating tmp table0.09 ms
    Sorting result0.03 ms
    Executing0.01 ms
    Sending data0.58 ms
    Creating sort index0.10 ms
    Removing tmp table0.18 ms
    Creating sort index0.17 ms
    End of update loop0.01 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.03 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    26JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    25Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    24FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    23Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    22FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    21PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:25
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    17Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    16Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    14Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    13Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    12Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  57. Query Time: 2.23 ms After last query: 2.07 ms Query memory: 0.029 MB Memory before query: 4.056 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 sjla_fields AS a
      LEFT JOIN `sjla_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sjla_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sjla_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sjla_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `sjla_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.categories'
      AND (fc.category_id IS NULL OR fc.category_id IN (12,0,9))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; Using filesort
    1SIMPLEleq_refidx_langcodeidx_langcode28jdb7971082.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4jdb7971082.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4jdb7971082.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4jdb7971082.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4jdb7971082.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4jdb7971082.a.id1Using where; Using index; Distinct
    Profile
    StatusDuration
    Starting0.21 ms
    Checking permissions0.02 ms
    Opening tables0.07 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.09 ms
    Optimizing0.05 ms
    Statistics0.14 ms
    Preparing0.06 ms
    Creating tmp table0.07 ms
    Sorting result0.02 ms
    Executing0.00 ms
    Sending data0.64 ms
    Creating sort index0.06 ms
    Removing tmp table0.10 ms
    Creating sort index0.24 ms
    End of update loop0.02 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.00 ms
    Freeing items0.02 ms
    Updating status0.03 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    28JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    27JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    26Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    25FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    24Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    23FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    22PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:324
    21PlgSystemFields->onContentAfterTitle()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:28
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    17Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    16Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    14Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    13Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    12Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  58. Query Time: 0.76 ms After last query: 1.26 ms Query memory: 0.027 MB Memory before query: 4.071 MB Rows returned: 1
    SELECT created_by, catid
    
      FROM sjla_content
      WHERE id = 12
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsjla_contentconstPRIMARYPRIMARY4const1
    Profile
    StatusDuration
    Starting0.06 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.02 ms
    Optimizing0.02 ms
    Statistics0.09 ms
    Preparing0.01 ms
    Unlocking tables0.19 ms
    Preparing0.02 ms
    Executing0.01 ms
    Sending data0.02 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.05 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
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
    22AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()JROOT/plugins/content/attachments/attachments.php:319
    21plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    17Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    16Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    14Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    13Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    12Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  59. Query Time: 0.88 ms After last query: 1.56 ms Query memory: 0.028 MB Memory before query: 4.090 MB Rows returned: 0
    SELECT a.*, u.name as creator_name
    
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
      WHERE a.parent_id=12
      AND a.state = 1
      AND a.parent_type='com_content'
      AND a.parent_entity='article'
      AND a.access IN (1,5)
      ORDER BY filename
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLNULLNO INDEX KEY COULD BE USEDNULLNULL23Using where; Using filesort
    1SIMPLEueq_refPRIMARYPRIMARY4jdb7971082.a.created_by1
    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.07 ms
    Optimizing0.08 ms
    Statistics0.03 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.27 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 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
    27JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    26JDatabaseDriver->loadObjectList()JROOT/components/com_attachments/models/attachments.php:436
    25AttachmentsModelAttachments->getAttachmentsList()JROOT/components/com_attachments/models/attachments.php:514
    24AttachmentsModelAttachments->someVisible()JROOT/components/com_attachments/controllers/attachments.php:98
    23AttachmentsControllerAttachments->displayString()JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
    22AttachmentsPlugin->insertAttachmentsList()JROOT/plugins/content/attachments/attachments.php:325
    21plgContentAttachments->onContentBeforeDisplay()JROOT/libraries/joomla/event/event.php:70
    20JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    19JEventDispatcher->trigger()JROOT/layouts/joomla/content/category_default.php:31
    18include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/src/Layout/FileLayout.php:125
    17Joomla\CMS\Layout\FileLayout->render()JROOT/libraries/src/Layout/LayoutHelper.php:73
    16Joomla\CMS\Layout\LayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    15include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    14Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    13Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    12Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    11ContentViewCategory->display()JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10Joomla\CMS\Cache\Controller\ViewController->get()JROOT/libraries/src/MVC/Controller/BaseController.php:655
    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.]

  60. Query Time: 1.27 ms After last query: 11.53 ms Query memory: 0.020 MB Memory before query: 4.077 MB Rows returned: 0
    SELECT folder.*
    
      FROM `sjla_eventgallery_folder` AS folder
      LEFT JOIN `sjla_eventgallery_file` AS file
      ON folder.folder = file.folder
      and file.published=1
      and file.ismainimage=0
      WHERE file.file IS NULL
      AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEfolderALLNULLNO INDEX KEY COULD BE USEDNULLNULL28Using where
    1SIMPLEfilereffile,index_folderfile377jdb7971082.folder.folder3Using where; Not exists
    Profile
    StatusDuration
    Starting0.12 ms
    Checking permissions0.01 ms
    Opening tables0.09 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.11 ms
    Optimizing0.08 ms
    Statistics0.03 ms
    Preparing0.04 ms
    Executing0.00 ms
    Sending data0.37 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.02 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    8JDatabaseDriver->loadObjectList()JROOT/plugins/system/picasaupdater/picasaupdater.php:80
    7plgSystemPicasaupdater->onAfterDispatch()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/SiteApplication.php:199
    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.]

  61. Query Time: 1.98 ms After last query: 3.22 ms Query memory: 0.043 MB Memory before query: 4.106 MB Rows returned: 19
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM sjla_modules AS m
      LEFT JOIN sjla_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      LEFT JOIN sjla_advancedmodules as am
      ON am.moduleid = m.id
      WHERE m.published = 1
      AND e.enabled = 1
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefpublished,newsfeedspublished1const22Using index condition; Using where; Using filesort
    1SIMPLEameq_refPRIMARYPRIMARY4jdb7971082.m.id1Using where
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403jdb7971082.m.module,const1Using index condition; Using where
    Profile
    StatusDuration
    Starting0.14 ms
    Checking permissions0.01 ms
    Opening tables0.07 ms
    After opening tables0.02 ms
    System lock0.01 ms
    Table lock0.01 ms
    Init0.06 ms
    Optimizing0.04 ms
    Statistics0.10 ms
    Preparing0.04 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    Creating sort index1.09 ms
    End of update loop0.06 ms
    Query end0.01 ms
    Commit0.01 ms
    Closing tables0.01 ms
    Unlocking tables0.00 ms
    Closing tables0.03 ms
    Starting cleanup0.01 ms
    Freeing items0.02 ms
    Updating status0.02 ms
    Reset for next command0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
    14PlgSystemAdvancedModuleHelper->getModuleList()JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
    13PlgSystemAdvancedModuleHelper->onPrepareModuleList()JROOT/libraries/joomla/event/dispatcher.php:165
    12JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    11Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Helper/ModuleHelper.php:366
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:91
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php: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.]

  62. Query Time: 1.11 ms After last query: 54.98 ms Query memory: 0.026 MB Memory before query: 4.484 MB Rows returned: 2
    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 `sjla_categories` AS `s`
      INNER JOIN `sjla_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,5)
      AND c.published = 1
      AND s.id = 2
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL2Using index condition; Using where
    Profile
    StatusDuration
    Starting0.17 ms
    Checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    Init0.08 ms
    Optimizing0.05 ms
    Statistics0.18 ms
    Preparing0.01 ms
    Unlocking tables0.00 ms
    Preparing0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.27 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.01 ms
    Updating status0.02 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/components/com_content/router.php:72
    17ContentRouter->getCategorySegment()Same as call in the line below.
    16call_user_func_array()JROOT/libraries/src/Component/Router/RouterView.php:120
    15Joomla\CMS\Component\Router\RouterView->getPath()JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()JROOT/libraries/src/Component/Router/RouterView.php:222
    13Joomla\CMS\Component\Router\RouterView->preprocess()JROOT/libraries/src/Router/SiteRouter.php:676
    12Joomla\CMS\Router\SiteRouter->processBuildRules()JROOT/libraries/src/Router/Router.php:266
    11Joomla\CMS\Router\Router->build()JROOT/libraries/src/Router/SiteRouter.php:155
    10Joomla\CMS\Router\SiteRouter->build()JROOT/libraries/src/Router/Route.php:144
    9Joomla\CMS\Router\Route::link()JROOT/libraries/src/Router/Route.php:93
    8Joomla\CMS\Router\Route::_()JROOT/plugins/system/sef/sef.php:110
    7PlgSystemSef->onAfterRender()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:1118
    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.]

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 11 × SELECT `m`.`tag_id`,`t`.* 
      FROM `sjla_contentitem_tag_map` AS m
      INNER JOIN `sjla_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 11 × SELECT created_by, catid 
      FROM sjla_content
  3. 11 × SELECT a.*, u.name as creator_name 
      FROM sjla_attachments AS a
      LEFT JOIN sjla_users AS u
      ON u.id = a.created_by
  4. 10 × SELECT id 
      FROM sjla_categories
  5. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `sjla_assets`
  6. 2 × 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 `sjla_categories` AS `s`
      INNER JOIN `sjla_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  7. 2 × 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 sjla_fields AS a
      LEFT JOIN `sjla_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sjla_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sjla_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sjla_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `sjla_fields_categories` AS fc
      ON fc.field_id = a.id
  8. 1 × SELECT `data` 
      FROM `sjla_session`
  9. 1 × SELECT `session_id` 
      FROM `sjla_session`
  10. 1 × SELECT id, rules 
      FROM `sjla_viewlevels
  11. 1 × SELECT b.id 
      FROM sjla_usergroups AS a
      LEFT JOIN sjla_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  12. 1 × SELECT `name` 
      FROM `sjla_extensions`
  13. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
      FROM `sjla_content` AS `i`
  14. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
      FROM sjla_content AS a
      LEFT JOIN sjla_categories AS c
      ON c.id = a.catid
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN sjla_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN sjla_categories as parent
      ON parent.id = c.parent_id
  15. 1 × SELECT COUNT(*) 
      FROM sjla_content AS a
      LEFT JOIN sjla_categories AS c
      ON c.id = a.catid
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN sjla_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN sjla_categories as parent
      ON parent.id = c.parent_id
  16. 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 sjla_fields AS a
      LEFT JOIN `sjla_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN sjla_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN sjla_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN sjla_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN sjla_fields_groups AS g
      ON g.id = a.group_id
  17. 1 × SELECT folder.* 
      FROM `sjla_eventgallery_folder` AS folder
      LEFT JOIN `sjla_eventgallery_file` AS file
      ON folder.folder = file.folder
      and file.published=1
      and file.ismainimage=0
  18. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
      FROM sjla_modules AS m
      LEFT JOIN sjla_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      LEFT JOIN sjla_advancedmodules as am
      ON am.moduleid = m.id
OTHER Tables:
  1. 1 × INSERT INTO `sjla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3075376c6264753171696b326466657469767365696571646368', 1, 1748163941, 0, '', 0
  2. 1 × UPDATE `sjla_extensions` 
      SET `params` = '{\"mediaversion\":\"2e1b617293393d8b99ea13e9243decad\"}'