Supreme Council of Freemasonary - A.A.S.R. For Lebanon & Arab Countries

Famous FMs

Abraham Lincoln	Ludwig Van Beethoven	Benjamin Franklin	Fransisco De Miranda
George Washington	Mozart Amadeus	Simon Bolivar	Winston Churchill

This is a short list of some "Famous FreeMasons". Of course, this is not a list of all Famous FreeMasons through the ages, but merely a small sampling of some of those that are well known to the general public:

Aldrin, Edwin E. - Astronaut
Allende, Salvador - President of Chile
Andrade, Edward Neville da Costa - Publisher of "The Structure of the Atom" 1923
Appleton, Sir Edward Victor - Nobel Prize Winner for physics in 1947
Armstrong, Louis - Jazz Musician
Armstrong, Neil - Astronaut
Ataturk, Mustapha Kemal - President of Turkey
Austin, Stephen F. - Father of Texas
Bartholdi, Frederic A. - Designed the Statue of Liberty
Benes, Eduard - President of Czechoslovakia
Berlin, Irving - Entertainer
Bertil - Prince of Sweden
Bolivar, Simon - Liberator of South America
Borglum, Gutzon & Lincoln - Father and Son who carved Mt. Rushmore
Borgnine, Ernest - Actor
Bradley, Gen. Omar N. - Military leader
Bruce, James - Discovered the source of the Blue Nile in Abyssinia 1770
Buchanan, James - President of the U.S.
Burns, Robert - The National Poet of Scotland
Byrd, Admiral Richard E. - Flew over North Pole
Carl XIV Johan - king of Sweden
Carson, Christopher "Kit" - Frontiersman, scout and explorer
Christian X - king of Denmark
Chrysler, Walter P. - Automotive fame
Churchill, Winston - British Leader
Citroen, Andre - French Engineer and motor car manufacturer
Clark, Roy - Country Western Star
Clark, William - Explorer
Clemens, Samuel L. - Mark Twain - writer
Cody, "Buffalo Bill" William - Indian fighter, Wild West Show
Collodi, Carlo - Writer of Pinocchio
Colt, Samuel - Firearms inventor
Cooper, Leroy Gordon - Astronaut
Crockett, David - American Frontiersman of Alamo fame
De Mille, Cecil B - Film producer-director
Dempsey, Jack - Boxer
Desaguliers, John Theophilus - Inventor of the planetarium
Doyle, Sir Author Conan - Writer - Sherlock Holmes
Dunant, Jean Henri - Founder of the Red Cross
Edward VII - King of England
Edward VIII - King of England
Faber, Eberhard - Head of the famous Eberhard Fabor Pencil Company
Fairbanks, Douglas - Silent film actor
Fields, W.C. - Actor
Fleming, Sir Alexander - Invented Penicillin
Ford, Gerald R. - President of the U.S.
Ford, Henry - Pioneer Automobile Manufacturer
Franklin, Benjamin - 1 of 13 Masonic signers of Constitution of the U.S.
Fredrik VIII - king of Denmark
Friedrich the Great - Germany
Gable, Clark - Actor
Garfield, James A. - President of the U.S.
George VI - King of England during W.W. II
Gibbon, Edward - Author of "Decline and Fall of the Roman Empire"
Gillett, King C. - Gillett Razor Co.
Glenn, John H. - First American to orbit the earth in a space craft
Godfrey, Arthur - Actor
Goethe, Johann Wolfgang von - German poet
Gray, Harold Lincoln - Creator of "Little Orphan Annie"
Grissom, Virgil - Astronaut
Guillotin, Joseph Ignace - Inventor of the "Guillotin"
Gustaf III - king of Sweden
Gustaf IV Adolf- king of Sweden
Gustaf V - king of Sweden
Hancock, John - 1of 9 Masonic signers of Declaration of Independance
Harding, Warren G. - President of the U.S.
Hardy, Oliver - Actor - Comedian
Haydn, Franz Josef - Austrian composer
Hilton, Charles C. - American Hotelier
Hoban, James - Architect for the U.S. Capital
Hoe, Richard M. - Invented the rotory press
Hope, Bob - Comedian
Houdini, Harry - Magician
Houston, Sam - 2nd & 4th President of the Republic of Texas
Irwin, James Benson - Astronaut
Jackson, Andrew - President of the U.S.
Jenner, Edward - Inventor - Vaccination
Johnson, Andrew - President of the U.S.
Jolson, Al - Fame as the first 'talking picture' the Jazz Singer
Jones, Melvin - One of the founders of the Lions International
Kane, Elisha Kent - Arctic explorer
Karl XIII - King of Sweden
Key, Francis Scott - Wrote U.S. National Anthem
Khan III, Aga - Statesman
King, Charles Glen - Isolated vitamin C
Kipling, Rudyard - Writer
Lafayette, Marquis de - Supporter of American Freedom
Lake, Simon - Built first submarine successful in open sea.
Land, Frank S. - Founder Order of DeMolay
Lewis, Meriwether - Explorer
Lincoln, Elmo - First actor to play Tarzan of the Apes (1918)
Lindbergh, Charles - Aviator
Lipton, Sir Thomas - Founder Lipton Tea Company
Liszt, Franz von - Hungarian composer
Lloyd, Harold C. - Entertainer
MacArthur, General Douglas - Commander of Armed Forces in Philillines
Masaryk, Jan - First President of Czechoslovakia
Mayer, Louis B. - Film producer who merged to form Metro-Goldwyn-Mayer (MGM)
Mayo, Dr. William and Charles - Founded the Mayo Clinic
Maytag, Fredrick - Maytag
McKinley, William - President of the U.S.
Michelson, Albert Abraham - Successfully measured the speed of light in 1882
Mix, Tom - U.S. Marshal turned actor. Stared in over 400 western films
Monroe, James - President of the U.S.
Montgolfier, Jacques Etienne - Co-developer of the first practical hot-air balloon
Morris, Dr. Robert - Poet and Founder of the Order of Eastern Star
Mozart, Wolfgang Amadeus - Composer
Naismith, James - Inventor of Basketball
New, Harry S. - Postmaster General who established Airmail
Newton, Joseph Fort - Christian Minister
O'Connell, Daniel - Irish patriot
Olds, Ransom E. - American automobile pioneer
Oscar I - king of Sweden
Ostwald, Wilhelm - Nobel prize-winner in chemistry 1909
Palmer, Arnold - Golf Pro
Peary, Robert E. - First man to reach the North Pole (1909)
Pershing, John Joseph - Decorated American Soldier
Pike, Zebulon - Pike's Peak named after him
Polk, James Knox - President of the U.S.
Pope, Alexander - English poet and satirist
Pullman, George - Built first sleeping car on train.
Pushkin, Aleksander - Russian Poet
Richet, Charles Robert - Nobel prize-winner in medicine and physiology 1913
Ringling Brothers - All 7 brothers and their father were Masons.
Rogers, Roy - American cowboy and screen star
Rogers, Will - Actor
Roosevelt, Franklin D. - President of the U.S.
Roosevelt, Theodore - President of the U.S.
Ryti, Risto - President of Finland
Sabatini, Raphael - English novelist "The Sea Hawk" "Captain Blood"
Salten, Felix - Creator of Bambi
Sarnoff, David - Father of T.V.
Sax, Antoine Joseph - Invented the Saxophone (1846)
Scott, Robert Falcon - English polar explorer
Scott, Sir Walter - Writer
Sellers, Peter - Actor
Sexson, Mark - Minister & Founder: Intl. Order of Rainbow for Girls
Shackelton, Sir Ernest H - English explorer
Sibelius, Jean - Composer (Finland)
Skelton, Red - Entertainer
Smith, John Stafford - Wrote the music that became the US National Anthem.
Sousa, John Philip - Led the U.S. Marine Band from 1880 - 1892
Stanford, Leland - Founded Stanford University
Still, Andrew T. - American Physician who devised treatment of Osteopathy
Streseman, Gustav - Nobel Peace prize-winner 1926
Swift, Johathan - Wrote Gulliver's Travels
Taft, William Howard - President of the U.S.
Thomas, Lowell - Brought Lawrence of Arabia to public notice
Tirpitz, Alfred Von - German Naval officer responsible for submarine warfare
Travis, Colonel William B. - Alamo
Truman, Harry S. - President of the U.S.
Voltaire - French writer and philosopher
Wallace, Lewis - Wrote "Ben Hur"
Warner, Jack - Warner Brothers Fame
Washington, George - President of US, 1st
Wayne, John - Actor
Webb, Matthew - First man to swim the English Channel (1875)
Wellington, Arthur, Duke of - Defeated Napoleon at Waterloo
Whiteman, Paul - "King of Jazz"
Wilde, Oscar - Writer
Wyler, William - Director of "Ben Hur"
Zanuck, Darryl F. - Co-founder of 20th Century Productions in 1933

About Freemasonry

Masonic Store

Events

Pictures

Newsletter Subscriber

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686078895,
                "last": 1686078895,
                "now": 1686078895
            },
            "token": "rJfvlYubnKaPkVRd39OkKkI2CJXZkw0M"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        },
        "calendar_style188": null,
        "border_color188": "#",
        "bg_border_color188": "#",
        "arrow_color188": "#",
        "text_color_week_days188": "#",
        "bg_color_selected188": "#",
        "text_color_this_month_evented188": "#",
        "bg_color_this_month_evented188": "#",
        "text_color_sun_days188": "#",
        "text_color_other_months188": "#",
        "text_color_this_month_unevented188": "#",
        "text_color_year188": "#",
        "text_color_month188": "#",
        "text_color_selected188": "#",
        "border_day188": "#",
        "calendar_font_day188": null,
        "calendar_font_month188": null,
        "calendar_font_year188": null,
        "calendar_font_weekday188": null,
        "weekstart188": null,
        "titlescloud188": null,
        "calendar_width188": null,
        "title_color188": "#",
        "title_size188": null,
        "title_font188": null,
        "title_style188": null,
        "date_color188": "#",
        "date_size188": null,
        "date_font188": null,
        "date_style188": null,
        "date_format188": null,
        "like_button188": null,
        "calendar_bg188": null,
        "titlescloud_text_color188": null,
        "show_time188": null,
        "show_repeat188": null,
        "select_menu_item188": null,
        "weekdays_bg_color188": "#",
        "weekday_su_bg_color188": "#",
        "cell_border_color188": "#"
    }
}

Profile Information

Time

Memory

Time: 11.70 ms / 11.70 ms Memory: 1.846 MB / 2.22 MB Application: afterLoad

Time: 77.09 ms / 88.79 ms Memory: 5.516 MB / 7.73 MB Application: afterInitialise

Time: 303.51 ms / 392.30 ms Memory: 18.768 MB / 26.50 MB Application: afterRoute

Time: 0.16 ms / 392.46 ms Memory: 0.014 MB / 26.51 MB Application: beforeRenderComponent com_content

Time: 3.49 ms / 395.96 ms Memory: 0.406 MB / 26.92 MB Application: Before Access::preloadComponents (all components)

Time: 1.98 ms / 397.94 ms Memory: 0.060 MB / 26.98 MB Application: After Access::preloadComponents (all components)

Time: 0.05 ms / 397.99 ms Memory: -0.003 MB / 26.98 MB Application: Before Access::preloadPermissions (com_content)

Time: 1.22 ms / 399.21 ms Memory: 0.175 MB / 27.15 MB Application: After Access::preloadPermissions (com_content)

Time: 0.03 ms / 399.24 ms Memory: -0.011 MB / 27.14 MB Application: Before Access::getAssetRules (id:314 name:com_content.article.109)

Time: 0.36 ms / 399.61 ms Memory: 0.027 MB / 27.17 MB Application: After Access::getAssetRules (id:314 name:com_content.article.109)

Time: 45.15 ms / 444.76 ms Memory: 1.810 MB / 28.98 MB Application: afterRenderComponent com_content

Time: 3.59 ms / 448.35 ms Memory: 0.130 MB / 29.11 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.02 ms / 448.37 ms Memory: 0.002 MB / 29.11 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 2.24 ms / 450.61 ms Memory: 0.102 MB / 29.21 MB Application: afterDispatch

Time: 12.06 ms / 462.67 ms Memory: 0.536 MB / 29.75 MB Application: beforeRenderModule mod_menu (Footer menu)

Time: 1.50 ms / 464.16 ms Memory: 0.081 MB / 29.83 MB Application: afterRenderModule mod_menu (Footer menu)

Time: 0.05 ms / 464.21 ms Memory: -0.003 MB / 29.83 MB Application: beforeRenderModule mod_languages (ZT Languages Footer for mobile)

Time: 1.12 ms / 465.33 ms Memory: 0.033 MB / 29.86 MB Application: afterRenderModule mod_languages (ZT Languages Footer for mobile)

Time: 0.06 ms / 465.39 ms Memory: 0.000 MB / 29.86 MB Application: beforeRenderModule mod_newsletter_subscriber (Newsletter Subscriber)

Time: 0.42 ms / 465.81 ms Memory: 0.017 MB / 29.88 MB Application: afterRenderModule mod_newsletter_subscriber (Newsletter Subscriber)

Time: 0.04 ms / 465.85 ms Memory: -0.009 MB / 29.87 MB Application: beforeRenderModule mod_custom (Pictures)

Time: 0.29 ms / 466.14 ms Memory: 0.006 MB / 29.87 MB Application: afterRenderModule mod_custom (Pictures)

Time: 0.04 ms / 466.18 ms Memory: -0.003 MB / 29.87 MB Application: beforeRenderModule mod_spidercalendar (Events)

Time: 0.53 ms / 466.70 ms Memory: 0.034 MB / 29.90 MB Application: afterRenderModule mod_spidercalendar (Events)

Time: 0.04 ms / 466.74 ms Memory: 0.000 MB / 29.90 MB Application: beforeRenderModule mod_menu (About Freemasonry)

Time: 0.98 ms / 467.72 ms Memory: 0.024 MB / 29.93 MB Application: afterRenderModule mod_menu (About Freemasonry)

Time: 0.02 ms / 467.74 ms Memory: -0.004 MB / 29.93 MB Application: beforeRenderModule mod_custom (Masonic Store)

Time: 0.10 ms / 467.84 ms Memory: 0.004 MB / 29.93 MB Application: afterRenderModule mod_custom (Masonic Store)

Time: 0.03 ms / 467.87 ms Memory: 0.001 MB / 29.93 MB Application: beforeRenderModule mod_breadcrumbs (breadcrumbs)

Time: 0.48 ms / 468.35 ms Memory: 0.021 MB / 29.95 MB Application: afterRenderModule mod_breadcrumbs (breadcrumbs)

Time: 0.04 ms / 468.39 ms Memory: -0.003 MB / 29.95 MB Application: beforeRenderModule mod_search (Search)

Time: 0.49 ms / 468.88 ms Memory: 0.018 MB / 29.97 MB Application: afterRenderModule mod_search (Search)

Time: 0.05 ms / 468.93 ms Memory: -0.004 MB / 29.96 MB Application: beforeRenderModule mod_languages (ZT Languages)

Time: 0.71 ms / 469.64 ms Memory: 0.008 MB / 29.97 MB Application: afterRenderModule mod_languages (ZT Languages)

Time: 0.02 ms / 469.66 ms Memory: -0.003 MB / 29.97 MB Application: beforeRenderModule mod_custom (Social menu)

Time: 0.12 ms / 469.78 ms Memory: 0.003 MB / 29.97 MB Application: afterRenderModule mod_custom (Social menu)

Time: 0.04 ms / 469.81 ms Memory: 0.001 MB / 29.97 MB Application: beforeRenderModule mod_custom (Header line)

Time: 0.09 ms / 469.91 ms Memory: 0.003 MB / 29.97 MB Application: afterRenderModule mod_custom (Header line)

Time: 6.48 ms / 476.38 ms Memory: 0.695 MB / 30.67 MB Application: afterRender

Database queries total: 39.56 ms

Memory Usage

Database Queries

28 Queries Logged 39.56 ms

Query Time: 2.59 ms Query memory: 0.023 MB Memory before query: 3.986 MB Rows returned: 0

SELECT `data`

  FROM `aua8l_session`

  WHERE `session_id` = X'6361646263373165656134633765663862393962656163343938653566623863'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.24 ms After last query: 0.96 ms Query memory: 0.020 MB Memory before query: 4.082 MB Rows returned: 0

SELECT `session_id`

  FROM `aua8l_session`

  WHERE `session_id` = X'6361646263373165656134633765663862393962656163343938653566623863' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 7.38 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 4.087 MB

INSERT INTO `aua8l_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6361646263373165656134633765663862393962656163343938653566623863', 1, 1686078895, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `aua8l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6361646263373165656134633765663862393962656163343938653566623863', 1, 1686078895, 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	2.38 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.62 ms After last query: 2.50 ms Query memory: 0.037 MB Memory before query: 4.274 MB Rows returned: 41

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `aua8l_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_extensions	NULL	ref	extension	extension	82	const	41	1.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 2.39 ms Query memory: 0.020 MB Memory before query: 4.522 MB Rows returned: 5

SELECT id, rules

  FROM `aua8l_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 4.534 MB Rows returned: 2

SELECT b.id

  FROM aua8l_usergroups AS a

  LEFT JOIN aua8l_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.72 ms Query memory: 0.022 MB Memory before query: 4.602 MB Rows returned: 105

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM aua8l_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_extensions	NULL	ref	extension	extension	82	const	123	0.60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.91 ms Query memory: 0.019 MB Memory before query: 4.720 MB Rows returned: 2

SELECT *

  FROM aua8l_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.28 ms After last query: 6.15 ms Query memory: 0.076 MB Memory before query: 5.490 MB Rows returned: 73

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 aua8l_menu AS m

  LEFT JOIN aua8l_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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	291	8.32	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1912921.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.79 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
26	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
23	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
22	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
21	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
20	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
19	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
18	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
17	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
16	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
15	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.01 ms After last query: 0.71 ms Query memory: 0.536 MB Memory before query: 5.675 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM aua8l_template_styles as s

  LEFT JOIN aua8l_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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	dbs1912921.e.element	1	75.00	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.35 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
17	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
16	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
15	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 2.85 ms Query memory: 0.027 MB Memory before query: 5.938 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `aua8l_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
25	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
24	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
23	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
22	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
21	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
20	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
19	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
18	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
17	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
16	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
15	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.73 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 5.933 MB

UPDATE `aua8l_extensions`

  SET `params` = '{\"mediaversion\":\"439bdbf1cd8926993dfe201f5f6d5198\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	aua8l_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.07 ms
end	0.01 ms
query end	2.40 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
20	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
19	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
18	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
17	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
16	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
15	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 7.09 ms Query memory: 0.020 MB Memory before query: 7.076 MB Rows returned: 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `aua8l_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 15.51 ms Query memory: 0.021 MB Memory before query: 8.401 MB Rows returned: 1

SELECT `template_style_id` 
  FROM `aua8l_menu` 
  WHERE `id` = 328

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/zo2/framework/includes/factory.php:99
10	Zo2Factory::getTemplate()	JROOT/plugins/system/zo2/framework/includes/framework.php:92
9	Zo2Framework->init()	JROOT/plugins/system/zo2/zo2.php:35
8	plgSystemZo2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 0.03 ms Query memory: 0.264 MB Memory before query: 8.407 MB Rows returned: 1

SELECT * 
  FROM `aua8l_template_styles` 
  WHERE `id` = 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_template_styles	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.18 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/zo2/framework/includes/factory.php:68
11	Zo2Factory::getTemplate()	JROOT/plugins/system/zo2/framework/includes/factory.php:105
10	Zo2Factory::getTemplate()	JROOT/plugins/system/zo2/framework/includes/framework.php:92
9	Zo2Framework->init()	JROOT/plugins/system/zo2/zo2.php:35
8	plgSystemZo2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.69 ms After last query: 298.27 ms Query memory: 0.025 MB Memory before query: 26.926 MB Rows returned: 41

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `aua8l_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_maximenuck','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sigpro','com_spidercalendar','com_tags','com_templates','com_users','com_wrapper','com_zt_layerslider')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	395	10.63	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.14 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.76 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.40 ms Query memory: 0.043 MB Memory before query: 26.979 MB Rows returned: 178

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `aua8l_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	395	22.50	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.22 ms After last query: 1.09 ms Query memory: 0.024 MB Memory before query: 27.208 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `aua8l_content`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
Opening tables	0.12 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.09 ms After last query: 2.16 ms Query memory: 0.005 MB Memory before query: 27.503 MB

UPDATE aua8l_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '109'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	aua8l_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.04 ms
updating	0.19 ms
end	0.03 ms
query end	4.48 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 1.50 ms Query memory: 0.038 MB Memory before query: 27.626 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 aua8l_content AS a

  INNER JOIN aua8l_categories AS c 
  on c.id = a.catid

  LEFT JOIN aua8l_users AS u 
  on u.id = a.created_by

  LEFT JOIN aua8l_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN aua8l_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 109 
  AND c.published > 0 
  AND a.language in ('en-GB','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-06 19:14:56') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-06 19:14:56') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 1.64 ms Query memory: 0.022 MB Memory before query: 27.777 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `aua8l_contentitem_tag_map` AS m 

  INNER JOIN `aua8l_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 109 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	47	2.13	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dbs1912921.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.42 ms After last query: 15.48 ms Query memory: 0.025 MB Memory before query: 28.434 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 `aua8l_categories` AS `s`

  INNER JOIN `aua8l_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 42

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	39	9.33	Using where

Profile

Status	Duration
starting	0.22 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.12 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.90 ms After last query: 0.78 ms Query memory: 0.025 MB Memory before query: 28.478 MB Rows returned: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM aua8l_fields AS a

  LEFT JOIN `aua8l_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN aua8l_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN aua8l_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN aua8l_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN aua8l_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `aua8l_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (42,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dbs1912921.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1912921.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1912921.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1912921.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1912921.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dbs1912921.a.id	1	100.00	Using where; Using index; Distinct

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.05 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.38 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.10 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 12.34 ms Query memory: 0.020 MB Memory before query: 29.007 MB Rows returned: 3

SELECT language,id

  FROM `aua8l_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	aua8l_menu	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	291	0.84	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 1.16 ms Query memory: 0.021 MB Memory before query: 29.085 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `aua8l_menu` AS `c`

  INNER JOIN `aua8l_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `aua8l_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `aua8l_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 328

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 0.56 ms Query memory: 0.021 MB Memory before query: 29.112 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `aua8l_content` AS `c`

  INNER JOIN `aua8l_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `aua8l_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `aua8l_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `aua8l_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 109 
  AND c2.access IN (1,1,5) 
  AND c2.language != 'en-GB' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2023-06-06 19:14:56') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2023-06-06 19:14:56') 
  AND c2.state = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.65 ms After last query: 3.98 ms Query memory: 0.025 MB Memory before query: 29.370 MB Rows returned: 24

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM aua8l_modules AS m

  LEFT JOIN aua8l_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN aua8l_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 <= '2023-06-06 19:14:56') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-06 19:14:56') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 328 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	50	1.31	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	dbs1912921.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dbs1912921.m.id	7	40.00	Using where; Using index

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.73 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/system/zo2/framework/layout.php:60
11	Zo2Layout->reSortRow()	JROOT/plugins/system/zo2/framework/layout.php:109
10	Zo2Layout->getHtml()	JROOT/plugins/system/zo2/framework/cache.php:124
9	Zo2Cache->get()	JROOT/plugins/system/zo2/framework/layout.php:38
8	Zo2Layout->render()	JROOT/templates/zo2_charity/index.php:39
7	require JROOT/templates/zo2_charity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.21 ms After last query: 2.83 ms Query memory: 0.041 MB Memory before query: 29.628 MB Rows returned: 29

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 aua8l_menu AS m

  LEFT JOIN aua8l_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  AND m.access IN ( 1,1,5 ) 
  AND m.menutype = 'mainmenu-en-gb'

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype	idx_menutype	98	const	31	2.49	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs1912921.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.63 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/zo2/framework/model/joomla.php:75
18	Zo2ModelJoomla->getMenuItemsByType()	JROOT/plugins/system/zo2/framework/megamenu.php:47
17	Zo2Megamenu->loadMegaMenu()	JROOT/plugins/system/zo2/framework/megamenu.php:39
16	Zo2Megamenu->__construct()	JROOT/plugins/system/zo2/framework/includes/framework.php:539
15	Zo2Framework->displayMegaMenu()	JROOT/plugins/system/zo2/framework/layout.php:572
14	Zo2Layout->_generateColumn()	JROOT/plugins/system/zo2/framework/layout.php:141
13	Zo2Layout->_buildItem()	JROOT/plugins/system/zo2/framework/layout.php:360
12	Zo2Layout->_generateRow()	JROOT/plugins/system/zo2/framework/layout.php:139
11	Zo2Layout->_buildItem()	JROOT/plugins/system/zo2/framework/layout.php:113
10	Zo2Layout->getHtml()	JROOT/plugins/system/zo2/framework/cache.php:124
9	Zo2Cache->get()	JROOT/plugins/system/zo2/framework/layout.php:38
8	Zo2Layout->render()	JROOT/templates/zo2_charity/index.php:39
7	require JROOT/templates/zo2_charity/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `aua8l_extensions`

2 × 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 aua8l_menu AS m 
  LEFT JOIN aua8l_extensions AS e 
  ON m.component_id = e.extension_id

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `aua8l_assets`

1 × SELECT `data` 
  FROM `aua8l_session`

1 × SELECT `session_id` 
  FROM `aua8l_session`

1 × SELECT id, rules 
  FROM `aua8l_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM aua8l_extensions

```
1 × SELECT * 
  FROM aua8l_languages
```

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

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `aua8l_extensions`

1 × SELECT `template_style_id` 
  FROM `aua8l_menu`

1 × SELECT * 
  FROM `aua8l_template_styles`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 aua8l_content AS a 
  INNER JOIN aua8l_categories AS c 
  on c.id = a.catid 
  LEFT JOIN aua8l_users AS u 
  on u.id = a.created_by 
  LEFT JOIN aua8l_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN aua8l_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `aua8l_contentitem_tag_map` AS m  
  INNER JOIN `aua8l_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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 `aua8l_categories` AS `s` 
  INNER JOIN `aua8l_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM aua8l_fields AS a 
  LEFT JOIN `aua8l_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN aua8l_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN aua8l_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN aua8l_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN aua8l_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `aua8l_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT language,id 
  FROM `aua8l_menu`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `aua8l_menu` AS `c` 
  INNER JOIN `aua8l_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `aua8l_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `aua8l_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `aua8l_content` AS `c` 
  INNER JOIN `aua8l_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `aua8l_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `aua8l_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `aua8l_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM aua8l_modules AS m 
  LEFT JOIN aua8l_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN aua8l_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

OTHER Tables:

1 × INSERT INTO `aua8l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6361646263373165656134633765663862393962656163343938653566623863', 1, 1686078895, 0, '', 0

1 × UPDATE `aua8l_extensions` 
  SET `params` = '{\"mediaversion\":\"439bdbf1cd8926993dfe201f5f6d5198\"}'

1 × SHOW FULL COLUMNS 
  FROM `aua8l_content

1 × UPDATE aua8l_content 
  SET `hits` = (`hits` + 1)