green benefit AG

This website uses cookies to make your browsing experience more enjoyable. If you continue to surf the site, you agree to the use of cookies.

More information

Top-Performer in 2019

Since the beginning of the year, our fund "green benefit Nachhaltigkeit Plus" has generated almost 30% profit, and is therefore ranked first in a Europe-wide comparison according to nachhaltiges-investment.org
Manfred Wiegel:

(CEO)

"Sustainability means investing in our life of tomorrow".

Weiterlesen ...
Sustainable means more

Sustainability means much more than just Renewable Energy
Our slogan:

Improve the world and benefit from it!

Weiterlesen ...

Longtime Investment
Enduring wealth comes from owning great companies for a long time.
Unternehmens-Motto von Jensen Investment Management
american asset-management company
Selecting employees
When you hire people who love what they do, they make you look like a genious.
Warren Buffett
american Value-Investor, chairman of Berkshire Hathaway (*1930)
Thankful
It is not happiness that makes you grateful, but gratefulness that makes you happy.
Brother David Steindl-Rast
american benedictine monk, austrian origin (*1926)
Testing
Test everything. Hold on to the good.
Paul in 1 Thessalonians 5:21
Government
It is impossible to rightly govern the world without God and the Bible.
George Washington
first american president 1789-97 (1732-99)
Trustee
What I possess, God owns.
Howard Dayton
Co-founder of Crown Financial Ministries (* 1943)
Buying behavior
I never attempt to make money on the stock market. I buy on the assumption that they could close the market the next day and not reopen it for five years.
Warren Buffett
american Value-Investor, Chairman from Berkshire Heathaway (*1930)
Holding period
How long should you hold a stock? As long as the good things that attracted you to the company are still there.
Philip Carret
Founder of the Pioneer Fund (1896-1997)
Community
Christians, like snowflakes, are frail, but when they stick together they can stop traffic.
Dr. Vance Havner
american pastor and author (1901-1986)
Christmas
Jesus comes into our night so that we can come into his light.
Peter Hahne
television presenter and former EKD Council Member (* 1952)
Volatility
Stocks are much more volatile than the businesses they represent.
Robert G. Kirby
american Investor (1925-2005)
Intelligent Investing
Investment is most intelligent, when it is most businesslike.
Benjamin Graham
born as Benjamin Großbaum, american Investor and founder from the systematic stock analysis (1894-1976)
Praying
I have been driven many times upon my knees by the overwhelming conviction that I had nowhere else to go. My own wisdom, and that of all about me, seemed insufficient for the day.
Abraham Lincoln
american president 1861-65 (1809-1865)
Cosmopolitanism
Common sense tells you that you will find more and sometimes better investment opportunities if you search everywhere in the world.
Sir John Templeton
Value-Investor and Philanthrop (1912-2008)
Courage
Similarly, in the world of securities, courage becomes the supreme virtue after adequate knowledge and a tested judgment are at hand.
Benjamin Graham
born as Benjamin Großbaum, american investor und founder from the systematic stock analysis (1894-1976)
Share Prices
If a business does well, the stock eventually follows.
Warren Buffett
american Value-Investor, Chairman from Berkshire Heathaway (*1930)
Patience
Patience is the most needed virtue for an investor.
Benjamin Graham
born as Benjamin Großbaum, american Investor and founder from the systematic stock analysis (1894-1976)
Art of investment
The art of investing in public companies is... simply to acquire, at a sensible price, a business with excellent economics and able, honest management. Thereafter you need only monitor whether these qualities are being preserved.
Charlie Munger
Vice-Chairman von Berkshire Hathaway (*1924)
Selection
It is only occasionally that there is any reason for selling (carefully selected stocks) at all.
Philip A. Fisher
Growth-Investor and mentor of Warren Buffett (1907-2004)
Long-term investments
More fortunes are made by sitting on good securities for years at a time than by active trading.
Philip Carret
Founder of the Pioneer Fund (1896-1997)
Happiness
Happiness is inward; and so it does not depend on what we have, but on what we are.
Henry J. van Dyke
american writer and reformed clergyman(1852-1933)
Motivation
You’ve got to make your employees happy. If the employees are happy, they are going to make the customers happy.
John Willard Marriott
american entrepreneur , founder of the Marriott hotel chain (1900-1985)
Concentration
It’s better to do a lot of work on one idea, than do some work on a lot of ideas.
Mike Onghai
american investor (*1970)
Charity
All of the good in the world is not done by foundation donations. Much more good is done via ordinary business operations of the corporations in which they invest.
Charlie Munger
Vice Chairman of Berkshire Hathaway
Information
The most successful person is usually the one with the best information.
Benjamin Disraeli
english writer and Prime Minister in 1868 and 1874-80 ( 1804-1881 )
Wishes
Though God will not fulfill all our requests, he will fulfill his promises.
Dietrich Bonhoeffer
Protestant theologian ( bekenndende church) and resistance fighter ( 1906-1945 )
Happy day
This is the day the Lord has made; let us rejoice and be glad in it.
Psalm 118:24
Why God loves us
God loves us not because we are lovable, but because He is love.
C. S. Lewis
British writer (1898-1963)

Who are we?

We are a fund boutique from Fuerth in Bavaria and have focused entirely on the topic of "sustainable investments". In accordance to our slogan "Improve the world and benefit from it", we invest with our mutual fund "green benefit Nachhaltigkeit Plus" exclusively in values that meet ecological, ethical and social criterias.
Our core approach and USP is the "Pure-play approach".
We use years of experience in the field of sustainability to manage individual sustainanable portfolios.
For more information on sustainable investments or the green benefit Nachhaltigkeit Plus fund, please call us or contact us here.

What is the most important signal for companies from the climate agreement?

Companies have greater planning security which they need for their long-term investments
The aim is to shift long-term investment towards a low-carbon production method.
- Infrastructure
- Power supply
- Product development

Which sectors could benefit the most from it??

renewable energies (wind, solar)
LED
energy efficiency
electromobility
power storage

We are already high weighted invested in these industry fields with our fund"green benefit Nachhaltigkeit Plus"

We invest sustainable. We choose our investments according to social, ethical and ecological principles with high passion.

Our qualifications you can benefit from:

green benefit AG = 100 % owner-managed fund management
Approved management team - cooperation 13 years
Successful track record by management team
- 5 Stars rating Morningstarfunds
- Lipper Leaders rating 5
Concentrated portfolio (20 – 30 companies) = high convictionstrong>
high active share of 99,44 % compared with worldwide ESG Index

Follow @ecoBerater

For current news follow us on Twitter or visit this page

Our philosophy:

"Improve the world and benefit from it!"

Electric mobility and vehicles

Benefiting from solar-powered charging stations.

Renewable energy

Participating in the global mega-trend of emission-free energy.

Efficiency in energy

With 80 % energy saving LED technology is on its way to becoming a mass market.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1568636865,
                "last": 1568636865,
                "now": 1568636865
            },
            "token": "Rh1ux7cpxc4JO5m8DpuI8qqmlAu4rvnE"
        },
        "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"
        }
    }
}

Profile Information

Time

Memory

Time: 271.09 ms / 271.09 ms Memory: 1.444 MB / 1.79 MB Application: afterLoad

Time: 471.66 ms / 742.76 ms Memory: 3.886 MB / 5.68 MB Application: afterInitialise

Time: 242.44 ms / 985.20 ms Memory: 1.054 MB / 6.73 MB Application: afterRoute

Time: 20.90 ms / 1006.09 ms Memory: 0.180 MB / 6.91 MB Application: beforeRenderComponent com_content

Time: 60.18 ms / 1066.27 ms Memory: 0.641 MB / 7.56 MB Application: Before Access::preloadComponents (all components)

Time: 2.66 ms / 1068.93 ms Memory: 0.048 MB / 7.60 MB Application: After Access::preloadComponents (all components)

Time: 0.09 ms / 1069.03 ms Memory: 0.000 MB / 7.60 MB Application: Before Access::preloadPermissions (com_content)

Time: 2.09 ms / 1071.11 ms Memory: 0.051 MB / 7.65 MB Application: After Access::preloadPermissions (com_content)

Time: 0.11 ms / 1071.22 ms Memory: 0.000 MB / 7.65 MB Application: Before Access::getAssetRules (id:304 name:com_content.category.96)

Time: 10.54 ms / 1081.76 ms Memory: 0.023 MB / 7.67 MB Application: After Access::getAssetRules (id:304 name:com_content.category.96)

Time: 48.38 ms / 1130.14 ms Memory: 0.186 MB / 7.86 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.08 ms / 1130.21 ms Memory: 0.005 MB / 7.86 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 348.98 ms / 1479.20 ms Memory: 1.217 MB / 9.08 MB Application: afterRenderComponent com_content

Time: 87.10 ms / 1566.30 ms Memory: 0.201 MB / 9.28 MB Application: afterDispatch

Time: 200.33 ms / 1766.63 ms Memory: 0.390 MB / 9.67 MB Application: beforeRenderModule mod_djimageslider (Testimonials_en)

Time: 28.41 ms / 1795.04 ms Memory: 0.238 MB / 9.91 MB Application: afterRenderModule mod_djimageslider (Testimonials_en)

Time: 19.53 ms / 1814.57 ms Memory: 0.000 MB / 9.86 MB Application: beforeRenderModule mod_custom (Who are we?)

Time: 8.25 ms / 1822.81 ms Memory: 0.006 MB / 9.87 MB Application: afterRenderModule mod_custom (Who are we?)

Time: 13.83 ms / 1836.65 ms Memory: 0.115 MB / 9.98 MB Application: beforeRenderModule mod_custom (Electric mobility and vehicles)

Time: 5.08 ms / 1841.72 ms Memory: 0.003 MB / 9.98 MB Application: afterRenderModule mod_custom (Electric mobility and vehicles)

Time: 0.30 ms / 1842.02 ms Memory: 0.002 MB / 9.99 MB Application: beforeRenderModule mod_custom (Renewable energy)

Time: 4.39 ms / 1846.41 ms Memory: 0.003 MB / 9.99 MB Application: afterRenderModule mod_custom (Renewable energy)

Time: 0.19 ms / 1846.60 ms Memory: 0.000 MB / 9.99 MB Application: beforeRenderModule mod_custom (Efficiency in energy)

Time: 3.05 ms / 1849.65 ms Memory: 0.003 MB / 9.99 MB Application: afterRenderModule mod_custom (Efficiency in energy)

Time: 8.67 ms / 1858.33 ms Memory: 0.000 MB / 9.99 MB Application: beforeRenderModule mod_menu (Sitemap)

Time: 59.93 ms / 1918.26 ms Memory: 0.101 MB / 10.09 MB Application: afterRenderModule mod_menu (Sitemap)

Time: 0.30 ms / 1918.56 ms Memory: 0.000 MB / 10.09 MB Application: beforeRenderModule mod_custom (Note)

Time: 3.97 ms / 1922.54 ms Memory: 0.003 MB / 10.10 MB Application: afterRenderModule mod_custom (Note)

Time: 0.19 ms / 1922.72 ms Memory: 0.000 MB / 10.10 MB Application: beforeRenderModule mod_custom (Contact)

Time: 33.70 ms / 1956.43 ms Memory: 0.591 MB / 10.69 MB Application: afterRenderModule mod_custom (Contact)

Time: 10.42 ms / 1966.85 ms Memory: 0.000 MB / 10.68 MB Application: beforeRenderModule mod_custom (Copyrights)

Time: 3.21 ms / 1970.06 ms Memory: 0.003 MB / 10.68 MB Application: afterRenderModule mod_custom (Copyrights)

Time: 0.04 ms / 1970.10 ms Memory: 0.000 MB / 10.68 MB Application: beforeRenderModule mod_menu (Imprint etc.)

Time: 14.10 ms / 1984.20 ms Memory: 0.018 MB / 10.70 MB Application: afterRenderModule mod_menu (Imprint etc.)

Time: 0.15 ms / 1984.34 ms Memory: 0.002 MB / 10.70 MB Application: beforeRenderModule mod_djimageslider (DJ-ImageSlider_en)

Time: 19.61 ms / 2003.96 ms Memory: 0.089 MB / 10.79 MB Application: afterRenderModule mod_djimageslider (DJ-ImageSlider_en)

Time: 0.26 ms / 2004.21 ms Memory: 0.000 MB / 10.77 MB Application: beforeRenderModule mod_djmenu (DJ-Menu Main Menu)

Time: 18.20 ms / 2022.41 ms Memory: 0.047 MB / 10.82 MB Application: afterRenderModule mod_djmenu (DJ-Menu Main Menu)

Time: 0.09 ms / 2022.50 ms Memory: 0.000 MB / 10.82 MB Application: beforeRenderModule mod_custom (Socials)

Time: 3.56 ms / 2026.06 ms Memory: 0.003 MB / 10.82 MB Application: afterRenderModule mod_custom (Socials)

Time: 0.10 ms / 2026.16 ms Memory: 0.001 MB / 10.82 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 41.92 ms / 2068.08 ms Memory: 0.047 MB / 10.87 MB Application: afterRenderModule mod_languages (Language Switcher)

Time: 66.67 ms / 2134.75 ms Memory: 0.302 MB / 11.17 MB Application: afterRender

Database queries total: 37.25 ms

Memory Usage

Database Queries

40 Queries Logged 37.25 ms

6 duplicate found!

2 duplicates: #27 #39

2 duplicates: #28 #29

2 duplicates: #31 #38

Query Time: 0.33 ms Query memory: 0.005 MB Memory before query: 3.249 MB Rows returned: 0

SELECT `data`

  FROM `efb28_session`

  WHERE `session_id` = '5f9d71b52063137eb3056311de341a07'

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.35 ms After last query: 9.15 ms Query memory: 0.003 MB Memory before query: 3.342 MB Rows returned: 0

SELECT `session_id`

  FROM `efb28_session`

  WHERE `session_id` = '5f9d71b52063137eb3056311de341a07' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.05 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.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.04 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.98 ms After last query: 0.09 ms Query memory: 0.003 MB Memory before query: 3.346 MB

INSERT INTO `efb28_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('5f9d71b52063137eb3056311de341a07', 1, 1568636865, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `efb28_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('5f9d71b52063137eb3056311de341a07', 1, 1568636865, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.09 ms
end	0.02 ms
query end	0.63 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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: 1.02 ms After last query: 23.26 ms Query memory: 0.004 MB Memory before query: 3.535 MB Rows returned: 40

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

  FROM `efb28_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	ref	extension	extension	82	const	41	100.00	Using index condition; 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.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.04 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:196
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: 19.89 ms Query memory: 0.003 MB Memory before query: 3.702 MB Rows returned: 5

SELECT id, rules

  FROM `efb28_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 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.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	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:321
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:196
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.36 ms After last query: 0.14 ms Query memory: 0.004 MB Memory before query: 3.711 MB Rows returned: 1

SELECT b.id

  FROM efb28_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 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.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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:321
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:196
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.26 ms After last query: 3.92 ms Query memory: 0.004 MB Memory before query: 3.770 MB Rows returned: 99

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

  FROM efb28_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	ref	extension	extension	82	const	121	100.00	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.01 ms
Sending data	0.01 ms
Creating sort index	0.64 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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:354
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:359
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:196
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.44 ms After last query: 119.94 ms Query memory: 0.003 MB Memory before query: 4.955 MB Rows returned: 1

SELECT `enabled`

  FROM `efb28_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; 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.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 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/plugins/system/backuponupdate/backuponupdate.php:36
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
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:625
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:196
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: 5.56 ms Query memory: 0.004 MB Memory before query: 5.035 MB Rows returned: 2

SELECT *

  FROM efb28_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.03 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.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
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:625
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:196
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.32 ms After last query: 0.14 ms Query memory: 0.003 MB Memory before query: 5.042 MB Rows returned: 4

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

  FROM `efb28_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	ref	extension	extension	82	const	4	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 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.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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:283
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:625
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:196
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.38 ms After last query: 116.42 ms Query memory: 0.007 MB Memory before query: 5.496 MB Rows returned: 30

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

  LEFT JOIN efb28_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	37	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	DB1985702.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	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:626
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:196
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.89 ms After last query: 209.58 ms Query memory: 0.004 MB Memory before query: 6.436 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM efb28_template_styles as s

  LEFT JOIN efb28_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00	NULL
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	DB1985702.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.04 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/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jmframework/jmframework.php:138
9	plgSystemJMFramework->getTemplateName()	JROOT/plugins/system/jmframework/jmframework.php:86
8	plgSystemJMFramework->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:1122
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:196
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.41 ms After last query: 53.15 ms Query memory: 0.005 MB Memory before query: 6.767 MB Rows returned: 1

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

  FROM `efb28_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

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.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:196
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.72 ms After last query: 0.19 ms Query memory: 0.003 MB Memory before query: 6.756 MB

UPDATE `efb28_extensions`

  SET `params` = '{\"mediaversion\":\"375378cc4aec43dc6bfc3d08240fa85f\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:196
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.20 ms After last query: 77.75 ms Query memory: 0.007 MB Memory before query: 7.559 MB Rows returned: 40

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

  FROM `efb28_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djimageslider','com_fields','com_finder','com_installer','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocamaps','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	202	20.30	Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.84 ms After last query: 1.08 ms Query memory: 0.007 MB Memory before query: 7.601 MB Rows returned: 59

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

  FROM `efb28_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	202	100.00	Using where

Profile

Status	Duration
starting	0.03 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.02 ms
executing	0.01 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.74 ms After last query: 38.12 ms Query memory: 0.006 MB Memory before query: 7.721 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,(
SELECT COUNT(i.`id`)

  FROM `efb28_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'en-GB')) AS numitems

  FROM `efb28_categories` AS `s`

  INNER JOIN `efb28_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.published = 1 
  AND s.id = 96

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	67	26.87	Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	DB1985702.c.id	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.13 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.25 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.86 ms After last query: 20.24 ms Query memory: 0.006 MB Memory before query: 7.864 MB Rows returned: 2

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM efb28_content AS a

  LEFT JOIN efb28_categories AS c 
  ON c.id = a.catid

  LEFT JOIN efb28_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN efb28_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 96 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-16 12:27:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-16 12:27:46') 
  AND a.language IN ('en-GB','*')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	4	100.00	Using where
1	SIMPLE	ua	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	DB1985702.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.29 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
Opening tables	0.03 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.07 ms
Creating tmp table	0.15 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.04 ms
Creating sort index	0.09 ms
end	0.01 ms
removing tmp table	0.31 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.06 ms
logging slow query	0.05 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()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.80 ms After last query: 6.37 ms Query memory: 0.006 MB Memory before query: 7.983 MB Rows returned: 1

SELECT COUNT(*)

  FROM efb28_content AS a

  LEFT JOIN efb28_categories AS c 
  ON c.id = a.catid

  LEFT JOIN efb28_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN efb28_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 96 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-16 12:27:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-16 12:27:46') 
  AND a.language IN ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	4	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB1985702.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	DB1985702.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	DB1985702.a.id	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.10 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
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.62 ms After last query: 9.36 ms Query memory: 0.005 MB Memory before query: 8.084 MB Rows returned: 0

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

  FROM `efb28_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 96 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.97 ms After last query: 72.07 ms Query memory: 0.007 MB Memory before query: 8.432 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 `efb28_categories` AS `s`

  INNER JOIN `efb28_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) 
  AND c.published = 1 
  AND s.id = 96

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.04 ms
cleaning up	0.01 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:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
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/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.58 ms After last query: 0.32 ms Query memory: 0.006 MB Memory before query: 8.445 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 efb28_fields AS a

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

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

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

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

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

  LEFT JOIN `efb28_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 (96,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','en-GB')

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.63 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.04 ms
cleaning up	0.01 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:308
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:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
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/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.17 ms After last query: 192.92 ms Query memory: 0.008 MB Memory before query: 9.050 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 efb28_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (96,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','en-GB')

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.17 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
Opening tables	0.04 ms
init	0.09 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.84 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.20 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/tmpl/blog.php:19
14	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.50 ms After last query: 58.96 ms Query memory: 0.003 MB Memory before query: 9.085 MB Rows returned: 2

SELECT language,id

  FROM `efb28_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	38	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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/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:196
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.40 ms After last query: 2.88 ms Query memory: 0.004 MB Memory before query: 9.145 MB Rows returned: 2

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

  FROM `efb28_menu` AS `c`

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

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

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

  WHERE c.id = 561

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	100.00	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	DB1985702.a2.id	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	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:196
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.52 ms After last query: 7.09 ms Query memory: 0.004 MB Memory before query: 9.183 MB Rows returned: 2

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

  FROM `efb28_categories` AS `c`

  INNER JOIN `efb28_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item'

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

  INNER JOIN `efb28_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

  WHERE c.id = 96 
  AND c.extension = 'com_content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	100.00	Using index
1	SIMPLE	c2	eq_ref	PRIMARY,cat_idx	PRIMARY	4	DB1985702.a2.id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.04 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/Language/Associations.php:115
11	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
10	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
9	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
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:196
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: 0.15 ms Query memory: 0.004 MB Memory before query: 9.186 MB Rows returned: 1

Duplicate queries: #39

SELECT `published`

  FROM `efb28_categories`

  WHERE access IN (1,1) 
  AND `id` = 90

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_categories	const	PRIMARY,idx_access	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.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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/administrator/components/com_categories/helpers/categories.php:132
10	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
9	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
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:196
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.33 ms After last query: 241.12 ms Query memory: 0.006 MB Memory before query: 9.519 MB Rows returned: 14

Duplicate queries: #29

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

  FROM efb28_modules AS m

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

  LEFT JOIN efb28_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 <= '2019-09-16 12:27:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-09-16 12:27:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 561 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	37	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	DB1985702.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	DB1985702.m.id	1	100.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.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.03 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()	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:432
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/jmframework/includes/libraries/template.php:178
10	JMFTemplate->countModules()	JROOT/templates/jm-renewable-energy/lib/jm_template.php:21
9	JMTemplateBlank->postSetUp()	JROOT/plugins/system/jmframework/includes/libraries/template.php:58
8	JMFTemplate->__construct()	JROOT/templates/jm-renewable-energy/index.php:18
7	require JROOT/templates/jm-renewable-energy/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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.56 ms After last query: 31.13 ms Query memory: 0.007 MB Memory before query: 9.650 MB Rows returned: 14

Duplicate queries: #28

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

  FROM efb28_modules AS m

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

  LEFT JOIN efb28_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 <= '2019-09-16 12:27:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-09-16 12:27:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 561 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	37	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	DB1985702.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	DB1985702.m.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:49
13	DJModuleHelper::renderModules()	JROOT/templates/jm-renewable-energy/tpl/blocks/top1.php:20
12	include JROOT/templates/jm-renewable-energy/tpl/blocks/top1.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
11	JMFTemplate->renderBlock()	JROOT/templates/jm-renewable-energy/tpl/default.php:22
10	include JROOT/templates/jm-renewable-energy/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:222
8	JMFTemplate->renderScheme()	JROOT/templates/jm-renewable-energy/index.php:19
7	require JROOT/templates/jm-renewable-energy/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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.18 ms After last query: 13.85 ms Query memory: 0.007 MB Memory before query: 9.809 MB Rows returned: 28

SELECT a.*

  FROM efb28_djimageslider AS a

  WHERE a.catid = 98 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-16 12:27:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-16 12:27:46')

  ORDER BY a.ordering ASC 
  LIMIT 95

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	28	100.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djimageslider/helper.php:120
17	modDJImageSliderHelper::getImagesFromDJImageSlider()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:45
16	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
13	DJModuleHelper::renderModules()	JROOT/templates/jm-renewable-energy/tpl/blocks/top1.php:20
12	include JROOT/templates/jm-renewable-energy/tpl/blocks/top1.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
11	JMFTemplate->renderBlock()	JROOT/templates/jm-renewable-energy/tpl/default.php:22
10	include JROOT/templates/jm-renewable-energy/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:222
8	JMFTemplate->renderScheme()	JROOT/templates/jm-renewable-energy/index.php:19
7	require JROOT/templates/jm-renewable-energy/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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: 2.70 ms Query memory: 0.007 MB Memory before query: 9.886 MB Rows returned: 1

Duplicate queries: #38

SELECT manifest_cache 
  FROM efb28_extensions 
  WHERE element='mod_djimageslider' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:97
16	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
13	DJModuleHelper::renderModules()	JROOT/templates/jm-renewable-energy/tpl/blocks/top1.php:20
12	include JROOT/templates/jm-renewable-energy/tpl/blocks/top1.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
11	JMFTemplate->renderBlock()	JROOT/templates/jm-renewable-energy/tpl/default.php:22
10	include JROOT/templates/jm-renewable-energy/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:222
8	JMFTemplate->renderScheme()	JROOT/templates/jm-renewable-energy/index.php:19
7	require JROOT/templates/jm-renewable-energy/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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.66 ms After last query: 142.31 ms Query memory: 0.010 MB Memory before query: 10.125 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 efb28_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND (fc.category_id IS NULL OR fc.category_id IN (96,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','en-GB')

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.19 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
Opening tables	0.04 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.59 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
20	JHtmlContent::prepare()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
16	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
13	DJModuleHelper::renderModules()	JROOT/templates/jm-renewable-energy/tpl/blocks/footer.php:25
12	include JROOT/templates/jm-renewable-energy/tpl/blocks/footer.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
11	JMFTemplate->renderBlock()	JROOT/templates/jm-renewable-energy/tpl/default.php:29
10	include JROOT/templates/jm-renewable-energy/tpl/default.php	JROOT/plugins/system/jmframework/includes/libraries/template.php:215
9	JMFTemplate->renderBlock()	JROOT/plugins/system/jmframework/includes/libraries/template.php:222
8	JMFTemplate->renderScheme()	JROOT/templates/jm-renewable-energy/index.php:19
7	require JROOT/templates/jm-renewable-energy/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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.65 ms After last query: 56.50 ms Query memory: 0.005 MB Memory before query: 10.752 MB Rows returned: 4

SELECT a.*

  FROM efb28_djimageslider AS a

  WHERE a.catid = 97 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-16 12:27:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-16 12:27:46')

  ORDER BY a.ordering ASC 
  LIMIT 95

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	4	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.04 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/modules/mod_djimageslider/helper.php:120
11	modDJImageSliderHelper::getImagesFromDJImageSlider()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:45
10	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.99 ms Query memory: 0.006 MB Memory before query: 10.773 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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM efb28_content AS a

  LEFT JOIN efb28_categories AS c 
  ON c.id = a.catid

  LEFT JOIN efb28_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN efb28_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND a.id = 89 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-16 12:27:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-16 12:27:46')

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.14 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
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/modules/mod_djimageslider/helper.php:172
12	modDJImageSliderHelper::getSlideLink()	JROOT/modules/mod_djimageslider/helper.php:124
11	modDJImageSliderHelper::getImagesFromDJImageSlider()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:45
10	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.71 ms After last query: 0.58 ms Query memory: 0.008 MB Memory before query: 10.800 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 `efb28_categories` AS `s`

  INNER JOIN `efb28_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) 
  AND c.published = 1 
  AND s.id = 92

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
22	ContentRouter->getCategorySegment()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_djimageslider/helper.php:175
12	modDJImageSliderHelper::getSlideLink()	JROOT/modules/mod_djimageslider/helper.php:124
11	modDJImageSliderHelper::getImagesFromDJImageSlider()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:45
10	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.78 ms After last query: 0.57 ms Query memory: 0.006 MB Memory before query: 10.797 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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM efb28_content AS a

  LEFT JOIN efb28_categories AS c 
  ON c.id = a.catid

  LEFT JOIN efb28_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN efb28_users AS uam 
  ON uam.id = a.modified_by

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND a.id = 90 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-16 12:27:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-16 12:27:46')

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.10 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.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/modules/mod_djimageslider/helper.php:172
12	modDJImageSliderHelper::getSlideLink()	JROOT/modules/mod_djimageslider/helper.php:124
11	modDJImageSliderHelper::getImagesFromDJImageSlider()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:45
10	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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: 0.42 ms Query memory: 0.008 MB Memory before query: 10.830 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 `efb28_categories` AS `s`

  INNER JOIN `efb28_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) 
  AND c.published = 1 
  AND s.id = 94

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
22	ContentRouter->getCategorySegment()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_djimageslider/helper.php:175
12	modDJImageSliderHelper::getSlideLink()	JROOT/modules/mod_djimageslider/helper.php:124
11	modDJImageSliderHelper::getImagesFromDJImageSlider()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:45
10	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.77 ms After last query: 1.64 ms Query memory: 0.004 MB Memory before query: 10.817 MB Rows returned: 1

Duplicate queries: #31

SELECT manifest_cache 
  FROM efb28_extensions 
  WHERE element='mod_djimageslider' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition

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.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.43 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	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/modules/mod_djimageslider/mod_djimageslider.php:97
10	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.51 ms After last query: 37.03 ms Query memory: 0.005 MB Memory before query: 10.861 MB Rows returned: 1

Duplicate queries: #27

SELECT `published`

  FROM `efb28_categories`

  WHERE access IN (1,1) 
  AND `id` = 90

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	efb28_categories	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.05 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/administrator/components/com_categories/helpers/categories.php:132
14	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
13	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
12	ContentHelperAssociation::getAssociations()	JROOT/modules/mod_languages/helper.php:68
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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: 1.60 ms Query memory: 0.008 MB Memory before query: 10.873 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 `efb28_categories` AS `s`

  INNER JOIN `efb28_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) 
  AND c.published = 1 
  AND s.id = 90

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	idx_left_right	4	NULL	10	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_languages/helper.php:115
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × 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 `efb28_categories` AS `s` 
  INNER JOIN `efb28_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)

3 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM efb28_content AS a 
  LEFT JOIN efb28_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN efb28_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN efb28_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN efb28_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN efb28_content_rating AS v 
  ON a.id = v.content_id

3 × 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 efb28_fields AS a 
  LEFT JOIN `efb28_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN efb28_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN efb28_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN efb28_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN efb28_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `efb28_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × SELECT manifest_cache 
  FROM efb28_extensions

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

2 × SELECT a.* 
  FROM efb28_djimageslider AS a

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM efb28_modules AS m 
  LEFT JOIN efb28_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN efb28_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

2 × SELECT `published` 
  FROM `efb28_categories`

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

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` 
  FROM `efb28_categories` AS `c` 
  INNER JOIN `efb28_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item' 
  INNER JOIN `efb28_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `efb28_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

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

1 × SELECT language,id 
  FROM `efb28_menu`

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

1 × SELECT `data` 
  FROM `efb28_session`

1 × SELECT COUNT(*) 
  FROM efb28_content AS a 
  LEFT JOIN efb28_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN efb28_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN efb28_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN efb28_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN efb28_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id` 
  FROM `efb28_session`

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

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 efb28_menu AS m 
  LEFT JOIN efb28_extensions AS e 
  ON m.component_id = e.extension_id

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

```
1 × SELECT * 
  FROM efb28_languages
```

1 × SELECT `enabled` 
  FROM `efb28_extensions`

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

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

1 × SELECT id, rules 
  FROM `efb28_viewlevels

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,( SELECT COUNT(i.`id`) 
  FROM `efb28_content` AS `i`

OTHER Tables:

1 × INSERT INTO `efb28_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('5f9d71b52063137eb3056311de341a07', 1, 1568636865, 0, '', 0

1 × UPDATE `efb28_extensions` 
  SET `params` = '{\"mediaversion\":\"375378cc4aec43dc6bfc3d08240fa85f\"}'

Who are we?

UN Climate Change Conference Paris 12.12.2015

Excellent conditions for a successful fund management

Electric mobility and vehicles

Renewable energy

Efficiency in energy

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

40 Queries Logged 37.25 ms

6 duplicate found!

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: