Joomla! Debug Console

Time

Memory

246 Queries Logged 183.4 ms

1. Query Time: 0.46 ms Query memory: 0.015 MB Memory before query: 2.270 MB Rows returned: 0

   SELECT `data`
   
     FROM `demo_session`
   
     WHERE `session_id` = '4u73chjid4ke07umv4c34b4gh7'

   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 `demo_session` WHERE `session_id` = '4u73chjid4ke07umv4c34b4g' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `demo_session` WHERE `session_id` = '4u73chjid4ke07umv4c34b4gh7'

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

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

   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.43 ms After last query: 2.43 ms Query memory: 0.012 MB Memory before query: 2.416 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `demo_session`
   
     WHERE `session_id` = '4u73chjid4ke07umv4c34b4gh7' 
     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 `demo_session` WHERE `session_id` = '4u73chjid4ke07umv4' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `demo_session` WHERE `session_id` = '4u73chjid4ke07umv4c34b4gh7' LIMIT 0, 1

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   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.36 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 2.428 MB

   INSERT INTO `demo_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('4u73chjid4ke07umv4c34b4gh7', 0, '1792042262')

   Explain

   EXPLAIN not possible on query: INSERT INTO `demo_session` (`session_id`, `client_id`, `time`) VALUES ('4u73chjid4ke07umv4c34b4gh7', 0, '1792042262')

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   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.70 ms After last query: 4.49 ms Query memory: 0.015 MB Memory before query: 2.788 MB Rows returned: 1

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

   JROOT/index.php:40

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

   ---

5. Query Time: 0.89 ms After last query: 1.64 ms Query memory: 0.014 MB Memory before query: 2.893 MB Rows returned: 1

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

6. Query Time: 0.53 ms After last query: 0.77 ms Query memory: 0.013 MB Memory before query: 2.956 MB Rows returned: 4

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

7. Query Time: 1.00 ms After last query: 0.25 ms Query memory: 0.014 MB Memory before query: 2.975 MB Rows returned: 56

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

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

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

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

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

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

   JROOT/index.php:40

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

   ---

8. Query Time: 0.69 ms After last query: 4.63 ms Query memory: 0.016 MB Memory before query: 3.372 MB Rows returned: 2

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

   JROOT/index.php:40

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

   ---

9. Query Time: 0.50 ms After last query: 0.27 ms Query memory: 0.018 MB Memory before query: 3.408 MB Rows returned: 1

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

   JROOT/index.php:40

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

   ---

10. Query Time: 1.54 ms After last query: 0.55 ms Query memory: 0.013 MB Memory before query: 3.439 MB Rows returned: 1

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

    JROOT/index.php:40

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

    ---

11. Query Time: 0.89 ms After last query: 10.35 ms Query memory: 0.022 MB Memory before query: 4.148 MB Rows returned: 1

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/ytshortcodes/ytshortcodes.php:34

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

12. Query Time: 0.61 ms After last query: 0.37 ms Query memory: 0.016 MB Memory before query: 4.154 MB

    UPDATE `demo_extensions`
    
      SET `params` = '{\"mediaversion\":\"c1c92b9d0d8a8959173a43bfeaa138c5\",\"Array\":[\"6c8ae80e85a4d51234e0982ff63e2b33\"]}'
    
      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 `demo_extensions` SET `params` = '{\"mediaversion\":\"c1c92b9d0d8a8959173' at line 1 SQL=EXPLAIN EXTENDED UPDATE `demo_extensions` SET `params` = '{\"mediaversion\":\"c1c92b9d0d8a8959173a43bfeaa138c5\",\"Array\":[\"6c8ae80e85a4d51234e0982ff63e2b33\"]}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/ytshortcodes/ytshortcodes.php:34

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

13. Query Time: 5.12 ms After last query: 25.85 ms Query memory: 0.056 MB Memory before query: 6.368 MB Rows returned: 171

    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 demo_menu AS m
    
      LEFT JOIN demo_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 demo_menu AS m LEFT JOIN demo_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

    No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

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

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

14. Query Time: 0.87 ms After last query: 18.79 ms Query memory: 0.015 MB Memory before query: 8.404 MB Rows returned: 1

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

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

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

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

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

    JROOT/index.php:40

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

    ---

15. Query Time: 0.93 ms After last query: 1.02 ms Query memory: 0.010 MB Memory before query: 8.439 MB Rows returned: 4

    SELECT id, home, template, s.params
    
      FROM demo_template_styles as s
    
      LEFT JOIN demo_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 demo_template_styles as s LEFT JOIN dem' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home, template, s.params FROM demo_template_styles as s LEFT JOIN demo_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

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

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

    JROOT/index.php:40

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

    ---

16. Query Time: 1.01 ms After last query: 12.32 ms Query memory: 0.024 MB Memory before query: 9.256 MB Rows returned: 1

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_content/models/article.php:55

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

    JROOT/components/com_content/models/article.php:75

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

    JROOT/components/com_content/views/article/view.html.php:44

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

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

    JROOT/index.php:40

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

    ---

17. Query Time: 1.00 ms After last query: 0.99 ms Query memory: 0.025 MB Memory before query: 9.312 MB Rows returned: 2

    SELECT b.rules
    
      FROM demo_assets AS a
    
      LEFT JOIN demo_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_content')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.rules FROM demo_assets AS a LEFT JOIN demo_assets AS b ON b.lft <= a.lf' at line 1 SQL=EXPLAIN EXTENDED SELECT b.rules FROM demo_assets AS a LEFT JOIN demo_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

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

    JROOT/components/com_content/models/article.php:55

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

    JROOT/components/com_content/models/article.php:75

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

    JROOT/components/com_content/views/article/view.html.php:44

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

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

    JROOT/index.php:40

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

    ---

18. Query Time: 4.11 ms After last query: 0.78 ms Query memory: 0.027 MB Memory before query: 9.358 MB Rows returned: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM demo_content AS a
    
      LEFT JOIN demo_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN demo_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN demo_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN demo_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM demo_categories AS cat JOIN demo_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.language in ('en-GB','*') 
      AND a.id = 200 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-15 05:31:02') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-15 05:31:02') 
      AND (a.state = 1 OR a.state =2)

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN ba' at line 1 SQL=EXPLAIN EXTENDED SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM demo_content AS a LEFT JOIN demo_categories AS c on c.id = a.catid LEFT JOIN demo_users AS u on u.id = a.created_by LEFT JOIN demo_categories as parent ON parent.id = c.parent_id LEFT JOIN demo_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM demo_categories AS cat JOIN demo_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.language in ('en-GB','*') AND a.id = 200 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-15 05:31:02') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-15 05:31:02') AND (a.state = 1 OR a.state =2)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_content/models/article.php:158

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

    JROOT/components/com_content/views/article/view.html.php:44

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

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

    JROOT/index.php:40

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

    ---

19. Query Time: 2.98 ms After last query: 3.42 ms Query memory: 0.026 MB Memory before query: 9.571 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM demo_categories as c
    
      LEFT JOIN demo_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM demo_categories AS cat JOIN demo_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=91 
      AND badcats.id is null
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1 SQL=EXPLAIN EXTENDED SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM demo_categories as c LEFT JOIN demo_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM demo_categories AS cat JOIN demo_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=91 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/legacy/categories/categories.php:288

    JROOT/libraries/legacy/categories/categories.php:181

    JROOT/components/com_content/helpers/route.php:41

    JROOT/components/com_content/views/article/view.html.php:72

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

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

    JROOT/index.php:40

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

    ---

20. Query Time: 0.86 ms After last query: 4.86 ms Query memory: 0.024 MB Memory before query: 9.852 MB Rows returned: 1

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/views/article/view.html.php:155

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

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

    JROOT/index.php:40

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

    ---

21. Query Time: 1.18 ms After last query: 0.33 ms Query memory: 0.024 MB Memory before query: 9.863 MB Rows returned: 0

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_content/views/article/view.html.php:155

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

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

    JROOT/index.php:40

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

    ---

22. Query Time: 3.75 ms After last query: 9.60 ms Query memory: 0.028 MB Memory before query: 10.389 MB Rows returned: 35

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM demo_modules AS m
    
      LEFT JOIN demo_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN demo_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-15 05:31:02') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-15 05:31:02') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 784 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1 SQL=EXPLAIN EXTENDED SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM demo_modules AS m LEFT JOIN demo_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN demo_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-15 05:31:02') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-15 05:31:02') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 784 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/cms/module/helper.php:376

    JROOT/libraries/cms/module/helper.php:84

    JROOT/plugins/content/loadmodule/loadmodule.php:139

    JROOT/plugins/content/loadmodule/loadmodule.php:80

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

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

    JROOT/components/com_content/views/article/view.html.php:160

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

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

    JROOT/index.php:40

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

    ---

23. Query Time: 4.18 ms After last query: 5.03 ms Query memory: 0.027 MB Memory before query: 10.640 MB Rows returned: 30

    SHOW FULL COLUMNS 
      FROM `demo_content`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/libraries/legacy/table/content.php:31

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

    JROOT/components/com_content/models/article.php:263

    JROOT/components/com_content/views/article/view.html.php:176

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

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

    JROOT/index.php:40

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

    ---

24. Query Time: 0.58 ms After last query: 3.01 ms Query memory: 0.026 MB Memory before query: 10.829 MB Rows returned: 1

    SELECT *
    
      FROM demo_content
    
      WHERE `id` = '200'

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_content/models/article.php:264

    JROOT/components/com_content/views/article/view.html.php:176

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

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

    JROOT/index.php:40

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

    ---

25. Query Time: 0.37 ms After last query: 0.30 ms Query memory: 0.016 MB Memory before query: 10.846 MB

    UPDATE demo_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '200'

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_content/models/article.php:265

    JROOT/components/com_content/views/article/view.html.php:176

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

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

    JROOT/index.php:40

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

    ---

26. Query Time: 1.07 ms After last query: 6.07 ms Query memory: 0.015 MB Memory before query: 11.058 MB Rows returned: 0

    SELECT m2.language, m2.id
    
      FROM demo_menu as m
    
      INNER JOIN demo_associations as a 
      ON a.id=m.id 
      AND a.context='com_menus.item'
    
      INNER JOIN demo_associations as a2 
      ON a.key=a2.key
    
      INNER JOIN demo_menu as m2 
      ON a2.id=m2.id
    
      WHERE m.id=784

    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 m2.language, m2.id FROM demo_menu as m INNER JOIN demo_associations as a ' at line 1 SQL=EXPLAIN EXTENDED SELECT m2.language, m2.id FROM demo_menu as m INNER JOIN demo_associations as a ON a.id=m.id AND a.context='com_menus.item' INNER JOIN demo_associations as a2 ON a.key=a2.key INNER JOIN demo_menu as m2 ON a2.id=m2.id WHERE m.id=784

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/administrator/components/com_menus/helpers/menus.php:257

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

    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/site.php:183

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

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

    JROOT/index.php:40

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

    ---

27. Query Time: 0.78 ms After last query: 1.48 ms Query memory: 0.017 MB Memory before query: 11.110 MB Rows returned: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `demo_content` AS `c`
    
      INNER JOIN `demo_associations` AS `a` 
      ON a.id = c.id 
      AND a.context='com_content.item'
    
      INNER JOIN `demo_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `demo_content` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `demo_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_content'
    
      WHERE c.id = 200

    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 `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS' at line 1 SQL=EXPLAIN EXTENDED SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` FROM `demo_content` AS `c` INNER JOIN `demo_associations` AS `a` ON a.id = c.id AND a.context='com_content.item' INNER JOIN `demo_associations` AS `a2` ON a.key = a2.key INNER JOIN `demo_content` AS `c2` ON a2.id = c2.`id` INNER JOIN `demo_categories` AS `ca` ON `c2`.`catid` = ca.id AND ca.extension = 'com_content' WHERE c.id = 200

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/cms/language/associations.php:83

    JROOT/components/com_content/helpers/association.php:48

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

    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/site.php:183

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

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

    JROOT/index.php:40

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

    ---

28. Query Time: 0.64 ms After last query: 7.25 ms Query memory: 0.017 MB Memory before query: 11.543 MB Rows returned: 1

    SELECT template_style_id 
      FROM demo_menu 
      WHERE id = 784

    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_style_id FROM demo_menu WHERE id = 784' at line 1 SQL=EXPLAIN EXTENDED SELECT template_style_id FROM demo_menu WHERE id = 784

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:129

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30

    JROOT/templates/sj_g2shop/includes/frame_inc.php:29

    JROOT/templates/sj_g2shop/index.php:29

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

29. Query Time: 0.42 ms After last query: 0.10 ms Query memory: 0.017 MB Memory before query: 11.559 MB Rows returned: 1

    SELECT id 
      FROM demo_template_styles 
      WHERE home = 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 id FROM demo_template_styles WHERE home = 1 AND client_id = 0' at line 1 SQL=EXPLAIN EXTENDED SELECT id FROM demo_template_styles WHERE home = 1 AND client_id = 0

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:133

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30

    JROOT/templates/sj_g2shop/includes/frame_inc.php:29

    JROOT/templates/sj_g2shop/index.php:29

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

30. Query Time: 0.40 ms After last query: 4.16 ms Query memory: 0.014 MB Memory before query: 11.682 MB Rows returned: 1
    Duplicate queries: #31

    SELECT home 
      FROM demo_menu 
      WHERE id=784

    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 home FROM demo_menu WHERE id=784' at line 1 SQL=EXPLAIN EXTENDED SELECT home FROM demo_menu WHERE id=784

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117

    JROOT/templates/sj_g2shop/index.php:71

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

31. Query Time: 0.26 ms After last query: 0.06 ms Query memory: 0.014 MB Memory before query: 11.696 MB Rows returned: 1
    Duplicate queries: #30

    SELECT home 
      FROM demo_menu 
      WHERE id=784

    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 home FROM demo_menu WHERE id=784' at line 1 SQL=EXPLAIN EXTENDED SELECT home FROM demo_menu WHERE id=784

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118

    JROOT/templates/sj_g2shop/index.php:71

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

32. Query Time: 7.14 ms After last query: 24.45 ms Query memory: 0.051 MB Memory before query: 13.358 MB Rows returned: 139

    SHOW FULL COLUMNS 
      FROM `demo_jshopping_config`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_jshopping/tables/config.php:15

    JROOT/components/com_jshopping/lib/factory.php:24

    JROOT/components/com_jshopping/lib/factory.php:221

    JROOT/components/com_jshopping/lib/factory.php:244

    JROOT/components/com_jshopping/router.php:15

    JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

    JROOT/libraries/joomla/application/route.php:63

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:423

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:176

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

33. Query Time: 1.25 ms After last query: 3.26 ms Query memory: 0.074 MB Memory before query: 13.872 MB Rows returned: 1

    SELECT *
    
      FROM demo_jshopping_config
    
      WHERE `id` = '1'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM demo_jshopping_config WHERE `id` = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_config WHERE `id` = '1'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/components/com_jshopping/lib/factory.php:27

    JROOT/components/com_jshopping/lib/factory.php:221

    JROOT/components/com_jshopping/lib/factory.php:244

    JROOT/components/com_jshopping/router.php:15

    JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

    JROOT/libraries/joomla/application/route.php:63

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:423

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:176

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

34. Query Time: 2.26 ms After last query: 1.36 ms Query memory: 0.045 MB Memory before query: 13.903 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `demo_jshopping_currencies`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_jshopping/tables/currency.php:22

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

    JROOT/components/com_jshopping/lib/factory.php:625

    JROOT/components/com_jshopping/tables/config.php:48

    JROOT/components/com_jshopping/lib/factory.php:29

    JROOT/components/com_jshopping/lib/factory.php:221

    JROOT/components/com_jshopping/lib/factory.php:244

    JROOT/components/com_jshopping/router.php:15

    JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

    JROOT/libraries/joomla/application/route.php:63

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:423

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:176

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

35. Query Time: 0.57 ms After last query: 0.28 ms Query memory: 0.039 MB Memory before query: 13.961 MB Rows returned: 3

    SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
      FROM `demo_jshopping_currencies` 
      WHERE currency_publish = '1' 
      ORDER BY currency_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 currency_id, currency_name, currency_code, currency_code_iso, currency_va' at line 1 SQL=EXPLAIN EXTENDED SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `demo_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/currency.php:30

    JROOT/components/com_jshopping/lib/factory.php:626

    JROOT/components/com_jshopping/tables/config.php:48

    JROOT/components/com_jshopping/lib/factory.php:29

    JROOT/components/com_jshopping/lib/factory.php:221

    JROOT/components/com_jshopping/lib/factory.php:244

    JROOT/components/com_jshopping/router.php:15

    JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

    JROOT/libraries/joomla/application/route.php:63

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:423

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:176

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

36. Query Time: 1.67 ms After last query: 0.72 ms Query memory: 0.036 MB Memory before query: 13.972 MB Rows returned: 74

    select id,link 
      from demo_menu 
      where `type`='component' 
      and published=1 
      and link like '%option=com_jshopping%' 
      and client_id=0 
      and (language='*' or language='en-GB') 
      and 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 id,link from demo_menu where `type`='component' and published=1 and link ' at line 1 SQL=EXPLAIN EXTENDED select id,link from demo_menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='en-GB') and access IN (1,1)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/lib/shop_item_menu.php:125

    JROOT/components/com_jshopping/lib/shop_item_menu.php:41

    JROOT/components/com_jshopping/lib/shop_item_menu.php:35

    JROOT/components/com_jshopping/router.php:16

    JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

    JROOT/libraries/joomla/application/route.php:63

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:423

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:176

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

37. Query Time: 0.52 ms After last query: 2.01 ms Query memory: 0.028 MB Memory before query: 14.122 MB Rows returned: 1

    SELECT id,title,module,position,content,showtitle,params 
      FROM demo_modules AS m 
      WHERE m.access IN (1,1) 
      AND m.published=1 
      AND m.id IN (322);

    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,title,module,position,content,showtitle,params FROM demo_modules AS m ' at line 1 SQL=EXPLAIN EXTENDED SELECT id,title,module,position,content,showtitle,params FROM demo_modules AS m WHERE m.access IN (1,1) AND m.published=1 AND m.id IN (322);

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:513

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:475

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default_group.php:22

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:232

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

38. Query Time: 0.39 ms After last query: 1.40 ms Query memory: 0.028 MB Memory before query: 14.155 MB Rows returned: 1

    SELECT id,title,module,position,content,showtitle,params 
      FROM demo_modules AS m 
      WHERE m.access IN (1,1) 
      AND m.published=1 
      AND m.id IN (323);

    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,title,module,position,content,showtitle,params FROM demo_modules AS m ' at line 1 SQL=EXPLAIN EXTENDED SELECT id,title,module,position,content,showtitle,params FROM demo_modules AS m WHERE m.access IN (1,1) AND m.published=1 AND m.id IN (323);

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:513

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:475

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default_group.php:22

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:232

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

39. Query Time: 0.35 ms After last query: 1.32 ms Query memory: 0.028 MB Memory before query: 14.187 MB Rows returned: 1

    SELECT id,title,module,position,content,showtitle,params 
      FROM demo_modules AS m 
      WHERE m.access IN (1,1) 
      AND m.published=1 
      AND m.id IN (324);

    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,title,module,position,content,showtitle,params FROM demo_modules AS m ' at line 1 SQL=EXPLAIN EXTENDED SELECT id,title,module,position,content,showtitle,params FROM demo_modules AS m WHERE m.access IN (1,1) AND m.published=1 AND m.id IN (324);

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:513

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:475

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default_group.php:22

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:232

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

40. Query Time: 0.98 ms After last query: 18.87 ms Query memory: 0.028 MB Memory before query: 14.284 MB Rows returned: 1

    SELECT id,title,module,position,content,showtitle,params 
      FROM demo_modules AS m 
      WHERE m.access IN (1,1) 
      AND m.published=1 
      AND m.id IN (226);

    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,title,module,position,content,showtitle,params FROM demo_modules AS m ' at line 1 SQL=EXPLAIN EXTENDED SELECT id,title,module,position,content,showtitle,params FROM demo_modules AS m WHERE m.access IN (1,1) AND m.published=1 AND m.id IN (226);

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:513

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:475

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:219

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:222

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/templates/sj_g2shop/menusys/class/mega/tmpl/default.php:30

    JROOT/templates/sj_g2shop/menusys/ytmenu.php:153

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:219

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:417

    JROOT/plugins/system/yt/includes/site/lib/yt_template.php:344

    JROOT/templates/sj_g2shop/index.php:176

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

41. Query Time: 0.77 ms After last query: 120.30 ms Query memory: 0.015 MB Memory before query: 13.658 MB Rows returned: 1

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/plugins/system/yt/yt.php:263

    JROOT/plugins/system/yt/yt.php:166

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

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

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

    JROOT/index.php:40

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

    ---

42. Query Time: 3.09 ms After last query: 11.65 ms Query memory: 0.019 MB Memory before query: 14.032 MB Rows returned: 30

    SELECT guest, client_id
    
      FROM demo_session
    
      WHERE 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 guest, client_id FROM demo_session WHERE client_id = 0' at line 1 SQL=EXPLAIN EXTENDED SELECT guest, client_id FROM demo_session WHERE client_id = 0

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_whosonline/helper.php:41

    JROOT/modules/mod_whosonline/mod_whosonline.php:19

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

43. Query Time: 4.33 ms After last query: 19.52 ms Query memory: 0.062 MB Memory before query: 14.562 MB Rows returned: 3

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured,a.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,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 demo_content AS a
    
      LEFT JOIN demo_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN demo_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN demo_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN demo_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN demo_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN demo_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM demo_categories AS cat JOIN demo_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (9) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-15 05:31:02') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-15 05:31:02') 
      AND a.language in ('en-GB','*')
    
      ORDER BY a.title ASC 
      LIMIT 0, 3

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked' at line 1 SQL=EXPLAIN EXTENDED SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured,a.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,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 demo_content AS a LEFT JOIN demo_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN demo_categories AS c ON c.id = a.catid LEFT JOIN demo_users AS ua ON ua.id = a.created_by LEFT JOIN demo_users AS uam ON uam.id = a.modified_by LEFT JOIN demo_categories as parent ON parent.id = c.parent_id LEFT JOIN demo_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM demo_categories AS cat JOIN demo_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND a.catid IN (9) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-15 05:31:02') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-15 05:31:02') AND a.language in ('en-GB','*') ORDER BY a.title ASC LIMIT 0, 3

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    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/modules/mod_sj_basic_news/core/helper.php:112

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:24

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

44. Query Time: 0.79 ms After last query: 1.10 ms Query memory: 0.029 MB Memory before query: 14.691 MB Rows returned: 0

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

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/modules/mod_sj_basic_news/core/helper.php:112

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:24

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

45. Query Time: 0.59 ms After last query: 0.77 ms Query memory: 0.029 MB Memory before query: 14.732 MB Rows returned: 0

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

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/modules/mod_sj_basic_news/core/helper.php:112

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:24

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

46. Query Time: 0.57 ms After last query: 0.62 ms Query memory: 0.029 MB Memory before query: 14.774 MB Rows returned: 0

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/modules/mod_sj_basic_news/core/helper.php:112

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:24

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

47. Query Time: 2.81 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 14.795 MB Rows returned: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM demo_categories as c
    
      LEFT JOIN demo_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM demo_categories AS cat JOIN demo_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=9 
      AND badcats.id is null
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1 SQL=EXPLAIN EXTENDED SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM demo_categories as c LEFT JOIN demo_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM demo_categories AS cat JOIN demo_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=9 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/libraries/legacy/categories/categories.php:288

    JROOT/libraries/legacy/categories/categories.php:181

    JROOT/components/com_content/helpers/route.php:80

    JROOT/modules/mod_sj_basic_news/core/helper.php:130

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_basic_news/mod_sj_basic_news.php:24

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

48. Query Time: 5.03 ms After last query: 13.72 ms Query memory: 0.029 MB Memory before query: 15.228 MB Rows returned: 67

    SHOW FULL COLUMNS 
      FROM `demo_jshopping_products`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_jshopping/tables/product.php:14

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

    JROOT/modules/mod_jshopping_tophits_products/mod_jshopping_tophits_products.php:31

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

49. Query Time: 1.72 ms After last query: 1.26 ms Query memory: 0.023 MB Memory before query: 15.427 MB Rows returned: 4

    SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices 
      FROM `demo_jshopping_products` AS prod
                      
      INNER JOIN `demo_jshopping_products_to_categories` AS pr_cat 
      ON pr_cat.product_id = prod.product_id
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND pr_cat.category_id IN (9) 
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1)
                      
      GROUP BY prod.product_id 
      ORDER BY prod.hits desc 
      LIMIT 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 prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`sho' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `demo_jshopping_products` AS prod INNER JOIN `demo_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND pr_cat.category_id IN (9) AND prod.access IN (1,1) AND cat.access IN (1,1) GROUP BY prod.product_id ORDER BY prod.hits desc LIMIT 4

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:938

    JROOT/modules/mod_jshopping_tophits_products/mod_jshopping_tophits_products.php:43

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

50. Query Time: 3.88 ms After last query: 2.15 ms Query memory: 0.030 MB Memory before query: 15.628 MB Rows returned: 52

    SHOW FULL COLUMNS 
      FROM `demo_jshopping_users`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_jshopping/tables/usershop.php:14

    JROOT/components/com_jshopping/lib/factory.php:126

    JROOT/components/com_jshopping/lib/functions.php:627

    JROOT/components/com_jshopping/tables/product.php:939

    JROOT/modules/mod_jshopping_tophits_products/mod_jshopping_tophits_products.php:43

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

51. Query Time: 2.12 ms After last query: 1.60 ms Query memory: 0.027 MB Memory before query: 15.790 MB Rows returned: 3

    SHOW FULL COLUMNS 
      FROM `demo_jshopping_taxes`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_jshopping/tables/tax.php:17

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

    JROOT/components/com_jshopping/lib/factory.php:418

    JROOT/components/com_jshopping/lib/functions.php:628

    JROOT/components/com_jshopping/tables/product.php:939

    JROOT/modules/mod_jshopping_tophits_products/mod_jshopping_tophits_products.php:43

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

52. Query Time: 0.50 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 15.820 MB Rows returned: 1

    SELECT tax_id, tax_name, tax_value 
      FROM `demo_jshopping_taxes`

    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 tax_id, tax_name, tax_value FROM `demo_jshopping_taxes`' at line 1 SQL=EXPLAIN EXTENDED SELECT tax_id, tax_name, tax_value FROM `demo_jshopping_taxes`

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/tax.php:24

    JROOT/components/com_jshopping/lib/factory.php:403

    JROOT/components/com_jshopping/lib/factory.php:419

    JROOT/components/com_jshopping/lib/functions.php:628

    JROOT/components/com_jshopping/tables/product.php:939

    JROOT/modules/mod_jshopping_tophits_products/mod_jshopping_tophits_products.php:43

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

53. Query Time: 0.62 ms After last query: 1.09 ms Query memory: 0.027 MB Memory before query: 15.856 MB Rows returned: 0

    select product_id as id, `alias_en-GB` as alias 
      from demo_jshopping_products 
      where `alias_en-GB`!=''

    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 product_id as id, `alias_en-GB` as alias from demo_jshopping_products whe' at line 1 SQL=EXPLAIN EXTENDED select product_id as id, `alias_en-GB` as alias from demo_jshopping_products where `alias_en-GB`!=''

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/lib/factory.php:351

    JROOT/components/com_jshopping/router.php:61

    JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

    JROOT/libraries/joomla/application/route.php:63

    JROOT/components/com_jshopping/lib/functions.php:487

    JROOT/components/com_jshopping/lib/functions.php:437

    JROOT/modules/mod_jshopping_tophits_products/mod_jshopping_tophits_products.php:44

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

54. Query Time: 0.36 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 15.882 MB Rows returned: 3

    select category_id as id, `alias_en-GB` as alias 
      from demo_jshopping_categories 
      where `alias_en-GB`!=''

    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 category_id as id, `alias_en-GB` as alias from demo_jshopping_categories ' at line 1 SQL=EXPLAIN EXTENDED select category_id as id, `alias_en-GB` as alias from demo_jshopping_categories where `alias_en-GB`!=''

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/lib/factory.php:317

    JROOT/components/com_jshopping/router.php:62

    JROOT/libraries/cms/component/router/legacy.php:70

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

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

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

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

    JROOT/libraries/joomla/application/route.php:63

    JROOT/components/com_jshopping/lib/functions.php:487

    JROOT/components/com_jshopping/lib/functions.php:437

    JROOT/modules/mod_jshopping_tophits_products/mod_jshopping_tophits_products.php:44

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

55. Query Time: 3.79 ms After last query: 12.77 ms Query memory: 0.029 MB Memory before query: 16.231 MB Rows returned: 46

    SHOW FULL COLUMNS 
      FROM `demo_jshopping_categories`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_jshopping/tables/category.php:15

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

    JROOT/modules/mod_sj_js_super_category/core/helper.php:20

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

56. Query Time: 0.52 ms After last query: 0.99 ms Query memory: 0.031 MB Memory before query: 16.373 MB Rows returned: 1

    SELECT *
    
      FROM demo_jshopping_categories
    
      WHERE `category_id` = '6'

    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 demo_jshopping_categories WHERE `category_id` = '6'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_categories WHERE `category_id` = '6'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/modules/mod_sj_js_super_category/core/helper.php:26

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

57. Query Time: 0.38 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 16.386 MB Rows returned: 1

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_id IN (6)  
      AND category_publish = '1'  
      AND access IN (1,1)
                       
      ORDER BY category_id 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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_id IN (6) AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_sj_js_super_category/core/helper.php:193

    JROOT/modules/mod_sj_js_super_category/core/helper.php:28

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

58. Query Time: 0.83 ms After last query: 0.35 ms Query memory: 0.020 MB Memory before query: 16.421 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (6)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (6)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:28

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

59. Query Time: 0.57 ms After last query: 0.84 ms Query memory: 0.024 MB Memory before query: 16.438 MB Rows returned: 5

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '6'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '6' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

60. Query Time: 0.59 ms After last query: 2.24 ms Query memory: 0.025 MB Memory before query: 16.484 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '56'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '56' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

61. Query Time: 0.49 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 16.508 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '57'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '57' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

62. Query Time: 0.48 ms After last query: 0.27 ms Query memory: 0.025 MB Memory before query: 16.531 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '80'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '80' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

63. Query Time: 0.46 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 16.554 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '81'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '81' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

64. Query Time: 0.45 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 16.577 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '82'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '82' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

65. Query Time: 0.46 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 16.573 MB Rows returned: 4

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_id IN (56, 57, 80, 81, 82)  
      AND category_publish = '1'  
      AND access IN (1,1)
                       
      ORDER BY `name_en-GB` asc 
      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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_id IN (56, 57, 80, 81, 82) AND category_publish = '1' AND access IN (1,1) ORDER BY `name_en-GB` asc LIMIT 0, 4

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_sj_js_super_category/core/helper.php:193

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

66. Query Time: 0.76 ms After last query: 0.37 ms Query memory: 0.020 MB Memory before query: 16.614 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (80)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (80)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

67. Query Time: 0.60 ms After last query: 0.32 ms Query memory: 0.020 MB Memory before query: 16.634 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (57)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (57)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

