สาระน่ารู้

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1776490128,
                "last": 1776490128,
                "now": 1776490130
            },
            "client": {
                "forwarded": "216.73.217.108"
            },
            "token": "xQXf5OxJtmJ2IPuua9b8zVpSnXTE0v0M"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "e056c47df07cfcfff5d6d77ed7cb6ec3fba0a8b0": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/38-other-news\/875-2020-03-26-05-08-38",
                    "expiry": 1776490128
                },
                "3c81c380867ef837c1ceeaabba5861e7268cfd18": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/38-other-news\/859-2020-03-17-02-38-28",
                    "expiry": 1776490128
                },
                "bb7451c8cc34f60e697c2256925ea52f5a219f02": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/38-other-news\/868-110",
                    "expiry": 1776490128
                },
                "5ab43e9c000d633d9c1a95f3d8474e6b512efd05": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/38-other-news\/841-cobra-gold-2020",
                    "expiry": 1776490128
                },
                "97283aa2eb5fdc9e9cea27cf1822d0865f8de399": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/38-other-news\/870-2020-03-24-08-30-53",
                    "expiry": 1776490128
                },
                "4478073e022885eda245038a08b186660c207ab0": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/38-other-news\/838-2563-7",
                    "expiry": 1776490128
                }
            }
        }
    }
}

Time

Memory

61 Queries Logged 319.44 ms

1. Query Time: 0.41 ms Query memory: 0.023 MB Memory before query: 1.014 MB Rows returned: 1

   SELECT `data`
   
     FROM `paew_session`
   
     WHERE `session_id` = '2o75okgdcga923kb03mg73qb8c'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	paew_session	const	PRIMARY	PRIMARY	575	const	1

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.09 ms
   preparing	0.01 ms
   Unlocking tables	0.02 ms
   executing	0.01 ms
   Sending data	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   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:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   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.]

   ---

2. Query Time: 0.25 ms After last query: 1.82 ms Query memory: 0.021 MB Memory before query: 1.114 MB Rows returned: 5

   SELECT id, rules
   
     FROM `paew_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
   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:310
   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:606
   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:195
   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.]

   ---

3. Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.125 MB Rows returned: 2

   SELECT b.id
   
     FROM paew_usergroups AS a
   
     LEFT JOIN paew_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
   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:310
   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:606
   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:195
   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.]

   ---

4. Query Time: 1.49 ms After last query: 3.51 ms Query memory: 0.006 MB Memory before query: 1.518 MB

   UPDATE `paew_extensions`
   
     SET `params` = '{\"mediaversion\":\"5cb4bd0a55d67d56c141642d3768ac19\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.07 ms
   updating	0.07 ms
   end	0.01 ms
   query end	1.17 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/kunena/kunena.php:70
   7	plgSystemKunena->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.]

   ---

5. Query Time: 0.30 ms After last query: 1.77 ms Query memory: 0.004 MB Memory before query: 1.792 MB

   UPDATE paew_extensions
   
     SET enabled=1
   
     WHERE `type`='plugin' 
     AND `element`='jacontenttype' 
     AND `folder`='ajax'

   Explain

   EXPLAIN not possible on query: UPDATE paew_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.08 ms
   updating	0.03 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/jacontenttype/jacontenttype.php:61
   8	PlgSystemJacontenttype->_check()	JROOT/plugins/system/jacontenttype/jacontenttype.php:43
   7	PlgSystemJacontenttype->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.]

   ---

6. Query Time: 0.23 ms After last query: 4.60 ms Query memory: 0.020 MB Memory before query: 1.952 MB Rows returned: 1

   SELECT count(*)
   
     FROM `paew_cwgears_schedule`

   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	Select tables optimized away

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
   8	plgSystemCwgears->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:623
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.]

   ---

7. Query Time: 0.18 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 1.958 MB Rows returned: 1

   SELECT count(*)
   
     FROM `paew_cwgears_schedule`
   
     WHERE time + '86400'<'1776490130'

   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.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   Unlocking tables	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:139
   8	plgSystemCwgears->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:623
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.]

   ---

8. Query Time: 0.74 ms After last query: 3.80 ms Query memory: 0.034 MB Memory before query: 2.348 MB Rows returned: 22

   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 `paew_categories` AS `s`
   
     INNER JOIN `paew_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 = 9
   
     ORDER BY c.lft

   Explain

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

   Profile

   Status	Duration
   starting	0.11 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.05 ms
   optimizing	0.03 ms
   statistics	0.12 ms
   preparing	0.01 ms
   Unlocking tables	0.02 ms
   Sorting result	0.02 ms
   executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.19 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
   12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
   11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
   10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
   9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
   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:138
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
   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:195
   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.]

   ---

9. Query Time: 0.28 ms After last query: 2.09 ms Query memory: 0.021 MB Memory before query: 2.621 MB Rows returned: 1

   SELECT count(*)
   
     FROM `paew_extensions`
   
     WHERE `element` = 'cwgears' 
     AND `extension_id` = ''

   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.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:1003
   9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:202
   8	plgSystemCwgears->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:1080
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
   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:195
   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.]

   ---

10. Query Time: 0.65 ms After last query: 2.57 ms Query memory: 0.029 MB Memory before query: 2.906 MB Rows returned: 43

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `paew_assets`
    
      WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactmap','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_irenecoremigrate','com_jabuilder','com_jaextmanager','com_jch_optimize','com_jdonation','com_jevents','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_rstbox','com_search','com_tags','com_templates','com_users','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	paew_assets	range	idx_asset_name	idx_asset_name	152	NULL	44	Using index condition

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.25 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

11. Query Time: 4.13 ms After last query: 0.18 ms Query memory: 0.545 MB Memory before query: 2.959 MB Rows returned: 4520

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `paew_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	3.83 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

12. Query Time: 9.66 ms After last query: 5.60 ms Query memory: 0.036 MB Memory before query: 6.724 MB Rows returned: 22

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `paew_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `paew_categories` AS `s`
    
      INNER JOIN `paew_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.published = 1 
      AND s.id = 9
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	PRIMARY	c	ALL	cat_idx,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	46	Using where; Using filesort
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid,catid,state	idx_catid	4	base_pohtecktung1418.c.id	39	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.11 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.05 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.19 ms
    executing	0.00 ms
    Sending data	0.31 ms
    executing	0.01 ms
    Sending data	0.11 ms
    executing	0.01 ms
    Sending data	0.09 ms
    executing	0.01 ms
    Sending data	1.09 ms
    executing	0.01 ms
    Sending data	0.06 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.84 ms
    executing	0.01 ms
    Sending data	0.82 ms
    executing	0.01 ms
    Sending data	1.78 ms
    executing	0.01 ms
    Sending data	1.14 ms
    executing	0.01 ms
    Sending data	0.12 ms
    executing	0.01 ms
    Sending data	0.26 ms
    executing	0.01 ms
    Sending data	0.63 ms
    executing	0.01 ms
    Sending data	0.64 ms
    executing	0.01 ms
    Sending data	0.23 ms
    executing	0.00 ms
    Sending data	0.13 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    removing tmp table	0.01 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    14	ContentModelCategory->getCategory()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:423
    13	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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 Time: 163.58 ms After last query: 0.92 ms Query memory: 0.095 MB Memory before query: 6.841 MB Rows returned: 6

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,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
    
      FROM paew_content AS a
    
      LEFT JOIN paew_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN paew_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN paew_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 9 OR a.catid IN (
    SELECT sub.id
    
      FROM paew_categories as sub
    
      INNER JOIN paew_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 9)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-18 05:28:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-18 05:28:50')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 3612, 6

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	46	Using where; Using temporary; Using filesort
    1	PRIMARY	a	ref	idx_access,idx_state,idx_catid,catid,state	idx_catid	4	base_pohtecktung1418.c.id	39	Using index condition; Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.created_by	1	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.modified_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.c.parent_id	1	Using where
    2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	MATERIALIZED	sub	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	46	Using where; Using index

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.09 ms
    optimizing	0.06 ms
    statistics	0.12 ms
    preparing	0.06 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.11 ms
    executing	0.01 ms
    Sending data	77.21 ms
    Creating sort index	32.23 ms
    removing tmp table	53.00 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    removing tmp table	0.01 ms
    freeing items	0.03 ms
    removing tmp table	0.01 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:423
    13	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

14. Query Time: 10.76 ms After last query: 1.47 ms Query memory: 0.025 MB Memory before query: 7.078 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM paew_content AS a
    
      LEFT JOIN paew_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN paew_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN paew_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 9 OR a.catid IN (
    SELECT sub.id
    
      FROM paew_categories as sub
    
      INNER JOIN paew_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 9)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-18 05:28:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-18 05:28:50')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	46	Using where
    1	PRIMARY	a	ref	idx_access,idx_state,idx_catid,catid,state	idx_catid	4	base_pohtecktung1418.c.id	39	Using index condition; Using where
    2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    2	MATERIALIZED	sub	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	46	Using where; Using index

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.14 ms
    preparing	0.01 ms
    Unlocking tables	0.04 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.08 ms
    executing	0.00 ms
    Sending data	9.88 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    removing tmp table	0.01 ms
    freeing items	0.01 ms
    removing tmp table	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    14	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:423
    13	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

15. Query Time: 0.57 ms After last query: 0.56 ms Query memory: 0.023 MB Memory before query: 7.087 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `paew_contentitem_tag_map` AS m 
    
      INNER JOIN `paew_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 9 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	16	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	base_pohtecktung1418.t.id	3	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.15 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

16. Query Time: 0.53 ms After last query: 1.15 ms Query memory: 0.025 MB Memory before query: 7.130 MB Rows returned: 0

    SELECT 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
    
      FROM paew_fields AS a
    
      LEFT JOIN `paew_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN paew_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN paew_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN paew_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `paew_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 (62,0,14,9)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	base_pohtecktung1418.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

17. Query Time: 0.85 ms After last query: 12.92 ms Query memory: 0.028 MB Memory before query: 7.498 MB Rows returned: 1

    SELECT 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
    
      FROM paew_fields AS a
    
      LEFT JOIN `paew_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN paew_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN paew_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN paew_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `paew_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.categories' 
      AND (fc.category_id IS NULL OR fc.category_id IN (62,0,14,9)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	base_pohtecktung1418.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/templates/ja_focus/html/com_content/category/blog.php:20
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

18. Query Time: 0.26 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 7.522 MB Rows returned: 1

    SELECT `field_id`,`value`
    
      FROM `paew_fields_values`
    
      WHERE `field_id` IN (2) 
      AND `item_id` = '9'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	paew_fields_values	ref	idx_field_id,idx_item_id	idx_item_id	575	const	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_fields/models/field.php:702
    20	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/templates/ja_focus/html/com_content/category/blog.php:20
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

19. Query Time: 0.66 ms After last query: 3.27 ms Query memory: 0.028 MB Memory before query: 7.623 MB Rows returned: 1

    SELECT 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
    
      FROM paew_fields AS a
    
      LEFT JOIN `paew_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN paew_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN paew_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN paew_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `paew_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.categories' 
      AND (fc.category_id IS NULL OR fc.category_id IN (9,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	base_pohtecktung1418.a.language	1	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.id	1	Using where; Using index

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.05 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.06 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:388
    19	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:308
    18	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/templates/ja_focus/html/com_content/category/blog.php:23
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

20. Query Time: 0.42 ms After last query: 1.73 ms Query memory: 0.025 MB Memory before query: 7.695 MB Rows returned: 1

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 9
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/category/blog.php:37
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

21. Query Time: 0.42 ms After last query: 0.53 ms Query memory: 0.026 MB Memory before query: 7.728 MB Rows returned: 1
    Duplicate queries: #22  #23  #24  #25  #26  #49

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 62
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    18	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/category/blog_item.php:46
    17	include JROOT/templates/ja_focus/html/com_content/category/blog_item.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    16	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/templates/ja_focus/html/com_content/category/blog.php:123
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

22. Query Time: 0.42 ms After last query: 2.56 ms Query memory: 0.026 MB Memory before query: 7.795 MB Rows returned: 1
    Duplicate queries: #21  #23  #24  #25  #26  #49

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 62
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    18	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/category/blog_item.php:46
    17	include JROOT/templates/ja_focus/html/com_content/category/blog_item.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    16	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/templates/ja_focus/html/com_content/category/blog.php:123
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

23. Query Time: 0.42 ms After last query: 2.12 ms Query memory: 0.026 MB Memory before query: 7.840 MB Rows returned: 1
    Duplicate queries: #21  #22  #24  #25  #26  #49

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 62
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    18	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/category/blog_item.php:46
    17	include JROOT/templates/ja_focus/html/com_content/category/blog_item.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    16	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/templates/ja_focus/html/com_content/category/blog.php:123
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

24. Query Time: 0.50 ms After last query: 2.94 ms Query memory: 0.026 MB Memory before query: 7.901 MB Rows returned: 1
    Duplicate queries: #21  #22  #23  #25  #26  #49

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 62
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    18	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/category/blog_item.php:46
    17	include JROOT/templates/ja_focus/html/com_content/category/blog_item.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    16	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/templates/ja_focus/html/com_content/category/blog.php:123
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.56 ms After last query: 2.55 ms Query memory: 0.026 MB Memory before query: 7.981 MB Rows returned: 1
    Duplicate queries: #21  #22  #23  #24  #26  #49

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 62
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    18	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/category/blog_item.php:46
    17	include JROOT/templates/ja_focus/html/com_content/category/blog_item.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    16	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/templates/ja_focus/html/com_content/category/blog.php:123
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.]

    ---

26. Query Time: 0.54 ms After last query: 2.63 ms Query memory: 0.026 MB Memory before query: 8.016 MB Rows returned: 1
    Duplicate queries: #21  #22  #23  #24  #25  #49

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 62
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    18	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/category/blog_item.php:46
    17	include JROOT/templates/ja_focus/html/com_content/category/blog_item.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    16	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/templates/ja_focus/html/com_content/category/blog.php:123
    15	include JROOT/templates/ja_focus/html/com_content/category/blog.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    13	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:269
    11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.49 ms After last query: 5.15 ms Query memory: 0.020 MB Memory before query: 8.368 MB Rows returned: 0

    select b.* 
      from paew_rstbox b 
      where b.published = 1  
      AND b.testmode=0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	21	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rstbox/helpers/helper.php:191
    8	EBHelper::getBoxes()	JROOT/plugins/system/rstbox/rstbox.php:78
    7	PlgSystemRstBox->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:195
    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.]

    ---

28. Query Time: 0.71 ms After last query: 5.06 ms Query memory: 0.023 MB Memory before query: 8.596 MB Rows returned: 1
    Duplicate queries: #29

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 12
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.15 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    12	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/tpls/blocks/mainnav.php:54
    11	include JROOT/templates/ja_focus/tpls/blocks/mainnav.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/ja_focus/tpls/default.php:35
    9	include JROOT/templates/ja_focus/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/ja_focus/index.php:34
    7	require JROOT/templates/ja_focus/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

29. Query Time: 0.54 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 8.604 MB Rows returned: 1
    Duplicate queries: #28

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 12
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    12	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/tpls/blocks/mainnav.php:55
    11	include JROOT/templates/ja_focus/tpls/blocks/mainnav.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/ja_focus/tpls/default.php:35
    9	include JROOT/templates/ja_focus/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/ja_focus/index.php:34
    7	require JROOT/templates/ja_focus/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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 Time: 0.37 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 8.612 MB Rows returned: 1
    Duplicate queries: #31  #59  #61

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 13
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    12	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/tpls/blocks/mainnav.php:54
    11	include JROOT/templates/ja_focus/tpls/blocks/mainnav.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/ja_focus/tpls/default.php:35
    9	include JROOT/templates/ja_focus/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/ja_focus/index.php:34
    7	require JROOT/templates/ja_focus/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

31. Query Time: 0.44 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 8.620 MB Rows returned: 1
    Duplicate queries: #30  #59  #61

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 13
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    12	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/tpls/blocks/mainnav.php:55
    11	include JROOT/templates/ja_focus/tpls/blocks/mainnav.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/ja_focus/tpls/default.php:35
    9	include JROOT/templates/ja_focus/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/ja_focus/index.php:34
    7	require JROOT/templates/ja_focus/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

32. Query Time: 0.36 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 8.628 MB Rows returned: 1
    Duplicate queries: #33

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 14
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    12	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/tpls/blocks/mainnav.php:54
    11	include JROOT/templates/ja_focus/tpls/blocks/mainnav.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/ja_focus/tpls/default.php:35
    9	include JROOT/templates/ja_focus/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/ja_focus/index.php:34
    7	require JROOT/templates/ja_focus/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

33. Query Time: 0.40 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 8.642 MB Rows returned: 1
    Duplicate queries: #32

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 14
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    12	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/tpls/blocks/mainnav.php:55
    11	include JROOT/templates/ja_focus/tpls/blocks/mainnav.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/ja_focus/tpls/default.php:35
    9	include JROOT/templates/ja_focus/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/ja_focus/index.php:34
    7	require JROOT/templates/ja_focus/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

34. Query Time: 0.56 ms After last query: 504.33 ms Query memory: 0.027 MB Memory before query: 8.736 MB Rows returned: 80

    SELECT * 
      FROM paew_acymailing_config

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    14	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
    13	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
    12	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
    11	include JROOT/modules/mod_acymailing/mod_acymailing.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

35. Query Time: 0.41 ms After last query: 0.81 ms Query memory: 0.023 MB Memory before query: 8.871 MB Rows returned: 1

    SELECT * 
      FROM paew_acymailing_list 
      WHERE type = 'list'  
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	paew_acymailing_list	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 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.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
    12	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:104
    11	include JROOT/modules/mod_acymailing/mod_acymailing.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

36. Query Time: 0.34 ms After last query: 3.35 ms Query memory: 0.022 MB Memory before query: 8.952 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM paew_modules AS m
    
      WHERE m.id = 127 
      AND m.published = 1 
      AND m.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:330
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

37. Query Time: 0.24 ms After last query: 1.29 ms Query memory: 0.022 MB Memory before query: 9.041 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM paew_modules AS m
    
      WHERE m.id = 126 
      AND m.published = 1 
      AND m.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:330
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

38. Query Time: 1.24 ms After last query: 0.52 ms Query memory: 0.060 MB Memory before query: 9.083 MB Rows returned: 4

    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
    
      FROM paew_content AS a
    
      LEFT JOIN paew_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN paew_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN paew_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (12,26,27,28,29,30) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-18 05:28:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-18 05:28:50')
    
      ORDER BY a.created DESC 
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index	idx_access,idx_state,idx_catid,catid,state	created	5	NULL	69	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	base_pohtecktung1418.a.catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.c.parent_id	1	Using where

    Profile

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.10 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.54 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
    16	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    15	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    14	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/t3/includes/menu/megamenu.php:336
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

39. Query Time: 0.33 ms After last query: 1.84 ms Query memory: 0.022 MB Memory before query: 9.077 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM paew_modules AS m
    
      WHERE m.id = 129 
      AND m.published = 1 
      AND m.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Unlocking tables	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
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:330
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

40. Query Time: 0.29 ms After last query: 1.06 ms Query memory: 0.022 MB Memory before query: 9.177 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM paew_modules AS m
    
      WHERE m.id = 128 
      AND m.published = 1 
      AND m.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:330
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

41. Query Time: 1.45 ms After last query: 0.43 ms Query memory: 0.060 MB Memory before query: 9.215 MB Rows returned: 4

    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
    
      FROM paew_content AS a
    
      LEFT JOIN paew_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN paew_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN paew_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (13,31,32) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-18 05:28:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-18 05:28:50')
    
      ORDER BY a.created DESC 
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index	idx_access,idx_state,idx_catid,catid,state	created	5	NULL	34	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	base_pohtecktung1418.a.catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.c.parent_id	1	Using where

    Profile

    Status	Duration
    starting	0.20 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
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.08 ms
    optimizing	0.04 ms
    statistics	0.19 ms
    preparing	0.14 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.52 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
    16	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    15	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    14	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/t3/includes/menu/megamenu.php:336
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

42. Query Time: 0.37 ms After last query: 1.81 ms Query memory: 0.022 MB Memory before query: 9.210 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM paew_modules AS m
    
      WHERE m.id = 131 
      AND m.published = 1 
      AND m.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:330
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

43. Query Time: 0.37 ms After last query: 2.01 ms Query memory: 0.022 MB Memory before query: 9.413 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM paew_modules AS m
    
      WHERE m.id = 130 
      AND m.published = 1 
      AND m.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:330
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

44. Query Time: 105.68 ms After last query: 0.44 ms Query memory: 0.060 MB Memory before query: 9.449 MB Rows returned: 4

    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
    
      FROM paew_content AS a
    
      LEFT JOIN paew_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN paew_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN paew_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN paew_categories as parent 
      ON parent.id = c.parent_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (14,35,36,37,38,39) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-18 05:28:50') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-18 05:28:50')
    
      ORDER BY a.created DESC 
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	46	Using where; Using temporary; Using filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,catid,state	idx_catid	4	base_pohtecktung1418.c.id	39	Using index condition; Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.c.parent_id	1	Using where

    Profile

    Status	Duration
    starting	0.24 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.09 ms
    optimizing	0.05 ms
    statistics	0.28 ms
    preparing	0.07 ms
    Creating tmp table	0.08 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	63.10 ms
    Creating sort index	9.88 ms
    removing tmp table	31.57 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    17	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
    16	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    15	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    14	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/t3/includes/menu/megamenu.php:336
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

45. Query Time: 0.24 ms After last query: 2.10 ms Query memory: 0.022 MB Memory before query: 9.428 MB Rows returned: 0

    SELECT uikit
    
      FROM `paew_cwgears`
    
      WHERE url = 'https://www.pohtecktung.org/donors/9-knowledge?start=3612'

    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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:417
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

46. Query Time: 0.16 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 9.435 MB Rows returned: 0

    SELECT uikit_plus
    
      FROM `paew_cwgears`
    
      WHERE url = 'https://www.pohtecktung.org/donors/9-knowledge?start=3612'

    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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:426
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

47. Query Time: 0.49 ms After last query: 3.98 ms Query memory: 0.025 MB Memory before query: 10.955 MB Rows returned: 1
    Duplicate queries: #51  #55

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 37
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

48. Query Time: 0.34 ms After last query: 0.68 ms Query memory: 0.025 MB Memory before query: 10.971 MB Rows returned: 0
    Duplicate queries: #52

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 63
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

49. Query Time: 0.34 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 10.980 MB Rows returned: 1
    Duplicate queries: #21  #22  #23  #24  #25  #26

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 62
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

50. Query Time: 0.41 ms After last query: 0.53 ms Query memory: 0.025 MB Memory before query: 10.991 MB Rows returned: 1
    Duplicate queries: #53  #56

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 36
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

51. Query Time: 0.40 ms After last query: 0.56 ms Query memory: 0.025 MB Memory before query: 11.001 MB Rows returned: 1
    Duplicate queries: #47  #55

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 37
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

52. Query Time: 0.37 ms After last query: 1.33 ms Query memory: 0.025 MB Memory before query: 11.022 MB Rows returned: 0
    Duplicate queries: #48

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 63
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

53. Query Time: 0.35 ms After last query: 0.53 ms Query memory: 0.025 MB Memory before query: 11.032 MB Rows returned: 1
    Duplicate queries: #50  #56

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 36
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

54. Query Time: 0.33 ms After last query: 0.54 ms Query memory: 0.025 MB Memory before query: 11.043 MB Rows returned: 1

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 40
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

55. Query Time: 0.33 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 11.053 MB Rows returned: 1
    Duplicate queries: #47  #51

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 37
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

56. Query Time: 0.33 ms After last query: 0.54 ms Query memory: 0.025 MB Memory before query: 11.063 MB Rows returned: 1
    Duplicate queries: #50  #53

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 36
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

57. Query Time: 0.36 ms After last query: 1.19 ms Query memory: 0.025 MB Memory before query: 11.078 MB Rows returned: 1

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 18
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

58. Query Time: 0.35 ms After last query: 0.52 ms Query memory: 0.025 MB Memory before query: 11.088 MB Rows returned: 1

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 38
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

59. Query Time: 0.34 ms After last query: 0.53 ms Query memory: 0.025 MB Memory before query: 11.098 MB Rows returned: 1
    Duplicate queries: #30  #31  #61

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 13
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

60. Query Time: 0.32 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 11.108 MB Rows returned: 0

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 52
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---

61. Query Time: 0.33 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 11.118 MB Rows returned: 1
    Duplicate queries: #30  #31  #59

    SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name
    				
      FROM paew_fields_values fv
    				
      LEFT JOIN paew_fields f 
      ON fv.field_id = f.id
    				
      LEFT JOIN paew_fields_groups fg 
      ON fg.id = f.group_id
    				
      WHERE fv.item_id = 13
    				
      AND f.context = "com_content.categories"
    				
      AND f.language IN ("*", "en-GB")
    				
      AND f.access = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	PRIMARY,idx_access,idx_context,idx_language	idx_access	4	const	1	Using where
    1	SIMPLE	fg	eq_ref	PRIMARY	PRIMARY	4	base_pohtecktung1418.f.group_id	1
    1	SIMPLE	fv	ref	idx_field_id,idx_item_id	idx_field_id	4	base_pohtecktung1418.f.id	16	Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
    16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
    15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
    14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
    11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
    10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
    9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
    8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
    7	plgSystemjatabs->onAfterRender()	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/CMSApplication.php:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.]

    ---