NEWYDDION

CYNHADLEDD FLYNYDDOL UCAC

5-6 Mai 2023

Cynhaliwyd Cynhadledd Flynyddol UCAC 2023 yng Ngwesty’r Coldra Court, ger Casnewydd ar 5-6 Mai, 2023. Cafwyd cyfle i drafod materion byd addysg mewn cyfarfodydd ffurfiol, yn ogystal â chyfle i drafod a chymdeithasu yn anffurfiol.

Roedd y cynigion a ddaeth gerbron yn adlewyrchiad teg o’r hyn sydd ar frig agenda byd addysg ar hyn o bryd , yn eu plith materion yn ymwneud ag amodau gwaith, y Cwricwlwm i Gymru, Bil Addysg y Gymraeg. Mae’n siŵr y bydd y materion hyn yn bynciau trafod pellach o fewn yr undeb ac yn ehangach yn ystod y flwyddyn sydd i ddod.

Datblygiadau digidol a’r Cwricwlwm i Gymru oedd themâu ein siaradwyr eleni a braf oedd gwrando ar gyfraniadau ysbrydoledig Meredudd Jones ac Alan Thomas-Williams, y naill yn siarad am ei waith ym maes Technoleg Gwybodaeth a'r llall yn siarad am ei waith ar y Cwricwlwm i Gymru. Cafwyd cyfle nid yn unig i glywed am y gwaith arbennig y mae’r ddau wedi ei wneud ond neilltuwyd amser hefyd i aelodau holi cwestiynau.

AMDDIFFYN YR HAWL I STREICIO – RALI TUC CYMRU

3 Chwefror 2023

Ddydd Mercher, 1 Chwefror, roedd Ioan Rhys Jones, Ysgrifennydd Cyffredinol UCAC, ymhlith y siaradwyr yn rali TUC Cymru, Amddiffyn yr Hawl i Streicio. Cynhaliwyd y rali yng Nghaerdydd mewn ymateb i’r camau sy’n cael eu cymryd gan Lywodraeth San Steffan i gyflwyno deddfwriaeth gwrth-undebol a fyddai’n cyfyngu ar hawliau unigolion i streicio. Mae’r gyfraith arfaethedig yn golygu y gellid gorfodi gweithwyr i weithio, er eu bod wedi pleidleisio’n ddemocrataidd i streicio. Dywedodd Ioan, “Mae’n bwysig ein bod yn amddiffyn rhyddid gweithwyr a’u hawl i leisio eu barn a gweithredu er mwyn amddiffyn eu cyflog a’u hamodau gwaith. Mae UCAC yn falch o sefyll dros hawliau ei haelodau.”

Roedd cannoedd yn bresennol yn y rali yng Nghaerdydd ac mae dros 200,000 o bobl eisoes wedi llofnodi deiseb yn erbyn y ddeddfwriaeth gwrth streicio.

Canlyniad Balot Diwydiannol UCAC

17 Ionawr 2023

Pleidleisiodd mwyafrif mawr o’r rhai a bleidleisiodd o blaid mynd ar streic, fodd bynnag, ni lwyddwyd i gyrraedd y trothwy angenrheidiol o 50% o bleidleisiau wedi eu dychwelyd i weithredu.

Pleidleisiau a fwriwyd fel canran o’r unigolion a oedd â’r hawl i bleidleisio 45.19%

Cwestiwn: Ydych chi’n barod i gymryd rhan mewn streic?

Nifer y papurau a ddifethwyd, neu yn annilys 0

Canlyniad y Bleidlais

Ydw 88.62%

Nac Ydw 11.38%

Byddwn felly yn ymgynnull cyfarfod brys o’r Cyngor Cenedlaethol wythnos nesaf i drafod y ffordd ymlaen. Yn y cyfamser bydd UCAC yn parhau i drafod gyda’r Llywodraeth a’r Awdurdodau ar ran aelodau o ran llwyth gwaith a chyflog.

