ข่าวใหม่ล่าสุด

"ป่อเต็กตึ๊ง สร้างสุข ใส่ใจ ผู้สูงวัย" มูลนิธิป่อเต็กตึ๊ง ลง...

"รวมพลัง ส่งต่อธารน้ำใจ สู้ภัยน้ำท่วม" แพ็กถุงยังชีพฉุกเฉิน เพื่อช่วยเหลือผู้ประสบภัยน้ำท่วมในพื้นที่จังหวัดอุตรดิตถ์

วันนี้ (1 ตุลาคม พ.ศ. 2568) เวลา 08.30 น. มูลนิธิป่อเต็กตึ๊ง นำโดย คุณอรัณย์ โตทวด ผู้จัดการใหญ่ นำทีมเจ้าหน้าที่ระดับบริหาร พนักงาน และอาสาสมัครมูลนิธิฯ เร่งบรรจุสิ่งของจำเป็นและเครื่องอุปโภคบริโภค อาทิ อาหารสำเร็จรูป ไฟฉาย ผ้าอนามัย ทิชชูเปียก ทิชชูแห้ง สบู่ ยากันยุง แปรงสีฟัน ยาสีฟัน ชุดยาสามัญประจำบ้าน ฯลฯ บรรจุลงในถุงมูลนิธิป่อเต็กตึ๊ง จัดเป็น “ถุงยังชีพฉุกเฉิน” เพื่อนำส่งให้ทีมบรรเทาสาธารณภัย นำออกแจกจ่ายให้กับผู้ประสบภัยน้ำท่วมในพื้นที่จังหวัดอุตรดิตถ์ ณ บริเวณลานสำนักงานมูลนิธิป่อเต็กตึ๊ง พลับพลาไชย กรุงเทพฯ

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 10,
            "timer": {
                "start": 1775826606,
                "last": 1775826621,
                "now": 1775826624
            },
            "client": {
                "forwarded": "216.73.216.120"
            },
            "token": "MI8S7h5zLOnkfHmJciZFanvdZG0TtWlq"
        },
        "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": {
                "797774ca6c533373e8f63a5bb5c4fdf43d58fa14": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/63-flood-news\/2434-2022-10-10-15-27-24",
                    "expiry": 1775826609
                },
                "52ed94a81d35b6189352972690246aa5ba0cca14": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/63-flood-news\/4317-2025-11-23-13-16-16",
                    "expiry": 1775826611
                },
                "2638646ee84397cb7882812620029afe4cfd6fc0": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/63-flood-news\/3464-2024-09-30-07-12-03",
                    "expiry": 1775826613
                },
                "4ea8b6b4d045bfbe2412d14d9023c44a86e41572": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/63-flood-news\/4157-2025-09-06-03-00-23",
                    "expiry": 1775826616
                },
                "16f544bca04423c2c745c4617e2e1ce32d49b494": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/63-flood-news\/4361-2025-12-02-08-41-44",
                    "expiry": 1775826621
                },
                "90980d160064f097bad1c450e9ba82ead7aec4fa": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/37-disaster-news\/4208-2025-10-02-09-57-57",
                    "expiry": 1775826624
                }
            }
        }
    }
}

Profile Information

Time

Memory

Time: 2.50 ms / 2.50 ms Memory: 0.383 MB / 0.73 MB Application: afterLoad

Time: 18.10 ms / 20.60 ms Memory: 1.228 MB / 1.96 MB Application: afterInitialise

Time: 5.32 ms / 25.92 ms Memory: 0.551 MB / 2.51 MB Application: afterRoute

Time: 0.53 ms / 26.44 ms Memory: 0.040 MB / 2.55 MB Application: beforeRenderComponent com_content

Time: 0.76 ms / 27.20 ms Memory: 0.047 MB / 2.60 MB Application: Before Access::preloadComponents (all components)

Time: 0.71 ms / 27.92 ms Memory: 0.061 MB / 2.66 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 27.94 ms Memory: 0.000 MB / 2.65 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.23 ms / 28.17 ms Memory: 0.008 MB / 2.66 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 22.16 ms / 50.34 ms Memory: 0.663 MB / 3.33 MB Application: afterRenderComponent com_content

Time: 0.29 ms / 50.63 ms Memory: 0.008 MB / 3.33 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Time: 0.04 ms / 50.67 ms Memory: 0.007 MB / 3.34 MB Application: After Access::getAssetRules (id:1 name:root.1)

Time: 2.09 ms / 52.76 ms Memory: 0.039 MB / 3.38 MB Application: afterDispatch

Time: 506.58 ms / 559.34 ms Memory: 0.340 MB / 3.72 MB Application: beforeRenderModule mod_acymailing (Subscribe Module)

Time: 1.91 ms / 561.25 ms Memory: 0.111 MB / 3.83 MB Application: afterRenderRawModule mod_acymailing (Subscribe Module)

Time: 0.02 ms / 561.27 ms Memory: 0.000 MB / 3.82 MB Application: beforeRenderModule mod_acymailing (Subscribe Module)

Time: 0.24 ms / 561.51 ms Memory: 0.003 MB / 3.82 MB Application: afterRenderModule mod_acymailing (Subscribe Module)

Time: 2.44 ms / 563.96 ms Memory: 0.103 MB / 3.93 MB Application: beforeRenderModule mod_articles_categories (หมวดหมู่เทศกาล)

Time: 3.42 ms / 567.38 ms Memory: 0.166 MB / 4.09 MB Application: afterRenderRawModule mod_articles_categories (หมวดหมู่เทศกาล)

Time: 0.02 ms / 567.40 ms Memory: 0.000 MB / 4.09 MB Application: beforeRenderModule mod_articles_categories (หมวดหมู่เทศกาล)

Time: 0.17 ms / 567.57 ms Memory: 0.002 MB / 4.09 MB Application: afterRenderModule mod_articles_categories (หมวดหมู่เทศกาล)

Time: 0.30 ms / 567.87 ms Memory: 0.003 MB / 4.10 MB Application: beforeRenderModule mod_articles_latest (เทศกาลงานบุญ)

Time: 2.56 ms / 570.43 ms Memory: 0.123 MB / 4.22 MB Application: afterRenderRawModule mod_articles_latest (เทศกาลงานบุญ)

Time: 0.03 ms / 570.46 ms Memory: 0.000 MB / 4.14 MB Application: beforeRenderModule mod_articles_latest (เทศกาลงานบุญ)

Time: 0.17 ms / 570.63 ms Memory: 0.002 MB / 4.14 MB Application: afterRenderModule mod_articles_latest (เทศกาลงานบุญ)

Time: 0.35 ms / 570.99 ms Memory: 0.002 MB / 4.14 MB Application: beforeRenderModule mod_articles_categories (ประเภทการบริจาค)

Time: 1.20 ms / 572.19 ms Memory: 0.120 MB / 4.26 MB Application: afterRenderRawModule mod_articles_categories (ประเภทการบริจาค)

Time: 0.01 ms / 572.20 ms Memory: 0.000 MB / 4.26 MB Application: beforeRenderModule mod_articles_categories (ประเภทการบริจาค)

Time: 0.15 ms / 572.35 ms Memory: 0.002 MB / 4.27 MB Application: afterRenderModule mod_articles_categories (ประเภทการบริจาค)

Time: 0.33 ms / 572.68 ms Memory: 0.002 MB / 4.27 MB Application: beforeRenderModule mod_articles_latest (บริจาค)

Time: 2.17 ms / 574.84 ms Memory: 0.105 MB / 4.37 MB Application: afterRenderRawModule mod_articles_latest (บริจาค)

Time: 0.02 ms / 574.86 ms Memory: 0.000 MB / 4.30 MB Application: beforeRenderModule mod_articles_latest (บริจาค)

Time: 0.16 ms / 575.02 ms Memory: 0.003 MB / 4.30 MB Application: afterRenderModule mod_articles_latest (บริจาค)

Time: 0.38 ms / 575.39 ms Memory: 0.000 MB / 4.30 MB Application: beforeRenderModule mod_articles_categories (ประเภทข่าว)

Time: 6.15 ms / 581.54 ms Memory: 0.361 MB / 4.66 MB Application: afterRenderRawModule mod_articles_categories (ประเภทข่าว)

Time: 0.01 ms / 581.55 ms Memory: 0.000 MB / 4.66 MB Application: beforeRenderModule mod_articles_categories (ประเภทข่าว)

Time: 0.20 ms / 581.75 ms Memory: 0.002 MB / 4.66 MB Application: afterRenderModule mod_articles_categories (ประเภทข่าว)

Time: 0.45 ms / 582.20 ms Memory: 0.001 MB / 4.66 MB Application: beforeRenderModule mod_articles_latest (ข่าวล่าสุด)

Time: 85.39 ms / 667.59 ms Memory: 0.121 MB / 4.78 MB Application: afterRenderRawModule mod_articles_latest (ข่าวล่าสุด)

Time: 0.03 ms / 667.62 ms Memory: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_articles_latest (ข่าวล่าสุด)

Time: 0.18 ms / 667.81 ms Memory: 0.002 MB / 4.69 MB Application: afterRenderModule mod_articles_latest (ข่าวล่าสุด)

Time: 3.11 ms / 670.92 ms Memory: 0.471 MB / 5.16 MB Application: beforeRenderModule mod_articles_category (Week)

Time: 5.88 ms / 676.80 ms Memory: 0.209 MB / 5.37 MB Application: afterRenderRawModule mod_articles_category (Week)

Time: 0.02 ms / 676.82 ms Memory: 0.000 MB / 5.28 MB Application: beforeRenderModule mod_articles_category (Week)

Time: 0.15 ms / 676.96 ms Memory: 0.002 MB / 5.28 MB Application: afterRenderModule mod_articles_category (Week)

Time: 0.05 ms / 677.02 ms Memory: 0.008 MB / 5.29 MB Application: beforeRenderModule mod_articles_category (Month)

Time: 4.75 ms / 681.76 ms Memory: 0.143 MB / 5.43 MB Application: afterRenderRawModule mod_articles_category (Month)

Time: 0.02 ms / 681.78 ms Memory: 0.000 MB / 5.34 MB Application: beforeRenderModule mod_articles_category (Month)

Time: 0.14 ms / 681.92 ms Memory: 0.002 MB / 5.34 MB Application: afterRenderModule mod_articles_category (Month)

Time: 0.07 ms / 681.99 ms Memory: 0.004 MB / 5.35 MB Application: beforeRenderModule mod_articles_category (All)

Time: 4.81 ms / 686.79 ms Memory: 0.202 MB / 5.55 MB Application: afterRenderRawModule mod_articles_category (All)

Time: 0.02 ms / 686.81 ms Memory: 0.000 MB / 5.42 MB Application: beforeRenderModule mod_articles_category (All)

Time: 0.14 ms / 686.95 ms Memory: 0.002 MB / 5.42 MB Application: afterRenderModule mod_articles_category (All)

Time: 2.50 ms / 689.45 ms Memory: 0.000 MB / 5.39 MB Application: afterRender

Database queries total: 111.80 ms

Memory Usage

Database Queries

66 Queries Logged 111.80 ms

19 duplicate found!

7 duplicates: #17 #53 #54 #58 #60 #63 #66

2 duplicates: #19 #20

2 duplicates: #21 #22

2 duplicates: #23 #24

2 duplicates: #51 #61

2 duplicates: #52 #62

2 duplicates: #57 #65

Query Time: 0.26 ms Query memory: 0.023 MB Memory before query: 1.012 MB Rows returned: 1

SELECT `data`

  FROM `paew_session`

  WHERE `session_id` = 'jfinqkmk7qb1d9k4jilbtdfb1l'

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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 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.03 ms
preparing	0.01 ms
Unlocking tables	0.03 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.]

Query Time: 0.25 ms After last query: 1.52 ms Query memory: 0.021 MB Memory before query: 1.111 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.02 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.]

Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.123 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.03 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.04 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
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.]

Query Time: 1.14 ms After last query: 3.69 ms Query memory: 0.006 MB Memory before query: 1.516 MB

UPDATE `paew_extensions`

  SET `params` = '{\"mediaversion\":\"612700dc4a02ce1edbe0355daf112464\"}'

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

Explain

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

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.00 ms
init	0.05 ms
updating	0.05 ms
end	0.01 ms
query end	0.90 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
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.]

Query Time: 0.26 ms After last query: 1.54 ms Query memory: 0.004 MB Memory before query: 1.789 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.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.07 ms
updating	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
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.]

Query Time: 0.21 ms After last query: 4.56 ms Query memory: 0.020 MB Memory before query: 1.950 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.03 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.01 ms
optimizing	0.03 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.00 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.]

Query Time: 0.16 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 1.955 MB Rows returned: 1

SELECT count(*)

  FROM `paew_cwgears_schedule`

  WHERE time + '86400'<'1775826624'

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
Unlocking tables	0.00 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.00 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.]

Query Time: 0.20 ms After last query: 5.22 ms Query memory: 0.021 MB Memory before query: 2.506 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.03 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.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	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
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.]

Query Time: 0.52 ms After last query: 1.45 ms Query memory: 0.028 MB Memory before query: 2.603 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.04 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.03 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.21 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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.]

Query Time: 0.86 ms After last query: 0.60 ms Query memory: 0.031 MB Memory before query: 2.665 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `paew_content`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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.]

Query Time: 0.32 ms After last query: 1.01 ms Query memory: 0.022 MB Memory before query: 2.721 MB Rows returned: 1

SELECT *

  FROM paew_content

  WHERE `id` = '4208'

Explain

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

Profile

Status	Duration
starting	0.02 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.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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.]

Query Time: 1.50 ms After last query: 0.10 ms Query memory: 0.005 MB Memory before query: 2.730 MB

UPDATE paew_content

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

  WHERE `id` = '4208'

Explain

EXPLAIN not possible on query: UPDATE paew_content SET `hits` = (`hits` + 1) WHERE `id` = '4208'

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.00 ms
init	0.03 ms
updating	0.05 ms
end	0.01 ms
query end	1.29 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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.]

Query Time: 0.77 ms After last query: 3.67 ms Query memory: 0.023 MB Memory before query: 2.904 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM paew_content AS a

  INNER JOIN paew_categories AS c 
  on c.id = a.catid

  LEFT JOIN paew_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 4208 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-10 13:10:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-10 13:10:24') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,catid,state	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profile

Status	Duration
starting	0.18 ms
checking permissions	0.03 ms
checking permissions	0.01 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.06 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
13	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:423
12	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->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.]

Query Time: 0.77 ms After last query: 2.06 ms Query memory: 0.028 MB Memory before query: 2.987 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 37

  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.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.05 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Unlocking tables	0.03 ms
Sorting result	0.01 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.16 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->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.]

Query Time: 0.42 ms After last query: 0.51 ms Query memory: 0.022 MB Memory before query: 3.022 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.article' 
  AND `m`.`content_item_id` = 4208 
  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.05 ms
checking permissions	0.01 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.04 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.10 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/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->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.]

Query Time: 0.53 ms After last query: 1.48 ms Query memory: 0.025 MB Memory before query: 3.077 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 (37,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.01 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.06 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 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/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/article/view.html.php:193
11	ContentViewArticle->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.]

Query Time: 0.60 ms After last query: 4.20 ms Query memory: 0.025 MB Memory before query: 3.269 MB Rows returned: 1

Duplicate queries: #53 #54 #58 #60 #63 #66

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.10 ms
checking permissions	0.01 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.05 ms
optimizing	0.03 ms
statistics	0.07 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.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
15	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/com_content/article/default.php:43
14	include JROOT/templates/ja_focus/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:695
13	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
12	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->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.]

Query Time: 0.36 ms After last query: 3.47 ms Query memory: 0.020 MB Memory before query: 3.339 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.04 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.02 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
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.]

Query Time: 0.48 ms After last query: 4.06 ms Query memory: 0.023 MB Memory before query: 3.630 MB Rows returned: 1

Duplicate queries: #20

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.07 ms
checking permissions	0.01 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.07 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.09 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.]

Query Time: 0.34 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.638 MB Rows returned: 1

Duplicate queries: #19

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.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.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.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.]

Query Time: 0.45 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 3.646 MB Rows returned: 1

Duplicate queries: #22

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.08 ms
checking permissions	0.01 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.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
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.]

Query Time: 0.33 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.653 MB Rows returned: 1

Duplicate queries: #21

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.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
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.]

Query Time: 0.39 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.661 MB Rows returned: 1

Duplicate queries: #24

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.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.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
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.]

Query Time: 0.32 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.669 MB Rows returned: 1

Duplicate queries: #23

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.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.]

Query Time: 0.29 ms After last query: 502.01 ms Query memory: 0.027 MB Memory before query: 3.764 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.03 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.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 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.]

Query Time: 0.28 ms After last query: 0.66 ms Query memory: 0.023 MB Memory before query: 3.836 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.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.02 ms
optimizing	0.01 ms
statistics	0.03 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.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/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.]

Query Time: 0.24 ms After last query: 2.71 ms Query memory: 0.022 MB Memory before query: 3.919 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.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.01 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.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: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.]

Query Time: 0.45 ms After last query: 0.74 ms Query memory: 0.031 MB Memory before query: 4.031 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 26

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 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.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.45 ms After last query: 0.29 ms Query memory: 0.031 MB Memory before query: 4.055 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 27

  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.06 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.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.10 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.51 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 4.074 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 28

  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.09 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.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.45 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.094 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 29

  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.06 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.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.10 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.21 ms After last query: 0.40 ms Query memory: 0.022 MB Memory before query: 4.088 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.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.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	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
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.]

Query Time: 1.03 ms After last query: 0.64 ms Query memory: 0.061 MB Memory before query: 4.139 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-10 13:10:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-10 13:10:24')

  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	56	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.11 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.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.09 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.42 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
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.]

Query Time: 0.23 ms After last query: 1.22 ms Query memory: 0.022 MB Memory before query: 4.136 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.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.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	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
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.]

Query Time: 0.49 ms After last query: 0.59 ms Query memory: 0.031 MB Memory before query: 4.260 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 20

  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.07 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.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 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.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.24 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 4.260 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.03 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.02 ms
executing	0.01 ms
Sending data	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
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.]

Query Time: 0.88 ms After last query: 0.31 ms Query memory: 0.060 MB Memory before query: 4.295 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-10 13:10:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-10 13:10:24')

  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	27	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.12 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.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.33 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.]

Query Time: 0.24 ms After last query: 1.29 ms Query memory: 0.022 MB Memory before query: 4.290 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.04 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.00 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	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
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.]

Query Time: 0.65 ms After last query: 0.67 ms Query memory: 0.031 MB Memory before query: 4.514 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 35

  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.12 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.00 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.13 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.47 ms After last query: 0.29 ms Query memory: 0.031 MB Memory before query: 4.534 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 36

  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.07 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.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.45 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 4.553 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 38

  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.06 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.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.43 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 4.572 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 18

  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.06 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.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.46 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.592 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 40

  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.07 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.00 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.44 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.611 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 62

  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.06 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.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.44 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 4.639 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 63

  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.07 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.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.46 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.658 MB Rows returned: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 52

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
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.07 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.03 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 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
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
18	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php:13
17	require JROOT/templates/ja_focus/html/mod_articles_categories/default_items.php	JROOT/templates/ja_focus/html/mod_articles_categories/default.php:13
16	require JROOT/templates/ja_focus/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
15	include JROOT/modules/mod_articles_categories/mod_articles_categories.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.]

Query Time: 0.32 ms After last query: 0.42 ms Query memory: 0.022 MB Memory before query: 4.653 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.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.02 ms
optimizing	0.01 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.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.]

Query Time: 83.88 ms After last query: 0.43 ms Query memory: 0.060 MB Memory before query: 4.688 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-10 13:10:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-10 13:10:24')

  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	catid	4	base_pohtecktung1418.c.id	49	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.11 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.03 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.14 ms
preparing	0.05 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	43.21 ms
Creating sort index	9.48 ms
removing tmp table	30.49 ms
Creating sort index	0.04 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.]

Query Time: 0.25 ms After last query: 2.11 ms Query memory: 0.022 MB Memory before query: 4.669 MB Rows returned: 0

SELECT uikit

  FROM `paew_cwgears`

  WHERE url = 'https://www.pohtecktung.org/services-news/37-disaster-news/4208-2025-10-02-09-57-57'

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.02 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.]

Query Time: 0.15 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.676 MB Rows returned: 0

SELECT uikit_plus

  FROM `paew_cwgears`

  WHERE url = 'https://www.pohtecktung.org/services-news/37-disaster-news/4208-2025-10-02-09-57-57'

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.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.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.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 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.]

Query Time: 0.46 ms After last query: 2.49 ms Query memory: 0.025 MB Memory before query: 5.296 MB Rows returned: 1

Duplicate queries: #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 = 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.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.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.02 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.]

Query Time: 0.33 ms After last query: 0.70 ms Query memory: 0.025 MB Memory before query: 5.309 MB Rows returned: 1

Duplicate queries: #62

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 = 35
				
  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.]

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

Duplicate queries: #17 #54 #58 #60 #63 #66

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.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.]

Query Time: 0.33 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 5.329 MB Rows returned: 1

Duplicate queries: #17 #53 #58 #60 #63 #66

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.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.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
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.]

Query Time: 0.32 ms After last query: 0.54 ms Query memory: 0.025 MB Memory before query: 5.339 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 = 15
				
  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.]

Query Time: 0.50 ms After last query: 0.48 ms Query memory: 0.036 MB Memory before query: 5.413 MB Rows returned: 5

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `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 = 15

  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.08 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.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.11 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
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
35	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
34	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
33	ContentRouter->getCategorySegment()	Same as call in the line below.
32	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
31	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
30	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
29	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
28	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
25	Joomla\CMS\Router\Route::_()	JROOT/templates/ja_focus/html/layouts/joomla/content/image/image.php:21
24	include JROOT/templates/ja_focus/html/layouts/joomla/content/image/image.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:125
23	Joomla\CMS\Layout\_FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
22	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/templates/ja_focus/html/layouts/joomla/content/image/article.php:33
21	include JROOT/templates/ja_focus/html/layouts/joomla/content/image/article.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:125
20	Joomla\CMS\Layout\_FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
19	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/templates/ja_focus/html/layouts/joomla/content/intro_image.php:20
18	include JROOT/templates/ja_focus/html/layouts/joomla/content/intro_image.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:125
17	Joomla\CMS\Layout\_FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
16	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:123
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.]

Query Time: 0.33 ms After last query: 0.78 ms Query memory: 0.025 MB Memory before query: 5.389 MB Rows returned: 1

Duplicate queries: #65

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.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.]

Query Time: 0.34 ms After last query: 0.60 ms Query memory: 0.025 MB Memory before query: 5.400 MB Rows returned: 1

Duplicate queries: #17 #53 #54 #60 #63 #66

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.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.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.]

Query Time: 0.33 ms After last query: 0.54 ms Query memory: 0.025 MB Memory before query: 5.410 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 = 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.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.]

Query Time: 0.34 ms After last query: 0.52 ms Query memory: 0.025 MB Memory before query: 5.420 MB Rows returned: 1

Duplicate queries: #17 #53 #54 #58 #63 #66

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.03 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.]

Query Time: 0.35 ms After last query: 0.51 ms Query memory: 0.025 MB Memory before query: 5.430 MB Rows returned: 1

Duplicate queries: #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 = 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.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.]

Query Time: 0.33 ms After last query: 1.16 ms Query memory: 0.025 MB Memory before query: 5.496 MB Rows returned: 1

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 = 35
				
  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.]

Query Time: 0.33 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 5.507 MB Rows returned: 1

Duplicate queries: #17 #53 #54 #58 #60 #66

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.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.]

Query Time: 0.33 ms After last query: 0.54 ms Query memory: 0.025 MB Memory before query: 5.517 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 = 27
				
  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.]

Query Time: 0.36 ms After last query: 0.52 ms Query memory: 0.030 MB Memory before query: 5.536 MB Rows returned: 1

Duplicate queries: #57

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.03 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.]

Query Time: 0.37 ms After last query: 0.52 ms Query memory: 0.025 MB Memory before query: 5.551 MB Rows returned: 1

Duplicate queries: #17 #53 #54 #58 #60 #63

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.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.03 ms
executing	0.00 ms
Sending data	0.09 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.]

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

22 × 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

15 × 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)

6 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params 
  FROM paew_modules AS m

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

1 × SELECT `data` 
  FROM `paew_session`

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

1 × SELECT uikit 
  FROM `paew_cwgears`

1 × SELECT * 
  FROM paew_acymailing_list

1 × SELECT * 
  FROM paew_acymailing_confi

```
1 × select b.* 
  from paew_rstbox b
```

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

1 × SELECT id, rules 
  FROM `paew_viewlevels

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM paew_content AS a 
  INNER JOIN paew_categories AS c 
  on c.id = a.catid 
  LEFT JOIN paew_users AS u 
  on u.id = a.created_by 
  LEFT JOIN paew_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN paew_content_rating AS v 
  ON a.id = v.content_id

```
1 × SELECT * 
  FROM paew_content
```

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

1 × SELECT count(*) 
  FROM `paew_extensions`

1 × SELECT count(*) 
  FROM `paew_cwgears_schedule`

1 × SELECT count(*) 
  FROM `paew_cwgears_schedule

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

1 × SELECT uikit_plus 
  FROM `paew_cwgears`

OTHER Tables:

1 × UPDATE `paew_extensions` 
  SET `params` = '{\"mediaversion\":\"612700dc4a02ce1edbe0355daf112464\"}'

1 × UPDATE paew_extensions 
  SET enabled=1

1 × SHOW FULL COLUMNS 
  FROM `paew_content

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

Sidebar

หมวดหมู่เมนู

เมนูข่าวสาร

หมวดหมู่เทศกาล

เทศกาลงานบุญ

ประเภทการบริจาค

บริจาค

ประเภทข่าว

ข่าวล่าสุด

Follow Us

Latest News

Most Read

Week

Month

All

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

66 Queries Logged 111.80 ms

19 duplicate found!

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: