Fiba - Home

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 4.27 ms / 4.27 ms Memory: 0.407 MB / 0.75 MB Application: afterLoad

Time: 28.95 ms / 33.22 ms Memory: 1.818 MB / 2.57 MB Application: afterInitialise

Time: 6.76 ms / 39.98 ms Memory: 0.496 MB / 3.06 MB Application: afterRoute

Time: 0.32 ms / 40.30 ms Memory: 0.033 MB / 3.10 MB Application: beforeRenderComponent com_content

Time: 3.18 ms / 43.48 ms Memory: 0.227 MB / 3.32 MB Application: Before Access::preloadComponents (all components)

Time: 1.60 ms / 45.08 ms Memory: 0.071 MB / 3.40 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 45.11 ms Memory: -0.004 MB / 3.39 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.20 ms / 45.31 ms Memory: 0.009 MB / 3.40 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 7.59 ms / 52.91 ms Memory: 0.191 MB / 3.59 MB Application: afterRenderComponent com_content

Time: 0.89 ms / 53.79 ms Memory: 0.009 MB / 3.60 MB Application: afterDispatch

Time: 11.36 ms / 65.15 ms Memory: 0.216 MB / 3.82 MB Application: beforeRenderModule mod_custom (Copyright Fiba)

Time: 0.30 ms / 65.45 ms Memory: 0.003 MB / 3.82 MB Application: afterRenderRawModule mod_custom (Copyright Fiba)

Time: 0.01 ms / 65.46 ms Memory: -0.000 MB / 3.82 MB Application: beforeRenderModule mod_custom (Copyright Fiba)

Time: 1.01 ms / 66.47 ms Memory: 0.120 MB / 3.94 MB Application: afterRenderModule mod_custom (Copyright Fiba)

Time: 0.53 ms / 67.00 ms Memory: 0.000 MB / 3.94 MB Application: beforeRenderModule mod_custom (Fiba 20 logo web)

Time: 0.10 ms / 67.10 ms Memory: 0.001 MB / 3.94 MB Application: afterRenderRawModule mod_custom (Fiba 20 logo web)

Time: 0.01 ms / 67.10 ms Memory: 0.001 MB / 3.94 MB Application: beforeRenderModule mod_custom (Fiba 20 logo web)

Time: 0.25 ms / 67.36 ms Memory: 0.003 MB / 3.95 MB Application: afterRenderModule mod_custom (Fiba 20 logo web)

Time: 0.22 ms / 67.57 ms Memory: -0.020 MB / 3.93 MB Application: beforeRenderModule mod_layer_slider (Layer Slider)

Time: 6.24 ms / 73.81 ms Memory: 0.415 MB / 4.34 MB Application: afterRenderRawModule mod_layer_slider (Layer Slider)

Time: 0.04 ms / 73.85 ms Memory: -0.378 MB / 3.96 MB Application: beforeRenderModule mod_layer_slider (Layer Slider)

Time: 0.23 ms / 74.08 ms Memory: 0.002 MB / 3.96 MB Application: afterRenderModule mod_layer_slider (Layer Slider)

Time: 0.35 ms / 74.43 ms Memory: 0.026 MB / 3.99 MB Application: beforeRenderModule mod_search (Search)

Time: 0.51 ms / 74.95 ms Memory: 0.011 MB / 4.00 MB Application: afterRenderRawModule mod_search (Search)

Time: 0.01 ms / 74.95 ms Memory: -0.001 MB / 4.00 MB Application: beforeRenderModule mod_search (Search)

Time: 0.30 ms / 75.25 ms Memory: 0.002 MB / 4.00 MB Application: afterRenderModule mod_search (Search)

Time: 0.31 ms / 75.56 ms Memory: -0.020 MB / 3.98 MB Application: beforeRenderModule mod_languages (Jezik)

Time: 2.63 ms / 78.19 ms Memory: 0.026 MB / 4.01 MB Application: afterRenderRawModule mod_languages (Jezik)

Time: 0.01 ms / 78.20 ms Memory: -0.001 MB / 4.01 MB Application: beforeRenderModule mod_languages (Jezik)

Time: 0.19 ms / 78.39 ms Memory: 0.002 MB / 4.01 MB Application: afterRenderModule mod_languages (Jezik)

Time: 253.35 ms / 331.74 ms Memory: 0.497 MB / 4.51 MB Application: afterRender

Database queries total: 22.45 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pjg71_session	const	PRIMARY	PRIMARY	194	const	1

