Energrow Inc - Energrow

Energrow Inc.

If farmers want to survive they are going to have to try some of these things!
Mr. Albrecht
Newton, Ontario

Energrow’s oilseed pressing system helps farmers CRUSH their feed costs.
The easy way to make fresh, home-grown, high-quality meal + expeller-pressed oil, right on the farm. The fully automated, turnkey CRUSH-Pro is easy to set up and run 24/7. Cows love the meal, and we’ll buy back the oil

SAVE THOUSANDS EACH YEAR
Energrow’s award-winning oilseed pressing system saves farmers thousands of dollars each year on feed costs, replacing 75% or more of your purchased protein with nutritious, highly palatable Soyex™ soybean meal. Farms with a 75-head dairy save more than $15,000 per year on average, with the system paying for itself in less than three years, and then many times over.

Plus, Energrow guarantees a market for the cold-pressed soybean oil: For every tonne of soybeans that you press, you can make approximately $60 for the oil you extract. We pick up the oil in 1,000L totes, and send you a cheque! Or keep the oil to offset your diesel usage on the farm. How much will you save?

FRESH, PALATABLE HIGH QUALITY PROTEIN AND ENERGY
Soyex™, the expeller-pressed soybean meal made by your CRUSH-Pro oilseed pressing system, is a consistent and palatable feed that your cows will love. It’s freshly pelleted, and ready to feed in a top dress, TMR or robot rations. Soyex™ is typically fed at around 2-3kg/lactating cow/day and can replace over 75% of your purchased protein. Need help adding Soyex™ to your cows’ diet? Contact our nutritionist. Energrow presses also process canola, flaxseed and other oilseeds.

EASY TO SET UP, RUN AND MAINTAIN
The fully automated Energrow oilseed pressing system is the most user-friendly, efficient and reliable oilseed pressing system on the market. Get crushing within a couple hours of the press arriving at your farm! Energrow makes crushing simple so you can continue to focus on running your farm.

An Energrow oilseed press can make up to 900kg of fresh pressed soybean meal per day. That’s enough to feed over 300 cows for only $5 of electricity. You can run your system a few days out of the week or run multiple presses if you need more production.

“It takes us basically 2 minutes to clean the press, get the sediment out of the sift, shake it out and then we walk back out for 24 hours.”

“It’s easy to operate, very easy to set-up and fairly maintenance free. If I have seed in the tank it’ll run 24 hours a day. It’ll operate while I’m sleeping or taking deposits to the bank!"

SUPPORTED WITH AN INDUSTRY-LEADING WARRANTY
The Energrow oilseed pressing system is designed and made in Canada, with an industry-leading warranty. Each CRUSH-Pro system comes with hands-on training at your farm, and is backed by a reliable service network to ensure a steady supply of feed - and profits too!

“Support’s great, they’re just a phone call away and they can walk you through any problems."

Learn more about the Energrow oil buyback program, exclusive to Energrow Crushers.
*Full program in effect for Ontario customers, some limitations apply to other Canadian provinces and US states. For program details, contact Energrow.

"It doesn't matter how you look at it, you're saving money by crushing beans. The oil will pay for the system. My banker even wanted to know how I'm feeding my cows so much cheaper than other robot farms."
Robot Dairy Farm in Moorefield, ON

Energrow is the proud Canadian distributor for RedJacket Electric Grain Roasters out of Kansas, USA!
"Makes High Value Feed, Easy and Affordable"

RedJacket Roasters are a complete unit that any farm or operation can plug in and roast immediately with no extra machinery needed to produce high quality roasted grain. Electrical cost is much lower than some assume at approximately $14.00 per ton or $0.35 per bushel. One huge advantage of our fully electric machines is the ability to run around the clock with no close supervision.

Features:

Fully Electric

Continuous Flow for Around the Clock Roasting on the Farm

Easily Adjustable Digital Thermostat

Designed and Manufactured in Kansas, USA

Engineered to be Economical and Efficient

Dependable and Reliable with Little to No Maintenance

Constructed of High-Quality Parts, Heavy Gauge Steel & Durable Powder Coat Finish

1 Year Machine Parts Warranty

Roast Your Own:

Soybeans

Corn

Barley

Milo

Hemp Seed

Other Grains or Products

Operations:

Dairy

Beef

Pork

Poultry

Sheep

Deer

Feed Mill

See Brochures for Capacities, Specifications & Additional Information:

Model 1040 Electric Grain Roaster

Model 2040 Electric Grain Roaster

250F Flaking Attachment for 1040 Roaster

600R Roller Attachment for 1040 and 2040 Roasters

Contact us for Pricing and Additional Questions.

Simple & Efficient Design for easy operation & fast return on your investment.
Take Control of your Feed Rations by Pressing and/or Roasting your Own Soybeans!

More Articles ...

Why Energrow?

An Energrow Story - Moyncroft Farms

Energrow ES3750B

Page 1 of 2

Start
Prev
1
2
Next
End

Markets

Financial Markets by TradingView

Value of Crushing Your Soybeans

Energrow Events

No events found

Joomla! Debug Console
Session
{ "__default": { "session": { "counter": 1, "timer": { "start": 1701792516, "last": 1701792516, "now": 1701792516 }, "token": "3vQv1g1U3lXajnsl0APgfAfgXhsF7iwg" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } } }

Profile Information
Time
Memory
Time: 37.48 ms / 37.48 ms Memory: 1.830 MB / 1.98 MB Application: afterLoad
Time: 99.33 ms / 136.81 ms Memory: 5.097 MB / 7.07 MB Application: afterInitialise
Time: 43.58 ms / 180.40 ms Memory: 1.500 MB / 8.57 MB Application: afterRoute
Time: 1.45 ms / 181.85 ms Memory: 0.031 MB / 8.60 MB Application: beforeRenderComponent com_content
Time: 11.06 ms / 192.90 ms Memory: 0.620 MB / 9.22 MB Application: Before Access::preloadComponents (all components)
Time: 1.31 ms / 194.21 ms Memory: 0.059 MB / 9.28 MB Application: After Access::preloadComponents (all components)
Time: 0.05 ms / 194.26 ms Memory: -0.003 MB / 9.28 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 1.20 ms / 195.46 ms Memory: 0.032 MB / 9.31 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 68.21 ms / 263.67 ms Memory: 2.273 MB / 11.59 MB Application: afterRenderComponent com_content
Time: 6.55 ms / 270.23 ms Memory: 0.108 MB / 11.69 MB Application: afterDispatch
Time: 19.23 ms / 289.46 ms Memory: 0.477 MB / 12.17 MB Application: beforeRenderModule mod_lab5_mobile_videos (Lab5 Mobile Videos Module (Homepage))
Time: 2.84 ms / 292.30 ms Memory: 0.076 MB / 12.25 MB Application: afterRenderRawModule mod_lab5_mobile_videos (Lab5 Mobile Videos Module (Homepage))
Time: 0.02 ms / 292.32 ms Memory: -0.007 MB / 12.24 MB Application: beforeRenderModule mod_lab5_mobile_videos (Lab5 Mobile Videos Module (Homepage))
Time: 1.82 ms / 294.13 ms Memory: 0.047 MB / 12.29 MB Application: afterRenderModule mod_lab5_mobile_videos (Lab5 Mobile Videos Module (Homepage))
Time: 0.09 ms / 294.22 ms Memory: -0.004 MB / 12.28 MB Application: beforeRenderModule mod_jafinance (Markets)
Time: 1.79 ms / 296.01 ms Memory: 0.031 MB / 12.31 MB Application: afterRenderRawModule mod_jafinance (Markets)
Time: 0.02 ms / 296.03 ms Memory: -0.009 MB / 12.31 MB Application: beforeRenderModule mod_jafinance (Markets)
Time: 1.04 ms / 297.06 ms Memory: 0.003 MB / 12.31 MB Application: afterRenderModule mod_jafinance (Markets)
Time: 0.05 ms / 297.11 ms Memory: -0.001 MB / 12.31 MB Application: beforeRenderModule mod_custom (TradingView attribution)
Time: 1.13 ms / 298.24 ms Memory: 0.005 MB / 12.31 MB Application: afterRenderRawModule mod_custom (TradingView attribution)
Time: 0.01 ms / 298.25 ms Memory: -0.001 MB / 12.31 MB Application: beforeRenderModule mod_custom (TradingView attribution)
Time: 1.01 ms / 299.26 ms Memory: 0.003 MB / 12.31 MB Application: afterRenderModule mod_custom (TradingView attribution)
Time: 0.20 ms / 299.46 ms Memory: 0.023 MB / 12.34 MB Application: beforeRenderModule mod_jagooglechart_2 (Value of Crushing Your Soybeans )
Time: 3.18 ms / 302.64 ms Memory: 0.135 MB / 12.47 MB Application: afterRenderRawModule mod_jagooglechart_2 (Value of Crushing Your Soybeans )
Time: 0.04 ms / 302.68 ms Memory: -0.052 MB / 12.42 MB Application: beforeRenderModule mod_jagooglechart_2 (Value of Crushing Your Soybeans )
Time: 1.03 ms / 303.72 ms Memory: 0.003 MB / 12.42 MB Application: afterRenderModule mod_jagooglechart_2 (Value of Crushing Your Soybeans )
Time: 0.07 ms / 303.78 ms Memory: -0.022 MB / 12.40 MB Application: beforeRenderModule mod_dpcalendar_upcoming (Energrow Events)
Time: 6.41 ms / 310.19 ms Memory: 0.288 MB / 12.69 MB Application: Before Access::preloadPermissions (com_dpcalendar)
Time: 0.71 ms / 310.91 ms Memory: 0.019 MB / 12.71 MB Application: After Access::preloadPermissions (com_dpcalendar)
Time: 0.03 ms / 310.94 ms Memory: 0.001 MB / 12.71 MB Application: Before Access::getAssetRules (id:530 name:com_dpcalendar.category.221)
Time: 0.09 ms / 311.03 ms Memory: 0.006 MB / 12.72 MB Application: After Access::getAssetRules (id:530 name:com_dpcalendar.category.221)
Time: 9.17 ms / 320.19 ms Memory: 0.330 MB / 13.05 MB Application: Before Access::getAssetRules (id:512 name:com_dpcalendar)
Time: 0.07 ms / 320.26 ms Memory: 0.005 MB / 13.05 MB Application: After Access::getAssetRules (id:512 name:com_dpcalendar)
Time: 36.79 ms / 357.05 ms Memory: 2.497 MB / 15.55 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.06 ms / 357.11 ms Memory: 0.005 MB / 15.55 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 11.35 ms / 368.46 ms Memory: 0.466 MB / 16.02 MB Application: afterRenderRawModule mod_dpcalendar_upcoming (Energrow Events)
Time: 0.05 ms / 368.51 ms Memory: -0.030 MB / 15.99 MB Application: beforeRenderModule mod_dpcalendar_upcoming (Energrow Events)
Time: 1.08 ms / 369.59 ms Memory: 0.003 MB / 15.99 MB Application: afterRenderModule mod_dpcalendar_upcoming (Energrow Events)
Time: 0.09 ms / 369.68 ms Memory: 0.007 MB / 16.00 MB Application: beforeRenderModule mod_tweetdisplayback (Twitter Feed)
Time: 0.13 ms / 369.82 ms Memory: 0.001 MB / 16.00 MB Application: afterRenderRawModule mod_tweetdisplayback (Twitter Feed)
Time: 0.01 ms / 369.82 ms Memory: 0.001 MB / 16.00 MB Application: beforeRenderModule mod_tweetdisplayback (Twitter Feed)
Time: 0.99 ms / 370.82 ms Memory: 0.002 MB / 16.00 MB Application: afterRenderModule mod_tweetdisplayback (Twitter Feed)
Time: 0.10 ms / 370.92 ms Memory: -0.007 MB / 16.00 MB Application: beforeRenderModule mod_articles_news (Testimonials)
Time: 8.75 ms / 379.66 ms Memory: 0.105 MB / 16.10 MB Application: afterRenderRawModule mod_articles_news (Testimonials)
Time: 0.02 ms / 379.69 ms Memory: -0.018 MB / 16.08 MB Application: beforeRenderModule mod_articles_news (Testimonials)
Time: 1.06 ms / 380.74 ms Memory: 0.002 MB / 16.09 MB Application: afterRenderModule mod_articles_news (Testimonials)
Time: 0.09 ms / 380.83 ms Memory: -0.001 MB / 16.08 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 3.50 ms / 384.34 ms Memory: 0.050 MB / 16.13 MB Application: afterRenderRawModule mod_breadcrumbs (Breadcrumbs)
Time: 0.01 ms / 384.35 ms Memory: -0.003 MB / 16.13 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.02 ms / 385.37 ms Memory: 0.003 MB / 16.13 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.12 ms / 385.49 ms Memory: 0.009 MB / 16.14 MB Application: beforeRenderModule mod_ariimageslider (ARI Image Slider)
Time: 12.76 ms / 398.25 ms Memory: 0.350 MB / 16.49 MB Application: afterRenderRawModule mod_ariimageslider (ARI Image Slider)
Time: 0.02 ms / 398.27 ms Memory: -0.012 MB / 16.48 MB Application: beforeRenderModule mod_ariimageslider (ARI Image Slider)
Time: 1.07 ms / 399.34 ms Memory: 0.003 MB / 16.48 MB Application: afterRenderModule mod_ariimageslider (ARI Image Slider)
Time: 0.12 ms / 399.46 ms Memory: -0.003 MB / 16.48 MB Application: beforeRenderModule mod_rokajaxsearch (RokAjaxSearch)
Time: 12.18 ms / 411.64 ms Memory: 0.069 MB / 16.55 MB Application: afterRenderRawModule mod_rokajaxsearch (RokAjaxSearch)
Time: 0.01 ms / 411.66 ms Memory: -0.002 MB / 16.55 MB Application: beforeRenderModule mod_rokajaxsearch (RokAjaxSearch)
Time: 1.01 ms / 412.67 ms Memory: 0.002 MB / 16.55 MB Application: afterRenderModule mod_rokajaxsearch (RokAjaxSearch)
Time: 0.08 ms / 412.75 ms Memory: -0.003 MB / 16.55 MB Application: beforeRenderModule mod_custom (Contact Banner)
Time: 1.63 ms / 414.37 ms Memory: 0.021 MB / 16.57 MB Application: afterRenderRawModule mod_custom (Contact Banner)
Time: 0.01 ms / 414.39 ms Memory: -0.000 MB / 16.57 MB Application: beforeRenderModule mod_custom (Contact Banner)
Time: 0.99 ms / 415.38 ms Memory: 0.002 MB / 16.57 MB Application: afterRenderModule mod_custom (Contact Banner)
Time: 60.38 ms / 475.76 ms Memory: 0.978 MB / 17.55 MB Application: afterRender

