rd+d - Mediterranean

Mediterranean

The Hummus & Pita Co. Expands Southeast Footprint

Mediterranean fast-casual The Hummus & Pita Co.signed a multi-unit deal to expand in the Southeast. Franchisees Jay Gill and Patrick Sidhu will bring five
...
Garbanzo Mediterranean Fresh Signs Multi-Unit Deal in Boston

Garbanzo Mediterranean Fresh signed a franchise deal to bring five new restaurants to Boston.
SAJJ Mediterranean Expands in California

SAJJ Mediterranean, the family of Bay Area-based restaurants and food trucks known for customizable Middle
...
Mediterranean Fast-Casual Plans Aggressive Expansion

San Francisco-based SAJJ Mediterranean, a fast-casual specializing in customizable Middle Eastern cuisine, has aggressive
...
Zoës Kitchen's New Prototype Stresses Mediterranean Roots

Based in Plano, Texas, Zoës Kitchen is a fast-casual Mediterranean concept with about 250 locations across the country. The chain
...
Ousia Debuts in Midtown West

Ousia, a Greek-focused Mediterranean restaurant, opened in Manhattan in January. The 7,000-square-foot
...
Cannon + Belle Brings Modern Twist to Texas Staples

Hilton Austin opened Cannon + Belle as part
...
Roti Focuses on the Casual in Fast-Casual

The fast-casual segment has thrived in recent years by offering food that rivals sit-down establishments in combination with the speed and convenience of a quick-serve
...
The Simple Greek Opens New Unit with New Partner Marcus "The Prophet" Lemonis

The Simple Greek, a fast-casual Greek and Mediterranean restaurant chain, has opened a new unit in Highland Park, Ill.,
...
Luna Grill Heads to Texas

Luna Grill, the San Diego-based Mediterranean fast-casual chain, is accelerating its expansion and has selected Texas to host the
...
Project Profile: Carmel Café and Wine Bar

New casual dining chain brings the art of modern Mediterranean cuisine and ambiance to life.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1601009713,
                "last": 1601009713,
                "now": 1601009713
            },
            "token": "pZHnQWQVffDtPUWvltMSp4FJM7lHCcNF"
        },
        "registry": {
            "com_ampz": {
                "shortcodes": {
                    "ordercol": null
                }
            }
        },
        "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
        }
    },
    "__sige": {
        "sigcount": null,
        "sigcountarticles": null
    }
}

Profile Information

Time

Memory

Time: 18.32 ms / 18.32 ms Memory: 1.774 MB / 2.14 MB Application: afterLoad

Time: 73.97 ms / 92.29 ms Memory: 6.575 MB / 8.72 MB Application: afterInitialise

Time: 38.55 ms / 130.84 ms Memory: 3.115 MB / 11.83 MB Application: afterRoute

Time: 0.60 ms / 131.44 ms Memory: 0.016 MB / 11.85 MB Application: beforeRenderComponent com_tags

Time: 45.89 ms / 177.33 ms Memory: 3.435 MB / 15.28 MB Application: Before Access::preloadComponents (all components)

Time: 0.97 ms / 178.29 ms Memory: 0.060 MB / 15.34 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 178.32 ms Memory: 0.000 MB / 15.34 MB Application: Before Access::getAssetRules (id:35 name:com_tags)

Time: 0.45 ms / 178.78 ms Memory: 0.027 MB / 15.37 MB Application: After Access::getAssetRules (id:35 name:com_tags)

Time: 3.11 ms / 181.89 ms Memory: 0.056 MB / 15.42 MB Application: afterRenderComponent com_tags

Time: 1.76 ms / 183.65 ms Memory: 0.164 MB / 15.59 MB Application: afterDispatch

Time: 44.39 ms / 228.04 ms Memory: 3.923 MB / 19.51 MB Application: beforeRenderModule mod_custom (Ad - Leaderboard Ad)

Time: 0.78 ms / 228.82 ms Memory: 0.030 MB / 19.54 MB Application: afterRenderModule mod_custom (Ad - Leaderboard Ad)

Time: 0.42 ms / 229.24 ms Memory: 0.000 MB / 19.54 MB Application: beforeRenderModule mod_custom (Ad - Full Banner)

Time: 0.23 ms / 229.47 ms Memory: 0.003 MB / 19.54 MB Application: afterRenderModule mod_custom (Ad - Full Banner)

Time: 0.22 ms / 229.69 ms Memory: 0.001 MB / 19.54 MB Application: beforeRenderModule mod_custom (Subscribe for FREE!)

Time: 0.23 ms / 229.92 ms Memory: 0.003 MB / 19.54 MB Application: afterRenderModule mod_custom (Subscribe for FREE!)

Time: 0.22 ms / 230.14 ms Memory: 0.000 MB / 19.54 MB Application: beforeRenderModule mod_custom (Ad - Rectangle Ad 1)

Time: 0.22 ms / 230.36 ms Memory: 0.004 MB / 19.55 MB Application: afterRenderModule mod_custom (Ad - Rectangle Ad 1)

Time: 0.24 ms / 230.59 ms Memory: 0.001 MB / 19.55 MB Application: beforeRenderModule mod_articles_popular (Most Popular Articles)

Time: 0.67 ms / 231.27 ms Memory: 0.051 MB / 19.60 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.05 ms / 231.32 ms Memory: 0.008 MB / 19.61 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 14.49 ms / 245.81 ms Memory: 0.198 MB / 19.81 MB Application: afterRenderModule mod_articles_popular (Most Popular Articles)

Time: 0.33 ms / 246.13 ms Memory: 0.000 MB / 19.74 MB Application: beforeRenderModule mod_custom (Ad - Rectangle Ad 2)

Time: 0.24 ms / 246.37 ms Memory: 0.003 MB / 19.75 MB Application: afterRenderModule mod_custom (Ad - Rectangle Ad 2)

Time: 0.23 ms / 246.60 ms Memory: 0.001 MB / 19.75 MB Application: beforeRenderModule mod_tags_popular (Popular Topics)

Time: 4.05 ms / 250.65 ms Memory: 0.102 MB / 19.85 MB Application: afterRenderModule mod_tags_popular (Popular Topics)

Time: 0.28 ms / 250.93 ms Memory: 0.000 MB / 19.84 MB Application: beforeRenderModule mod_custom (Ad - Rectangle Ad 3)

Time: 0.23 ms / 251.17 ms Memory: 0.003 MB / 19.84 MB Application: afterRenderModule mod_custom (Ad - Rectangle Ad 3)

Time: 0.24 ms / 251.41 ms Memory: 0.000 MB / 19.84 MB Application: beforeRenderModule mod_custom (rd+d's Digital Edition)

Time: 0.22 ms / 251.63 ms Memory: 0.003 MB / 19.84 MB Application: afterRenderModule mod_custom (rd+d's Digital Edition)

Time: 0.45 ms / 252.07 ms Memory: 0.005 MB / 19.85 MB Application: beforeRenderModule mod_menu (Site Links)

Time: 2.07 ms / 254.14 ms Memory: 0.068 MB / 19.91 MB Application: afterRenderModule mod_menu (Site Links)

Time: 0.26 ms / 254.41 ms Memory: 0.000 MB / 19.91 MB Application: beforeRenderModule mod_menu (Resources)

Time: 1.41 ms / 255.82 ms Memory: 0.038 MB / 19.95 MB Application: afterRenderModule mod_menu (Resources)

Time: 0.24 ms / 256.06 ms Memory: 0.000 MB / 19.95 MB Application: beforeRenderModule mod_menu (Events)

Time: 1.18 ms / 257.24 ms Memory: 0.012 MB / 19.96 MB Application: afterRenderModule mod_menu (Events)

Time: 0.24 ms / 257.47 ms Memory: 0.000 MB / 19.96 MB Application: beforeRenderModule mod_menu (Newsletters)

Time: 1.15 ms / 258.63 ms Memory: 0.022 MB / 19.98 MB Application: afterRenderModule mod_menu (Newsletters)

Time: 0.26 ms / 258.88 ms Memory: 0.000 MB / 19.98 MB Application: beforeRenderModule mod_menu (Related Sites)

Time: 0.82 ms / 259.70 ms Memory: 0.010 MB / 19.99 MB Application: afterRenderModule mod_menu (Related Sites)

Time: 0.26 ms / 259.96 ms Memory: 0.000 MB / 19.99 MB Application: beforeRenderModule mod_menu (Follow rd+d magazine)

Time: 1.11 ms / 261.07 ms Memory: 0.013 MB / 20.00 MB Application: afterRenderModule mod_menu (Follow rd+d magazine)

Time: 1.04 ms / 262.12 ms Memory: 0.030 MB / 20.03 MB Application: beforeRenderModule mod_menu (Privacy/Terms)

Time: 1.02 ms / 263.13 ms Memory: 0.019 MB / 20.05 MB Application: afterRenderModule mod_menu (Privacy/Terms)

Time: 32.22 ms / 295.35 ms Memory: 1.588 MB / 21.64 MB Application: afterRender

Database queries total: 35.25 ms

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

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

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

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

EXPLAIN not possible on query: INSERT INTO `rdd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6339613133343330383265396138353039646262303236346236346330633861', 1, 1601009713, 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.09 ms
end	0.01 ms
query end	0.99 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.46 ms After last query: 2.66 ms Query memory: 0.024 MB Memory before query: 4.242 MB Rows returned: 38

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

  FROM `rdd_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.22 ms After last query: 2.30 ms Query memory: 0.021 MB Memory before query: 4.433 MB Rows returned: 5

SELECT id, rules

  FROM `rdd_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

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

SELECT b.id

  FROM rdd_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.79 ms After last query: 0.63 ms Query memory: 0.046 MB Memory before query: 4.514 MB Rows returned: 97

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

  FROM rdd_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.30 ms After last query: 43.96 ms Query memory: 0.023 MB Memory before query: 8.500 MB Rows returned: 30

SELECT *

  FROM rdd_rsform_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 3.99 ms Query memory: 0.112 MB Memory before query: 8.901 MB Rows returned: 69

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

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

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	74	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/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:76
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:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
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:491
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:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM `rdd_tags`

  WHERE `alias` = 'mediterranean'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rdd_tags	NULL	ref	idx_alias	idx_alias	402	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_tags/router.php:179
10	TagsRouter->fixSegment()	JROOT/components/com_tags/router.php:147
9	TagsRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.19 ms After last query: 1.71 ms Query memory: 0.022 MB Memory before query: 9.654 MB Rows returned: 0

SELECT DISTINCT a.*

  FROM `rdd_ampz` AS a 
  LIMIT 30

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_ampz/models/shortcodes.php:66
11	AmpzModelShortcodes->getItems()	JROOT/plugins/system/ampz/helper.php:50
10	PlgSystemAmpzHelper->__construct()	JROOT/plugins/system/ampz/ampz.php:943
9	plgSystemAmpz->getHelper()	JROOT/plugins/system/ampz/ampz.php:114
8	plgSystemAmpz->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.86 ms Query memory: 0.021 MB Memory before query: 9.665 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM rdd_template_styles as s

  LEFT JOIN rdd_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	2	2.50	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	rddmag_rddMag.e.element	3	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
9	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/mvcoverridecwmulticats/mvcoverridecwmulticats.php:118
8	PlgSystemMVCOverrideCWMulticats->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 17.37 ms Query memory: 0.026 MB Memory before query: 11.245 MB Rows returned: 1

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

  FROM `rdd_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
22	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
19	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
18	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
17	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163
13	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
12	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/g5_helium/includes/theme.php:28
11	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118
10	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:234
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.25 ms After last query: 0.17 ms Query memory: 0.008 MB Memory before query: 11.239 MB

UPDATE `rdd_extensions`

  SET `params` = '{\"mediaversion\":\"63bf5ad6de4126210d09844955d6cdda\"}'

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
18	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
17	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163
13	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
12	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/g5_helium/includes/theme.php:28
11	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118
10	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:234
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 4.40 ms Query memory: 0.023 MB Memory before query: 11.656 MB Rows returned: 7

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM rdd_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'g5_helium'

  ORDER BY s.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	index	idx_template,idx_client_id,idx_client_id_home	PRIMARY	4	NULL	7	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:304
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 2.35 ms Query memory: 0.019 MB Memory before query: 11.839 MB Rows returned: 1

SELECT *

  FROM rdd_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 4.60 ms Query memory: 0.043 MB Memory before query: 12.866 MB Rows returned: 13

SELECT *

  FROM `rdd_content_types`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Helper/TagsHelper.php:794
17	Joomla\CMS\Helper\TagsHelper::getTypes()	JROOT/libraries/src/Helper/TagsHelper.php:628
16	Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:149
15	TagsModelTag->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.26 ms After last query: 0.13 ms Query memory: 0.047 MB Memory before query: 12.878 MB Rows returned: 11

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM rdd_contentitem_tag_map AS m

  INNER JOIN rdd_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2020-09-25 04:55:13')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2020-09-25 04:55:13')

  INNER JOIN rdd_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN rdd_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN rdd_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (345) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email

  ORDER BY MAX(`c`.`core_publish_up`) DESC 
  LIMIT 30

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	11	50.00	Using where; Using temporary; Using filesort
1	SIMPLE	ct	NULL	ref	idx_alias	idx_alias	402	rddmag_rddMag.m.type_alias	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	rddmag_rddMag.m.core_content_id	1	5.00	Using where
1	SIMPLE	tc	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.c.core_catid	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.c.core_created_user_id	1	100.00	Using where

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.12 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.19 ms
Creating sort index	0.19 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 2.56 ms Query memory: 0.033 MB Memory before query: 13.175 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `rdd_tags`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
14	TagsTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_tags/models/tag.php:279
12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 1.30 ms Query memory: 0.023 MB Memory before query: 13.272 MB Rows returned: 1

Duplicate queries: #27

SELECT *

  FROM rdd_tags

  WHERE `id` = '345'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:288
12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.51 ms After last query: 0.96 ms Query memory: 0.046 MB Memory before query: 13.378 MB Rows returned: 11

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM rdd_contentitem_tag_map AS m

  INNER JOIN rdd_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2020-09-25 04:55:13')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2020-09-25 04:55:13')

  INNER JOIN rdd_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN rdd_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN rdd_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (345) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email

  ORDER BY MAX(`c`.`core_publish_up`) DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	11	50.00	Using where; Using temporary; Using filesort
1	SIMPLE	ct	NULL	ref	idx_alias	idx_alias	402	rddmag_rddMag.m.type_alias	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	rddmag_rddMag.m.core_content_id	1	5.00	Using where
1	SIMPLE	tc	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.c.core_catid	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.c.core_created_user_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:97
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 8.66 ms Query memory: 0.026 MB Memory before query: 14.166 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 `rdd_categories` AS `s`

  INNER JOIN `rdd_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 = 32

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.79 ms After last query: 0.51 ms Query memory: 0.025 MB Memory before query: 14.211 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 rdd_fields AS a

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

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

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

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

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

  LEFT JOIN `rdd_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 (32,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.52 ms After last query: 5.23 ms Query memory: 0.026 MB Memory before query: 14.590 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 `rdd_categories` AS `s`

  INNER JOIN `rdd_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 = 31

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.78 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 14.596 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 rdd_fields AS a

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

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

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

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

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

  LEFT JOIN `rdd_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 (31,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.34 ms After last query: 3.03 ms Query memory: 0.006 MB Memory before query: 14.633 MB

UPDATE rdd_tags

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

  WHERE `id` = '345'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_tags/models/tag.php:343
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:239
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 14.640 MB Rows returned: 1

Duplicate queries: #20

SELECT *

  FROM rdd_tags

  WHERE `id` = '345'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:346
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:239
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.71 ms After last query: 3.10 ms Query memory: 0.027 MB Memory before query: 14.917 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 rdd_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_tag.tag' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
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:187
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()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
17	JHtmlContent::prepare()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/g5_helium/html/com_tags/tag/default.php:25
13	include JROOT/templates/g5_helium/html/com_tags/tag/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 5.69 ms Query memory: 0.029 MB Memory before query: 15.289 MB Rows returned: 38

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

  FROM `rdd_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_ampz','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_multicats','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_unitegallery','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rdd_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	39	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/templates/g5_helium/html/com_tags/tag/default_items.php:22
15	include JROOT/templates/g5_helium/html/com_tags/tag/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/g5_helium/html/com_tags/tag/default.php:50
13	include JROOT/templates/g5_helium/html/com_tags/tag/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 3.75 ms Query memory: 0.021 MB Memory before query: 15.423 MB Rows returned: 12

SELECT `content`

  FROM `rdd_modules`

  WHERE `published` = 1 
  AND `client_id` = 0 
  AND `content` <> ''

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rdd_modules	NULL	ref	published	published	1	const	34	9.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ampz/helper.php:84
8	PlgSystemAmpzHelper->onAfterDispatch()	JROOT/plugins/system/ampz/ampz.php:128
7	plgSystemAmpz->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 37.89 ms Query memory: 0.035 MB Memory before query: 18.964 MB Rows returned: 8

SELECT a.menutype

  FROM rdd_menu_types AS a

  WHERE a.client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	12.50	Using where

Profile

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

Call Stack

#	Caller	File and line number
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
43	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
42	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
41	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
39	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/b8/b89f89eb83a6c3658e9fb158bf3911606ba0102da2997b473325e7b8776c6bd9.php:32
38	__TwigTemplate_abe408e5806812acde8de3b2ddae4f06b7d350277865e863347db8c8323e8a4c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/b2/b2d5f86120e9a9cde0a0a3278c2ed6eb957613ab778a41018564c9086b0bc6df.php:71
35	__TwigTemplate_b03bdd93e11c8f0a454a4c4a94f59b6567b38a90017902ebb1e0af97d9e07690->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
33	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
32	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 6.18 ms Query memory: 0.041 MB Memory before query: 19.464 MB Rows returned: 16

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

  FROM rdd_modules AS m

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

  LEFT JOIN rdd_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 <= '2020-09-25 04:55:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-25 04:55:13') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	28	1.79	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	rddmag_rddMag.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	rddmag_rddMag.m.id	1	40.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
54	JDatabaseDriver->loadObjectList()	Same as call in the line below.
53	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
52	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
51	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
50	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
49	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 11.45 ms After last query: 3.85 ms Query memory: 0.077 MB Memory before query: 19.614 MB Rows returned: 5

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,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,mc.catid AS mcatids,m.ordering AS m_ordering

  FROM rdd_content AS a

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

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

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

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

  LEFT JOIN rdd_multicats_content_catid AS mc 
  ON mc.item_id = a.id

  LEFT JOIN rdd_content_multicats AS m 
  ON (m.content_id = a.id 
  AND FIND_IN_SET(m.catid,mc.catid) )

  WHERE a.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND ( FIND_IN_SET("31",mc.catid) OR FIND_IN_SET("32",mc.catid) ) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-09-25 04:55:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-09-25 04:55:13') 
  AND a.publish_up >= DATE_ADD('2020-09-25 04:55:13', INTERVAL -30 DAY)

  GROUP BY a.id

  ORDER BY a.hits DESC 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	46	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	a	NULL	ref	PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias	idx_catid	4	rddmag_rddMag.c.id	54	5.33	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.a.modified_by	1	100.00	Using where
1	SIMPLE	mc	NULL	ref	item_id	item_id	4	rddmag_rddMag.a.id	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	rddmag_rddMag.c.parent_id	1	100.00	Using where
1	SIMPLE	m	NULL	ref	PRIMARY,content_id	PRIMARY	4	rddmag_rddMag.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	10.42 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.06 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
57	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
56	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
55	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_multicats/copy/code/com_content/models/articles.php:653
54	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
53	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
52	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.25 ms Query memory: 0.039 MB Memory before query: 19.691 MB Rows returned: 1

Duplicate queries: #35 #36 #37 #38

SELECT c.id

  FROM rdd_categories AS c

  WHERE c.id = 32 
  AND c.access IN (1,1,5)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
55	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_multicats/copy/code/com_content/models/articles.php:684
54	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
53	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
52	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.20 ms Query memory: 0.039 MB Memory before query: 19.721 MB Rows returned: 1

Duplicate queries: #34 #36 #37 #38

SELECT c.id

  FROM rdd_categories AS c

  WHERE c.id = 32 
  AND c.access IN (1,1,5)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
55	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_multicats/copy/code/com_content/models/articles.php:684
54	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
53	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
52	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.18 ms Query memory: 0.039 MB Memory before query: 19.748 MB Rows returned: 1

Duplicate queries: #34 #35 #37 #38

SELECT c.id

  FROM rdd_categories AS c

  WHERE c.id = 32 
  AND c.access IN (1,1,5)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
55	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_multicats/copy/code/com_content/models/articles.php:684
54	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
53	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
52	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.16 ms Query memory: 0.039 MB Memory before query: 19.775 MB Rows returned: 1

Duplicate queries: #34 #35 #36 #38

SELECT c.id

  FROM rdd_categories AS c

  WHERE c.id = 32 
  AND c.access IN (1,1,5)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
55	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_multicats/copy/code/com_content/models/articles.php:684
54	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
53	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
52	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.19 ms Query memory: 0.039 MB Memory before query: 19.801 MB Rows returned: 1

Duplicate queries: #34 #35 #36 #37

SELECT c.id

  FROM rdd_categories AS c

  WHERE c.id = 32 
  AND c.access IN (1,1,5)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
55	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_multicats/copy/code/com_content/models/articles.php:684
54	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
53	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
52	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.15 ms After last query: 2.44 ms Query memory: 0.042 MB Memory before query: 19.820 MB Rows returned: 15

SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params

  FROM `rdd_contentitem_tag_map` AS `m`

  INNER JOIN `rdd_tags` AS `t` 
  ON `tag_id` = t.id

  INNER JOIN `rdd_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

  WHERE `t`.`access` IN (1,1,5) 
  AND `t`.`published` = 1  
  AND `tag_date` > DATE_ADD('2020-09-25 04:55:13', INTERVAL -1 MONTH) 
  AND `m`.`type_alias` = `c`.`core_type_alias` 
  AND `c`.`core_state` = 1 
  AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0) 
  AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2020-09-25 04:55:13') 
  AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2020-09-25 04:55:13')

  GROUP BY `tag_id`,`title`,`access`,`alias`

  ORDER BY `count` DESC 
  LIMIT 15

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_tag_type,idx_date_id,idx_core_content_id	idx_date_id	4	NULL	134	100.00	Using index condition; Using temporary; Using filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	rddmag_rddMag.m.tag_id	1	89.96	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	rddmag_rddMag.m.core_content_id	1	5.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
57	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
56	ModTagsPopularHelper::getList()	Same as call in the line below.
55	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
54	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:587
53	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
52	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
51	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
50	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
49	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
48	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:704
47	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:43
46	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:216
45	Twig\Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/b1/b1da766bbc773a224518594906e7258ca09b4d13c1469126731aba3fa152eb33.php:73
44	__TwigTemplate_ad02247b60432618074f1628c7b6da120aced33504e582e68f5252b3d69c0b07->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
43	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
42	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/65/65a9b9a14fc0c5556238bdfe61e1b2c7f99abad23636a388855d2eb0907f3433.php:35
41	__TwigTemplate_3b9ef5439878f47bc836554b7b8469c960c71dcc438d29ba59b7356f46b118b2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
40	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
39	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/6c/6c88ee2c44f9e54610677285ba3b2f3b565fa701259806d5d40d7a8f95c9c8c3.php:53
38	__TwigTemplate_8b4088083802512c177f574e88c0a4e711563009a6b648a7f0923c370106c77f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
36	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
35	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
34	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
33	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
32	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:767
31	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
30	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
29	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:702
21	Twig\Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/8c/8c339e586b3fd727f68763903b1fed6c2016b2292f0e63701d2bd7876c7a06b5.php:47
20	__TwigTemplate_fcf6b84d99ee0c649bbd3565c54e357a0b8455743ec1bdfa54be543f1fe55e65->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
18	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/2c/2cb196d44e2d55a80030333c3721d52dbc2012edd44e32941b7e342f770326bf.php:35
17	__TwigTemplate_049bc175fb6b7bac2cab934343319fcd6a77e54455f720d9fac0f2bf28551b2f->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
15	Twig\Template->display()	JROOT/cache/gantry5/g5_helium/twig/f8/f8ba4a3c8e0efebb0b769d03de634c127856cd385ed64f291d413ccdd1b430ac.php:35
14	__TwigTemplate_6e7faa0ae24a7596fbfce0dc7880e4ceb6b1e7a93b86375938b1bc41b68404df->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:455
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:422
12	Twig\Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/src/Template.php:434
11	Twig\Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

5 × SELECT c.id 
  FROM rdd_categories AS c

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM rdd_contentitem_tag_map AS m 
  INNER JOIN rdd_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2020-09-25 04:55:13')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2020-09-25 04:55:13') 
  INNER JOIN rdd_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  LEFT JOIN rdd_categories AS tc 
  ON tc.id = c.core_catid 
  LEFT JOIN rdd_users AS ua 
  ON ua.id = c.core_created_user_id

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

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 rdd_fields AS a 
  LEFT JOIN `rdd_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN rdd_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN rdd_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN rdd_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN rdd_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `rdd_fields_categories` AS fc 
  ON fc.field_id = a.id

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 `rdd_categories` AS `s` 
  INNER JOIN `rdd_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

```
2 × SELECT * 
  FROM rdd_tags
```

1 × SELECT `data` 
  FROM `rdd_session`

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,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,mc.catid AS mcatids,m.ordering AS m_ordering 
  FROM rdd_content AS a 
  LEFT JOIN rdd_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN rdd_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN rdd_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN rdd_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN rdd_multicats_content_catid AS mc 
  ON mc.item_id = a.id 
  LEFT JOIN rdd_content_multicats AS m 
  ON (m.content_id = a.id 
  AND FIND_IN_SET(m.catid,mc.catid) )

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

1 × SELECT a.menutype 
  FROM rdd_menu_types AS a

1 × SELECT `content` 
  FROM `rdd_modules`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `rdd_assets`

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

1 × SELECT * 
  FROM `rdd_content_types

1 × SELECT `session_id` 
  FROM `rdd_session`

```
1 × SELECT * 
  FROM rdd_languages
```

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM rdd_template_styles AS s

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

1 × SELECT DISTINCT a.* 
  FROM `rdd_ampz` AS a 
  LIMIT 3

```
1 × SELECT id 
  FROM `rdd_tags`
```

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

```
1 × SELECT * 
  FROM rdd_rsform_confi
```

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

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

1 × SELECT id, rules 
  FROM `rdd_viewlevels

