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

ป่อเต็กตึ๊งรุดดูแลสุขภาพพี่น้องชาวโนนสุวรรณ ขนทัพหน่วยแพทย์เ...

มูลนิธิป่อเต็กตึ๊ง ลงพื้นที่จังหวัดสมุทรสงคราม เยียวยาผู้ประสบอัคคีภัย 2 อำเภอ มอบเงินและสิ่งของบรรเทาทุกข์ รวมกว่า 2.6 หมื่นบาท

วานนี้ (วันที่ 8 เมษายน พ.ศ. 2569) เวลา 09.00 น. มูลนิธิป่อเต็กตึ๊ง ฝ่ายสาธารณภัย นำโดย นายภูวดล จินดาวรเวทย์ และ นายวุฒิพงษ์ หอมดาวเรือง เจ้าหน้าที่แผนกสาธารณภัย ลงพื้นที่จังหวัดสมุทรสงคราม ร่วมกับ นางสาวเภารำไพ จรรยา หัวหน้าสำนักงานป้องกันและบรรเทาสาธารณภัยจังหวัดสมุทรสงคราม (ปภ.) เพื่อให้ความช่วยเหลือผู้ประสบอัคคีภัยจำนวน 2 พื้นที่ รวม 3 หลังคาเรือน ดังนี้:

จุดที่ 1 (อ.อัมพวา): ณ บ้านเลขที่ -/7 หมู่ 7 ต.บางแค มีผู้ประสบภัย 1 ครอบครัว (รวม 4 คน) มอบเงินสดคนละ 3,500 บาท เป็นเงิน 14,000 บาท พร้อมเครื่องอุปโภคบริโภครายครอบครัว 1 ชุด มูลค่า 2,500 บาท โดยมี นายธนะวิโรจน์ เอกสินธุ์ นายก อบต.บางแค ร่วมในพิธีมอบ
จุดที่ 2 (อ.บางคนที): ณ พื้นที่หมู่ 10 ต.กระดังงา ช่วยเหลือผู้ประสบภัย 2 หลังคาเรือน (รวม 2 คน) มอบเงินสดคนละ 3,500 บาท และเครื่องอุปโภคบริโภครายบุคคล หลังละ 1 ชุด (ชุดละ 1,500 บาท) โดยมี นางจินตนา กลิ่นช้าง นายก อบต.กระดังงา ร่วมในพิธีมอบ

รวมการดำเนินการช่วยเหลือผู้ประสบอัคคีภัยทั้ง 2 แห่ง เป็นเงินทั้งสิ้น 26,500 บาท (สองหมื่นหกพันห้าร้อยบาทถ้วน)

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1775728899,
                "last": 1775728899,
                "now": 1775728900
            },
            "client": {
                "forwarded": "216.73.216.120"
            },
            "token": "kk05gHYW3DQCxzUHRUmUrk65F0YWON9P"
        },
        "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": {
            "formtime": 1775728900,
            "links": {
                "eb89f8ff3aaca5ae2a4aa2d0081aae305a4b45bb": {
                    "link": "https:\/\/www.pohtecktung.org\/services-news\/37-disaster-news\/4612-2-2-6",
                    "expiry": 1775728900
                }
            }
        }
    }
}

Profile Information

Time

Memory

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

Time: 15.78 ms / 18.07 ms Memory: 1.222 MB / 1.95 MB Application: afterInitialise

Time: 5.52 ms / 23.59 ms Memory: 0.551 MB / 2.50 MB Application: afterRoute

Time: 0.47 ms / 24.06 ms Memory: 0.040 MB / 2.54 MB Application: beforeRenderComponent com_content

Time: 0.79 ms / 24.85 ms Memory: 0.047 MB / 2.59 MB Application: Before Access::preloadComponents (all components)

Time: 0.72 ms / 25.57 ms Memory: 0.061 MB / 2.65 MB Application: After Access::preloadComponents (all components)

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

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

Time: 20.47 ms / 46.27 ms Memory: 0.585 MB / 3.24 MB Application: afterRenderComponent com_content

Time: 0.26 ms / 46.53 ms Memory: 0.008 MB / 3.25 MB Application: Before Access::getAssetRules (id:1 name:root.1)

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

Time: 1.89 ms / 48.45 ms Memory: 0.039 MB / 3.29 MB Application: afterDispatch

Time: 437.49 ms / 485.94 ms Memory: 0.332 MB / 3.63 MB Application: beforeRenderModule mod_acymailing (Subscribe Module)

Time: 1.93 ms / 487.87 ms Memory: 0.111 MB / 3.74 MB Application: afterRenderRawModule mod_acymailing (Subscribe Module)

Time: 0.03 ms / 487.90 ms Memory: 0.000 MB / 3.73 MB Application: beforeRenderModule mod_acymailing (Subscribe Module)

Time: 0.28 ms / 488.18 ms Memory: 0.002 MB / 3.73 MB Application: afterRenderModule mod_acymailing (Subscribe Module)

Time: 2.63 ms / 490.81 ms Memory: 0.104 MB / 3.84 MB Application: beforeRenderModule mod_articles_categories (หมวดหมู่เทศกาล)

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

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

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

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

Time: 2.60 ms / 497.38 ms Memory: 0.123 MB / 4.13 MB Application: afterRenderRawModule mod_articles_latest (เทศกาลงานบุญ)

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

Time: 0.19 ms / 497.60 ms Memory: 0.002 MB / 4.05 MB Application: afterRenderModule mod_articles_latest (เทศกาลงานบุญ)

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

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

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

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

Time: 0.31 ms / 499.56 ms Memory: 0.002 MB / 4.18 MB Application: beforeRenderModule mod_articles_latest (บริจาค)

Time: 2.02 ms / 501.58 ms Memory: 0.105 MB / 4.28 MB Application: afterRenderRawModule mod_articles_latest (บริจาค)

Time: 0.03 ms / 501.61 ms Memory: 0.000 MB / 4.20 MB Application: beforeRenderModule mod_articles_latest (บริจาค)

Time: 0.17 ms / 501.78 ms Memory: 0.003 MB / 4.21 MB Application: afterRenderModule mod_articles_latest (บริจาค)

Time: 0.34 ms / 502.12 ms Memory: 0.000 MB / 4.21 MB Application: beforeRenderModule mod_articles_categories (ประเภทข่าว)

Time: 6.02 ms / 508.14 ms Memory: 0.353 MB / 4.56 MB Application: afterRenderRawModule mod_articles_categories (ประเภทข่าว)

Time: 0.02 ms / 508.15 ms Memory: 0.000 MB / 4.56 MB Application: beforeRenderModule mod_articles_categories (ประเภทข่าว)

Time: 0.19 ms / 508.34 ms Memory: 0.002 MB / 4.56 MB Application: afterRenderModule mod_articles_categories (ประเภทข่าว)

Time: 0.30 ms / 508.65 ms Memory: 0.001 MB / 4.56 MB Application: beforeRenderModule mod_articles_latest (ข่าวล่าสุด)

Time: 117.88 ms / 626.53 ms Memory: 0.124 MB / 4.69 MB Application: afterRenderRawModule mod_articles_latest (ข่าวล่าสุด)

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

Time: 0.27 ms / 626.83 ms Memory: 0.002 MB / 4.60 MB Application: afterRenderModule mod_articles_latest (ข่าวล่าสุด)

Time: 4.01 ms / 630.85 ms Memory: 0.331 MB / 4.93 MB Application: beforeRenderModule mod_articles_category (Week)

Time: 5.70 ms / 636.55 ms Memory: 0.210 MB / 5.14 MB Application: afterRenderRawModule mod_articles_category (Week)

Time: 0.03 ms / 636.58 ms Memory: 0.000 MB / 5.01 MB Application: beforeRenderModule mod_articles_category (Week)

Time: 0.15 ms / 636.72 ms Memory: 0.002 MB / 5.01 MB Application: afterRenderModule mod_articles_category (Week)

Time: 0.06 ms / 636.78 ms Memory: 0.008 MB / 5.02 MB Application: beforeRenderModule mod_articles_category (Month)

Time: 4.92 ms / 641.70 ms Memory: 0.177 MB / 5.20 MB Application: afterRenderRawModule mod_articles_category (Month)