Database queries total: 21.54 ms
Memory Usage
17.71 MB (18,569,336 Bytes)
Database Queries
37 Queries Logged 21.54 ms

2 duplicate found!
2 duplicates: #27 #31
Query Time: 0.21 ms Query memory: 0.013 MB Memory before query: 3.708 MB Rows returned: 0
SELECT `data`
  FROM `eg6dl_session`
  WHERE `session_id` = X'3938646566326331396131626432353835616339356230383238626361363865'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_session const PRIMARY PRIMARY 194 const 1
Profile
Error
MySql have_profiling = off
Call Stack
# Caller File and line number
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45
14 JSessionStorageDatabase->read() Same as call in the line below.
13 session_start() JROOT/libraries/joomla/session/handler/native.php:260
12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50
11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88
10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661
9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621
8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499
7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456
6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826
5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136
4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66
3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.11 ms After last query: 2.81 ms Query memory: 0.008 MB Memory before query: 3.841 MB Rows returned: 0
SELECT `session_id`
  FROM `eg6dl_session`
  WHERE `session_id` = X'3938646566326331396131626432353835616339356230383238626361363865'
  LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_session const PRIMARY PRIMARY 194 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74
7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154
6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828
5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136
4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66
3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.11 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 3.851 MB
INSERT INTO `eg6dl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
  VALUES (X'3938646566326331396131626432353835616339356230383238626361363865', 1, 1701792516, 0, '', 0)
Explain
EXPLAIN not possible on query: INSERT INTO `eg6dl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3938646566326331396131626432353835616339356230383238626361363865', 1, 1701792516, 0, '', 0)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116
7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154
6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828
5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136
4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66
3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.45 ms After last query: 4.27 ms Query memory: 0.017 MB Memory before query: 4.089 MB Rows returned: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `eg6dl_extensions`
  WHERE `type` = 'component'
  AND `state` = 0
  AND `enabled` = 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_extensions ref extension extension 62 const 31 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445
10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below.
9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453
7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519
6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44
5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103
4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.09 ms After last query: 4.13 ms Query memory: 0.009 MB Memory before query: 4.327 MB Rows returned: 4
SELECT id, rules
  FROM `eg6dl_viewlevels`
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063
8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458
7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318
6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87
5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129
4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.20 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 4.342 MB Rows returned: 2
SELECT b.id
  FROM eg6dl_usergroups AS a
  LEFT JOIN eg6dl_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 9
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550
10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980
9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095
8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458
7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318
6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87
5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129
4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.84 ms After last query: 0.83 ms Query memory: 0.012 MB Memory before query: 4.419 MB Rows returned: 103
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
  FROM eg6dl_extensions
  WHERE enabled = 1
  AND type = 'plugin'
  AND state IN (0,1)
  AND access IN (1,1,5)
  ORDER BY ordering
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_extensions ref extension extension 62 const 142 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351
9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below.
8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356
6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87
5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129
4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.44 ms After last query: 60.58 ms Query memory: 0.023 MB Memory before query: 7.305 MB Rows returned: 77
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 eg6dl_menu AS m
  LEFT JOIN eg6dl_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 Extra
1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 2 Using where; Using filesort
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 energrow_ca_2.m.component_id 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93
17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() 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/Menu/SiteMenu.php:101
14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78
13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62
12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142
11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417
10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275
9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65
8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189
7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533
6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403
5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.51 ms After last query: 25.72 ms Query memory: 0.011 MB Memory before query: 8.124 MB Rows returned: 8
SELECT id, home, template, s.params
  FROM eg6dl_template_styles as s
  LEFT JOIN eg6dl_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 Extra
1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 7
1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 energrow_ca_2.s.template,const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486
11 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:348
10 T3::detect() JROOT/plugins/system/t3/t3.php:81
9 plgSystemT3->onAfterRoute() Same as call in the line below.
8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.50 ms After last query: 6.93 ms Query memory: 0.016 MB Memory before query: 8.365 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `eg6dl_extensions`
  WHERE `type` = 'library'
  AND `element` = 'joomla'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662
19 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167
18 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below.
17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175
15 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43
14 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90
13 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321
12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778
11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234
10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jbtype/jbtype.php:29
9 plgSystemJbtype->onAfterRoute() Same as call in the line below.
8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.37 ms After last query: 0.24 ms Query memory: 0.010 MB Memory before query: 8.363 MB
UPDATE `eg6dl_extensions`
  SET `params` = '{\"mediaversion\":\"f22120f5bc004cd9bdf09515b97bfbdf\"}'
  WHERE `type` = 'library'
  AND `element` = 'joomla'
Explain
EXPLAIN not possible on query: UPDATE `eg6dl_extensions` SET `params` = '{\"mediaversion\":\"f22120f5bc004cd9bdf09515b97bfbdf\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117
14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372
13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331
12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778
11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234
10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jbtype/jbtype.php:29
9 plgSystemJbtype->onAfterRoute() Same as call in the line below.
8 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.12 ms After last query: 3.47 ms Query memory: 0.009 MB Memory before query: 8.585 MB Rows returned: 1
SELECT *
  FROM eg6dl_languages
  WHERE published=1
  ORDER BY ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_languages system NULL NO INDEX KEY COULD BE USED NULL NULL 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150
5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330
4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.81 ms After last query: 12.22 ms Query memory: 0.018 MB Memory before query: 9.229 MB Rows returned: 42
SELECT `id`,`name`,`rules`,`parent_id`
  FROM `eg6dl_assets`
  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mymaplocations','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_spupgrade','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 Extra
1 SIMPLE eg6dl_assets range idx_asset_name idx_asset_name 152 NULL 43 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429
19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213
18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531
17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183
16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398
15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/articles.php:115
14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:45
13 ContentModelFeatured->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/featured/view.html.php:55
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.79 ms After last query: 3.39 ms Query memory: 0.022 MB Memory before query: 9.375 MB Rows returned: 6
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,fp.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 eg6dl_content AS a
  INNER JOIN eg6dl_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eg6dl_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eg6dl_content_rating AS v
  ON a.id = v.content_id
  WHERE a.access IN (1,1,5)
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND a.state = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 16:08:37')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 16:08:37')
  ORDER BY a.featured DESC, fp.ordering,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
  LIMIT 7
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 0 const row not found
1 SIMPLE fp ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 7 Using temporary; Using filesort
1 SIMPLE a eq_ref PRIMARY,idx_access,idx_state,idx_catid PRIMARY 4 energrow_ca_2.fp.content_id 1 Using where
1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 energrow_ca_2.a.catid 1 Using where
1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.created_by 1
1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.modified_by 1
1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 energrow_ca_2.c.parent_id 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:322
15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576
13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:126
12 ContentModelFeatured->getItems() JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.24 ms After last query: 4.13 ms Query memory: 0.013 MB Memory before query: 9.709 MB Rows returned: 1
SELECT COUNT(*)
  FROM eg6dl_content AS a
  INNER JOIN eg6dl_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eg6dl_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eg6dl_content_rating AS v
  ON a.id = v.content_id
  WHERE a.access IN (1,1,5)
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND a.state = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 16:08:37')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 16:08:37')
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 0 const row not found
1 SIMPLE fp index PRIMARY PRIMARY 4 NULL 7 Using index
1 SIMPLE a eq_ref PRIMARY,idx_access,idx_state,idx_catid PRIMARY 4 energrow_ca_2.fp.content_id 1 Using where
1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 energrow_ca_2.a.catid 1 Using where
1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.created_by 1 Using index
1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.modified_by 1 Using index
1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 energrow_ca_2.c.parent_id 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289
13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239
12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:425
11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/featured/view.html.php:57
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.75 ms After last query: 11.94 ms Query memory: 0.022 MB Memory before query: 10.306 MB Rows returned: 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 `eg6dl_categories` AS `s`
  INNER JOIN `eg6dl_categories` AS `c`
  ON (s.lft <= c.lft
  AND c.lft < s.rgt) OR (c.lft < s.lft
  AND s.rgt < c.rgt)
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND s.id = 52
  ORDER BY c.lft
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort
1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 119 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203
18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140
17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.37 ms After last query: 1.11 ms Query memory: 0.020 MB Memory before query: 10.379 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
  LEFT JOIN `eg6dl_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 (52,0,116,212))
  AND a.access IN (1,1,5)
  AND (a.group_id = 0 OR g.access IN (1,1,5))
  AND a.state = 1
  AND (a.group_id = 0 OR g.state = 1)
  ORDER BY a.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333
17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.66 ms After last query: 6.26 ms Query memory: 0.022 MB Memory before query: 10.791 MB Rows returned: 3
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 `eg6dl_categories` AS `s`
  INNER JOIN `eg6dl_categories` AS `c`
  ON (s.lft <= c.lft
  AND c.lft < s.rgt) OR (c.lft < s.lft
  AND s.rgt < c.rgt)
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND s.id = 67
  ORDER BY c.lft
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1
1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 20 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203
18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140
17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.20 ms After last query: 0.35 ms Query memory: 0.020 MB Memory before query: 10.808 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
  LEFT JOIN `eg6dl_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 (67,0,119))
  AND a.access IN (1,1,5)
  AND (a.group_id = 0 OR g.access IN (1,1,5))
  AND a.state = 1
  AND (a.group_id = 0 OR g.state = 1)
  ORDER BY a.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333
17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.69 ms After last query: 1.85 ms Query memory: 0.021 MB Memory before query: 10.833 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 `eg6dl_categories` AS `s`
  INNER JOIN `eg6dl_categories` AS `c`
  ON (s.lft <= c.lft
  AND c.lft < s.rgt) OR (c.lft < s.lft
  AND s.rgt < c.rgt)
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND s.id = 215
  ORDER BY c.lft
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort
1 SIMPLE c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 119 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203
18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140
17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.20 ms After last query: 0.28 ms Query memory: 0.020 MB Memory before query: 10.846 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
  LEFT JOIN `eg6dl_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 (215,0))
  AND a.access IN (1,1,5)
  AND (a.group_id = 0 OR g.access IN (1,1,5))
  AND a.state = 1
  AND (a.group_id = 0 OR g.state = 1)
  ORDER BY a.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333
17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.63 ms After last query: 2.51 ms Query memory: 0.022 MB Memory before query: 10.873 MB Rows returned: 3
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 `eg6dl_categories` AS `s`
  INNER JOIN `eg6dl_categories` AS `c`
  ON (s.lft <= c.lft
  AND c.lft < s.rgt) OR (c.lft < s.lft
  AND s.rgt < c.rgt)
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND s.id = 222
  ORDER BY c.lft
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1
1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 21 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203
18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140
17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.19 ms After last query: 0.30 ms Query memory: 0.020 MB Memory before query: 10.885 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
  LEFT JOIN `eg6dl_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 (222,0,119))
  AND a.access IN (1,1,5)
  AND (a.group_id = 0 OR g.access IN (1,1,5))
  AND a.state = 1
  AND (a.group_id = 0 OR g.state = 1)
  ORDER BY a.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333
17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
14 PlgSystemFields->onContentPrepare() Same as call in the line below.
13 call_user_func_array() 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/featured/view.html.php:102
10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.50 ms After last query: 46.10 ms Query memory: 0.016 MB Memory before query: 12.117 MB Rows returned: 30
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM eg6dl_modules AS m
  LEFT JOIN eg6dl_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN eg6dl_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-12-05 16:08:37')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-05 16:08:37')
  AND m.access IN (1,1,5)
  AND m.client_id = 0
  AND (mm.menuid = 316 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 54 Using where; Using filesort
1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 energrow_ca_2.m.module,const 1 Using where
1 SIMPLE mm ref PRIMARY PRIMARY 4 energrow_ca_2.m.id 5 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:441
14 Joomla\CMS\Helper\_ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:371
13 Joomla\CMS\Helper\_ModuleHelper::load() JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:87
12 Joomla\CMS\Helper\_ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601
11 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:686
10 T3Template->checkSpotlight() JROOT/templates/flux/tpls/sidebar-right.php:23
9 include JROOT/templates/flux/tpls/sidebar-right.php JROOT/plugins/system/t3/includes/core/template.php:226
8 T3Template->loadLayout() JROOT/templates/flux/index.php:34
7 require JROOT/templates/flux/index.php JROOT/libraries/src/Document/HtmlDocument.php:678
6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740
5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555
4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.83 ms After last query: 29.75 ms Query memory: 0.018 MB Memory before query: 12.666 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 `eg6dl_categories` AS `s`
  INNER JOIN `eg6dl_categories` AS `c`
  ON (s.lft <= c.lft
  AND c.lft < s.rgt) OR (c.lft < s.lft
  AND s.rgt < c.rgt)
  WHERE (c.extension='com_dpcalendar' OR c.extension='system')
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND s.id = 221
  ORDER BY c.lft
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 157 NULL 4 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
13 DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:68
12 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.51 ms After last query: 0.31 ms Query memory: 0.017 MB Memory before query: 12.690 MB Rows returned: 5
SELECT `id`,`name`,`rules`,`parent_id`
  FROM `eg6dl_assets`
  WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_assets ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 586 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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/administrator/components/com_dpcalendar/helpers/dpcalendar.php:56
13 DPCalendarHelper::getCalendar() JROOT/components/com_dpcalendar/models/calendar.php:68
12 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.39 ms After last query: 1.66 ms Query memory: 0.019 MB Memory before query: 12.792 MB Rows returned: 0
Duplicate queries: #31
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
  FROM `eg6dl_dpcalendar_caldav_calendars` c
  LEFT
  OUTER JOIN eg6dl_dpcalendar_caldav_principals mainp
  on mainp.uri = c.principaluri
  LEFT
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
  from eg6dl_dpcalendar_caldav_principals memberp
  inner join eg6dl_dpcalendar_caldav_groupmembers m
  on memberp.id = m.member_id
  inner join eg6dl_dpcalendar_caldav_principals linkp
  on m.principal_id = linkp.id) as mp
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
  ORDER BY c.displayname ASC
  LIMIT 20
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
2 DERIVED NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL no matching row in const table
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/profile.php:38
18 DPCalendarModelProfile->getItems() JROOT/plugins/system/dpcalendar/dpcalendar.php:237
17 PlgSystemDpcalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:470
16 DPCalendarPlugin->onCalendarsFetch() Same as call in the line below.
15 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
13 JEventDispatcher->trigger() JROOT/components/com_dpcalendar/models/calendar.php:102
12 DPCalendarModelCalendar->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.12 ms After last query: 1.98 ms Query memory: 0.019 MB Memory before query: 12.916 MB Rows returned: 50
SHOW FULL COLUMNS
  FROM `eg6dl_dpcalendar_events`
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `eg6dl_dpcalendar_events`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448
18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261
17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180
16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_dpcalendar/tables/event.php:19
15 DPCalendarTableEvent->__construct() JROOT/components/com_dpcalendar/models/events.php:577
14 DPCalendarModelEvents->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/events.php:138
12 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:72
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.98 ms After last query: 1.98 ms Query memory: 0.022 MB Memory before query: 13.010 MB Rows returned: 0
SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
  FROM `eg6dl_dpcalendar_events` AS a
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_dpcalendar_events_location AS rel
  ON a.id = rel.event_id
  LEFT JOIN eg6dl_dpcalendar_locations AS v
  ON rel.location_id = v.id
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
  WHERE a.access IN (1,1,5)
  AND a.original_id > -1
  AND a.catid IN ('221')
  AND (c.access IN (1,1,5) or c.access is null)
  AND a.state = 1
  AND a.state != -2
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 16:08:37')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 16:08:37')
  AND (a.start_date >= '2023-12-05 16:00:00' or '2023-12-05 16:08:37' between a.start_date
  and a.end_date or (a.start_date='2023-12-05'
  and all_day=1) or (a.end_date='2023-12-05'
  and all_day=1))
  AND a.language in ('en-GB','*')
  GROUP BY a.id
  ORDER BY a.start_date asc
  LIMIT 13
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ref idx_access,idx_start_date,idx_end_date,idx_state,idx_catid,idx_language idx_state 1 const 73 Using where; Using temporary; Using filesort
1 SIMPLE c eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.catid 1 Using where
1 SIMPLE rel ref PRIMARY PRIMARY 4 energrow_ca_2.a.id 1 Using index
1 SIMPLE v eq_ref PRIMARY PRIMARY 4 energrow_ca_2.rel.location_id 1 Using index
1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.created_by 1
1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.modified_by 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
15 JDatabaseDriver->loadObjectList() JROOT/components/com_dpcalendar/models/events.php:580
14 DPCalendarModelEvents->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/events.php:138
12 DPCalendarModelEvents->getItems() JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:72
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.27 ms After last query: 1.43 ms Query memory: 0.014 MB Memory before query: 13.056 MB Rows returned: 1
SELECT c.id AS id, a.name AS asset_name
  FROM ( SELECT id,asset_id
  FROM eg6dl_categories
  WHERE extension = 'com_dpcalendar'
  AND published = 1) AS c
  INNER JOIN eg6dl_assets AS a
  ON c.asset_id = a.id
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY <derived2> system NULL NO INDEX KEY COULD BE USED NULL NULL 1
1 PRIMARY a const PRIMARY PRIMARY 4 const 1
2 DERIVED eg6dl_categories ref cat_idx cat_idx 153 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/User/User.php:428
15 Joomla\CMS\User\User->getAuthorisedCategories() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:917
14 DPCalendarHelper::canCreateEvent() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:522
13 DPCalendarHelper::renderEvents() JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php:55
12 require JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:74
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.27 ms After last query: 35.20 ms Query memory: 0.021 MB Memory before query: 15.508 MB Rows returned: 0
Duplicate queries: #27
SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
  FROM `eg6dl_dpcalendar_caldav_calendars` c
  LEFT
  OUTER JOIN eg6dl_dpcalendar_caldav_principals mainp
  on mainp.uri = c.principaluri
  LEFT
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
  from eg6dl_dpcalendar_caldav_principals memberp
  inner join eg6dl_dpcalendar_caldav_groupmembers m
  on memberp.id = m.member_id
  inner join eg6dl_dpcalendar_caldav_principals linkp
  on m.principal_id = linkp.id) as mp
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)
  ORDER BY c.displayname ASC
  LIMIT 20
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
2 DERIVED NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL no matching row in const table
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_dpcalendar/models/profile.php:38
20 DPCalendarModelProfile->getItems() JROOT/plugins/system/dpcalendar/dpcalendar.php:237
19 PlgSystemDpcalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:470
18 DPCalendarPlugin->onCalendarsFetch() Same as call in the line below.
17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
15 JEventDispatcher->trigger() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:922
14 DPCalendarHelper::canCreateEvent() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:522
13 DPCalendarHelper::renderEvents() JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php:55
12 require JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:74
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.19 ms After last query: 1.10 ms Query memory: 0.021 MB Memory before query: 15.551 MB Rows returned: 1
SELECT *
  FROM eg6dl_gcalendar
  WHERE access IN (1,1,5)
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_gcalendar system NULL NO INDEX KEY COULD BE USED NULL NULL 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
23 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_gcalendar/models/gcalendars.php:31
22 GCalendarModelGCalendars->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gcalendar/dbutil.php:47
20 GCalendarDBUtil::getAllCalendars() JROOT/plugins/dpcalendar/dpcalendar_gcalendar/dpcalendar_gcalendar.php:94
19 PlgDPCalendarDPCalendar_GCalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:470
18 DPCalendarPlugin->onCalendarsFetch() Same as call in the line below.
17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
15 JEventDispatcher->trigger() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:922
14 DPCalendarHelper::canCreateEvent() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:522
13 DPCalendarHelper::renderEvents() JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php:55
12 require JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:74
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.54 ms After last query: 1.15 ms Query memory: 0.024 MB Memory before query: 15.594 MB Rows returned: 9
SHOW FULL COLUMNS
  FROM `eg6dl_gcalendar`
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `eg6dl_gcalendar`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
28 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448
27 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261
26 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180
25 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_gcalendar/tables/gcalendar.php:31
24 GCalendarTableGCalendar->__construct() JROOT/libraries/src/Table/Table.php:328
23 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_gcalendar/models/gcalendars.php:37
22 GCalendarModelGCalendars->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gcalendar/dbutil.php:47
20 GCalendarDBUtil::getAllCalendars() JROOT/plugins/dpcalendar/dpcalendar_gcalendar/dpcalendar_gcalendar.php:94
19 PlgDPCalendarDPCalendar_GCalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:470
18 DPCalendarPlugin->onCalendarsFetch() Same as call in the line below.
17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
15 JEventDispatcher->trigger() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:922
14 DPCalendarHelper::canCreateEvent() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:522
13 DPCalendarHelper::renderEvents() JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php:55
12 require JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:74
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.08 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 15.629 MB Rows returned: 1
SELECT *
  FROM eg6dl_gcalendar
  WHERE `id` = '2'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE eg6dl_gcalendar system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465
25 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747
24 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_gcalendar/tables/gcalendar.php:49
23 GCalendarTableGCalendar->load() JROOT/administrator/components/com_gcalendar/models/gcalendars.php:38
22 GCalendarModelGCalendars->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gcalendar/dbutil.php:47
20 GCalendarDBUtil::getAllCalendars() JROOT/plugins/dpcalendar/dpcalendar_gcalendar/dpcalendar_gcalendar.php:94
19 PlgDPCalendarDPCalendar_GCalendar->fetchCalendars() JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:470
18 DPCalendarPlugin->onCalendarsFetch() Same as call in the line below.
17 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
15 JEventDispatcher->trigger() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:922
14 DPCalendarHelper::canCreateEvent() JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:522
13 DPCalendarHelper::renderEvents() JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php:55
12 require JROOT/templates/flux/html/mod_dpcalendar_upcoming/default.php JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:74
11 include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.89 ms After last query: 13.29 ms Query memory: 0.021 MB Memory before query: 16.066 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,fp.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 eg6dl_content AS a
  LEFT JOIN eg6dl_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eg6dl_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eg6dl_content_rating AS v
  ON a.id = v.content_id
  WHERE a.access IN (1,1,5)
  AND c.access IN (1,1,5)
  AND c.published = 1
  AND a.state = 1
  AND a.catid IN (67)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 16:08:37')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 16:08:37')
  ORDER BY RAND() ASC
  LIMIT 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v system PRIMARY NO INDEX KEY COULD BE USED NULL NULL 0 const row not found
1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 Using temporary; Using filesort
1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 11 Using intersect(idx_catid,idx_state); Using where
1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.created_by 1
1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.modified_by 1
1 SIMPLE fp eq_ref PRIMARY PRIMARY 4 energrow_ca_2.a.id 1
1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:322
15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576
13 ContentModelArticles->getItems() JROOT/modules/mod_articles_news/helper.php:100
12 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15
11 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.19 ms After last query: 1.35 ms Query memory: 0.024 MB Memory before query: 16.110 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
  WHERE a.context = 'mod_articles_news.content'
  AND a.access IN (1,1,5)
  AND (a.group_id = 0 OR g.access IN (1,1,5))
  AND a.state = 1
  AND (a.group_id = 0 OR g.state = 1)
  ORDER BY a.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
24 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333
23 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
22 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
21 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
20 PlgSystemFields->onContentPrepare() Same as call in the line below.
19 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
18 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
17 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41
16 JHtmlContent::prepare() Same as call in the line below.
15 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239
14 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146
13 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_articles_news/helper.php:123
12 ModArticlesNewsHelper::getList() JROOT/modules/mod_articles_news/mod_articles_news.php:15
11 include JROOT/modules/mod_articles_news/mod_articles_news.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.30 ms After last query: 36.20 ms Query memory: 0.023 MB Memory before query: 16.573 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
  WHERE a.context = 'mod_custom.content'
  AND a.access IN (1,1,5)
  AND (a.group_id = 0 OR g.access IN (1,1,5))
  AND a.state = 1
  AND (a.group_id = 0 OR g.state = 1)
  ORDER BY a.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
# Caller File and line number
25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
23 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333
22 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
20 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
19 PlgSystemFields->onContentPrepare() Same as call in the line below.
18 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
16 JEventDispatcher->trigger() JROOT/libraries/cms/html/content.php:41
15 JHtmlContent::prepare() Same as call in the line below.
14 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239
13 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111
12 Joomla\CMS\HTML\HTMLHelper::_() JROOT/modules/mod_custom/mod_custom.php:15
11 include JROOT/modules/mod_custom/mod_custom.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
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:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
25 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × 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 `eg6dl_categories` AS `s`
  INNER JOIN `eg6dl_categories` AS `c`
  ON (s.lft <= c.lft
  AND c.lft < s.rgt) OR (c.lft < s.lft
  AND s.rgt < c.rgt)
4 × 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
  LEFT JOIN `eg6dl_fields_categories` AS fc
  ON fc.field_id = a.id
2 × SELECT `id`,`name`,`rules`,`parent_id`
  FROM `eg6dl_assets`
2 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access
  FROM `eg6dl_dpcalendar_caldav_calendars` c
  LEFT
  OUTER JOIN eg6dl_dpcalendar_caldav_principals mainp
  on mainp.uri = c.principaluri
  LEFT
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri
  from eg6dl_dpcalendar_caldav_principals memberp
  inner join eg6dl_dpcalendar_caldav_groupmembers m
  on memberp.id = m.member_id
  inner join eg6dl_dpcalendar_caldav_principals linkp
  on m.principal_id = linkp.id) as mp
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')
2 × 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 eg6dl_fields AS a
  LEFT JOIN `eg6dl_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN eg6dl_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN eg6dl_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN eg6dl_fields_groups AS g
  ON g.id = a.group_id
2 × SELECT *
  FROM eg6dl_gcalendar
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `eg6dl_extensions`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM eg6dl_modules AS m
  LEFT JOIN eg6dl_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN eg6dl_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
1 × SELECT c.id AS id, a.name AS asset_name
  FROM ( SELECT id,asset_id
  FROM eg6dl_categories
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,fp.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 eg6dl_content AS a
  LEFT JOIN eg6dl_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eg6dl_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eg6dl_content_rating AS v
  ON a.id = v.content_id
1 × SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author
  FROM `eg6dl_dpcalendar_events` AS a
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_dpcalendar_events_location AS rel
  ON a.id = rel.event_id
  LEFT JOIN eg6dl_dpcalendar_locations AS v
  ON rel.location_id = v.id
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
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,fp.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 eg6dl_content AS a
  INNER JOIN eg6dl_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eg6dl_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eg6dl_content_rating AS v
  ON a.id = v.content_id
1 × SELECT b.id
  FROM eg6dl_usergroups AS a
  LEFT JOIN eg6dl_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
1 × SELECT id, rules
  FROM `eg6dl_viewlevels
1 × SELECT `session_id`
  FROM `eg6dl_session`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
  FROM eg6dl_extensions
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 eg6dl_menu AS m
  LEFT JOIN eg6dl_extensions AS e
  ON m.component_id = e.extension_id
1 × SELECT `data`
  FROM `eg6dl_session`
1 × SELECT *
  FROM eg6dl_languages
1 × SELECT id, home, template, s.params
  FROM eg6dl_template_styles as s
  LEFT JOIN eg6dl_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
1 × SELECT COUNT(*)
  FROM eg6dl_content AS a
  INNER JOIN eg6dl_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN eg6dl_categories AS c
  ON c.id = a.catid
  LEFT JOIN eg6dl_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eg6dl_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN eg6dl_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eg6dl_content_rating AS v
  ON a.id = v.content_id
OTHER Tables:
1 × SHOW FULL COLUMNS
  FROM `eg6dl_gcalendar
1 × SHOW FULL COLUMNS
  FROM `eg6dl_dpcalendar_events
1 × UPDATE `eg6dl_extensions`
  SET `params` = '{\"mediaversion\":\"f22120f5bc004cd9bdf09515b97bfbdf\"}'
1 × INSERT INTO `eg6dl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
  VALUES (X'3938646566326331396131626432353835616339356230383238626361363865', 1, 1701792516, 0, '', 0