Dogfen Cyflog ac Amodau Athrawon Ysgol (Cymru) 2022

21 Tachwedd 2022

Mae Dogfen Cyflog ac Amodau Gwaith Athrawon Ysgol (Cymru) 2022 bellach ar wefan llywodraeth Cymru.

Isod mae dolenni i ddatganiad ysgrifenedig gan y Gweinidog Addysg a’r Gymraeg, yn derbyn holl argymhellion Corff Adolygu Cyflogau Annibynnol Cymru ar gyfer 2022/23 ac i’r Ddogfen Cyflog ac Amodau Gwaith Athrawon Ysgol (Cymru) 2022 ddiwygiedig.

https://llyw.cymru/datganiad-ysgrifenedig-dyfarniad-cyflog-athrawon-2022

https://llyw.cymru/dogfen-cyflog-ac-amodau-athrawon-ysgol-cymru-2022

Os ydych yn gweithio'n rhan amser ac yn derbyn CAD, cofiwch ei bod yn bwysig gwirio gyda’ch pennaeth a ydych yn gymwys bellach i dderbyn CAD yn llawn.

Newidiadau i drefniadau sefydlu statudol athrawon newydd gymhwyso yng Nghymru

7 Tachwedd 2022

Yn dilyn ymgynghoriad cyhoeddus ar gynigion i newid trefniadau sefydlu statudol athrawon newydd gymhwyso yng Nghymru, mae newidiadau’n dod i rym o 7 Tachwedd. Cyhoeddwyd rheoliadau sefydlu a chanllawiau diwygiedig yr wythnos hon ar gyfer pob parti sy’n ymwneud â threfniadau sefydlu ar gyfer athrawon newydd gymhwyso yng Nghymru.

Mae’r newidiadau’n cynnwys:

caniatáu ymgymryd â chyfnod sefydlu mewn Unedau Cyfeirio Disgyblion
cyflwyno hyblygrwydd: mae gan Gyrff Priodol ddisgresiwn i leihau hyd y cyfnod sefydlu ar gyfer athrawon newydd gymhwyso sy’n gallu dangos eu bod yn bodloni’r safonau proffesiynol mewn llai na thri thymor / 380 o sesiynau
cyflwyno terfyn amser ar gyfer cwblhau cyfnod sefydlu yn foddhaol

Mae canllawiau diwygiedig ar yr holl newidiadau wedi’u cyhoeddi ar Hwb.

Mwy o Erthyglau...

Cysylltu â ni

Prif Swyddfa UCAC
Ffordd Penglais
Aberystwyth
Ceredigion SY23 2EU

01970 639950
Mae'r cyfeiriad e-bost hwn wedi'i warchod rhag robotiaid sbam. Rhaid i chi alluogi JavaScript i'w weld.

Darllenodd y rhan fwyaf

Newyddion poblogaidd

Dilynwch ni

Polisi preifatrwydd

©UCAC Holl hawliau ar gadw. Datblygwyd gan AIM Development

Consol Difa Chwilod Joomla!

Sesiwn

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

Gwybodaeth Proffil

Amser

Cof

Amser: 2.18 ms / 2.18 ms Cof: 0.342 MB / 0.67 MB Application: afterLoad

Amser: 28.73 ms / 30.91 ms Cof: 0.991 MB / 1.66 MB Application: afterInitialise

Amser: 4.38 ms / 35.29 ms Cof: 0.192 MB / 1.85 MB Application: afterRoute

Amser: 52.29 ms / 87.58 ms Cof: 0.032 MB / 1.88 MB Application: beforeRenderComponent com_content

Amser: 3.32 ms / 90.90 ms Cof: 0.147 MB / 2.03 MB Application: Before Access::preloadComponents (all components)

Amser: 1.84 ms / 92.74 ms Cof: 0.052 MB / 2.08 MB Application: After Access::preloadComponents (all components)

Amser: 0.05 ms / 92.79 ms Cof: -0.001 MB / 2.08 MB Application: Before Access::preloadPermissions (com_content)

Amser: 2.76 ms / 95.55 ms Cof: 0.508 MB / 2.59 MB Application: After Access::preloadPermissions (com_content)

Amser: 0.06 ms / 95.61 ms Cof: -0.018 MB / 2.57 MB Application: Before Access::getAssetRules (id:122 name:com_content.category.10)

Amser: 0.27 ms / 95.88 ms Cof: 0.011 MB / 2.58 MB Application: After Access::getAssetRules (id:122 name:com_content.category.10)

Amser: 5.19 ms / 101.07 ms Cof: 0.027 MB / 2.61 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Amser: 0.03 ms / 101.10 ms Cof: 0.001 MB / 2.61 MB Application: After Access::getAssetRules (id:8 name:com_content)

Amser: 35.76 ms / 136.86 ms Cof: 1.502 MB / 4.11 MB Application: afterRenderComponent com_content

Amser: 5.31 ms / 142.17 ms Cof: 0.054 MB / 4.17 MB Application: afterDispatch

Amser: 2.59 ms / 144.76 ms Cof: 0.148 MB / 4.31 MB Application: beforeRenderModule mod_yootheme_builder (Footer - Welsh)

Amser: 0.09 ms / 144.85 ms Cof: 0.004 MB / 4.32 MB Application: afterRenderModule mod_yootheme_builder (Footer - Welsh)

Amser: 0.39 ms / 145.24 ms Cof: 0.106 MB / 4.42 MB Application: beforeRenderModule mod_articles_popular (Most Read (Welsh))

Amser: 4.60 ms / 149.84 ms Cof: 0.248 MB / 4.67 MB Application: afterRenderModule mod_articles_popular (Most Read (Welsh))

Amser: 0.18 ms / 150.02 ms Cof: -0.188 MB / 4.48 MB Application: beforeRenderModule mod_articles_popular (Most Read - Welsh News (Welsh))

Amser: 4.71 ms / 154.73 ms Cof: 0.079 MB / 4.56 MB Application: afterRenderModule mod_articles_popular (Most Read - Welsh News (Welsh))

Amser: 2.86 ms / 157.59 ms Cof: -0.068 MB / 4.49 MB Application: beforeRenderModule mod_languages (Language Selector)

Amser: 0.86 ms / 158.45 ms Cof: 0.015 MB / 4.51 MB Application: afterRenderModule mod_languages (Language Selector)

Amser: 0.19 ms / 158.64 ms Cof: -0.004 MB / 4.50 MB Application: beforeRenderModule mod_menu ()

Amser: 1.33 ms / 159.97 ms Cof: 0.226 MB / 4.73 MB Application: afterRenderModule mod_menu ()

Amser: 0.67 ms / 160.64 ms Cof: -0.199 MB / 4.53 MB Application: beforeRenderModule mod_menu ()

Amser: 0.95 ms / 161.60 ms Cof: 0.209 MB / 4.74 MB Application: afterRenderModule mod_menu ()

Amser: 4.11 ms / 165.71 ms Cof: -0.090 MB / 4.65 MB Application: afterRender

Cyfanswm ymholiadau cronfa ddata: 84.87 ms

Defnydd Cof

Ymholiadau Cronfa Ddata

28 Ymholiad wedi'u Logio 84.87 ms

Amser yr Ymholiad: 0.51 ms Cof ymholiadau: 0.022 MB Cof cyn ymholiad: 0.744 MB Rhesi a ddychwelwyd: 1

SELECT `data`

  FROM `l4qpe_session`

  WHERE `session_id` = X'3264666232353064646239646638646566373466343437356434303938396564'

Eglurwch

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

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Yr un fath a'r alwad yn y llinell isod.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:47

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.41 ms Ar ôl yr ymholiad diwethaf: 1.24 ms Cof ymholiadau: 0.020 MB Cof cyn ymholiad: 0.819 MB Rhesi a ddychwelwyd: 5

SELECT id, rules

  FROM `l4qpe_viewlevels`

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4qpe_viewlevels	ALL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	5

Proffil

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

Stac Galwadau

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

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.51 ms Ar ôl yr ymholiad diwethaf: 0.14 ms Cof ymholiadau: 0.020 MB Cof cyn ymholiad: 0.829 MB Rhesi a ddychwelwyd: 2

SELECT b.id

  FROM l4qpe_usergroups AS a

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

  WHERE a.id = 9

Eglurwch

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

Proffil

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

Stac Galwadau

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

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.68 ms Ar ôl yr ymholiad diwethaf: 13.98 ms Cof ymholiadau: 0.024 MB Cof cyn ymholiad: 1.419 MB Rhesi a ddychwelwyd: 1

SELECT id,template 
  FROM l4qpe_template_styles 
  WHERE client_id=0 
  AND home=1

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4qpe_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	Using where

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Yr un fath a'r alwad yn y llinell isod.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
8	plgSystemWidgetkit->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.38 ms Ar ôl yr ymholiad diwethaf: 0.19 ms Cof ymholiadau: 0.021 MB Cof cyn ymholiad: 1.434 MB Rhesi a ddychwelwyd: 0

select email 
  from l4qpe_users 
  where id=0 
  LIMIT 1

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:311
12	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:324
11	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:28
10	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:178
9	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:354
8	plgSystembfstop->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.38 ms Ar ôl yr ymholiad diwethaf: 0.10 ms Cof ymholiadau: 0.021 MB Cof cyn ymholiad: 1.441 MB Rhesi a ddychwelwyd: 0

SELECT id, ipaddress 
  from l4qpe_bfstop_allowlist 
  WHERE (ipaddress='216.73.217.39' 
  AND LOCATE('/', ipaddress) = 0)

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4qpe_bfstop_allowlist	ALL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	1	Using where

Proffil

Status	Duration
Starting	0.06 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.03 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:192
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:228
9	BFStopDBHelper->isIPOnAllowList()	JROOT/plugins/system/bfstop/bfstop.php:373
8	plgSystembfstop->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.47 ms Ar ôl yr ymholiad diwethaf: 0.04 ms Cof ymholiadau: 0.021 MB Cof cyn ymholiad: 1.446 MB Rhesi a ddychwelwyd: 0

SELECT id, ipaddress 
  from l4qpe_bfstop_allowlist 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('216.73.217.39') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4qpe_bfstop_allowlist	ALL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	1	Using where

Proffil

Status	Duration
Starting	0.11 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.05 ms
Optimizing	0.05 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:192
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:229
9	BFStopDBHelper->isIPOnAllowList()	JROOT/plugins/system/bfstop/bfstop.php:373
8	plgSystembfstop->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 1.05 ms Ar ôl yr ymholiad diwethaf: 0.05 ms Cof ymholiadau: 0.021 MB Cof cyn ymholiad: 1.453 MB Rhesi a ddychwelwyd: 0

SELECT id, ipaddress, crdate, duration 
  FROM l4qpe_bfstop_bannedip b 
  WHERE (ipaddress='216.73.217.39' 
  AND LOCATE('/', ipaddress) = 0) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2026-10-13 21:58:40') 
  AND NOT EXISTS (SELECT 1 
  FROM l4qpe_bfstop_unblock u 
  WHERE b.id = u.block_id)

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	b	ALL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	769	Using where
2	MATERIALIZED	u	ALL	PRIMARY	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	1

Proffil

Status	Duration
Starting	0.09 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.06 ms
Optimizing	0.06 ms
Statistics	0.02 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.48 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:192
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:218
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:377
8	plgSystembfstop->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 1.40 ms Ar ôl yr ymholiad diwethaf: 0.04 ms Cof ymholiadau: 0.021 MB Cof cyn ymholiad: 1.459 MB Rhesi a ddychwelwyd: 0

SELECT id, ipaddress, crdate, duration 
  FROM l4qpe_bfstop_bannedip b 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('216.73.217.39') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2026-10-13 21:58:40') 
  AND NOT EXISTS (SELECT 1 
  FROM l4qpe_bfstop_unblock u 
  WHERE b.id = u.block_id)

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	b	ALL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	769	Using where
2	MATERIALIZED	u	ALL	PRIMARY	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	1

Proffil

Status	Duration
Starting	0.15 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.07 ms
Optimizing	0.07 ms
Statistics	0.02 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.74 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:192
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:219
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:377
8	plgSystembfstop->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 50.85 ms Ar ôl yr ymholiad diwethaf: 5.64 ms Cof ymholiadau: 0.004 MB Cof cyn ymholiad: 1.855 MB

UPDATE `l4qpe_extensions`

  SET `params` = '{\"mediaversion\":\"3600ed56e43c8cb5124f59d3248b9359\"}'

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

Eglurwch

Nid yw EXPLAIN yn bosibl ar yr ymholiad: UPDATE `l4qpe_extensions` SET `params` = '{\"mediaversion\":\"3600ed56e43c8cb5124f59d3248b9359\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Proffil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.02 ms
Updating main table	0.01 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.10 ms
Updating	0.12 ms
End of update loop	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	50.07 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 1.32 ms Ar ôl yr ymholiad diwethaf: 4.74 ms Cof ymholiadau: 0.025 MB Cof cyn ymholiad: 2.033 MB Rhesi a ddychwelwyd: 37

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

  FROM `l4qpe_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_ucac','com_users','com_widgetkit','com_wrapper')

Eglurwch

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

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 1.67 ms Ar ôl yr ymholiad diwethaf: 0.42 ms Cof ymholiadau: 0.052 MB Cof cyn ymholiad: 2.081 MB Rhesi a ddychwelwyd: 590

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

  FROM `l4qpe_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4qpe_assets	ALL	idx_asset_name,idx_parent_id	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	684	Using where

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 3.75 ms Ar ôl yr ymholiad diwethaf: 1.93 ms Cof ymholiadau: 0.023 MB Cof cyn ymholiad: 2.578 MB Rhesi a ddychwelwyd: 3

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

  FROM `l4qpe_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1 
  AND (i.language = '*' OR i.language = 'cy-GB')) AS numitems

  FROM `l4qpe_categories` AS `s`

  INNER JOIN `l4qpe_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('cy-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id = 10

  ORDER BY c.lft

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	PRIMARY	c	range	cat_idx,idx_left_right,idx_language	cat_idx	203	NULL	8	Using index condition; Using where; Yn defnyddio filesort
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	ucac_joomla_v5_upgrade_work.c.id	79	Using index condition; Using where

Proffil

Status	Duration
Starting	0.22 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.13 ms
Optimizing	0.06 ms
Statistics	0.17 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.19 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	2.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
14	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 4.47 ms Ar ôl yr ymholiad diwethaf: 0.92 ms Cof ymholiadau: 0.055 MB Cof cyn ymholiad: 2.609 MB Rhesi a ddychwelwyd: 9

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 l4qpe_content AS a

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

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

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

  LEFT JOIN l4qpe_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 = 10 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-13 20:58:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-13 20:58:40') 
  AND a.language IN ('cy-GB','*')

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

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	range	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	NULL	305	Using index condition; Using where; Yn defnyddio filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 2.03 ms Ar ôl yr ymholiad diwethaf: 1.26 ms Cof ymholiadau: 0.024 MB Cof cyn ymholiad: 2.772 MB Rhesi a ddychwelwyd: 1

SELECT COUNT(*)

  FROM l4qpe_content AS a

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

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

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

  LEFT JOIN l4qpe_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 = 10 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-13 20:58:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-13 20:58:40') 
  AND a.language IN ('cy-GB','*')

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ALL	idx_access,idx_state,idx_catid,idx_language	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	397	Using where

Proffil

Status	Duration
Starting	0.15 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.08 ms
Optimizing	0.07 ms
Statistics	0.18 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	1.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.95 ms Ar ôl yr ymholiad diwethaf: 0.60 ms Cof ymholiadau: 0.022 MB Cof cyn ymholiad: 2.782 MB Rhesi a ddychwelwyd: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `l4qpe_contentitem_tag_map` AS m 

  INNER JOIN `l4qpe_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 10 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	tag_idx	5	NULL	1	Using index condition
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	ucac_joomla_v5_upgrade_work.t.id	1	Using index condition; Using where

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 1.17 ms Ar ôl yr ymholiad diwethaf: 14.69 ms Cof ymholiadau: 0.025 MB Cof cyn ymholiad: 3.353 MB Rhesi a ddychwelwyd: 3

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 `l4qpe_categories` AS `s`

  INNER JOIN `l4qpe_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('cy-GB','*')) 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 = 10

  ORDER BY c.lft

Eglurwch

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,idx_language	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	12	Using where; Yn defnyddio filesort

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
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:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 1.98 ms Ar ôl yr ymholiad diwethaf: 0.23 ms Cof ymholiadau: 0.024 MB Cof cyn ymholiad: 3.374 MB Rhesi a ddychwelwyd: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM l4qpe_fields AS a

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

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

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

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

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

  LEFT JOIN `l4qpe_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 (10,0,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) 
  AND a.language in ('*','cy-GB')

  ORDER BY a.ordering ASC

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_context	766	const	1	Using where; Using temporary; Yn defnyddio filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ucac_joomla_v5_upgrade_work.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.id	1	Using where; Distinct

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
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:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.82 ms Ar ôl yr ymholiad diwethaf: 2.43 ms Cof ymholiadau: 0.219 MB Cof cyn ymholiad: 3.402 MB Rhesi a ddychwelwyd: 1

SELECT custom_data 
  FROM l4qpe_extensions 
  WHERE element = 'yootheme' 
  AND folder = 'system' 
  LIMIT 1

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4qpe_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using index condition

Proffil

Status	Duration
Starting	0.07 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.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
37	JDatabaseDriver->loadAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Database.php:39
36	YOOtheme\Joomla\Database->fetchAssoc()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Storage.php:23
35	YOOtheme\Joomla\Storage->__construct()	Yr un fath a'r alwad yn y llinell isod.
34	ReflectionClass->newInstanceArgs()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:181
33	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:154
32	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:329
31	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:94
30	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:410
29	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:360
28	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:179
27	YOOtheme\Container\Service->resolveClass()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container/Service.php:154
26	YOOtheme\Container\Service->resolveInstance()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:329
25	YOOtheme\Container->resolve()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:94
24	YOOtheme\Container->get()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:410
23	YOOtheme\Container->resolveDependencies()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:360
22	YOOtheme\Container->resolveArguments()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:276
21	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/application/src/Application/EventLoader.php:70
20	YOOtheme\Application\EventLoader::YOOtheme\Application\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
19	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
18	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/Dispatcher.php:47
17	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ViewTrait.php:22
14	Viewbe2562c828438c82133cbf69eb02504d->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.83 ms Ar ôl yr ymholiad diwethaf: 6.98 ms Cof ymholiadau: 0.020 MB Cof cyn ymholiad: 4.130 MB Rhesi a ddychwelwyd: 3

SELECT language,id

  FROM `l4qpe_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l4qpe_menu	ALL	idx_client_id_parent_id_alias_language	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	135	Using where

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.71 ms Ar ôl yr ymholiad diwethaf: 0.45 ms Cof ymholiadau: 0.020 MB Cof cyn ymholiad: 4.149 MB Rhesi a ddychwelwyd: 0

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

  FROM `l4qpe_menu` AS `c`

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

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

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

  WHERE c.id = 134

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.50 ms Ar ôl yr ymholiad diwethaf: 0.27 ms Cof ymholiadau: 0.021 MB Cof cyn ymholiad: 4.156 MB Rhesi a ddychwelwyd: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`

  FROM `l4qpe_categories` AS `c`

  INNER JOIN `l4qpe_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item'

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

  INNER JOIN `l4qpe_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

  WHERE c.id = 10 
  AND c.extension = 'com_content'

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NID OEDD YN BOSIBL DEFNYDDIO ALLWEDD INDEX	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
11	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:113
10	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:44
9	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:91
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 2.10 ms Ar ôl yr ymholiad diwethaf: 4.13 ms Cof ymholiadau: 0.187 MB Cof cyn ymholiad: 4.454 MB Rhesi a ddychwelwyd: 6

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

  FROM l4qpe_content AS a

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

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

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

  LEFT JOIN l4qpe_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 (2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-13 20:58:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-13 20:58:40') 
  AND a.language IN ('cy-GB','*')

  ORDER BY a.hits DESC 
  LIMIT 6

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	84	Using where; Yn defnyddio filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
35	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
34	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
33	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
32	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
31	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
30	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/module/element.php:35
28	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:289
27	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95
22	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112
21	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder/bootstrap.php:44
20	YOOtheme\Application::YOOtheme\Builder\{closure}()	Yr un fath a'r alwad yn y llinell isod.
19	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86
18	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/position.php:49
17	require JROOT/templates/yootheme/templates/position.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274
16	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:16
15	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:70
13	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:23
11	YOOtheme\Theme\Joomla\UrlListener->resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
10	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237
9	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
8	YOOtheme\View->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:41
7	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 1.02 ms Ar ôl yr ymholiad diwethaf: 0.53 ms Cof ymholiadau: 0.034 MB Cof cyn ymholiad: 4.666 MB Rhesi a ddychwelwyd: 2

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

  FROM `l4qpe_categories` AS `s`

  INNER JOIN `l4qpe_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('cy-GB','*')) 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 = 2

  ORDER BY c.lft

