Lets Go Publish!

Main Menu

  • Home
  • LGP Books
  • LGP Technical (IBM i) Books
  • LGP Joomla! Books
  • Book Stores
  • LGP! on Joomla!
  • Downloads
  • Acknowledgments
  • The News
  • RPG /RPGIV Tutorial 2nd Edition
  • IBM: They Call Me the Squanderer!
  • Thank You IBM Materials

Thank You IBM

Title Author Hits
How to buy Thank You IBM Written by Administrator Hits: 175
Thank You IBM Chapter 1 Written by Administrator Hits: 181
Thank You IBM Table Of Contents Written by Administrator Hits: 187
Thank You IBM Preface Written by Administrator Hits: 183

Patriotic & Tech Books

  • What's In the Books?
  • Link to Patriotic Books
  • Link to IBM i Tech Books
  • Obama's Seven Deadly Sins
  • Taxation Without Representation
  • Healthcare Accountability
  • Political Donations- Authors

LGP Learning

  • What is IBM i?
  • Help Beyond LGP! Books

Back to Top

© 2026 Lets Go Publish!

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 23.05 ms / 23.05 ms Memory: 0.142 MB / 0.51 MB Application: afterLoad
Time: 84.19 ms / 107.24 ms Memory: 0.989 MB / 1.49 MB Application: afterInitialise
Time: 15.90 ms / 123.14 ms Memory: 0.282 MB / 1.78 MB Application: afterRoute
Time: 8.74 ms / 131.88 ms Memory: 0.129 MB / 1.91 MB Application: beforeRenderComponent com_content
Time: 24.50 ms / 156.38 ms Memory: 0.206 MB / 2.11 MB Application: Start JAccess::getAssetRules Old (1)
Time: 1.97 ms / 158.35 ms Memory: 0.079 MB / 2.19 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.03 ms / 158.38 ms Memory: 0.000 MB / 2.19 MB Application: New JAccess Preloading Process(com_content.category)
Time: 0.78 ms / 159.16 ms Memory: 0.070 MB / 2.26 MB Application: After preloadPermissionsParentIdMapping (com_content.category)
Time: 2.30 ms / 161.45 ms Memory: 0.092 MB / 2.35 MB Application: After preloadPermissions (com_content.category)
Time: 0.01 ms / 161.46 ms Memory: 0.001 MB / 2.35 MB Application: End New JAccess Preloading Process(com_content.category)
Time: 0.01 ms / 161.47 ms Memory: 0.001 MB / 2.35 MB Application: Start JAccess::getAssetRules New (com_content.category.46)
Time: 0.04 ms / 161.51 ms Memory: 0.007 MB / 2.36 MB Application: Finish JAccess::getAssetRules New (com_content.category.46)
Time: 9.25 ms / 170.76 ms Memory: 0.045 MB / 2.40 MB Application: Start JAccess::preload(components)
Time: 1.75 ms / 172.51 ms Memory: 0.182 MB / 2.58 MB Application: Finish JAccess::preload(components)
Time: 45.39 ms / 217.91 ms Memory: 0.478 MB / 3.06 MB Application: afterRenderComponent com_content
Time: 0.68 ms / 218.58 ms Memory: 0.004 MB / 3.07 MB Application: afterDispatch
Time: 12.98 ms / 231.56 ms Memory: 0.047 MB / 3.11 MB Application: beforeRenderModule mod_menu (Patriotic & Tech Books)
Time: 5.97 ms / 237.53 ms Memory: 0.026 MB / 3.14 MB Application: afterRenderModule mod_menu (Patriotic & Tech Books)
Time: 0.02 ms / 237.56 ms Memory: 0.000 MB / 3.14 MB Application: beforeRenderModule mod_menu (LGP Learning)
Time: 0.65 ms / 238.20 ms Memory: 0.007 MB / 3.14 MB Application: afterRenderModule mod_menu (LGP Learning)
Time: 0.05 ms / 238.25 ms Memory: 0.000 MB / 3.14 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 1.91 ms / 240.16 ms Memory: 0.035 MB / 3.18 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.04 ms / 240.20 ms Memory: 0.000 MB / 3.18 MB Application: beforeRenderModule mod_custom (LGP Header)
Time: 0.84 ms / 241.04 ms Memory: 0.005 MB / 3.18 MB Application: afterRenderModule mod_custom (LGP Header)
Time: 2.19 ms / 243.23 ms Memory: 0.015 MB / 3.20 MB Application: afterRender

Database queries total: 27.97 ms

Memory Usage

3.49 MB (3,656,112 Bytes)

Database Queries

25 Queries Logged 27.97 ms


  1. Query Time: 0.60 ms Query memory: 0.022 MB Memory before query: 0.934 MB Rows returned: 0
    SELECT `data`
    
      FROM `j25_session`
      WHERE `session_id` = 'cdca5466e765c8988267be8cbcebc319'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = 'cdca5466e765c8988267be8cb' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `#__session` WHERE `session_id` = 'cdca5466e765c8988267be8cbcebc319'
    Profile
    StatusDuration
    starting0.10 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.16 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:44
    12JSessionStorageDatabase->read()Same as call in the line below.
    11session_start()JROOT/libraries/joomla/session/handler/native.php:259
    10JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:49
    9JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:81
    8JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:636
    7JSession->_start()JROOT/libraries/joomla/session/session.php:596
    6JSession->start()JROOT/libraries/cms/application/cms.php:773
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::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.35 ms After last query: 5.98 ms Query memory: 0.019 MB Memory before query: 1.015 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `j25_session`
      WHERE `session_id` = 'cdca5466e765c8988267be8cbcebc319'
      LIMIT 1
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = 'cdca5466e765c898826' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `#__session` WHERE `session_id` = 'cdca5466e765c8988267be8cbcebc319' LIMIT 1
    Profile
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::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.03 ms After last query: 0.04 ms Query memory: 0.003 MB Memory before query: 1.020 MB
    INSERT INTO `j25_session`
    (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('cdca5466e765c8988267be8cbcebc319', 0, 1, '1794992384', 0, '')
    Explain
    EXPLAIN not possible on query: INSERT INTO `j25_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('cdca5466e765c8988267be8cbcebc319', 0, 1, '1794992384', 0, '')
    Profile
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    update0.13 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.58 ms
    closing tables0.06 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:212
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::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.79 ms After last query: 5.84 ms Query memory: 0.022 MB Memory before query: 1.047 MB Rows returned: 32
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j25_extensions`
      WHERE `type` = 'component'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `j25' at line 1 SQL=EXPLAIN EXTENDED SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `#__extensions` WHERE `type` = 'component'
    Profile
    StatusDuration
    starting0.09 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.15 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.14 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    8JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  5. Query Time: 0.72 ms After last query: 4.07 ms Query memory: 0.021 MB Memory before query: 1.125 MB Rows returned: 1
    SELECT b.id
    
      FROM j25_usergroups AS a
      LEFT JOIN j25_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft <= a' at line 1 SQL=EXPLAIN EXTENDED SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
    Profile
    StatusDuration
    starting0.09 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.20 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.03 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    10JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:835
    9JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:904
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.47 ms After last query: 1.71 ms Query memory: 0.021 MB Memory before query: 1.130 MB Rows returned: 3
    SELECT id, rules
    
      FROM `j25_viewlevels`
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1 SQL=EXPLAIN EXTENDED SELECT id, rules FROM `#__viewlevels`
    Profile
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.12 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.03 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    9JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:921
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.65 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 1.138 MB Rows returned: 46
    SELECT folder AS type, element AS name, params
    
      FROM j25_extensions
      WHERE enabled = 1
      AND type ='plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled' at line 1 SQL=EXPLAIN EXTENDED SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering
    Profile
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.25 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    7JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:310
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.18 ms After last query: 22.95 ms Query memory: 0.051 MB Memory before query: 1.506 MB Rows returned: 35
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM j25_menu AS m
      LEFT JOIN j25_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1 SQL=EXPLAIN EXTENDED SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM #__menu AS m LEFT JOIN #__extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
    Profile
    StatusDuration
    starting0.14 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.23 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.03 ms
    executing0.38 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:86
    14JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    13JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    12JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:145
    11JMenu::getInstance()JROOT/libraries/cms/application/cms.php:439
    10JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    9JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:57
    8JRouterSite->__construct()JROOT/libraries/cms/router/router.php:197
    7JRouter::getInstance()JROOT/libraries/cms/application/cms.php:535
    6JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:407
    5JApplicationSite::getRouter()JROOT/libraries/cms/application/cms.php:1115
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  9. Query Time: 0.56 ms After last query: 11.75 ms Query memory: 0.022 MB Memory before query: 1.796 MB Rows returned: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j25_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `j25' at line 1 SQL=EXPLAIN EXTENDED SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `#__extensions` WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.09 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.04 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    12JDatabaseDriver->loadObject()JROOT/libraries/joomla/cache/controller/callback.php:152
    11JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:156
    10JLibraryHelper::_load()JROOT/libraries/cms/library/helper.php:47
    9JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:90
    8JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:274
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  10. Query Time: 1.06 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 1.786 MB
    UPDATE `j25_extensions`
    
      SET `params` = '{\"mediaversion\":\"ebe58d7b92ce00ffa8491f9a0ad0930e\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"ebe58d7b92ce00ffa849' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"ebe58d7b92ce00ffa8491f9a0ad0930e\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profile
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.05 ms
    updating0.12 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.57 ms
    closing tables0.05 ms
    freeing items0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:119
    9JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:325
    8JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:284
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  11. Query Time: 0.67 ms After last query: 4.41 ms Query memory: 0.019 MB Memory before query: 1.891 MB Rows returned: 1
    SELECT *
    
      FROM j25_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC
    Profile
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.21 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.04 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.02 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:164
    5JLanguageHelper::getLanguages()JROOT/libraries/cms/application/site.php:329
    4JApplicationSite->getParams()JROOT/libraries/cms/application/site.php:135
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  12. Query Time: 0.58 ms After last query: 0.15 ms Query memory: 0.019 MB Memory before query: 1.898 MB Rows returned: 7
    SELECT id, home, template, s.params
    
      FROM j25_template_styles as s
      LEFT JOIN j25_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN #__' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN #__extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
    Profile
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.10 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.04 ms
    preparing0.03 ms
    executing0.11 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:484
    4JApplicationSite->getTemplate()JROOT/libraries/cms/application/site.php:165
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  13. Query Time: 3.78 ms After last query: 17.24 ms Query memory: 0.028 MB Memory before query: 2.081 MB Rows returned: 8
    SHOW FULL COLUMNS 
      FROM `j25_assets`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j25_assets`
    Profile
    StatusDuration
    starting0.12 ms
    Executing hook on transaction 0.01 ms
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables2.43 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.11 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    executing0.13 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.07 ms
    checking permissions0.03 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.04 ms
    end0.20 ms
    query end0.01 ms
    waiting for handler commit0.03 ms
    closing tables0.02 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    23JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    22JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    21JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    20JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    19JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:308
    18JTable::getInstance()JROOT/libraries/joomla/access/access.php:696
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.55 ms After last query: 3.29 ms Query memory: 0.025 MB Memory before query: 2.106 MB Rows returned: 1
    SELECT *
    
      FROM j25_assets
      WHERE `id` = '1'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__assets WHERE `id` = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__assets WHERE `id` = '1'
    Profile
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.17 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    19JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:719
    18JTable->load()JROOT/libraries/joomla/access/access.php:697
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.36 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 2.113 MB Rows returned: 1
    SELECT a.rules
    
      FROM j25_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')' at line 1 SQL=EXPLAIN EXTENDED SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')
    Profile
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.06 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    17JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:652
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.66 ms After last query: 1.64 ms Query memory: 0.031 MB Memory before query: 2.188 MB Rows returned: 113
    SELECT a.id, a.parent_id
    
      FROM j25_assets AS a
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.parent_id FROM #__assets AS a WHERE (a.name LIKE 'com_content.%'' at line 1 SQL=EXPLAIN EXTENDED SELECT a.id, a.parent_id FROM #__assets AS a WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)
    Profile
    StatusDuration
    starting0.04 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.12 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    19JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:332
    18JAccess::preloadPermissionsParentIdMapping()JROOT/libraries/joomla/access/access.php:240
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.73 ms After last query: 1.49 ms Query memory: 0.035 MB Memory before query: 2.262 MB Rows returned: 113
    SELECT a.id, a.name, a.rules
    
      FROM j25_assets AS a
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.name, a.rules FROM #__assets AS a WHERE (a.name LIKE 'com_conten' at line 1 SQL=EXPLAIN EXTENDED SELECT a.id, a.name, a.rules FROM #__assets AS a WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )
    Profile
    StatusDuration
    starting0.10 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.23 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1255
    19JDatabaseDriver->getIterator()JROOT/libraries/joomla/access/access.php:373
    18JAccess::preloadPermissions()JROOT/libraries/joomla/access/access.php:243
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 2.88 ms After last query: 3.70 ms Query memory: 0.025 MB Memory before query: 2.368 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,COUNT(i.`id`) AS numitems
      FROM j25_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN j25_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN `j25_content` AS i
      ON i.`catid` = c.id
      AND i.state = 1
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=46
      GROUP BY 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
      ORDER BY c.lft
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1 SQL=EXPLAIN EXTENDED 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,COUNT(i.`id`) AS numitems FROM #__categories as c LEFT JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN #__categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN `#__content` AS i ON i.`catid` = c.id AND i.state = 1 WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND badcats.id is null AND s.id=46 GROUP BY 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 ORDER BY c.lft
    Profile
    StatusDuration
    starting0.26 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.49 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    Creating tmp table0.04 ms
    statistics0.49 ms
    preparing0.04 ms
    Creating tmp table0.41 ms
    executing0.46 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.02 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    15JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    14JCategories->get()JROOT/components/com_content/models/category.php:354
    13ContentModelCategory->getCategory()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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: 2.92 ms Query memory: 0.027 MB Memory before query: 2.401 MB Rows returned: 31
    SELECT element
    
      FROM j25_extensions
      WHERE type = 'component'
      AND enabled = '1'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT element FROM #__extensions WHERE type = 'component' AND enabled = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT element FROM #__extensions WHERE type = 'component' AND enabled = '1'
    Profile
    StatusDuration
    starting0.10 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.10 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    22JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:413
    21JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    20JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    19JAccess::check()JROOT/libraries/joomla/user/user.php:394
    18JUser->authorise()JROOT/components/com_content/models/articles.php:466
    17ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.59 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 2.415 MB Rows returned: 31
    SELECT a.name, a.rules
    
      FROM j25_assets AS a
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.name, a.rules FROM #__assets AS a WHERE (a.name IN ('com_admin','com_a' at line 1 SQL=EXPLAIN EXTENDED SELECT a.name, a.rules FROM #__assets AS a WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')
    Profile
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.17 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    22JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:441
    21JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    20JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    19JAccess::check()JROOT/libraries/joomla/user/user.php:394
    18JUser->authorise()JROOT/components/com_content/models/articles.php:466
    17ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  21. Query Time: 4.41 ms After last query: 0.53 ms Query memory: 0.129 MB Memory before query: 2.586 MB Rows returned: 4
    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j25_content AS a
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 46
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-18 08:59:44')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-18 08:59:44')
      ORDER BY
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 10
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked' at line 1 SQL=EXPLAIN EXTENDED 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 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,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM #__content AS a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 46 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-18 08:59:44') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-18 08:59:44') ORDER BY CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 10
    Profile
    StatusDuration
    starting0.20 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.48 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.34 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    Creating tmp table0.05 ms
    statistics0.11 ms
    preparing0.16 ms
    executing2.48 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.02 ms
    closing tables0.01 ms
    freeing items0.05 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    17JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    16JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  22. Query Time: 0.92 ms After last query: 2.49 ms Query memory: 0.024 MB Memory before query: 2.772 MB Rows returned: 1
    SELECT COUNT(*)
    
      FROM j25_content AS a
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 46
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-18 08:59:44')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-18 08:59:44')
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(*) FROM #__content AS a LEFT JOIN #__categories AS c ON c.id = a.' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(*) FROM #__content AS a LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid = 46 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-18 08:59:44') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-18 08:59:44')
    Profile
    StatusDuration
    starting0.12 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.09 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    Creating tmp table0.04 ms
    statistics0.09 ms
    preparing0.13 ms
    executing0.11 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    17JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:337
    16JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:278
    15JModelList->getTotal()JROOT/libraries/legacy/model/list.php:228
    14JModelList->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/legacy/view/legacy.php:408
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  23. Query Time: 1.45 ms After last query: 2.91 ms Query memory: 0.022 MB Memory before query: 2.839 MB Rows returned: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `j25_contentitem_tag_map` AS m
      INNER JOIN `j25_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 46
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `m`.`tag_id`,`t`.* FROM `#__contentitem_tag_map` AS m INNER JOIN `#__t' at line 1 SQL=EXPLAIN EXTENDED SELECT `m`.`tag_id`,`t`.* FROM `#__contentitem_tag_map` AS m INNER JOIN `#__tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.category' AND `m`.`content_item_id` = 46 AND `t`.`published` = 1 AND t.access IN (1,1)
    Profile
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables1.04 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:435
    12JHelperTags->getItemTags()JROOT/libraries/legacy/view/category.php:217
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->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.49 ms After last query: 31.25 ms Query memory: 0.028 MB Memory before query: 3.091 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 j25_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN j25_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=46
      GROUP BY 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
      ORDER BY c.lft
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1 SQL=EXPLAIN EXTENDED 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 #__categories as c LEFT JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN #__categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND badcats.id is null AND s.id=46 GROUP BY 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 ORDER BY c.lft
    Profile
    StatusDuration
    starting0.30 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.15 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    Creating tmp table0.04 ms
    statistics0.11 ms
    preparing0.04 ms
    Creating tmp table0.26 ms
    executing0.14 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.02 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    23JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    22JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    21JCategories->get()JROOT/components/com_content/helpers/route.php:44
    20ContentHelperRoute::getArticleRoute()JROOT/components/com_content/views/category/tmpl/default_articles.php:135
    19include JROOT/components/com_content/views/category/tmpl/default_articles.phpJROOT/libraries/legacy/view/legacy.php:677
    18JViewLegacy->loadTemplate()JROOT/layouts/joomla/content/category_default.php:60
    17include JROOT/layouts/joomla/content/category_default.phpJROOT/libraries/cms/layout/file.php:121
    16JLayoutFile->render()JROOT/libraries/cms/layout/helper.php:72
    15JLayoutHelper::render()JROOT/components/com_content/views/category/tmpl/default.php:20
    14include JROOT/components/com_content/views/category/tmpl/default.phpJROOT/libraries/legacy/view/legacy.php:677
    13JViewLegacy->loadTemplate()JROOT/libraries/legacy/view/legacy.php:216
    12JViewLegacy->display()JROOT/libraries/legacy/view/category.php:233
    11JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:258
    10ContentViewCategory->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  25. Query Time: 0.88 ms After last query: 3.25 ms Query memory: 0.024 MB Memory before query: 3.108 MB Rows returned: 9
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j25_modules AS m
      LEFT JOIN j25_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j25_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-11-18 08:59:44')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-18 08:59:44')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 129 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1 SQL=EXPLAIN EXTENDED SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM #__modules AS m LEFT JOIN #__modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN #__extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-11-18 08:59:44') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-11-18 08:59:44') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 129 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
    Profile
    StatusDuration
    starting0.07 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.07 ms
    preparing0.04 ms
    executing0.23 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    12JCacheControllerCallback->get()JROOT/libraries/cms/module/helper.php:425
    11JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:361
    10JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    9JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    8JDocumentHtml->countModules()JROOT/templates/protostar/index.php:94
    7require JROOT/templates/protostar/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:640
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1072
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `j25_extensions`
  2. 1 × SELECT `data` 
      FROM `j25_session`
  3. 1 × SELECT a.id, a.name, a.rules 
      FROM j25_assets AS a
  4. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM j25_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  5. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `j25_contentitem_tag_map` AS m
      INNER JOIN `j25_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  6. 1 × SELECT COUNT(*) 
      FROM j25_content AS a
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  7. 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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j25_content AS a
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  8. 1 × SELECT a.name, a.rules 
      FROM j25_assets AS a
  9. 1 × SELECT element 
      FROM j25_extensions
  10. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
      FROM j25_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  11. 1 × SELECT a.rules 
      FROM j25_assets AS a
  12. 1 × SELECT a.id, a.parent_id 
      FROM j25_assets AS a
  13. 1 × SELECT `session_id` 
      FROM `j25_session`
  14. 1 × SELECT * 
      FROM j25_assets
  15. 1 × SELECT id, home, template, s.params 
      FROM j25_template_styles as s
      LEFT JOIN j25_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  16. 1 × SELECT * 
      FROM j25_languages
  17. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM j25_menu AS m
      LEFT JOIN j25_extensions AS e
      ON m.component_id = e.extension_id
  18. 1 × SELECT folder AS type, element AS name, params 
      FROM j25_extensions
  19. 1 × SELECT id, rules 
      FROM `j25_viewlevels
  20. 1 × SELECT b.id 
      FROM j25_usergroups AS a
      LEFT JOIN j25_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  21. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM j25_modules AS m
      LEFT JOIN j25_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j25_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
OTHER Tables:
  1. 1 × INSERT INTO `j25_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('cdca5466e765c8988267be8cbcebc319', 0, 1, '1794992384', 0, ''
  2. 1 × UPDATE `j25_extensions` 
      SET `params` = '{\"mediaversion\":\"ebe58d7b92ce00ffa8491f9a0ad0930e\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `j25_assets