Warning: count(): Parameter must be an array or an object that implements Countable in /home/newbklgpbania/letsgopublish.com/libraries/cms/application/cms.php on line 464
Great IBM i Tech Books; Great Joomla! Books; and Great Patriotic Books
Lets Go Publish!

Main Menu

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

Great IBM i Tech Books; Great Joomla! Books; and Great Patriotic Books

92 Book Titles -- All Written by Wilkes-Barre's Brian Kelly

Lets Go Publish!

is pleased to have Brian W. Kelly under exclusive contract.

Kelly is the most published non-fiction book author in the entire world

Ninety-Two Books-- All written by a native of Wilkes-Barre, Pennsylvania

 

Hi Folks.

Brian Kelly has written ninety-two books so far in his short life. Feel free to go to www.bookhawkers.com or Amazon.com or Kindle if you would like to claim one of these books for your personal library. I bet you'll like it!  Many Lets Go Publish! books are now available on Amazon and Kindle. Whatever is easier for you.  Books in this article are presented in last published to first published sequence. Newer books are only on available on Amazon and Kindle!  Trump Books and political books are shown on www.trumpbookshop.com and www.conservativebookshop.com. Sports books are located at www.notredamebooks.com  Try amazon.com/author/brianwkelly for a complete list of books available on Amazon and Kindle.

For those interested in books about Donald Trump, Please click here to see The Trump Way, an 11-book Series from Lets Go Publish, featuring author Brian W. Kelly.

  

Enjoy!

 

92. Thank You IBM Special Edition 2016
8.5 X 11 inexpensive version-- The Story of how IBM helped today's technology millionaires and billionaires gain their vast fortunes
Let's Go Publish! -- An American Publisher

91. AS/400 & IBM i RPG & RPGIV Tutorial & Lab Exercises 2016
Tutorial & Lab book for corporate or college courses in RPG / RPGIV
Let's Go Publish! -- An American Publisher

90. AS/400 & IBM i RPG & RPGIV Developers’ Guide 2016
Concepts, Coding Examples & Exercises
Let's Go Publish! -- An American Publisher

89. AS/400 & IBM i Pocket Query Guide 2016
The best every tutorial for the IBM Native Query Product
Let's Go Publish! -- An American Publisher

88. AS/400 & IBM i Pocket SQL Guide 2016
SQL Concepts, Coding Examples & Exercises
Let's Go Publish! -- An American Publisher

87. AS/400 & IBM i Pocket Database Guide 2016
Database Concepts, Coding Examples & Exercises
Let's Go Publish! -- An American Publisher

86. AS/400 & IBM i Pocket Developers’ Guide 2016
Tutorials about all the tools you need to develop on IBM i
Let's Go Publish! -- An American Publisher

85. Seniors, Social Security, & the Minimum Wage.2016
Why Do Seniors Always Come in Last?
Let's Go Publish! -- An American Publisher

84. How to Write Your First Book and Publish It UsIng CreateSpace. 2016
Shows you how to write your book with MS Word and get it
published the EZ way
Let's Go Publish! -- An American Publisher

83. Healthcare & Welfare Accountability The Trump Way. 2016
Donald Trump's Plan to account for free healthcare and
welfare debt
Let's Go Publish! -- An American Publisher

82. Take the Train to Myrtle Beach The Trump Way. 2016
A Donald Trump Plan to restart private passenger
railway systems in America.
Let's Go Publish! -- An American Publisher

81. RRRRRR The Trump Way. 2016
Reduce, Repeal, Reindustrialize, Raise, Revitalize, Remember
Let's Go Publish! -- An American Publisher

80. The US Immigration Fix The Trump Way 2016
A Donald Trump Plan to fix the problem of 60 million
interlopers in America.
Let's Go Publish! -- An American Publisher

79. Jobs! Jobs! Jobs! The Trump Way. 2016
The Trump Solution for Creating Jobs in America
Let's Go Publish! -- An American Publisher

78. Obama's Seven Deadly Sins Second Edition. 2016
Learn the Top Seven Obama sins in his eight years
Let's Go Publish! -- An American Publisher

77. 101 Secrets How to be High Information Voter. 2016
Ways to never become a Low Information Voter
Let's Go Publish! -- An American Publisher

76. Just Say No to Chris Christie for President Second Edition. 2016
All the reasons to reject Christie in 2024
Let's Go Publish! -- An American Publisher

75. The Trump Plan Solves the Student Debt Crisis. 2016
The solution for new student debt and the existing $1.3
Trillion debt accumulation
Let's Go Publish! -- An American Publisher

74. Kill The Republican Party Second Edition. 2016
Too Many Establishment Elites-- Bring on the American Party
Let's Go Publish! -- An American Publisher

73. Why Trump? You Already Know But I Will Tell You Anyway! 2016
Why should Donald Trump be President of the United States
Let's Go Publish! -- An American Publisher

72. Saving America The Trump Way 2016
Learn How Donald Trump WIll Save America
Let's Go Publish! -- An American Publisher

71. The US Immigration Fix. 2016
This is really the Immigration fix that is being demanded
by the American people. it is very acheivable.
Let's Go Publish! -- An American Publisher

70. Great Moments in Penn State Football. 2016
All Penn State from the beginning to Coach Jim Franklin
Let's Go Publish! -- An American Publisher

69. Taxation Without Representation Third Edition. 2016
Can the US Avoid Another Boston Tea Party?
Let's Go Publish! -- An American Publisher

68. What Ever Happened to the IBM AS/400?. 2016
Does anybody use this box today?
Let's Go Publish! -- An American Publisher

67. IBM Could Still be # 1. 2016
Will Big Blue Ever Choose to try
Let's Go Publish! -- An American Publisher

66. The Federalist Papers Companion. 2016
A Guide to Reading and Comprehending The Federalist Papers
Let's Go Publish! -- An American Publisher

65. Great Moments in Notre Dame Football 2016
All Notre Dame from the beginning to Coach Brian Kelly
Let's Go Publish -- An American Publisher

64. The All-Everything Machine: Second Edition. 2016
The Story of IBM's Finest Computer System
Let's Go Publish! -- An American Publisher

63. Brian Kelly for Congress: How to Run for Public Office. 2016
Contains Helpers and Platform Points
Let's Go Publish! -- An American Publisher

62. Thank You, IBM: 2nd Edition The story of how IBM helped today’s technology millionaires and billionaires gain their vast fortunes. 2016
Let's Go Publish! -- An American Publisher

61. WineDiets.Com Presents: The Wine Diet! 2016
Let's Go Publish! -- An American Publisher

60. Thank You, IBM: The story of how IBM helped today’s technology millionaires
and billionaires gain their vast fortunes. 2016
Let's Go Publish! -- An American Publisher

59. The Lifetime Guest Plan: A long-term immigration fix that puts Americans first
2015
Let's Go Publish! -- An American Publisher

58. Wilkes-Barre, PA: Return to Glory, 2015
Let's Go Publish! -- An American Publisher

57. Geoffrey Parsons…Land of Fair Play, 2014
Let's Go Publish! -- An American Publisher

56. Sol Bloom’s Epoch…Story of the Constitution, 2014
Let’s Go Publish! -- An American Publisher

55. The Bill of Rights 4 Dummmies! 2014
Let’s Go Publish! -- An American Publisher

54. The Constitution 4 Dummmies! , 2014
Let’s Go Publish! -- An American Publisher

53. America 4 Dummmies!, 2014
Let’s Go Publish! -- An American Publisher

52. The Federalist Papers by Hamilton, Jay, and Madison, 2014
Let’s Go Publish! -- An American Publisher

51. Just Say No to Chris Christie for President, 2014
Let’s Go Publish! -- An American Publisher

50. Bring on The American Party, 2013
Let’s Go Publish! -- An American Publisher

49. Kill the Republican Party, 2013
Let’s Go Publish! -- An American Publisher

48. No Amnesty! No Way!, 2013
Let’s Go Publish! -- An American Publisher

47. Saving America: The How To Book 2013
Let’s Go Publish! -- An American Publisher

46. RRR: A Unique Plan for Economic Recovery and Job Creation 2012
Let’s Go Publish! -- An American Publisher

45. Americans Need Not Apply, 2011
Let’s Go Publish! -- An American Publisher

44. Kill the EPA!, 2011
Let’s Go Publish! -- An American Publisher

43. Jobs Jobs! Jobs!, 2010
Let’s Go Publish! -- An American Publisher

42. The IBM i RPG & RPGIV Tutorial & Lab Exercises Second Edition, 2010
Let’s Go Publish! -- An American Publisher