68. Query Time: 0.58 ms After last query: 0.30 ms Query memory: 0.020 MB Memory before query: 16.654 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (82)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (82)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

69. Query Time: 0.76 ms After last query: 0.23 ms Query memory: 0.020 MB Memory before query: 16.674 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (81)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (81)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

70. Query Time: 0.93 ms After last query: 0.35 ms Query memory: 0.019 MB Memory before query: 16.681 MB Rows returned: 1
    Duplicate queries: #71  #72

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (6,56,57,80,81,82)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (6,56,57,80,81,82)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:60

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

71. Query Time: 1.01 ms After last query: 0.19 ms Query memory: 0.019 MB Memory before query: 16.701 MB Rows returned: 1
    Duplicate queries: #70  #72

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (6,56,57,80,81,82)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (6,56,57,80,81,82)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:60

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

72. Query Time: 1.00 ms After last query: 0.21 ms Query memory: 0.019 MB Memory before query: 16.720 MB Rows returned: 1
    Duplicate queries: #70  #71

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (6,56,57,80,81,82)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (6,56,57,80,81,82)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:60

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

73. Query Time: 2.70 ms After last query: 0.49 ms Query memory: 0.025 MB Memory before query: 16.754 MB Rows returned: 4

    SELECT distinct prod.product_id , SUM(OI.product_quantity) as best_seller, prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices 
      FROM `demo_jshopping_products` AS prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
    				  
      LEFT JOIN `demo_jshopping_order_item` AS OI  
      ON prod.product_id = OI.product_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (6,56,57,80,81,82)
                      
      GROUP BY prod.product_id  
      ORDER BY prod.reviews_count ASC 
      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 distinct prod.product_id , SUM(OI.product_quantity) as best_seller, prod.' at line 1 SQL=EXPLAIN EXTENDED SELECT distinct prod.product_id , SUM(OI.product_quantity) as best_seller, prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `demo_jshopping_products` AS prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id LEFT JOIN `demo_jshopping_order_item` AS OI ON prod.product_id = OI.product_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (6,56,57,80,81,82) GROUP BY prod.product_id ORDER BY prod.reviews_count ASC LIMIT 0, 4

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_sj_js_super_category/core/helper.php:112

    JROOT/modules/mod_sj_js_super_category/core/helper.php:72

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

74. Query Time: 0.80 ms After last query: 19.60 ms Query memory: 0.032 MB Memory before query: 16.874 MB Rows returned: 1

    SELECT *
    
      FROM demo_jshopping_categories
    
      WHERE `category_id` = '9'

    Explain

    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM demo_jshopping_categories WHERE `category_id` = '9'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_categories WHERE `category_id` = '9'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/modules/mod_sj_js_super_category/core/helper.php:26

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

75. Query Time: 0.39 ms After last query: 0.33 ms Query memory: 0.021 MB Memory before query: 16.888 MB Rows returned: 1

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_id IN (9)  
      AND category_publish = '1'  
      AND access IN (1,1)
                       
      ORDER BY category_id 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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_id IN (9) AND category_publish = '1' AND access IN (1,1) ORDER BY category_id asc

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_sj_js_super_category/core/helper.php:193

    JROOT/modules/mod_sj_js_super_category/core/helper.php:28

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

76. Query Time: 0.79 ms After last query: 0.34 ms Query memory: 0.020 MB Memory before query: 16.922 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (9)

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (9)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:28

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

77. Query Time: 0.61 ms After last query: 0.85 ms Query memory: 0.024 MB Memory before query: 16.939 MB Rows returned: 5

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '9'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '9' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

78. Query Time: 0.56 ms After last query: 2.03 ms Query memory: 0.025 MB Memory before query: 16.985 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '1'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '1' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

79. Query Time: 0.43 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 17.009 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '2'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '2' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

80. Query Time: 0.45 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 17.032 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '7'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '7' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

81. Query Time: 0.43 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 17.055 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '3'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '3' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

82. Query Time: 0.46 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 17.078 MB Rows returned: 0

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_parent_id = '4'  
      AND category_publish = '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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_parent_id = '4' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/category.php:33

    JROOT/modules/mod_sj_js_super_category/core/helper.php:127

    JROOT/modules/mod_sj_js_super_category/core/helper.php:134

    JROOT/modules/mod_sj_js_super_category/core/helper.php:120

    JROOT/modules/mod_sj_js_super_category/core/helper.php:146

    JROOT/modules/mod_sj_js_super_category/core/helper.php:40

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

83. Query Time: 0.43 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 17.073 MB Rows returned: 5

    SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image 
      FROM `demo_jshopping_categories`
                       
      WHERE category_id IN (1, 2, 7, 3, 4)  
      AND category_publish = '1'  
      AND access IN (1,1)
                       
      ORDER BY `name_en-GB` desc 
      LIMIT 0, 7

    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 `name_en-GB` as name,`description_en-GB` as description,`short_descriptio' at line 1 SQL=EXPLAIN EXTENDED SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_parent_id, category_publish, ordering, category_image FROM `demo_jshopping_categories` WHERE category_id IN (1, 2, 7, 3, 4) AND category_publish = '1' AND access IN (1,1) ORDER BY `name_en-GB` desc LIMIT 0, 7

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_sj_js_super_category/core/helper.php:193

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

84. Query Time: 0.75 ms After last query: 0.47 ms Query memory: 0.020 MB Memory before query: 17.114 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (2)

    Explain

    Error

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (2)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

85. Query Time: 0.61 ms After last query: 0.31 ms Query memory: 0.020 MB Memory before query: 17.135 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (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 COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (1)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

86. Query Time: 0.54 ms After last query: 0.33 ms Query memory: 0.020 MB Memory before query: 17.155 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (7)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (7)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

87. Query Time: 0.56 ms After last query: 0.29 ms Query memory: 0.020 MB Memory before query: 17.175 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (3)

    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(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (3)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

88. Query Time: 0.58 ms After last query: 0.47 ms Query memory: 0.020 MB Memory before query: 17.195 MB Rows returned: 1

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (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 COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (4)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:197

    JROOT/modules/mod_sj_js_super_category/core/helper.php:41

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

89. Query Time: 0.79 ms After last query: 0.50 ms Query memory: 0.019 MB Memory before query: 17.202 MB Rows returned: 1
    Duplicate queries: #90  #91

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (9,1,2,7,3,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 COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (9,1,2,7,3,4)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:60

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

90. Query Time: 0.78 ms After last query: 0.26 ms Query memory: 0.019 MB Memory before query: 17.221 MB Rows returned: 1
    Duplicate queries: #89  #91

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (9,1,2,7,3,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 COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (9,1,2,7,3,4)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:60

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

91. Query Time: 0.77 ms After last query: 0.23 ms Query memory: 0.019 MB Memory before query: 17.241 MB Rows returned: 1
    Duplicate queries: #89  #90

    SELECT COUNT(distinct prod.product_id) 
      FROM `demo_jshopping_products` as prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (9,1,2,7,3,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 COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod ' at line 1 SQL=EXPLAIN EXTENDED SELECT COUNT(distinct prod.product_id) FROM `demo_jshopping_products` as prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (9,1,2,7,3,4)

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:986

    JROOT/modules/mod_sj_js_super_category/core/helper.php:60

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

92. Query Time: 1.47 ms After last query: 0.56 ms Query memory: 0.025 MB Memory before query: 17.275 MB Rows returned: 4

    SELECT distinct prod.product_id , SUM(OI.product_quantity) as best_seller, prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices 
      FROM `demo_jshopping_products` AS prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
    				  
      LEFT JOIN `demo_jshopping_order_item` AS OI  
      ON prod.product_id = OI.product_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (9,1,2,7,3,4)
                      
      GROUP BY prod.product_id  
      ORDER BY prod.average_rating 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 distinct prod.product_id , SUM(OI.product_quantity) as best_seller, prod.' at line 1 SQL=EXPLAIN EXTENDED SELECT distinct prod.product_id , SUM(OI.product_quantity) as best_seller, prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `demo_jshopping_products` AS prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id LEFT JOIN `demo_jshopping_order_item` AS OI ON prod.product_id = OI.product_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (9,1,2,7,3,4) GROUP BY prod.product_id ORDER BY prod.average_rating DESC LIMIT 0, 4

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_sj_js_super_category/core/helper.php:112

    JROOT/modules/mod_sj_js_super_category/core/helper.php:72

    JROOT/modules/mod_sj_js_super_category/mod_sj_js_super_category.php:47

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

93. Query Time: 3.54 ms After last query: 39.99 ms Query memory: 0.035 MB Memory before query: 17.519 MB Rows returned: 50

    SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices 
      FROM `demo_jshopping_products` AS prod
                      
      LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id)
                      
      LEFT JOIN `demo_jshopping_categories` AS cat 
      ON pr_cat.category_id = cat.category_id
                      
                      
      WHERE prod.product_publish = '1' 
      AND cat.category_publish='1'  
      AND prod.access IN (1,1) 
      AND cat.access IN (1,1) 
      AND cat.category_id in (9,17,10,18,5,6,58)
                      
      GROUP BY prod.product_id  
      ORDER BY prod.date_modify  desc 
      LIMIT 0, 50

    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 prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`sho' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `demo_jshopping_products` AS prod LEFT JOIN `demo_jshopping_products_to_categories` AS pr_cat USING (product_id) LEFT JOIN `demo_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) AND cat.category_id in (9,17,10,18,5,6,58) GROUP BY prod.product_id ORDER BY prod.date_modify desc LIMIT 0, 50

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:965

    JROOT/modules/mod_sj_js_slider/core/helper.php:61

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

94. Query Time: 2.65 ms After last query: 2.41 ms Query memory: 0.031 MB Memory before query: 17.792 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `demo_jshopping_product_labels`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

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

    JROOT/components/com_jshopping/tables/productlabel.php:14

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

    JROOT/components/com_jshopping/lib/functions.php:602

    JROOT/components/com_jshopping/lib/functions.php:734

    JROOT/components/com_jshopping/tables/product.php:966

    JROOT/modules/mod_sj_js_slider/core/helper.php:61

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

95. Query Time: 0.77 ms After last query: 0.37 ms Query memory: 0.025 MB Memory before query: 17.838 MB Rows returned: 2

    SELECT id, image, `name_en-GB` as name 
      FROM `demo_jshopping_product_labels` 
      ORDER BY name

    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, image, `name_en-GB` as name FROM `demo_jshopping_product_labels` ORDE' at line 1 SQL=EXPLAIN EXTENDED SELECT id, image, `name_en-GB` as name FROM `demo_jshopping_product_labels` ORDER BY name

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/productlabel.php:22

    JROOT/components/com_jshopping/lib/functions.php:603

    JROOT/components/com_jshopping/lib/functions.php:734

    JROOT/components/com_jshopping/tables/product.php:966

    JROOT/modules/mod_sj_js_slider/core/helper.php:61

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

96. Query Time: 0.90 ms After last query: 48.13 ms Query memory: 0.040 MB Memory before query: 18.158 MB Rows returned: 1

    SELECT *
    
      FROM demo_jshopping_products
    
      WHERE `product_id` = '3'

    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 demo_jshopping_products WHERE `product_id` = '3'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '3'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/modules/mod_sj_js_slider/core/helper.php:65

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

97. Query Time: 1.00 ms After last query: 0.39 ms Query memory: 0.023 MB Memory before query: 18.170 MB Rows returned: 1

    SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
      FROM `demo_jshopping_products_images` as I 
      left join `demo_jshopping_products` as P 
      on P.product_id=I.product_id
                     
      WHERE I.product_id = '3' 
      ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '3' ORDER BY sort, I.ordering

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/components/com_jshopping/tables/product.php:322

    JROOT/modules/mod_sj_js_slider/core/helper.php:66

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

98. Query Time: 0.29 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 18.193 MB Rows returned: 1

    SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
      FROM demo_jshopping_products AS prod 
      WHERE prod.product_id =3

    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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =3

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    JROOT/modules/mod_sj_js_slider/core/helper.php:73

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

99. Query Time: 0.40 ms After last query: 0.62 ms Query memory: 0.040 MB Memory before query: 18.229 MB Rows returned: 1

    SELECT *
    
      FROM demo_jshopping_products
    
      WHERE `product_id` = '55'

    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 demo_jshopping_products WHERE `product_id` = '55'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '55'

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

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

    JROOT/modules/mod_sj_js_slider/core/helper.php:65

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

    JROOT/libraries/cms/module/helper.php:488

    JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

    JROOT/libraries/cms/module/helper.php:190

    JROOT/libraries/joomla/document/html/renderer/module.php:105

    JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

100. Query Time: 0.59 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 18.241 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '55' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '55' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

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

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

     JROOT/index.php:40

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

     ---

101. Query Time: 0.32 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 18.261 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =55

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =55

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

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

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

     JROOT/index.php:40

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

     ---

102. Query Time: 0.41 ms After last query: 0.54 ms Query memory: 0.040 MB Memory before query: 18.291 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '65'

     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 demo_jshopping_products WHERE `product_id` = '65'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '65'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

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

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

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

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

     JROOT/index.php:40

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

     ---

103. Query Time: 0.57 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 18.303 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '65' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '65' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

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

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

     JROOT/index.php:40

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

     ---

104. Query Time: 0.29 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 18.323 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =65

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =65

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

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

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

     JROOT/index.php:40

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

     ---

105. Query Time: 0.40 ms After last query: 0.51 ms Query memory: 0.040 MB Memory before query: 18.353 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '141'

     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 demo_jshopping_products WHERE `product_id` = '141'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '141'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

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

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

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

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

     JROOT/index.php:40

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

     ---

106. Query Time: 0.57 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 18.365 MB Rows returned: 2

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '141' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '141' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

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

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

107. Query Time: 0.26 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 18.387 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =141

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =141

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

108. Query Time: 0.43 ms After last query: 0.49 ms Query memory: 0.040 MB Memory before query: 18.417 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '145'

     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 demo_jshopping_products WHERE `product_id` = '145'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '145'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

109. Query Time: 0.56 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 18.429 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '145' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '145' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

110. Query Time: 0.26 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 18.448 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =145

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =145

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

111. Query Time: 0.38 ms After last query: 0.50 ms Query memory: 0.040 MB Memory before query: 18.478 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '30'

     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 demo_jshopping_products WHERE `product_id` = '30'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '30'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

112. Query Time: 0.61 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 18.489 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '30' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '30' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

113. Query Time: 0.25 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 18.510 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =30

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =30

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

114. Query Time: 0.38 ms After last query: 0.50 ms Query memory: 0.040 MB Memory before query: 18.540 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '28'

     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 demo_jshopping_products WHERE `product_id` = '28'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '28'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

115. Query Time: 0.59 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 18.551 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '28' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '28' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

116. Query Time: 0.28 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 18.572 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =28

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =28

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

117. Query Time: 0.42 ms After last query: 0.52 ms Query memory: 0.040 MB Memory before query: 18.602 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '153'

     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 demo_jshopping_products WHERE `product_id` = '153'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '153'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

118. Query Time: 0.59 ms After last query: 0.36 ms Query memory: 0.023 MB Memory before query: 18.614 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '153' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '153' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

119. Query Time: 0.28 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 18.634 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =153

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =153

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

120. Query Time: 0.39 ms After last query: 0.52 ms Query memory: 0.040 MB Memory before query: 18.664 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '156'

     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 demo_jshopping_products WHERE `product_id` = '156'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '156'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

121. Query Time: 0.63 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 18.676 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '156' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '156' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

122. Query Time: 0.26 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 18.696 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =156

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =156

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

123. Query Time: 0.41 ms After last query: 0.49 ms Query memory: 0.040 MB Memory before query: 18.726 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '80'

     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 demo_jshopping_products WHERE `product_id` = '80'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '80'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

124. Query Time: 0.54 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 18.738 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '80' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '80' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

125. Query Time: 0.25 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 18.759 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =80

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =80

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

126. Query Time: 0.38 ms After last query: 0.48 ms Query memory: 0.040 MB Memory before query: 18.788 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '116'

     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 demo_jshopping_products WHERE `product_id` = '116'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '116'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

127. Query Time: 0.55 ms After last query: 0.28 ms Query memory: 0.023 MB Memory before query: 18.800 MB Rows returned: 1

     SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
       FROM `demo_jshopping_products_images` as I 
       left join `demo_jshopping_products` as P 
       on P.product_id=I.product_id
                      
       WHERE I.product_id = '116' 
       ORDER BY sort, I.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 I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_i' at line 1 SQL=EXPLAIN EXTENDED SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `demo_jshopping_products_images` as I left join `demo_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '116' ORDER BY sort, I.ordering

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/components/com_jshopping/tables/product.php:322

     JROOT/modules/mod_sj_js_slider/core/helper.php:66

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

128. Query Time: 0.25 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 18.821 MB Rows returned: 1

     SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description 
       FROM demo_jshopping_products AS prod 
       WHERE prod.product_id =116

     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 prod.product_date_added, prod.date_modify, prod.`description_en-GB` as de' at line 1 SQL=EXPLAIN EXTENDED SELECT prod.product_date_added, prod.date_modify, prod.`description_en-GB` as description FROM demo_jshopping_products AS prod WHERE prod.product_id =116

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/modules/mod_sj_js_slider/core/helper.php:73

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

129. Query Time: 0.43 ms After last query: 0.59 ms Query memory: 0.041 MB Memory before query: 18.854 MB Rows returned: 1

     SELECT *
     
       FROM demo_jshopping_products
     
       WHERE `product_id` = '207'

     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 demo_jshopping_products WHERE `product_id` = '207'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM demo_jshopping_products WHERE `product_id` = '207'

     Profile

     No SHOW PROFILE (maybe because there are more than 100 queries)

     Call Stack

     JROOT/libraries/joomla/table/table.php:705

     JROOT/modules/mod_sj_js_slider/core/helper.php:65

     JROOT/libraries/joomla/cache/controller/callback.php:158

     JROOT/libraries/cms/module/helper.php:488

     JROOT/modules/mod_sj_js_slider/mod_sj_js_slider.php:37

     JROOT/libraries/cms/module/helper.php:190

     JROOT/libraries/joomla/document/html/renderer/module.php:105

     JROOT/libraries/joomla/document/html/renderer/modules.php:46

     JROOT/libraries/joomla/document/html/html.php:408

     JROOT/libraries/joomla/document/html/html.php:696

     JROOT/libraries/joomla/document/html/html.php:474

     JROOT/libraries/cms/application/cms.php:982

     JROOT/libraries/cms/application/site.php:718

     JROOT/libraries/cms/application/cms.php:251

     JROOT/index.php:40

     [Add xdebug.file_link_format directive to your php.ini file to have links for files]

     ---

130. Query Time: 0.54 ms After last query: 0.30 ms Query memory: 0.023 MB Memory before query: 18.866 MB Rows returned: 1