Eglurwch

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_language	idx_left_right	4	NULL	3	Using index condition; Using where

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
44	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
43	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
42	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
41	ContentRouter->getCategorySegment()	Yr un fath a'r alwad yn y llinell isod.
40	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
39	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
38	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
37	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
36	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
35	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
34	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
33	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
32	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_popular/helper.php:89
31	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
30	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/module/element.php:35
28	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:289
27	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95
22	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112
21	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder/bootstrap.php:44
20	YOOtheme\Application::YOOtheme\Builder\{closure}()	Yr un fath a'r alwad yn y llinell isod.
19	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86
18	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/position.php:49
17	require JROOT/templates/yootheme/templates/position.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274
16	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:16
15	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:70
13	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:23
11	YOOtheme\Theme\Joomla\UrlListener->resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
10	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237
9	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
8	YOOtheme\View->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:41
7	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 3.75 ms Ar ôl yr ymholiad diwethaf: 0.96 ms Cof ymholiadau: 0.046 MB Cof cyn ymholiad: 4.508 MB Rhesi a ddychwelwyd: 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 l4qpe_content AS a

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

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

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

  LEFT JOIN l4qpe_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 (10) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-13 20:58:40') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-13 20:58:40') 
  AND a.language IN ('cy-GB','*')

  ORDER BY a.hits DESC 
  LIMIT 3

Eglurwch

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	range	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	NULL	305	Using index condition; Using where; Yn defnyddio filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	ucac_joomla_v5_upgrade_work.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Proffil

Status	Duration
Starting	0.27 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.15 ms
Optimizing	0.08 ms
Statistics	0.19 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.11 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	2.40 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
35	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
34	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
33	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
32	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
31	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
30	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
29	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/yootheme/vendor/yootheme/builder-joomla/elements/module/element.php:35
28	YOOtheme\Configuration\Resolver->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:289
27	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
26	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
25	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
24	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:274
23	YOOtheme\Builder->applyTransforms()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:95
22	YOOtheme\Builder->load()	JROOT/templates/yootheme/vendor/yootheme/builder/src/Builder.php:112
21	YOOtheme\Builder->render()	JROOT/templates/yootheme/vendor/yootheme/builder/bootstrap.php:44
20	YOOtheme\Application::YOOtheme\Builder\{closure}()	Yr un fath a'r alwad yn y llinell isod.
19	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86
18	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/position.php:49
17	require JROOT/templates/yootheme/templates/position.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274
16	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:16
15	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:70
13	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:23
11	YOOtheme\Theme\Joomla\UrlListener->resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
10	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237
9	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
8	YOOtheme\View->__invoke()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/src/ModulesRenderer.php:41
7	YOOtheme\Theme\Joomla\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.55 ms Ar ôl yr ymholiad diwethaf: 9.72 ms Cof ymholiadau: 0.023 MB Cof cyn ymholiad: 4.595 MB Rhesi a ddychwelwyd: 1

SELECT `alias`

  FROM `l4qpe_content`

  WHERE id = '19'

Eglurwch

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

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Yr un fath a'r alwad yn y llinell isod.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->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:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.34 ms Ar ôl yr ymholiad diwethaf: 0.22 ms Cof ymholiadau: 0.023 MB Cof cyn ymholiad: 4.639 MB Rhesi a ddychwelwyd: 1

SELECT `alias`

  FROM `l4qpe_content`

  WHERE id = '373'

Eglurwch

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

Proffil

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

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Yr un fath a'r alwad yn y llinell isod.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->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:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

Amser yr Ymholiad: 0.30 ms Ar ôl yr ymholiad diwethaf: 0.07 ms Cof ymholiadau: 0.023 MB Cof cyn ymholiad: 4.647 MB Rhesi a ddychwelwyd: 1

SELECT alias

  FROM l4qpe_content

  WHERE id=373

Eglurwch

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

Proffil

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.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stac Galwadau

#	Galwr	Ffeil a rhif llinell
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->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:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

[Ychwanegu cyfarwyddeb xdebug.file_link_format i'ch ffeil php.ini i gael dolenni i ffeiliau.]

21 Math o Ymholiadau wedi'u Logio, yn Nhrefn y Nifer.

Tablau SELECT:

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 l4qpe_content AS a 
  LEFT JOIN l4qpe_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN l4qpe_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN l4qpe_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN l4qpe_categories as parent 
  ON parent.id = c.parent_id

2 × SELECT id, ipaddress 
  from l4qpe_bfstop_allowlist

2 × SELECT id, ipaddress, crdate, duration 
  FROM l4qpe_bfstop_bannedip b

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `l4qpe_assets`

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `l4qpe_categories` AS `s` 
  INNER JOIN `l4qpe_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('cy-GB','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

2 × SELECT `alias` 
  FROM `l4qpe_content`

1 × SELECT `data` 
  FROM `l4qpe_session`

1 × SELECT id, rules 
  FROM `l4qpe_viewlevels

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

1 × SELECT id,template 
  FROM l4qpe_template_styles

```
1 × select email 
  from l4qpe_users
```

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

1 × SELECT COUNT(*) 
  FROM l4qpe_content AS a 
  LEFT JOIN l4qpe_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN l4qpe_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN l4qpe_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN l4qpe_categories as parent 
  ON parent.id = c.parent_id

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

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

1 × SELECT custom_data 
  FROM l4qpe_extensions

1 × SELECT language,id 
  FROM `l4qpe_menu`

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

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` 
  FROM `l4qpe_categories` AS `c` 
  INNER JOIN `l4qpe_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_categories.item' 
  INNER JOIN `l4qpe_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `l4qpe_categories` AS `c2` 
  ON a2.id = c2.`id` 
  AND c2.extension = 'com_content'

1 × SELECT alias 
  FROM l4qpe_content

Tablau ERAILL:

1 × UPDATE `l4qpe_extensions` 
  SET `params` = '{\"mediaversion\":\"3600ed56e43c8cb5124f59d3248b9359\"}'