41. Healthcare Accountability, 2009
Let’s Go Publish! -- An American Publisher

40. Obama's Seven Deadly Sins. 2009
Let’s Go Publish! -- An American Publisher

39. Taxation Without Representation 2010 - 2011 Edition, 2009
Let's Go Publish!

38. The All-Everything Operating System, 2009 (Forward by Dr. Frank Soltis; IBM's
Father of AS/400)
Let's Go Publish! --- An American Publisher

37. The Best Damm Joomla! Tutorial Ever!, 2008
Let’s Go Publish! -- An American Publisher

36. The Best Damm Joomla! Intranet Tutorial Ever!, 2008
Let’s Go Publish! -- An American Publisher

35. The Best Damm Joomla! Template Tutorial Ever!, 2008
Let’s Go Publish! -- An American Publisher

34. The Best Damm Joomla! Installation Guide Ever!, 2008
Let’s Go Publish! -- An American Publisher

33. The Best Damm Blueprint for Building Your Own Corporate Intranet?, 2008
Let’s Go Publish! -- An American Publisher

32. PHP & MySQL Installation & Operations Guide for IBM i, 2008
Let’s Go Publish! -- An American Publisher

31. Intro to PHP & MySQL Programming for IBM i, 2008
Let’s Go Publish! -- An American Publisher

30. Taxation Without Representation, 2007
Let’s Go Publish! -- An American Publisher

29. Getting Started with PHP for i5/OS, 2007
Let’s Go Publish! -- An American Publisher

28. The System i RPG & RPGIV Tutorial & Lab Exercises, 1st Edition 2007
Let’s Go Publish! -- An American Publisher


27. The System i Pocket RPG & RPGIV Guide, 2006
Let’s Go Publish! -- An American Publisher

26. The System i Pocket SQL Guide, 2005
Let’s Go Publish! -- An American Publisher

25. Chip Wars, 2005
Let’s Go Publish! -- An American Publisher

24. The All Everything Machine, 2005
Let’s Go Publish! -- An American Publisher

23. Doorway to Dreamland, 2005
Let’s Go Publish! -- An American Publisher

22. The iSeries Web Implementer’s Guide, 2004
Let’s Go Publish! -- An American Publisher

21. Can the AS/400 Survive IBM?, 2004
Let’s Go Publish! -- An American Publisher

20. Getting Started with WebSphere Development Studio Client, 2003
Let’s Go Publish! -- An American Publisher

19. Getting Started With WebSphere Express Server for iSeries, 2003
Let’s Go Publish! -- An American Publisher

18. Migrating to WebSphere Express for iSeries, 2003
Let’s Go Publish! -- An American Publisher

17. The iSeries WebFacing Pocket Primer, 2003
Let’s Go Publish! -- An American Publisher

16. The WebFacing Application Development Guide, 2003
Let’s Go Publish! -- An American Publisher

15. Getting Started with WebSphere: The How-to Guide for Setting Up
iSeries Web Application Servers, 2002
29th Street Press

14. Getting Started With WebSphere Development Studio, 2002
Let’s Go Publish! -- An American Publisher

13. The iSeries Pocket Developers' Guide, 2002
Let’s Go Publish! -- An American Publisher

12. The iSeries Pocket Database Guide, 2002
Let’s Go Publish! -- An American Publisher

11. The iSeries Pocket Query Guide, 2002
Let’s Go Publish! -- An American Publisher

10. AS/400 Data Warehousing, Second Edition, 1997
Midrange Computing

9. AS/400, the Internet & E-Mail, 1996
Midrange Computing

8. AS/400 Data Warehousing, 1995
Cardinal Business Media (CBM Books)

7. AS/400 Implementation Planning Guide, 1988
IBM Corporation

6. Directory of IBM Personal Computers, 1986
John Wiley & Sons, Publishers

5. Directory of IBM Compatible Computers, 1986
John Wiley & Sons, Publishers

4. Directory of DEC Computers, 1986
John Wiley & Sons, Publishers

3. Directory of Apple Computers, 1986
John Wiley & Sons, Publishers

2. Directory of Word Processing Systems, 1986
John Wiley & Sons, Publishers

1. The Personal Computer Buyer's Guide, 1984
Ballinger, Harper & Row, Publishers

Add a comment

Patriotic & Tech Books


Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/newbklgpbania/letsgopublish.com/modules/mod_menu/helper.php on line 97
  • What's In the Books?
  • Link to Patriotic Books
  • Link to IBM i Tech Books
  • Obama's Seven Deadly Sins
  • Taxation Without Representation
  • Healthcare Accountability
  • Political Donations- Authors

LGP Learning

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

Back to Top

© 2026 Lets Go Publish!

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 30.29 ms / 30.29 ms Memory: 0.142 MB / 0.51 MB Application: afterLoad
Time: 95.55 ms / 125.84 ms Memory: 0.990 MB / 1.50 MB Application: afterInitialise
Time: 18.77 ms / 144.61 ms Memory: 0.282 MB / 1.78 MB Application: afterRoute
Time: 10.32 ms / 154.93 ms Memory: 0.138 MB / 1.92 MB Application: beforeRenderComponent com_content
Time: 25.44 ms / 180.37 ms Memory: 0.181 MB / 2.10 MB Application: Start JAccess::getAssetRules Old (1)
Time: 1.85 ms / 182.22 ms Memory: 0.017 MB / 2.11 MB Application: Finish JAccess::getAssetRules Old (1)
Time: 0.03 ms / 182.24 ms Memory: 0.000 MB / 2.11 MB Application: Start JAccess::preload(components)
Time: 1.87 ms / 184.11 ms Memory: 0.186 MB / 2.29 MB Application: Finish JAccess::preload(components)
Time: 48.51 ms / 232.62 ms Memory: 0.440 MB / 2.73 MB Application: afterRenderComponent com_content
Time: 3.42 ms / 236.05 ms Memory: 0.008 MB / 2.74 MB Application: afterDispatch
Time: 8.28 ms / 244.32 ms Memory: 0.051 MB / 2.79 MB Application: beforeRenderModule mod_menu (Patriotic & Tech Books)
Time: 6.66 ms / 250.98 ms Memory: 0.024 MB / 2.82 MB Application: afterRenderModule mod_menu (Patriotic & Tech Books)
Time: 0.02 ms / 251.00 ms Memory: 0.000 MB / 2.81 MB Application: beforeRenderModule mod_menu (LGP Learning)
Time: 0.60 ms / 251.60 ms Memory: 0.007 MB / 2.82 MB Application: afterRenderModule mod_menu (LGP Learning)
Time: 0.05 ms / 251.65 ms Memory: 0.000 MB / 2.82 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 2.61 ms / 254.26 ms Memory: 0.027 MB / 2.85 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.04 ms / 254.30 ms Memory: 0.000 MB / 2.85 MB Application: beforeRenderModule mod_custom (LGP Header)
Time: 1.06 ms / 255.36 ms Memory: 0.006 MB / 2.85 MB Application: afterRenderModule mod_custom (LGP Header)
Time: 6.13 ms / 261.49 ms Memory: 0.159 MB / 3.01 MB Application: afterRender

Database queries total: 39.12 ms

Memory Usage

3.24 MB (3,398,400 Bytes)

Database Queries

21 Queries Logged 39.12 ms


  1. Query Time: 2.26 ms Query memory: 0.022 MB Memory before query: 0.932 MB Rows returned: 0
    SELECT `data`
    
      FROM `j25_session`
      WHERE `session_id` = '6b9e6ebd76dc6b6403c09e6a2e5d41f1'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = '6b9e6ebd76dc6b6403c09e6a2' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `#__session` WHERE `session_id` = '6b9e6ebd76dc6b6403c09e6a2e5d41f1'
    Profile
    StatusDuration
    starting0.07 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables1.77 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.15 ms
    freeing items0.03 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:44
    12JSessionStorageDatabase->read()Same as call in the line below.
    11session_start()JROOT/libraries/joomla/session/handler/native.php:259
    10JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:49
    9JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:81
    8JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:636
    7JSession->_start()JROOT/libraries/joomla/session/session.php:596
    6JSession->start()JROOT/libraries/cms/application/cms.php:773
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  2. Query Time: 0.27 ms After last query: 5.18 ms Query memory: 0.019 MB Memory before query: 1.013 MB Rows returned: 0
    SELECT `session_id`
    
      FROM `j25_session`
      WHERE `session_id` = '6b9e6ebd76dc6b6403c09e6a2e5d41f1'
      LIMIT 1
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = '6b9e6ebd76dc6b6403c' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `#__session` WHERE `session_id` = '6b9e6ebd76dc6b6403c09e6a2e5d41f1' LIMIT 1
    Profile
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.00 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  3. Query Time: 1.23 ms After last query: 0.04 ms Query memory: 0.003 MB Memory before query: 1.018 MB
    INSERT INTO `j25_session`
    (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('6b9e6ebd76dc6b6403c09e6a2e5d41f1', 0, 1, '1788947902', 0, '')
    Explain
    EXPLAIN not possible on query: INSERT INTO `j25_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('6b9e6ebd76dc6b6403c09e6a2e5d41f1', 0, 1, '1788947902', 0, '')
    Profile
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.00 ms
    System lock0.01 ms
    update0.09 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.91 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:212
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  4. Query Time: 1.90 ms After last query: 5.87 ms Query memory: 0.022 MB Memory before query: 1.045 MB Rows returned: 32
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `j25_extensions`
      WHERE `type` = 'component'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `j25' at line 1 SQL=EXPLAIN EXTENDED SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `#__extensions` WHERE `type` = 'component'
    Profile
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables1.15 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.13 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.25 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    8JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  6. Query Time: 1.92 ms After last query: 1.67 ms Query memory: 0.021 MB Memory before query: 1.128 MB Rows returned: 3
    SELECT id, rules
    
      FROM `j25_viewlevels`
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1 SQL=EXPLAIN EXTENDED SELECT id, rules FROM `#__viewlevels`
    Profile
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables1.56 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.03 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.08 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    9JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:921
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  7. Query Time: 0.58 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 1.136 MB Rows returned: 48
    SELECT folder AS type, element AS name, params
    
      FROM j25_extensions
      WHERE enabled = 1
      AND type ='plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled' at line 1 SQL=EXPLAIN EXTENDED SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering
    Profile
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.00 ms
    starting0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    init0.00 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.21 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    7JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:310
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

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

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

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

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

  13. Query Time: 4.13 ms After last query: 18.91 ms Query memory: 0.028 MB Memory before query: 2.065 MB Rows returned: 8
    SHOW FULL COLUMNS 
      FROM `j25_assets`
    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `j25_assets`
    Profile
    StatusDuration
    starting0.09 ms
    Executing hook on transaction 0.01 ms
    starting0.82 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables2.35 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.03 ms
    Creating tmp table0.04 ms
    executing0.10 ms
    checking permissions0.06 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.04 ms
    checking permissions0.01 ms
    checking permissions0.03 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.04 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    23JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    22JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    21JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    20JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    19JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:308
    18JTable::getInstance()JROOT/libraries/joomla/access/access.php:696
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  14. Query Time: 1.26 ms After last query: 1.64 ms Query memory: 0.025 MB Memory before query: 2.090 MB Rows returned: 1
    SELECT *
    
      FROM j25_assets
      WHERE `id` = '1'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__assets WHERE `id` = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__assets WHERE `id` = '1'
    Profile
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.77 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.14 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    19JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:719
    18JTable->load()JROOT/libraries/joomla/access/access.php:697
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  15. Query Time: 0.38 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 2.098 MB Rows returned: 1
    SELECT a.rules
    
      FROM j25_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')' at line 1 SQL=EXPLAIN EXTENDED SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')
    Profile
    StatusDuration
    starting0.03 ms
    Executing hook on transaction 0.00 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.08 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    17JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:652
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  16. Query Time: 0.56 ms After last query: 1.50 ms Query memory: 0.026 MB Memory before query: 2.109 MB Rows returned: 31
    SELECT element
    
      FROM j25_extensions
      WHERE type = 'component'
      AND enabled = '1'
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT element FROM #__extensions WHERE type = 'component' AND enabled = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT element FROM #__extensions WHERE type = 'component' AND enabled = '1'
    Profile
    StatusDuration
    starting0.06 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.10 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    19JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:413
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  17. Query Time: 0.66 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 2.124 MB Rows returned: 31
    SELECT a.name, a.rules
    
      FROM j25_assets AS a
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.name, a.rules FROM #__assets AS a WHERE (a.name IN ('com_admin','com_a' at line 1 SQL=EXPLAIN EXTENDED SELECT a.name, a.rules FROM #__assets AS a WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')
    Profile
    StatusDuration
    starting0.05 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    Opening tables0.04 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.04 ms
    executing0.23 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    19JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:441
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

  18. Query Time: 8.62 ms After last query: 2.02 ms Query memory: 0.095 MB Memory before query: 2.379 MB Rows returned: 1
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j25_content AS a
      INNER JOIN j25_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-09 09:58:22')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-09 09:58:22')
      ORDER BY a.featured DESC, fp.ordering,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 20
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked' at line 1 SQL=EXPLAIN EXTENDED SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM #__content AS a INNER JOIN #__content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-09 09:58:22') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-09 09:58:22') ORDER BY a.featured DESC, fp.ordering, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC LIMIT 20
    Profile
    StatusDuration
    starting0.26 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables6.12 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    Creating tmp table0.06 ms
    statistics0.11 ms
    preparing0.04 ms
    Creating tmp table0.29 ms
    executing0.65 ms
    end0.01 ms
    query end0.01 ms
    waiting for handler commit0.02 ms
    closing tables0.70 ms
    freeing items0.06 ms
    cleaning up0.01 ms
    Call Stack
    #CallerFile and line number
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    15JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    14JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

  20. Query Time: 1.52 ms After last query: 16.72 ms Query memory: 0.026 MB Memory before query: 2.580 MB Rows returned: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM j25_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN j25_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=38
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    Explain
    Error
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, ' at line 1 SQL=EXPLAIN EXTENDED SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM #__categories as c LEFT JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id LEFT JOIN #__categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND badcats.id is null AND s.id=38 GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
    Profile
    StatusDuration
    starting0.24 ms
    Executing hook on transaction 0.01 ms
    starting0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    Creating tmp table0.05 ms
    statistics0.11 ms
    preparing0.03 ms
    Creating tmp table0.26 ms
    executing0.21 ms
    end0.01 ms
    query end0.00 ms
    waiting for handler commit0.02 ms
    closing tables0.01 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Call Stack
    #CallerFile and line number
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    18JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    17JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    16JCategories->get()JROOT/components/com_content/helpers/route.php:44
    15ContentHelperRoute::getArticleRoute()JROOT/plugins/content/jw_disqus/jw_disqus.php:185
    14plgContentJw_disqus->renderDisqus()JROOT/plugins/content/jw_disqus/jw_disqus.php:47
    13plgContentJw_disqus->onContentPrepare()JROOT/libraries/joomla/event/event.php:69
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    11JEventDispatcher->trigger()JROOT/components/com_content/views/featured/view.html.php:97
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

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

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `j25_extensions`
  2. 1 × SELECT `data` 
      FROM `j25_session`
  3. 1 × SELECT a.rules 
      FROM j25_assets AS a
  4. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM j25_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  5. 1 × SELECT COUNT(*) 
      FROM j25_content AS a
      INNER JOIN j25_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  6. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM j25_content AS a
      INNER JOIN j25_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN j25_categories AS c
      ON c.id = a.catid
      LEFT JOIN j25_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN j25_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN j25_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN j25_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM j25_categories AS cat JOIN j25_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  7. 1 × SELECT a.name, a.rules 
      FROM j25_assets AS a
  8. 1 × SELECT element 
      FROM j25_extensions
  9. 1 × SELECT id, home, template, s.params 
      FROM j25_template_styles as s
      LEFT JOIN j25_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  10. 1 × SELECT * 
      FROM j25_assets
  11. 1 × SELECT `session_id` 
      FROM `j25_session`
  12. 1 × SELECT * 
      FROM j25_languages
  13. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM j25_menu AS m
      LEFT JOIN j25_extensions AS e
      ON m.component_id = e.extension_id
  14. 1 × SELECT folder AS type, element AS name, params 
      FROM j25_extensions
  15. 1 × SELECT id, rules 
      FROM `j25_viewlevels
  16. 1 × SELECT b.id 
      FROM j25_usergroups AS a
      LEFT JOIN j25_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  17. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM j25_modules AS m
      LEFT JOIN j25_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN j25_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
OTHER Tables:
  1. 1 × INSERT INTO `j25_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('6b9e6ebd76dc6b6403c09e6a2e5d41f1', 0, 1, '1788947902', 0, ''
  2. 1 × UPDATE `j25_extensions` 
      SET `params` = '{\"mediaversion\":\"efde84de249b5c674b6134d13d837430\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `j25_assets