Time: 0.03 ms / 641.72 ms Memory: 0.000 MB / 5.08 MB Application: beforeRenderModule mod_articles_category (Month)

Time: 0.15 ms / 641.87 ms Memory: 0.002 MB / 5.08 MB Application: afterRenderModule mod_articles_category (Month)

Time: 0.08 ms / 641.95 ms Memory: 0.004 MB / 5.08 MB Application: beforeRenderModule mod_articles_category (All)

Time: 8.71 ms / 650.66 ms Memory: 0.203 MB / 5.29 MB Application: afterRenderRawModule mod_articles_category (All)

Time: 0.03 ms / 650.69 ms Memory: 0.000 MB / 5.16 MB Application: beforeRenderModule mod_articles_category (All)

Time: 0.15 ms / 650.84 ms Memory: 0.002 MB / 5.16 MB Application: afterRenderModule mod_articles_category (All)

Time: 2.68 ms / 653.53 ms Memory: 0.005 MB / 5.16 MB Application: afterRender

Database queries total: 149.19 ms

Memory Usage

Database Queries

65 Queries Logged 149.19 ms

20 duplicate found!

3 duplicates: #17 #53 #60

2 duplicates: #19 #20

5 duplicates: #21 #22 #56 #61 #62

2 duplicates: #23 #24

4 duplicates: #51 #57 #63 #65

4 duplicates: #52 #54 #58 #64

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

SELECT `data`

  FROM `paew_session`

  WHERE `session_id` = 'qme4m34qde3arfbe5tc54c18uv'

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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.01 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
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.21 ms After last query: 1.35 ms Query memory: 0.021 MB Memory before query: 1.105 MB Rows returned: 5

SELECT id, rules

  FROM `paew_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 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.25 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.117 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.01 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.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.02 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: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: 0.27 ms After last query: 3.48 ms Query memory: 0.006 MB Memory before query: 1.510 MB

UPDATE `paew_extensions`

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

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

Explain

EXPLAIN not possible on query: UPDATE `paew_extensions` SET `params` = '{\"mediaversion\":\"f5a69a4da88d89979821c0967f0395c3\"}' 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.01 ms
System lock	0.00 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.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.24 ms After last query: 1.34 ms Query memory: 0.004 MB Memory before query: 1.783 MB

UPDATE paew_extensions

  SET enabled=1

  WHERE `type`='plugin' 
  AND `element`='jacontenttype' 
  AND `folder`='ajax'

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.05 ms
updating	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
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.19 ms After last query: 4.40 ms Query memory: 0.020 MB Memory before query: 1.944 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.02 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
executing	0.01 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
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.21 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 1.949 MB Rows returned: 1

SELECT count(*)

  FROM `paew_cwgears_schedule`

  WHERE time + '86400'<'1775728900'

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.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 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.46 ms After last query: 5.16 ms Query memory: 0.021 MB Memory before query: 2.500 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.01 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.53 ms After last query: 1.42 ms Query memory: 0.028 MB Memory before query: 2.597 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.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.22 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.91 ms After last query: 0.56 ms Query memory: 0.031 MB Memory before query: 2.659 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.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.19 ms
After opening tables	0.01 ms
System lock	0.01 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.04 ms
checking permissions	0.04 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.02 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.02 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.01 ms
closing tables	0.00 ms
removing tmp table	0.09 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
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.28 ms After last query: 0.86 ms Query memory: 0.022 MB Memory before query: 2.715 MB Rows returned: 1

SELECT *

  FROM paew_content

  WHERE `id` = '4612'

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.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 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: 5.30 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 2.726 MB

UPDATE paew_content

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

  WHERE `id` = '4612'

Explain

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

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.00 ms
init	0.03 ms
updating	0.05 ms
end	0.01 ms
query end	5.07 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
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.55 ms After last query: 1.44 ms Query memory: 0.039 MB Memory before query: 2.900 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 = 4612 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-04-09 10:01:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 10:01:40') 
  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.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 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.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.49 ms After last query: 1.26 ms Query memory: 0.028 MB Memory before query: 2.984 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.08 ms
checking permissions	0.01 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.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
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.38 ms After last query: 0.40 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` = 4612 
  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.03 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.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.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
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.59 ms After last query: 1.21 ms Query memory: 0.025 MB Memory before query: 3.076 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.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.03 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.43 ms After last query: 3.06 ms Query memory: 0.025 MB Memory before query: 3.239 MB Rows returned: 1

Duplicate queries: #53 #60

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.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.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.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.34 ms After last query: 3.28 ms Query memory: 0.020 MB Memory before query: 3.255 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.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.01 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.00 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: 3.66 ms Query memory: 0.023 MB Memory before query: 3.546 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.06 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.09 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.32 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 3.554 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.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/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.31 ms After last query: 0.05 ms Query memory: 0.023 MB Memory before query: 3.562 MB Rows returned: 1

Duplicate queries: #22 #56 #61 #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 = 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.03 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.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/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.569 MB Rows returned: 1

Duplicate queries: #21 #56 #61 #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 = 13
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/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.30 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 3.577 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.03 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.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/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.585 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.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.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.04 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.28 ms After last query: 433.42 ms Query memory: 0.027 MB Memory before query: 3.672 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.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.01 ms
executing	0.01 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
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.27 ms After last query: 0.70 ms Query memory: 0.023 MB Memory before query: 3.744 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.00 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
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.22 ms After last query: 2.94 ms Query memory: 0.022 MB Memory before query: 3.827 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.01 ms
System lock	0.01 ms
Table lock	0.01 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.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: 0.47 ms After last query: 0.73 ms Query memory: 0.031 MB Memory before query: 3.939 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.01 ms
System lock	0.00 ms
Table lock	0.01 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.08 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
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.49 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 3.963 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.11 ms
checking permissions	0.01 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.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.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.51 ms After last query: 0.24 ms Query memory: 0.031 MB Memory before query: 3.982 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.07 ms
checking permissions	0.01 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.14 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.001 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.01 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.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.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.21 ms After last query: 0.43 ms Query memory: 0.022 MB Memory before query: 3.996 MB Rows returned: 1

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

  FROM paew_modules AS m

  WHERE m.id = 126 
  AND m.published = 1 
  AND m.access IN (1,1,5)

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.02 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: 1.07 ms After last query: 0.57 ms Query memory: 0.061 MB Memory before query: 4.047 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-09 10:01:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 10:01:40')

  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	49	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.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
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.13 ms
preparing	0.12 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.37 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
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.044 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.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 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.03 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.50 ms After last query: 0.53 ms Query memory: 0.031 MB Memory before query: 4.168 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.09 ms
checking permissions	0.01 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.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.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.22 ms After last query: 0.35 ms Query memory: 0.022 MB Memory before query: 4.167 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.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.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.01 ms

Call Stack

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

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

Query Time: 0.89 ms After last query: 0.29 ms Query memory: 0.060 MB Memory before query: 4.203 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-09 10:01:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 10:01:40')

  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	23	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.01 ms
checking permissions	0.01 ms
checking permissions	0.00 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.08 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.32 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
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.22 ms After last query: 1.16 ms Query memory: 0.022 MB Memory before query: 4.197 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.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.01 ms
optimizing	0.01 ms
statistics	0.02 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.46 ms After last query: 0.64 ms Query memory: 0.031 MB Memory before query: 4.422 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.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.05 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.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.48 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 4.441 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.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.08 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.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.22 ms Query memory: 0.031 MB Memory before query: 4.461 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.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 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.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.46 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 4.480 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.09 ms
checking permissions	0.01 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.04 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.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.49 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.500 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.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.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 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.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.44 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.519 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.07 ms
checking permissions	0.01 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.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.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.25 ms Query memory: 0.031 MB Memory before query: 4.539 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.08 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.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.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.50 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 4.558 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.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.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.01 ms
Sending data	0.02 ms
Creating sort index	0.12 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.21 ms After last query: 0.39 ms Query memory: 0.022 MB Memory before query: 4.552 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.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.01 ms
optimizing	0.01 ms
statistics	0.02 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: 115.92 ms After last query: 0.38 ms Query memory: 0.060 MB Memory before query: 4.596 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-09 10:01:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-09 10:01:40')

  ORDER BY a.created DESC 
  LIMIT 4

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	46	Using where; Using temporary; Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,catid,state	idx_catid	4	base_pohtecktung1418.c.id	67	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.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	54.45 ms
Creating sort index	14.72 ms
removing tmp table	41.85 ms
Creating sort index	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.03 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.28 ms After last query: 3.01 ms Query memory: 0.022 MB Memory before query: 4.577 MB Rows returned: 0

SELECT uikit

  FROM `paew_cwgears`

  WHERE url = 'https://www.pohtecktung.org/services-news/37-disaster-news/4612-2-2-6'

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 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.01 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.21 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 4.583 MB Rows returned: 0

SELECT uikit_plus

  FROM `paew_cwgears`

  WHERE url = 'https://www.pohtecktung.org/services-news/37-disaster-news/4612-2-2-6'

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.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 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.01 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.47 ms After last query: 3.25 ms Query memory: 0.025 MB Memory before query: 5.099 MB Rows returned: 0

Duplicate queries: #57 #63 #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 = 63
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

Status	Duration
starting	0.05 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.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 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.02 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.76 ms Query memory: 0.025 MB Memory before query: 5.112 MB Rows returned: 1

Duplicate queries: #54 #58 #64

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

Call Stack

#	Caller	File and line number
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.55 ms Query memory: 0.025 MB Memory before query: 5.122 MB Rows returned: 1

Duplicate queries: #17 #60

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.01 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.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 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.132 MB Rows returned: 1

Duplicate queries: #52 #58 #64

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.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.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.35 ms After last query: 0.54 ms Query memory: 0.025 MB Memory before query: 5.142 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.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
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: 1.28 ms Query memory: 0.025 MB Memory before query: 5.156 MB Rows returned: 1

Duplicate queries: #21 #22 #61 #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 = 13
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.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.54 ms Query memory: 0.025 MB Memory before query: 5.166 MB Rows returned: 0

Duplicate queries: #51 #63 #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 = 63
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

Status	Duration
starting	0.05 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.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.03 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
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.53 ms Query memory: 0.025 MB Memory before query: 5.176 MB Rows returned: 1

Duplicate queries: #52 #54 #64

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 5.186 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 = 29
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/templates/ja_focus/helper.php:41
16	JATemplateHelper::getCustomFields()	JROOT/templates/ja_focus/html/mod_articles_category/news-9.php:112
15	require JROOT/templates/ja_focus/html/mod_articles_category/news-9.php	JROOT/modules/mod_articles_category/mod_articles_category.php:90
14	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
13	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/plugins/system/jatabs/jatabs.php:324
11	plgSystemjatabs->parseTabModules()	JROOT/plugins/system/jatabs/jatabs.php:252
10	plgSystemjatabs->Jatabs_replacer_DIRECT()	JROOT/plugins/system/jatabs/jatabs/parser.php:159
9	ReplaceCallbackParserTabs->callBack()	JROOT/plugins/system/jatabs/jatabs/parser.php:103
8	ReplaceCallbackParserTabs->parse()	JROOT/plugins/system/jatabs/jatabs.php:115
7	plgSystemjatabs->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicate queries: #17 #53

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.60 ms After last query: 1.27 ms Query memory: 0.025 MB Memory before query: 5.232 MB Rows returned: 1

Duplicate queries: #21 #22 #56 #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 = 13
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.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: 3.51 ms After last query: 0.56 ms Query memory: 0.025 MB Memory before query: 5.243 MB Rows returned: 1

Duplicate queries: #21 #22 #56 #61

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.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.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.]

Query Time: 0.42 ms After last query: 0.78 ms Query memory: 0.025 MB Memory before query: 5.253 MB Rows returned: 0

Duplicate queries: #51 #57 #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 = 63
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 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.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.37 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 5.262 MB Rows returned: 1

Duplicate queries: #52 #54 #58

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.54 ms Query memory: 0.030 MB Memory before query: 5.282 MB Rows returned: 0

Duplicate queries: #51 #57 #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 = 63
				
  AND f.context = "com_content.categories"
				
  AND f.language IN ("*", "en-GB")
				
  AND f.access = 1

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.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.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.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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

14 × 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\":\"f5a69a4da88d89979821c0967f0395c3\"}'

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

65 Queries Logged 149.19 ms

20 duplicate found!

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: