Joomla! Debug Console

Time

Memory

22 Queries Logged 20.0 ms

1. Query Time: 0.42 ms Query memory: 0.025 MB Memory before query: 1.730 MB Rows returned: 0

   SELECT `data`
   
     FROM `zf29e_session`
   
     WHERE `session_id` = '5bdf7jv16co8o0j62ehtngvqu5'

   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 `zf29e_session` WHERE `session_id` = '5bdf7jv16co8o0j62ehtngv' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `zf29e_session` WHERE `session_id` = '5bdf7jv16co8o0j62ehtngvqu5'

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.2 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/session/storage/database.php:46

   JROOT/libraries/joomla/session/session.php:658

   JROOT/libraries/joomla/session/session.php:596

   JROOT/libraries/cms/application/cms.php:672

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:332

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

2. Query Time: 0.28 ms After last query: 1.30 ms Query memory: 0.023 MB Memory before query: 1.819 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `zf29e_session`
   
     WHERE `session_id` = '5bdf7jv16co8o0j62ehtngvqu5' 
     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 `zf29e_session` WHERE `session_id` = '5bdf7jv16co8o0j62' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `zf29e_session` WHERE `session_id` = '5bdf7jv16co8o0j62ehtngvqu5' LIMIT 0, 1

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/application/cms.php:175

   JROOT/libraries/cms/application/cms.php:698

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:332

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

3. Query Time: 0.29 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 1.825 MB

   INSERT INTO `zf29e_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('5bdf7jv16co8o0j62ehtngvqu5', 0, '1774638240')

   Explain

   EXPLAIN not possible on query: INSERT INTO `zf29e_session` (`session_id`, `client_id`, `time`) VALUES ('5bdf7jv16co8o0j62ehtngvqu5', 0, '1774638240')

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   update	0.1 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/application/cms.php:207

   JROOT/libraries/cms/application/cms.php:698

   JROOT/libraries/cms/application/cms.php:131

   JROOT/libraries/cms/application/site.php:63

   JROOT/libraries/cms/application/cms.php:332

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

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

   ---

4. Query Time: 0.56 ms After last query: 2.53 ms Query memory: 0.025 MB Memory before query: 2.062 MB Rows returned: 1

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM zf29e_extensions
   
     WHERE `type` = 'component' 
     AND `element` = 'com_users'

   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 zf29e_exten' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM zf29e_extensions WHERE `type` = 'component' AND `element` = 'com_users'

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.1 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:396

   JROOT/libraries/cms/component/helper.php:43

   JROOT/libraries/cms/component/helper.php:91

   JROOT/libraries/cms/application/site.php:541

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

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

   ---

5. Query Time: 0.55 ms After last query: 0.83 ms Query memory: 0.024 MB Memory before query: 2.123 MB Rows returned: 1

   SELECT b.id
   
     FROM zf29e_usergroups AS a
   
     LEFT JOIN zf29e_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 zf29e_usergroups AS a LEFT JOIN zf29e_usergroups AS b ON b.lft ' at line 1 SQL=EXPLAIN EXTENDED SELECT b.id FROM zf29e_usergroups AS a LEFT JOIN zf29e_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.2 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   preparing	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/access/access.php:336

   JROOT/libraries/joomla/access/access.php:405

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

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

   ---

6. Query Time: 0.39 ms After last query: 0.40 ms Query memory: 0.024 MB Memory before query: 2.160 MB Rows returned: 4

   SELECT id, rules
   
     FROM `zf29e_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 `zf29e_viewlevels`' at line 1 SQL=EXPLAIN EXTENDED SELECT id, rules FROM `zf29e_viewlevels`

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.1 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   preparing	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/access/access.php:422

   JROOT/libraries/joomla/user/user.php:420

   JROOT/libraries/cms/plugin/helper.php:298

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

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

   ---

7. Query Time: 0.73 ms After last query: 0.09 ms Query memory: 0.036 MB Memory before query: 2.171 MB Rows returned: 56

   SELECT folder AS type, element AS name, params
   
     FROM zf29e_extensions
   
     WHERE enabled >= 1 
     AND type ='plugin' 
     AND state >= 0 
     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 zf29e_extensions WHERE enabl' at line 1 SQL=EXPLAIN EXTENDED SELECT folder AS type, element AS name, params FROM zf29e_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.3 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/cms/plugin/helper.php:312

   JROOT/libraries/cms/plugin/helper.php:165

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

   [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: 2.32 ms Query memory: 0.027 MB Memory before query: 2.489 MB Rows returned: 1

   SELECT *
   
     FROM zf29e_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 zf29e_languages WHERE published=1 ORDER BY ordering ASC' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM zf29e_languages WHERE published=1 ORDER BY ordering ASC

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.9 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.0 ms
   preparing	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.1 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/language/helper.php:166

   JROOT/plugins/system/languagefilter/languagefilter.php:67

   JROOT/libraries/cms/plugin/helper.php:257

   JROOT/libraries/cms/plugin/helper.php:172

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

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

   ---

9. Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.026 MB Memory before query: 2.517 MB Rows returned: 1

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM zf29e_extensions
   
     WHERE `type` = 'component' 
     AND `element` = 'com_languages'

   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 zf29e_exten' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM zf29e_extensions WHERE `type` = 'component' AND `element` = 'com_languages'

   Profile

   Status	Duration
   starting	0.1 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.0 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/joomla/cache/controller/callback.php:158

   JROOT/libraries/cms/component/helper.php:396

   JROOT/libraries/cms/component/helper.php:43

   JROOT/libraries/cms/component/helper.php:91

   JROOT/plugins/system/languagefilter/languagefilter.php:69

   JROOT/libraries/cms/plugin/helper.php:257

   JROOT/libraries/cms/plugin/helper.php:172

   JROOT/libraries/cms/application/site.php:546

   JROOT/libraries/cms/application/site.php:196

   JROOT/libraries/cms/application/cms.php:255

   JROOT/index.php:40

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

   ---

10. Query Time: 2.41 ms After last query: 0.30 ms Query memory: 0.023 MB Memory before query: 2.525 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM `zf29e_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    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 `zf29e_menu` WHERE home = 1 AND published = 1 AND client_id' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(*) FROM `zf29e_menu` WHERE home = 1 AND published = 1 AND client_id = 0

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	1.6 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.4 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32

    JROOT/plugins/system/languagefilter/languagefilter.php:71

    JROOT/libraries/cms/plugin/helper.php:257

    JROOT/libraries/cms/plugin/helper.php:172

    JROOT/libraries/cms/application/site.php:546

    JROOT/libraries/cms/application/site.php:196

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

11. Query Time: 1.20 ms After last query: 12.06 ms Query memory: 0.072 MB Memory before query: 3.673 MB Rows returned: 48

    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 zf29e_menu AS m
    
      LEFT JOIN zf29e_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 zf29e_menu AS m LEFT JOIN zf29e_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.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.7 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/menu/site.php:47

    JROOT/libraries/cms/menu/menu.php:64

    JROOT/libraries/cms/menu/menu.php:118

    JROOT/libraries/cms/application/cms.php:357

    JROOT/libraries/cms/application/site.php:250

    JROOT/libraries/cms/router/site.php:210

    JROOT/libraries/cms/router/router.php:391

    JROOT/libraries/cms/router/router.php:184

    JROOT/libraries/cms/router/site.php:82

    JROOT/libraries/cms/application/cms.php:1022

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

12. Query Time: 0.41 ms After last query: 1.58 ms Query memory: 0.029 MB Memory before query: 4.087 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM zf29e_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 zf29e_exten' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM zf29e_extensions WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/library/helper.php:156

    JROOT/libraries/cms/library/helper.php:47

    JROOT/libraries/cms/library/helper.php:90

    JROOT/libraries/cms/version/version.php:179

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/jcomments/jcomments.php:111

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

13. Query Time: 0.40 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 4.083 MB

    UPDATE `zf29e_extensions`
    
      SET `params` = '{\"Array\":[\"5ceace78950af75b02b5b92aa585591c\"]}'
    
      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 `zf29e_extensions` SET `params` = '{\"Array\":[\"5ceace78950af75b02b5b92a' at line 1 SQL=EXPLAIN EXTENDED UPDATE `zf29e_extensions` SET `params` = '{\"Array\":[\"5ceace78950af75b02b5b92aa585591c\"]}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.1 ms
    updating	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/library/helper.php:119

    JROOT/libraries/cms/version/version.php:230

    JROOT/libraries/cms/version/version.php:189

    JROOT/libraries/joomla/factory.php:734

    JROOT/libraries/joomla/factory.php:215

    JROOT/plugins/system/jcomments/jcomments.php:111

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

14. Query Time: 1.16 ms After last query: 2.52 ms Query memory: 0.030 MB Memory before query: 4.334 MB Rows returned: 0

    SELECT *
    
      FROM `zf29e_jcomments_settings`
    
      WHERE `lang` = 'en-GB' 
      AND `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 * FROM `zf29e_jcomments_settings` WHERE `lang` = 'en-GB' AND `component` ' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `zf29e_jcomments_settings` WHERE `lang` = 'en-GB' AND `component` = ''

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.8 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_jcomments/classes/config.php:140

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/components/com_jcomments/classes/config.php:159

    JROOT/components/com_jcomments/classes/config.php:47

    JROOT/components/com_jcomments/classes/factory.php:188

    JROOT/components/com_jcomments/classes/multilingual.php:45

    JROOT/components/com_jcomments/classes/config.php:41

    JROOT/components/com_jcomments/helpers/system.php:39

    JROOT/plugins/system/jcomments/jcomments.php:139

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

15. Query Time: 0.64 ms After last query: 0.05 ms Query memory: 0.043 MB Memory before query: 4.348 MB Rows returned: 91

    SELECT *
    
      FROM `zf29e_jcomments_settings`
    
      WHERE `lang` = '' 
      AND `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 * FROM `zf29e_jcomments_settings` WHERE `lang` = '' AND `component` = ''' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `zf29e_jcomments_settings` WHERE `lang` = '' AND `component` = ''

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.3 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/components/com_jcomments/classes/config.php:140

    JROOT/components/com_jcomments/classes/config.php:143

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/components/com_jcomments/classes/config.php:159

    JROOT/components/com_jcomments/classes/config.php:47

    JROOT/components/com_jcomments/classes/factory.php:188

    JROOT/components/com_jcomments/classes/multilingual.php:45

    JROOT/components/com_jcomments/classes/config.php:41

    JROOT/components/com_jcomments/helpers/system.php:39

    JROOT/plugins/system/jcomments/jcomments.php:139

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

16. Query Time: 0.56 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 4.359 MB Rows returned: 6

    SELECT id, home, template, s.params
    
      FROM zf29e_template_styles as s
    
      LEFT JOIN zf29e_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 zf29e_template_styles as s LEFT JOIN zf' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home, template, s.params FROM zf29e_template_styles as s LEFT JOIN zf29e_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.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/application/site.php:457

    JROOT/components/com_jcomments/helpers/system.php:46

    JROOT/plugins/system/jcomments/jcomments.php:139

    JROOT/libraries/joomla/event/event.php:71

    JROOT/libraries/joomla/event/dispatcher.php:162

    JROOT/libraries/joomla/application/base.php:106

    JROOT/libraries/cms/application/cms.php:1031

    JROOT/libraries/cms/application/site.php:720

    JROOT/libraries/cms/application/site.php:202

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

17. Query Time: 0.37 ms After last query: 0.65 ms Query memory: 0.025 MB Memory before query: 4.462 MB Rows returned: 1

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM zf29e_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_content'

    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 zf29e_exten' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM zf29e_extensions WHERE `type` = 'component' AND `element` = 'com_content'

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:396

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/libraries/cms/application/site.php:299

    JROOT/libraries/cms/application/site.php:122

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

18. Query Time: 1.05 ms After last query: 5.75 ms Query memory: 0.029 MB Memory before query: 5.027 MB Rows returned: 1

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

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.7 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/access/access.php:250

    JROOT/libraries/joomla/user/user.php:356

    JROOT/components/com_content/models/articles.php:107

    JROOT/components/com_content/models/featured.php:39

    JROOT/libraries/legacy/model/legacy.php:415

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_content/views/featured/view.html.php:46

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:16

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

19. Query Time: 5.94 ms After last query: 0.69 ms Query memory: 0.149 MB Memory before query: 5.083 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, 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 zf29e_content AS a
    
      LEFT JOIN zf29e_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN zf29e_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN zf29e_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN zf29e_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN zf29e_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM zf29e_categories AS cat JOIN zf29e_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
    
      INNER JOIN zf29e_content_frontpage AS fp 
      ON fp.content_id = a.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 IN (0,1,2) 
      AND a.language in ('en-GB','*')
    
      ORDER BY c.lft,  a.featured DESC, fp.ordering,  a.created DESC   
      LIMIT 0, 4

    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, 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 zf29e_content AS a LEFT JOIN zf29e_categories AS c ON c.id = a.catid LEFT JOIN zf29e_users AS ua ON ua.id = a.created_by LEFT JOIN zf29e_users AS uam ON uam.id = a.modified_by LEFT JOIN zf29e_categories as parent ON parent.id = c.parent_id LEFT JOIN zf29e_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM zf29e_categories AS cat JOIN zf29e_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 INNER JOIN zf29e_content_frontpage AS fp ON fp.content_id = a.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 IN (0,1,2) AND a.language in ('en-GB','*') ORDER BY c.lft, a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 4

    Profile

    Status	Duration
    starting	0.4 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	4.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    Creating tmp table	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    Creating tmp table	0.1 ms
    executing	0.8 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.1 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/legacy/model/legacy.php:301

    JROOT/libraries/legacy/model/list.php:171

    JROOT/components/com_content/models/articles.php:537

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_content/views/featured/view.html.php:47

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:16

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

20. Query Time: 0.39 ms After last query: 1.92 ms Query memory: 0.031 MB Memory before query: 5.475 MB Rows returned: 0

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM zf29e_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_tags'

    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 zf29e_exten' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM zf29e_extensions WHERE `type` = 'component' AND `element` = 'com_tags'

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/cache/controller/callback.php:158

    JROOT/libraries/cms/component/helper.php:396

    JROOT/libraries/cms/component/helper.php:43

    JROOT/libraries/cms/component/helper.php:91

    JROOT/libraries/cms/helper/tags.php:389

    JROOT/components/com_content/models/articles.php:663

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_content/views/featured/view.html.php:47

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:16

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

21. Query Time: 0.39 ms After last query: 0.64 ms Query memory: 0.010 MB Memory before query: 5.507 MB

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `zf29e_contentitem_tag_map` AS m 
    
      INNER JOIN `zf29e_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 77 
      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 `zf29e_contentitem_tag_map` AS m INNER JOIN `zf2' at line 1 SQL=EXPLAIN EXTENDED SELECT `m`.`tag_id`,`t`.* FROM `zf29e_contentitem_tag_map` AS m INNER JOIN `zf29e_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 77 AND `t`.`published` = 1 AND t.access IN (1,1)

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.2 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/cms/helper/tags.php:409

    JROOT/components/com_content/models/articles.php:663

    JROOT/components/com_content/models/featured.php:84

    JROOT/libraries/legacy/view/legacy.php:398

    JROOT/components/com_content/views/featured/view.html.php:47

    JROOT/libraries/legacy/controller/legacy.php:685

    JROOT/components/com_content/controller.php:79

    JROOT/libraries/legacy/controller/legacy.php:722

    JROOT/components/com_content/content.php:16

    JROOT/libraries/cms/component/helper.php:352

    JROOT/libraries/cms/component/helper.php:332

    JROOT/libraries/cms/application/site.php:178

    JROOT/libraries/cms/application/site.php:208

    JROOT/libraries/cms/application/cms.php:255

    JROOT/index.php:40

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

    ---

22. Query Time: 0.35 ms After last query: 0.76 ms Query memory: 0.002 MB Memory before query: 5.522 MB

    UPDATE `zf29e_session`
    
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1774638240;s:18:\"session.timer.last\";i:1774638240;s:17:\"session.timer.now\";i:1774638240;s:24:\"session.client.forwarded\";s:14:\"216.73.216.133\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
    	, `time` = '1774638240'
    
      WHERE `session_id` = '5bdf7jv16co8o0j62ehtngvqu5'

    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 `zf29e_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1' at line 1 SQL=EXPLAIN EXTENDED UPDATE `zf29e_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1774638240;s:18:\"session.timer.last\";i:1774638240;s:17:\"session.timer.now\";i:1774638240;s:24:\"session.client.forwarded\";s:14:\"216.73.216.133\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1774638240' WHERE `session_id` = '5bdf7jv16co8o0j62ehtngvqu5'

    Profile

    Status	Duration
    starting	0.1 ms
    Executing hook on transaction	0.0 ms
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    init	0.0 ms
    System lock	0.0 ms
    updating	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/session/storage/database.php:85

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

    ---

17 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 5 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM zf29e_extensions

2. 2 × SELECT * 
     FROM `zf29e_jcomments_settings`

3. 1 × SELECT `data` 
     FROM `zf29e_session`

4. 1 × SELECT `session_id` 
     FROM `zf29e_session`

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

6. 1 × SELECT id, rules 
     FROM `zf29e_viewlevels

7. 1 × SELECT folder AS type, element AS name, params 
     FROM zf29e_extensions

8. 1 × SELECT * 
     FROM zf29e_languages

9. 1 × SELECT COUNT(*) 
     FROM `zf29e_menu`

10. 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 zf29e_menu AS m 
      LEFT JOIN zf29e_extensions AS e 
      ON m.component_id = e.extension_id

11. 1 × SELECT id, home, template, s.params 
      FROM zf29e_template_styles as s 
      LEFT JOIN zf29e_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

12. 1 × SELECT a.rules 
      FROM zf29e_assets AS a

13. 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, 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 zf29e_content AS a 
      LEFT JOIN zf29e_categories AS c 
      ON c.id = a.catid 
      LEFT JOIN zf29e_users AS ua 
      ON ua.id = a.created_by 
      LEFT JOIN zf29e_users AS uam 
      ON uam.id = a.modified_by 
      LEFT JOIN zf29e_categories as parent 
      ON parent.id = c.parent_id 
      LEFT JOIN zf29e_content_rating AS v 
      ON a.id = v.content_id 
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM zf29e_categories AS cat JOIN zf29e_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt

14. 1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `zf29e_contentitem_tag_map` AS m  
      INNER JOIN `zf29e_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`

OTHER Tables:

1. 1 × INSERT INTO `zf29e_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('5bdf7jv16co8o0j62ehtngvqu5', 0, '1774638240'

2. 1 × UPDATE `zf29e_extensions` 
     SET `params` = '{\"Array\":[\"5ceace78950af75b02b5b92aa585591c\"]}'

3. 1 × UPDATE `zf29e_session` 
     SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1774638240;s:18:\"session.timer.last\";i:1774638240;s:17:\"session.timer.now\";i:1774638240;s:24:\"session.client.forwarded\";s:14:\"216.73.216.133\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'  , `time` = '1774638240'