1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
  FROM `rdd_contentitem_tag_map` AS `m` 
  INNER JOIN `rdd_tags` AS `t` 
  ON `tag_id` = t.id 
  INNER JOIN `rdd_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

OTHER Tables:

1 × INSERT INTO `rdd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6339613133343330383265396138353039646262303236346236346330633861', 1, 1601009713, 0, '', 0

1 × UPDATE `rdd_extensions` 
  SET `params` = '{\"mediaversion\":\"63bf5ad6de4126210d09844955d6cdda\"}'

1 × SHOW FULL COLUMNS 
  FROM `rdd_tags

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

Mediterranean

The Hummus & Pita Co. Expands Southeast Footprint

Garbanzo Mediterranean Fresh Signs Multi-Unit Deal in Boston

SAJJ Mediterranean Expands in California

Mediterranean Fast-Casual Plans Aggressive Expansion

Zoës Kitchen's New Prototype Stresses Mediterranean Roots

Ousia Debuts in Midtown West

Cannon + Belle Brings Modern Twist to Texas Staples

Roti Focuses on the Casual in Fast-Casual

The Simple Greek Opens New Unit with New Partner Marcus "The Prophet" Lemonis

Luna Grill Heads to Texas

Project Profile: Carmel Café and Wine Bar

Site Links

Resources

Events

Newsletters

Related Sites

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

39 Queries Logged 35.25 ms

7 duplicate found!

30 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: