Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713614189,
                "last": 1713614189,
                "now": 1713614189
            }
        },
        "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": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Time

Memory

26 Queries Logged 63.55 ms

1. Query Time: 2.29 ms Query memory: 0.017 MB Memory before query: 2.693 MB Rows returned: 0

   SELECT `data`
   
     FROM `hlk_session`
   
     WHERE `session_id` = 'i3e1ah2hhduae366sg6r1vr0f0'

   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` = 'i3e1ah2hhduae366sg6r1vr0f' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `#__session` WHERE `session_id` = 'i3e1ah2hhduae366sg6r1vr0f0'

   Profile

   Status	Duration
   starting	0.23 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	1.59 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.11 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.08 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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.59 ms After last query: 2.11 ms Query memory: 0.008 MB Memory before query: 2.895 MB

   DELETE 
   
     FROM `hlk_session`
   
     WHERE `time` < '1713603389'

   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 'DELETE FROM `#__session` WHERE `time` < '1713603389'' at line 1 SQL=EXPLAIN EXTENDED DELETE FROM `#__session` WHERE `time` < '1713603389'

   Profile

   Status	Duration
   starting	0.15 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.10 ms
   updating	0.08 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:765
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.50 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 2.907 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `hlk_session`
   
     WHERE `session_id` = 'i3e1ah2hhduae366sg6r1vr0f0' 
     LIMIT 0, 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` = 'i3e1ah2hhduae366sg6' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `#__session` WHERE `session_id` = 'i3e1ah2hhduae366sg6r1vr0f0' LIMIT 0, 1

   Profile

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.04 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.11 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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.89 ms After last query: 0.13 ms Query memory: 0.009 MB Memory before query: 2.919 MB

   INSERT INTO `hlk_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('i3e1ah2hhduae366sg6r1vr0f0', 0, '1713614189')

   Explain

   EXPLAIN not possible on query: INSERT INTO `hlk_session` (`session_id`, `client_id`, `time`) VALUES ('i3e1ah2hhduae366sg6r1vr0f0', 0, '1713614189')

   Profile

   Status	Duration
   starting	0.11 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.02 ms
   update	0.13 ms
   end	0.03 ms
   query end	0.01 ms
   waiting for handler commit	0.32 ms
   closing tables	0.03 ms
   freeing items	0.10 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 2.47 ms After last query: 3.20 ms Query memory: 0.012 MB Memory before query: 3.287 MB Rows returned: 36

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM hlk_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 #__extensi' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM #__extensions WHERE `type` = 'component'

   Profile

   Status	Duration
   starting	0.14 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	1.53 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.11 ms
   preparing	0.05 ms
   executing	0.26 ms
   end	0.02 ms
   query end	0.05 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.10 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 2.11 ms After last query: 1.49 ms Query memory: 0.012 MB Memory before query: 3.437 MB Rows returned: 2

   SELECT b.id
   
     FROM hlk_usergroups AS a
   
     LEFT JOIN hlk_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   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 = 9

   Profile

   Status	Duration
   starting	0.18 ms
   Executing hook on transaction	0.02 ms
   starting	0.03 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	1.28 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.15 ms
   preparing	0.04 ms
   executing	0.05 ms
   end	0.02 ms
   query end	0.03 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
   9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
   8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->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.92 ms After last query: 0.61 ms Query memory: 0.011 MB Memory before query: 3.493 MB Rows returned: 5

   SELECT id, rules
   
     FROM `hlk_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

   Status	Duration
   starting	0.09 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	1.11 ms
   init	0.04 ms
   System lock	0.03 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.33 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
   8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 2.06 ms After last query: 0.27 ms Query memory: 0.009 MB Memory before query: 3.512 MB Rows returned: 75

   SELECT folder AS type, element AS name, params
   
     FROM hlk_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     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,5) ORDER BY ordering

   Profile

   Status	Duration
   starting	0.25 ms
   Executing hook on transaction	0.04 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.35 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.04 ms
   statistics	0.08 ms
   preparing	0.03 ms
   executing	0.96 ms
   end	0.03 ms
   query end	0.03 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 3.44 ms After last query: 12.59 ms Query memory: 0.030 MB Memory before query: 4.982 MB Rows returned: 46

   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 hlk_menu AS m
   
     LEFT JOIN hlk_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

   Status	Duration
   starting	0.20 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	2.05 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.04 ms
   executing	0.75 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   26	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   25	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   24	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   23	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
   22	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   21	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   20	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
   19	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:334
   18	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:679
   17	JHtml::script()	Same as call in the line below.
   16	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
   15	JHtml::call()	JROOT/libraries/cms/html/html.php:138
   14	JHtml::_()	JROOT/libraries/cms/html/behavior.php:61
   13	JHtmlBehavior::framework()	Same as call in the line below.
   12	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
   11	JHtml::call()	JROOT/libraries/cms/html/html.php:138
   10	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
   9	plgSystemJCKModal->onAfterInitialise()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 2.16 ms After last query: 2.73 ms Query memory: 0.023 MB Memory before query: 5.479 MB Rows returned: 6

    SELECT id, home, template, s.params
    
      FROM hlk_template_styles as s
    
      LEFT JOIN hlk_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

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.24 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.07 ms
    executing	0.19 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 ms
    freeing items	0.09 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    19	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:334
    18	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:679
    17	JHtml::script()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    14	JHtml::_()	JROOT/libraries/cms/html/behavior.php:61
    13	JHtmlBehavior::framework()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    11	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    10	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
    9	plgSystemJCKModal->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->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.62 ms After last query: 1.02 ms Query memory: 0.029 MB Memory before query: 5.558 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM hlk_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 #__extensi' 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

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.04 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    26	JDatabaseDriver->loadObject()	Same as call in the line below.
    25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
    24	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    23	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    22	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    21	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    20	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
    19	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    18	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:700
    17	JHtml::script()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    14	JHtml::_()	JROOT/libraries/cms/html/behavior.php:61
    13	JHtmlBehavior::framework()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    11	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    10	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
    9	plgSystemJCKModal->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->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.99 ms After last query: 1.43 ms Query memory: 0.025 MB Memory before query: 5.680 MB

    UPDATE `hlk_extensions`
    
      SET `params` = '{\"mediaversion\":\"77bdd947e2762a8428b74fc04b76f05d\"}'
    
      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\":\"77bdd947e2762a8428b7' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"77bdd947e2762a8428b74fc04b76f05d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.08 ms
    updating	0.15 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.35 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    22	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    21	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    20	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
    19	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    18	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:700
    17	JHtml::script()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    14	JHtml::_()	JROOT/libraries/cms/html/behavior.php:61
    13	JHtmlBehavior::framework()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    11	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    10	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
    9	plgSystemJCKModal->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 7.09 ms After last query: 3.27 ms Query memory: 0.014 MB Memory before query: 6.005 MB Rows returned: 149
    Duplicate queries: #16  #26

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.07 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:80
    9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 2.66 ms After last query: 0.27 ms Query memory: 0.013 MB Memory before query: 6.048 MB Rows returned: 0

    SELECT file_id 
      from hlk_jdownloads_files 
      WHERE published = 1 
      AND use_timeframe = 1 
      AND publish_to != '0000-00-00 00:00:00' 
      AND publish_to <= '2024-04-20 11:56:29'

    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 file_id from #__jdownloads_files WHERE published = 1 AND use_timeframe =' at line 1 SQL=EXPLAIN EXTENDED SELECT file_id from #__jdownloads_files WHERE published = 1 AND use_timeframe = 1 AND publish_to != '0000-00-00 00:00:00' AND publish_to <= '2024-04-20 11:56:29'

    Profile

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.02 ms
    starting	0.05 ms
    checking permissions	0.03 ms
    Opening tables	2.01 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:108
    9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->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.57 ms After last query: 0.08 ms Query memory: 0.013 MB Memory before query: 6.061 MB Rows returned: 0

    SELECT file_id 
      from hlk_jdownloads_files 
      WHERE published = 0 
      AND use_timeframe = 1 
      AND publish_from != '0000-00-00 00:00:00' 
      AND publish_from <= '2024-04-20 11:56:29'

    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 file_id from #__jdownloads_files WHERE published = 0 AND use_timeframe =' at line 1 SQL=EXPLAIN EXTENDED SELECT file_id from #__jdownloads_files WHERE published = 0 AND use_timeframe = 1 AND publish_from != '0000-00-00 00:00:00' AND publish_from <= '2024-04-20 11:56:29'

    Profile

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.06 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:116
    9	plgSystemjdownloads->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 6.28 ms After last query: 5.71 ms Query memory: 0.014 MB Memory before query: 6.615 MB Rows returned: 149
    Duplicate queries: #13  #26

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.13 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.07 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.14 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.08 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.13 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:350
    9	plgSystemjdownloads->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 2.44 ms After last query: 1.08 ms Query memory: 0.009 MB Memory before query: 6.690 MB Rows returned: 1

    SELECT *
    
      FROM hlk_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

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	1.75 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.15 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 1.89 ms After last query: 6.10 ms Query memory: 0.018 MB Memory before query: 7.312 MB Rows returned: 1

    SELECT a.rules
    
      FROM hlk_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.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 a.rules FROM #__assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.l' at line 1 SQL=EXPLAIN EXTENDED SELECT a.rules FROM #__assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft

    Profile

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	1.25 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 1.11 ms After last query: 0.70 ms Query memory: 0.020 MB Memory before query: 7.364 MB Rows returned: 2

    SELECT b.rules
    
      FROM hlk_assets AS a
    
      LEFT JOIN hlk_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_content')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.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 b.rules FROM #__assets AS a LEFT JOIN #__assets AS b ON b.lft <= a.lft ' at line 1 SQL=EXPLAIN EXTENDED SELECT b.rules FROM #__assets AS a LEFT JOIN #__assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft

    Profile

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.13 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.22 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 4.26 ms After last query: 0.88 ms Query memory: 0.020 MB Memory before query: 7.466 MB Rows returned: 30

    SHOW FULL COLUMNS 
      FROM `hlk_content`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hlk_content`

    Profile

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.02 ms
    starting	1.31 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.96 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Creating tmp table	0.05 ms
    executing	0.14 ms
    checking permissions	0.10 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.09 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->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.96 ms After last query: 2.83 ms Query memory: 0.015 MB Memory before query: 7.814 MB Rows returned: 1

    SELECT *
    
      FROM hlk_content
    
      WHERE `id` = '16'

    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 #__content WHERE `id` = '16'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__content WHERE `id` = '16'

    Profile

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
    10	JTable->load()	JROOT/components/com_content/models/article.php:265
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->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.01 ms After last query: 0.19 ms Query memory: 0.014 MB Memory before query: 7.829 MB

    UPDATE hlk_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '16'

    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 #__content SET `hits` = (`hits` + 1) WHERE `id` = '16'' at line 1 SQL=EXPLAIN EXTENDED UPDATE #__content SET `hits` = (`hits` + 1) WHERE `id` = '16'

    Profile

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.06 ms
    updating	0.08 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.43 ms
    closing tables	0.04 ms
    freeing items	0.10 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
    10	JTable->hit()	JROOT/components/com_content/models/article.php:266
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 4.92 ms After last query: 1.97 ms Query memory: 0.017 MB Memory before query: 8.012 MB Rows returned: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM hlk_content AS a
    
      LEFT JOIN hlk_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN hlk_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN hlk_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN hlk_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM hlk_categories AS cat JOIN hlk_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 16 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 11:56:29') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 11:56:29') 
      AND (a.state = 1 OR a.state =2)

    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.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN ba' at line 1 SQL=EXPLAIN EXTENDED SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM #__content AS a LEFT JOIN #__categories AS c on c.id = a.catid LEFT JOIN #__users AS u on u.id = a.created_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 <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 16 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 11:56:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 11:56:29') AND (a.state = 1 OR a.state =2)

    Profile

    Status	Duration
    starting	0.22 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	3.50 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Creating tmp table	0.08 ms
    statistics	0.31 ms
    preparing	0.12 ms
    executing	0.08 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->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.41 ms After last query: 2.30 ms Query memory: 0.018 MB Memory before query: 8.273 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 hlk_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM hlk_categories AS cat JOIN hlk_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 hlk_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,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=11
    
      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,5) AND c.published = 1 AND badcats.id is null AND s.id=11 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

    Status	Duration
    starting	0.20 ms
    Executing hook on transaction	0.03 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    statistics	0.15 ms
    preparing	0.04 ms
    Creating tmp table	0.13 ms
    executing	0.21 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.05 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 3.53 ms After last query: 1.58 ms Query memory: 0.016 MB Memory before query: 8.391 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `hlk_contentitem_tag_map` AS m 
    
      INNER JOIN `hlk_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 16 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    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.article' AND `m`.`content_item_id` = 16 AND `t`.`published` = 1 AND t.access IN (1,1,5)

    Profile

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	2.69 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.18 ms
    preparing	0.03 ms
    executing	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:426
    11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 5.38 ms After last query: 9.10 ms Query memory: 0.013 MB Memory before query: 9.086 MB Rows returned: 149
    Duplicate queries: #13  #16

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.09 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:255
    8	plgSystemjdownloads->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1074
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT file_id 
     from hlk_jdownloads_files

2. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM hlk_extensions

3. 1 × SELECT b.rules 
     FROM hlk_assets AS a 
     LEFT JOIN hlk_assets AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

4. 1 × SELECT a.rules 
     FROM hlk_assets AS a

5. 1 × SELECT * 
     FROM hlk_content

6. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
     CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
     FROM hlk_content AS a 
     LEFT JOIN hlk_categories AS c 
     on c.id = a.catid 
     LEFT JOIN hlk_users AS u 
     on u.id = a.created_by 
     LEFT JOIN hlk_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN hlk_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN  (SELECT cat.id as id 
     FROM hlk_categories AS cat JOIN hlk_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

7. 1 × SELECT `m`.`tag_id`,`t`.* 
     FROM `hlk_contentitem_tag_map` AS m  
     INNER JOIN `hlk_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

8. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM hlk_categories as c 
     LEFT JOIN  (SELECT cat.id as id 
     FROM hlk_categories AS cat JOIN hlk_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

9. 1 × SELECT * 
     FROM hlk_languages

10. 1 × SELECT id, home, template, s.params 
      FROM hlk_template_styles as s 
      LEFT JOIN hlk_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

11. 1 × SELECT b.id 
      FROM hlk_usergroups AS a 
      LEFT JOIN hlk_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

12. 1 × SELECT `session_id` 
      FROM `hlk_session`

13. 1 × SELECT id, rules 
      FROM `hlk_viewlevels

14. 1 × SELECT folder AS type, element AS name, params 
      FROM hlk_extensions

15. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM hlk_menu AS m 
      LEFT JOIN hlk_extensions AS e 
      ON m.component_id = e.extension_id

16. 1 × SELECT `data` 
      FROM `hlk_session`

OTHER Tables:

1. 3 × SHOW TABLE

2. 1 × SHOW FULL COLUMNS 
     FROM `hlk_content

3. 1 × UPDATE hlk_content 
     SET `hits` = (`hits` + 1)

4. 1 × UPDATE `hlk_extensions` 
     SET `params` = '{\"mediaversion\":\"77bdd947e2762a8428b74fc04b76f05d\"}'

5. 1 × INSERT INTO `hlk_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('i3e1ah2hhduae366sg6r1vr0f0', 0, '1713614189'

6. 1 × DELETE  
     FROM `hlk_session`