Status	Duration
Starting	0.30 ms
checking permissions	0.08 ms
Opening tables	0.16 ms
After opening tables	0.04 ms
System lock	0.05 ms
table lock	0.05 ms
init	0.06 ms
Optimizing	0.07 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.05 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
Query end	0.03 ms
closing tables	0.04 ms
Unlocking tables	0.04 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.12 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pjg71_session	const	PRIMARY	PRIMARY	194	const	1	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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `pjg71_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6a6561616335756f6c637234386e38357574666f373471726936', 1, 1775158937, 0, '', 0)

Profile

Status	Duration
Starting	0.22 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.04 ms
table lock	0.03 ms
init for update	0.04 ms
Update	0.11 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.14 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.14 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Call Stack

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

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

Query Time: 1.27 ms After last query: 0.95 ms Query memory: 0.005 MB Memory before query: 1.153 MB Rows returned: 5

SELECT id, rules

  FROM `pjg71_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.04 ms
System lock	0.04 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.06 ms
Query end	0.04 ms
closing tables	0.04 ms
Unlocking tables	0.04 ms
closing tables	0.05 ms
Query end	0.03 ms
Starting cleanup	0.04 ms
Freeing items	0.13 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 1.25 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 1.165 MB Rows returned: 2

SELECT b.id

  FROM pjg71_usergroups AS a

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

  WHERE a.id = 13

Explain

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

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Unlocking tables	0.04 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.04 ms
Query end	0.05 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.12 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

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

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

Query Time: 0.94 ms After last query: 18.19 ms Query memory: 0.006 MB Memory before query: 2.944 MB

