Joomla! Debug Console

Time

Memory

26 Queries Logged 27.6 ms

1. Query Time: 1.44 ms Query memory: 0.015 MB Memory before query: 0.828 MB Rows returned: 0

   SELECT `data`
   
     FROM `dcv6x_session`
   
     WHERE `session_id` = 'd882592162da64b5076b2b32547aa5e5'

   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 `dcv6x_session` WHERE `session_id` = 'd882592162da64b5076b2b3' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `dcv6x_session` WHERE `session_id` = 'd882592162da64b5076b2b32547aa5e5'

   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.1 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   waiting for handler commit	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:44

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

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:42

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

   ---

2. Query Time: 0.31 ms After last query: 1.30 ms Query memory: 0.012 MB Memory before query: 0.883 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `dcv6x_session`
   
     WHERE `session_id` = 'd882592162da64b5076b2b32547aa5e5' 
     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 `dcv6x_session` WHERE `session_id` = 'd882592162da64b50' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `dcv6x_session` WHERE `session_id` = 'd882592162da64b5076b2b32547aa5e5' 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
   waiting for handler commit	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:176

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:42

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

   ---

3. Query Time: 3.31 ms After last query: 0.11 ms Query memory: 0.009 MB Memory before query: 0.895 MB

   INSERT INTO `dcv6x_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('d882592162da64b5076b2b32547aa5e5', 0, '1741885104')

   Explain

   EXPLAIN not possible on query: INSERT INTO `dcv6x_session` (`session_id`, `client_id`, `time`) VALUES ('d882592162da64b5076b2b32547aa5e5', 0, '1741885104')

   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
   waiting for handler commit	3.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:208

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:42

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

   ---

4. Query Time: 0.95 ms After last query: 1.02 ms Query memory: 0.023 MB Memory before query: 0.976 MB Rows returned: 40

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

   Profile

   Status	Duration
   starting	0.2 ms
   Executing hook on transaction	0.0 ms
   starting	0.0 ms
   checking permissions	0.0 ms
   Opening tables	0.3 ms
   init	0.0 ms
   System lock	0.0 ms
   optimizing	0.0 ms
   statistics	0.1 ms
   preparing	0.0 ms
   executing	0.2 ms
   end	0.0 ms
   query end	0.0 ms
   waiting for handler commit	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:157

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

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

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

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

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

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

   JROOT/index.php:45

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

   ---

5. Query Time: 0.78 ms After last query: 0.78 ms Query memory: 0.014 MB Memory before query: 1.050 MB Rows returned: 1

   SELECT b.id
   
     FROM dcv6x_usergroups AS a
   
     LEFT JOIN dcv6x_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 dcv6x_usergroups AS a LEFT JOIN dcv6x_usergroups AS b ON b.lft ' at line 1 SQL=EXPLAIN EXTENDED SELECT b.id FROM dcv6x_usergroups AS a LEFT JOIN dcv6x_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.4 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
   waiting for handler commit	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:332

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

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

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

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

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

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

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

   JROOT/index.php:45

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

   ---

6. Query Time: 0.44 ms After last query: 0.19 ms Query memory: 0.013 MB Memory before query: 1.069 MB Rows returned: 3

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

   Profile

   Status	Duration
   starting	0.0 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
   preparing	0.0 ms
   executing	0.0 ms
   end	0.0 ms
   query end	0.0 ms
   waiting for handler commit	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:418

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

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

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

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

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

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

   JROOT/index.php:45

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

   ---

7. Query Time: 0.86 ms After last query: 0.21 ms Query memory: 0.013 MB Memory before query: 1.087 MB Rows returned: 68

   SELECT folder AS type, element AS name, params
   
     FROM dcv6x_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

   Error

   You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT folder AS type, element AS name, params FROM dcv6x_extensions WHERE enabl' at line 1 SQL=EXPLAIN EXTENDED SELECT folder AS type, element AS name, params FROM dcv6x_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) 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.5 ms
   end	0.0 ms
   query end	0.0 ms
   waiting for handler commit	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

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

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

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

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

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

   JROOT/index.php:45

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

   ---

8. Query Time: 0.94 ms After last query: 7.50 ms Query memory: 0.019 MB Memory before query: 1.554 MB Rows returned: 1
   Duplicate queries: #9

   SELECT template
   
     FROM dcv6x_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 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 template FROM dcv6x_template_styles as s WHERE s.client_id = 0 AND s.home' at line 1 SQL=EXPLAIN EXTENDED SELECT template FROM dcv6x_template_styles as s WHERE s.client_id = 0 AND s.home = 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.4 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
   waiting for handler commit	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31

   JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105

   JROOT/libraries/rokcommon/RokCommon/Service.php:71

   JROOT/libraries/rokcommon/include.php:38

   JROOT/plugins/system/rokcommon/rokcommon.php:96

   JROOT/plugins/system/rokcommon/rokcommon.php:54

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

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

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

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

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

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

   JROOT/index.php:45

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

   ---

9. Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 1.573 MB Rows returned: 1
   Duplicate queries: #8

   SELECT template
   
     FROM dcv6x_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 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 template FROM dcv6x_template_styles as s WHERE s.client_id = 0 AND s.home' at line 1 SQL=EXPLAIN EXTENDED SELECT template FROM dcv6x_template_styles as s WHERE s.client_id = 0 AND s.home = 1

   Profile

   Status	Duration
   starting	0.0 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.0 ms
   end	0.0 ms
   query end	0.0 ms
   waiting for handler commit	0.0 ms
   closing tables	0.0 ms
   freeing items	0.0 ms
   cleaning up	0.0 ms

   Call Stack

   JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31

   JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67

   JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106

   JROOT/libraries/rokcommon/RokCommon/Service.php:71

   JROOT/libraries/rokcommon/include.php:38

   JROOT/plugins/system/rokcommon/rokcommon.php:96

   JROOT/plugins/system/rokcommon/rokcommon.php:54

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

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

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

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

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

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

   JROOT/index.php:45

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

   ---

10. Query Time: 0.55 ms After last query: 2.92 ms Query memory: 0.015 MB Memory before query: 1.788 MB Rows returned: 2

    SELECT extension, file, type
    
      FROM dcv6x_rokcommon_configs
    
      ORDER BY priority

    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, file, type FROM dcv6x_rokcommon_configs ORDER BY priority' at line 1 SQL=EXPLAIN EXTENDED SELECT extension, file, type FROM dcv6x_rokcommon_configs ORDER BY priority

    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.3 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
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/plugins/system/rokcommon/rokcommon.php:132

    JROOT/plugins/system/rokcommon/rokcommon.php:76

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

11. Query Time: 2.52 ms After last query: 8.90 ms Query memory: 0.023 MB Memory before query: 2.317 MB Rows returned: 17

    SHOW FULL COLUMNS 
      FROM `dcv6x_extensions`

    Explain

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

    Profile

    Status	Duration
    starting	0.2 ms
    Executing hook on transaction	0.0 ms
    starting	0.1 ms
    checking permissions	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.2 ms
    preparing	0.0 ms
    Creating tmp table	0.1 ms
    executing	0.1 ms
    checking permissions	0.1 ms
    checking permissions	0.1 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
    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.1 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/table/table.php:241

    JROOT/libraries/joomla/table/table.php:162

    JROOT/libraries/joomla/table/extension.php:30

    JROOT/libraries/joomla/table/table.php:305

    JROOT/plugins/system/roksprocket/roksprocket.php:45

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

12. Query Time: 0.42 ms After last query: 0.86 ms Query memory: 0.016 MB Memory before query: 2.385 MB Rows returned: 1

    SELECT `extension_id`
    
      FROM `dcv6x_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    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` FROM `dcv6x_extensions` WHERE type = 'component' AND eleme' at line 1 SQL=EXPLAIN EXTENDED SELECT `extension_id` FROM `dcv6x_extensions` WHERE type = 'component' AND element = 'com_roksprocket'

    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
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/table/extension.php:108

    JROOT/plugins/system/roksprocket/roksprocket.php:49

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

13. Query Time: 0.23 ms After last query: 0.15 ms Query memory: 0.020 MB Memory before query: 2.403 MB Rows returned: 1
    Duplicate queries: #15

    SELECT *
    
      FROM dcv6x_extensions
    
      WHERE `extension_id` = '10014'

    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 dcv6x_extensions WHERE `extension_id` = '10014'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM dcv6x_extensions WHERE `extension_id` = '10014'

    Profile

    Status	Duration
    starting	0.0 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.0 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/table/table.php:728

    JROOT/plugins/system/roksprocket/roksprocket.php:54

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

14. Query Time: 0.24 ms After last query: 0.13 ms Query memory: 0.016 MB Memory before query: 2.416 MB Rows returned: 1

    SELECT `extension_id`
    
      FROM `dcv6x_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    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` FROM `dcv6x_extensions` WHERE type = 'module' AND element ' at line 1 SQL=EXPLAIN EXTENDED SELECT `extension_id` FROM `dcv6x_extensions` WHERE type = 'module' AND element = 'mod_roksprocket'

    Profile

    Status	Duration
    starting	0.0 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
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/table/extension.php:108

    JROOT/plugins/system/roksprocket/roksprocket.php:72

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

15. Query Time: 0.27 ms After last query: 0.11 ms Query memory: 0.020 MB Memory before query: 2.432 MB Rows returned: 1
    Duplicate queries: #13

    SELECT *
    
      FROM dcv6x_extensions
    
      WHERE `extension_id` = '10014'

    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 dcv6x_extensions WHERE `extension_id` = '10014'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM dcv6x_extensions WHERE `extension_id` = '10014'

    Profile

    Status	Duration
    starting	0.0 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.0 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/table/table.php:728

    JROOT/plugins/system/roksprocket/roksprocket.php:76

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

16. Query Time: 1.47 ms After last query: 20.96 ms Query memory: 0.026 MB Memory before query: 2.884 MB Rows returned: 12

    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 dcv6x_menu AS m
    
      LEFT JOIN dcv6x_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 dcv6x_menu AS m LEFT JOIN dcv6x_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.2 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.4 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.1 ms
    executing	0.4 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

17. Query Time: 0.63 ms After last query: 2.85 ms Query memory: 0.024 MB Memory before query: 3.173 MB Rows returned: 1

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

    Profile

    Status	Duration
    starting	0.2 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.1 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	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:157

    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:189

    JROOT/libraries/joomla/factory.php:736

    JROOT/libraries/joomla/factory.php:216

    JROOT/plugins/system/k2/k2.php:40

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

18. Query Time: 3.03 ms After last query: 0.98 ms Query memory: 0.017 MB Memory before query: 3.194 MB

    UPDATE `dcv6x_extensions`
    
      SET `params` = '{\"mediaversion\":\"805ec684aa4af98091134d9810fe0baf\"}'
    
      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 `dcv6x_extensions` SET `params` = '{\"mediaversion\":\"805ec684aa4af98091' at line 1 SQL=EXPLAIN EXTENDED UPDATE `dcv6x_extensions` SET `params` = '{\"mediaversion\":\"805ec684aa4af98091134d9810fe0baf\"}' 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.2 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	2.5 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:240

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

    JROOT/libraries/joomla/factory.php:736

    JROOT/libraries/joomla/factory.php:216

    JROOT/plugins/system/k2/k2.php:40

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

19. Query Time: 0.63 ms After last query: 1.18 ms Query memory: 0.022 MB Memory before query: 3.318 MB Rows returned: 1

    SELECT *
    
      FROM dcv6x_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 dcv6x_languages WHERE published=1 ORDER BY ordering ASC' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM dcv6x_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.3 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

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

    JROOT/components/com_k2/helpers/utilities.php:305

    JROOT/administrator/components/com_k2/helpers/html.php:56

    JROOT/plugins/system/k2/k2.php:45

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

20. Query Time: 0.52 ms After last query: 0.73 ms Query memory: 0.027 MB Memory before query: 3.367 MB Rows returned: 4
    Duplicate queries: #22  #23

    SELECT id, home, template, s.params
    
      FROM dcv6x_template_styles as s
    
      LEFT JOIN dcv6x_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 dcv6x_template_styles as s LEFT JOIN dc' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home, template, s.params FROM dcv6x_template_styles as s LEFT JOIN dcv6x_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.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.1 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

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

    JROOT/libraries/cms/html/html.php:334

    JROOT/libraries/cms/html/html.php:680

    JROOT/libraries/cms/html/html.php:236

    JROOT/libraries/cms/html/html.php:138

    JROOT/libraries/cms/html/jquery.php:53

    JROOT/libraries/cms/html/html.php:236

    JROOT/libraries/cms/html/html.php:138

    JROOT/administrator/components/com_k2/helpers/html.php:79

    JROOT/plugins/system/k2/k2.php:45

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

21. Query Time: 0.85 ms After last query: 2.57 ms Query memory: 0.022 MB Memory before query: 3.481 MB Rows returned: 9

    SELECT * 
      FROM dcv6x_rokcandy 
      WHERE published=1

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM dcv6x_rokcandy WHERE published=1' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM dcv6x_rokcandy WHERE published=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.3 ms
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 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.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27

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

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

    JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17

    JROOT/plugins/system/rokcandy/rokcandy.php:28

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

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

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

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

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

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

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

    JROOT/index.php:45

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

    ---

22. Query Time: 1.02 ms After last query: 17.27 ms Query memory: 0.023 MB Memory before query: 5.314 MB Rows returned: 4
    Duplicate queries: #20  #23

    SELECT id, home, template, s.params
    
      FROM dcv6x_template_styles as s
    
      LEFT JOIN dcv6x_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 dcv6x_template_styles as s LEFT JOIN dc' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home, template, s.params FROM dcv6x_template_styles as s LEFT JOIN dcv6x_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.2 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.2 ms
    preparing	0.1 ms
    executing	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/gantry/core/gantrytemplate.class.php:638

    JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65

    JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:42

    JROOT/libraries/gantry/core/gantry.class.php:1843

    JROOT/libraries/gantry/core/gantry.class.php:392

    JROOT/libraries/gantry/gantry.php:275

    JROOT/libraries/gantry/gantry.php:432

    JROOT/templates/rt_osmosis/lib/gantry/gantry.php:21

    JROOT/templates/rt_osmosis/component.php:15

    JROOT/libraries/joomla/document/html/html.php:578

    JROOT/libraries/joomla/document/html/html.php:635

    JROOT/libraries/joomla/document/html/html.php:455

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

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

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

    JROOT/index.php:45

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

    ---

23. Query Time: 0.58 ms After last query: 1.23 ms Query memory: 0.024 MB Memory before query: 5.339 MB Rows returned: 4
    Duplicate queries: #20  #22

    SELECT id, home, template, s.params
    
      FROM dcv6x_template_styles as s
    
      LEFT JOIN dcv6x_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 dcv6x_template_styles as s LEFT JOIN dc' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home, template, s.params FROM dcv6x_template_styles as s LEFT JOIN dcv6x_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.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.1 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/gantry/core/gantrytemplate.class.php:638

    JROOT/libraries/gantry/core/gantrytemplate.class.php:590

    JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69

    JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:42

    JROOT/libraries/gantry/core/gantry.class.php:1843

    JROOT/libraries/gantry/core/gantry.class.php:392

    JROOT/libraries/gantry/gantry.php:275

    JROOT/libraries/gantry/gantry.php:432

    JROOT/templates/rt_osmosis/lib/gantry/gantry.php:21

    JROOT/templates/rt_osmosis/component.php:15

    JROOT/libraries/joomla/document/html/html.php:578

    JROOT/libraries/joomla/document/html/html.php:635

    JROOT/libraries/joomla/document/html/html.php:455

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

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

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

    JROOT/index.php:45

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

    ---

24. Query Time: 2.04 ms After last query: 21.71 ms Query memory: 0.029 MB Memory before query: 5.768 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `dcv6x_template_styles`

    Explain

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

    Profile

    Status	Duration
    starting	0.2 ms
    Executing hook on transaction	0.0 ms
    starting	0.1 ms
    checking permissions	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.1 ms
    preparing	0.0 ms
    Creating tmp table	0.1 ms
    executing	0.1 ms
    checking permissions	0.1 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.1 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/table/table.php:241

    JROOT/libraries/joomla/table/table.php:162

    JROOT/administrator/components/com_templates/tables/style.php:30

    JROOT/libraries/joomla/table/table.php:305

    JROOT/plugins/system/gantry/gantry.php:194

    JROOT/plugins/system/gantry/gantry.php:165

    JROOT/plugins/system/gantry/gantry.php:234

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

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

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

    JROOT/libraries/joomla/document/html/renderer/head.php:57

    JROOT/libraries/joomla/document/html/renderer/head.php:34

    JROOT/libraries/joomla/document/html/html.php:411

    JROOT/libraries/joomla/document/html/html.php:697

    JROOT/libraries/joomla/document/html/html.php:477

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

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

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

    JROOT/index.php:45

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

    ---

25. Query Time: 0.28 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 5.811 MB Rows returned: 1

    SELECT *
    
      FROM dcv6x_template_styles
    
      WHERE `id` = '11'

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

    Profile

    Status	Duration
    starting	0.0 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.0 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

    Call Stack

    JROOT/libraries/joomla/table/table.php:728

    JROOT/plugins/system/gantry/gantry.php:168

    JROOT/plugins/system/gantry/gantry.php:234

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

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

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

    JROOT/libraries/joomla/document/html/renderer/head.php:57

    JROOT/libraries/joomla/document/html/renderer/head.php:34

    JROOT/libraries/joomla/document/html/html.php:411

    JROOT/libraries/joomla/document/html/html.php:697

    JROOT/libraries/joomla/document/html/html.php:477

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

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

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

    JROOT/index.php:45

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

    ---

26. Query Time: 3.02 ms After last query: 10.65 ms Query memory: 0.003 MB Memory before query: 5.890 MB

    UPDATE `dcv6x_session`
    
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1741885104;s:18:\"session.timer.last\";i:1741885104;s:17:\"session.timer.now\";i:1741885104;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:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;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:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";N;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:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"com_mailto.formtime\";i:1741885104;s:13:\"session.token\";s:32:\"c60762c55c4d525d5e32b3e9bbef91f2\";}'
    	, `time` = '1741885104'
    
      WHERE `session_id` = 'd882592162da64b5076b2b32547aa5e5'

    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 `dcv6x_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1' at line 1 SQL=EXPLAIN EXTENDED UPDATE `dcv6x_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1741885104;s:18:\"session.timer.last\";i:1741885104;s:17:\"session.timer.now\";i:1741885104;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:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;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:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";N;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:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"com_mailto.formtime\";i:1741885104;s:13:\"session.token\";s:32:\"c60762c55c4d525d5e32b3e9bbef91f2\";}' , `time` = '1741885104' WHERE `session_id` = 'd882592162da64b5076b2b32547aa5e5'

    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.2 ms
    end	0.0 ms
    query end	0.0 ms
    waiting for handler commit	2.2 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:84

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

    ---

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 3 × SELECT id, home, template, s.params 
     FROM dcv6x_template_styles as s 
     LEFT JOIN dcv6x_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

2. 2 × SELECT `extension_id` 
     FROM `dcv6x_extensions`

3. 2 × SELECT template 
     FROM dcv6x_template_styles as s

4. 2 × SELECT * 
     FROM dcv6x_extensions

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

6. 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 dcv6x_menu AS m 
     LEFT JOIN dcv6x_extensions AS e 
     ON m.component_id = e.extension_id

7. 1 × SELECT * 
     FROM dcv6x_rokcandy

8. 1 × SELECT * 
     FROM dcv6x_languages

9. 1 × SELECT * 
     FROM dcv6x_template_styles

10. 1 × SELECT extension, file, type 
      FROM dcv6x_rokcommon_configs

11. 1 × SELECT `session_id` 
      FROM `dcv6x_session`

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

13. 1 × SELECT id, rules 
      FROM `dcv6x_viewlevels

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

15. 1 × SELECT `data` 
      FROM `dcv6x_session`

OTHER Tables:

1. 1 × UPDATE `dcv6x_session` 
     SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1741885104;s:18:\"session.timer.last\";i:1741885104;s:17:\"session.timer.now\";i:1741885104;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:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";N;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:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";N;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:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:19:\"com_mailto.formtime\";i:1741885104;s:13:\"session.token\";s:32:\"c60762c55c4d525d5e32b3e9bbef91f2\";}'  , `time` = '1741885104'

2. 1 × SHOW FULL COLUMNS 
     FROM `dcv6x_template_styles

3. 1 × UPDATE `dcv6x_extensions` 
     SET `params` = '{\"mediaversion\":\"805ec684aa4af98091134d9810fe0baf\"}'

4. 1 × SHOW FULL COLUMNS 
     FROM `dcv6x_extensions

5. 1 × INSERT INTO `dcv6x_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('d882592162da64b5076b2b32547aa5e5', 0, '1741885104'