UPDATE `pjg71_extensions`

  SET `params` = '{\"mediaversion\":\"d2c8d0ccba651bbe52910d6b7d8de88b\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `pjg71_extensions` SET `params` = '{\"mediaversion\":\"d2c8d0ccba651bbe52910d6b7d8de88b\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init for update	0.10 ms
Updating	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.10 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:66
9	plgSystemVmogmetatag->_init()	JROOT/plugins/system/vmogmetatag/vmogmetatag.php:103
8	plgSystemVmogmetatag->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 5.36 ms Query memory: 0.010 MB Memory before query: 3.329 MB Rows returned: 44

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

  FROM `pjg71_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_fields','com_finder','com_installer','com_j2xml','com_jaextmanager','com_jalang','com_jchoptimize','com_joomlaupdate','com_languages','com_layer_slider','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sitemapfaster','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pjg71_assets	range	idx_asset_name	idx_asset_name	202	NULL	45	Using index condition

Profile

Status	Duration
Starting	0.19 ms
checking permissions	0.05 ms
Opening tables	0.11 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.09 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.28 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.02 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/components/com_content/models/articles.php:115
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425
12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.92 ms After last query: 0.83 ms Query memory: 0.009 MB Memory before query: 3.427 MB Rows returned: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM pjg71_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-02 19:42:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-02 19:42:17') 
  AND a.language IN ('en-GB','*')

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref\|filter	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid\|idx_state	1\|1	const	21 (14%)	Using where; Using temporary; Using filesort; Using rowid filter
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	foodmach_4tuc300X50A6Z3M.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	foodmach_4tuc300X50A6Z3M.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	foodmach_4tuc300X50A6Z3M.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	foodmach_4tuc300X50A6Z3M.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	foodmach_4tuc300X50A6Z3M.a.id	1	Using where

Profile

Status	Duration
Starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.04 ms
table lock	0.02 ms
init	0.10 ms
Optimizing	0.06 ms
Statistics	0.15 ms
Preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.44 ms
Creating sort index	0.05 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.11 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
13	ContentModelFeatured->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425
12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.07 ms After last query: 1.24 ms Query memory: 0.009 MB Memory before query: 3.586 MB Rows returned: 1

SELECT COUNT(*)

  FROM pjg71_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-02 19:42:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-02 19:42:17') 
  AND a.language IN ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref\|filter	idx_access,idx_state,idx_catid,idx_featured_catid,idx_language	idx_featured_catid\|idx_state	1\|1	const	21 (14%)	Using where; Using rowid filter
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	foodmach_4tuc300X50A6Z3M.a.catid	1	Using where

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425
12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 7.11 ms After last query: 6.29 ms Query memory: 0.010 MB Memory before query: 3.736 MB Rows returned: 36

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

  FROM pjg71_modules AS m

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

  LEFT JOIN pjg71_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-04-02 19:42:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-02 19:42:17') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 878 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	1.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:441
16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:371
15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:87
14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:653
12	T3Template->countModules()	JROOT/templates/purity_iii/tpls/blocks/header.php:62
11	include JROOT/templates/purity_iii/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:200
10	T3Template->loadBlock()	JROOT/templates/purity_iii/tpls/blog.php:38
9	include JROOT/templates/purity_iii/tpls/blog.php	JROOT/plugins/system/t3/includes/core/template.php:226
8	T3Template->loadLayout()	JROOT/templates/purity_iii/index.php:35
7	require JROOT/templates/purity_iii/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.18 ms After last query: 4.30 ms Query memory: 0.008 MB Memory before query: 3.944 MB Rows returned: 1

SELECT option_value

  FROM `pjg71_layerslider_options`

  WHERE `option_name`='ls-google-fonts'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pjg71_layerslider_options	const	option_name	option_name	194	const	1

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.28 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.05 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.06 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
15	JDatabaseDriver->loadRow()	JROOT/modules/mod_layer_slider/layer_slider_helper.php:32
14	get_option()	JROOT/modules/mod_layer_slider/layer_slider_helper.php:43
13	ls_load_google_fonts()	JROOT/modules/mod_layer_slider/layer_slider_helper.php:65
12	require_once JROOT/modules/mod_layer_slider/layer_slider_helper.php	JROOT/modules/mod_layer_slider/mod_layer_slider.php:27
11	include JROOT/modules/mod_layer_slider/mod_layer_slider.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.15 ms After last query: 0.17 ms Query memory: 0.007 MB Memory before query: 3.955 MB Rows returned: 1

SELECT *

  FROM `pjg71_layerslider`

  WHERE id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pjg71_layerslider	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.19 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.04 ms
Commit	0.03 ms
Query end	0.04 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/components/com_layer_slider/base/classes/class.ls.sliders.php:314
13	LS_Sliders::_getById()	JROOT/components/com_layer_slider/base/classes/class.ls.sliders.php:68
12	LS_Sliders::find()	JROOT/modules/mod_layer_slider/mod_layer_slider.php:61
11	include JROOT/modules/mod_layer_slider/mod_layer_slider.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.55 ms After last query: 2.07 ms Query memory: 0.007 MB Memory before query: 4.335 MB Rows returned: 0

SELECT option_value

  FROM `pjg71_layerslider_options`

  WHERE `option_name`='ls_put_js_to_body'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
14	JDatabaseDriver->loadRow()	JROOT/modules/mod_layer_slider/layer_slider_helper.php:32
13	get_option()	JROOT/components/com_layer_slider/base/includes/slider_markup_init.php:97
12	include JROOT/components/com_layer_slider/base/includes/slider_markup_init.php	JROOT/modules/mod_layer_slider/mod_layer_slider.php:79
11	include JROOT/modules/mod_layer_slider/mod_layer_slider.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 3.34 ms Query memory: 0.007 MB Memory before query: 4.010 MB Rows returned: 2

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

  FROM `pjg71_menu` AS `c`

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

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

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

  WHERE c.id = 878

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	765	const	2	Using where
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	foodmach_4tuc300X50A6Z3M.a2.id	1

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.08 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
14	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
13	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
12	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
11	include JROOT/modules/mod_languages/mod_languages.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT option_value 
  FROM `pjg71_layerslider_options`

1 × SELECT `data` 
  FROM `pjg71_session`

1 × SELECT `session_id` 
  FROM `pjg71_session`

1 × SELECT id, rules 
  FROM `pjg71_viewlevels

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

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM pjg71_content AS a 
  LEFT JOIN pjg71_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN pjg71_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN pjg71_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN pjg71_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pjg71_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT COUNT(*) 
  FROM pjg71_content AS a 
  LEFT JOIN pjg71_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN pjg71_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN pjg71_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN pjg71_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pjg71_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT * 
  FROM `pjg71_layerslider`

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

OTHER Tables:

1 × INSERT INTO `pjg71_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6a6561616335756f6c637234386e38357574666f373471726936', 1, 1775158937, 0, '', 0

1 × UPDATE `pjg71_extensions` 
  SET `params` = '{\"mediaversion\":\"d2c8d0ccba651bbe52910d6b7d8de88b\"}'

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

14 Queries Logged 22.45 ms

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: