❆ Assalamu'alaikum Warahmatullahi Wabarakaatuh ❆ ___________________________▁▂▃▅▆▇ Selamat Datang di website resmi Pengadilan Agama Bintuhan Kelas II di Kabupaten Kaur ▇▆▅▃▂▁

Pengumuman

Update Aplikasi E-Keuangan dan E-Register | (08/01)
Pengumuman Daftar Nama Peserta yang Lolos Tes Seleksi PPNPN/ Honorer Tahun Anggaran 2020 | (27/12)
Pengumuman Hasil Penilaian Peserta Seleksi Calon PPNPN / Honorer Tahun Anggaran 2020 | (23/12)
Pengumuman Hasil Seleksi Administrasi Penerimaan PPNPN | (17/12)
Penerimaan Pegawai Pemerintah non Pegawai Negeri (PPNPN/ Honorer) untuk Tahun Anggaran 2020 | (03/12)
Edaran Imbauan Pencegahan Gratifikasi | (27/05)
Penetapan Jam Kerja pada Bulan Ramadhan 1440 H | (06/05)
Hari Pemungutan Suara PEMILU Tahun 2019 sebagai Hari Libur Nasional | (10/04)

Pengumuman Lainnya

Berita Pengadilan

Ada Seragam Olga Baru di PA Bintuhan

| (16/02)

Ketua PA Bintuhan Dapat Oleh-oleh dari Hakim Agung

| (12/02)

Di Bali PA Bintuhan Raih Akreditasi A

| (03/02)

Bagaimana Membantu Masyarakat Pencari Keadilan?

| (03/02)

Pernikahan Dini Dikaji Dalam Diskusi Perdana 2020 PA Bintuhan

| (28/01)

Biru Ceria di PA Bintuhan

| (14/01)

Berita Lainnya

Jadwal Sidang

Pengadilan Agama Bintuhan memberikan kemudahan akses informasi jadwal sidang untuk para pihak yang sedang berperkara. Informasi yang disuguhkan yaitu jadwal sidang untuk hari ini, jadwal persidangan yang lalu maupun yang akan datang.

Lebih Lanjut

Penelusuran Perkara

Sampai sejauh mana perkara anda ditangani di Pengadilan Agama Bintuhan. Silahkan anda telusuri informasinya melaui Sistem Informasi Penelusuran Perkara (SIPP). Melalui SIPP, anda akan mengetahui tahapan, status, biaya dan riwayat perkara.

Lebih Lanjut

Bagaimana Cara Mendapatkan Pelayanan Informasi?

Typography Ketua Mahkamah Agung RI pada tanggal 5 Januari 2011 telah menerbitkan Surat Keputusan Ketua Mahkamah Agung RI Nomor 1-144/KMA/SK/I/2011 tentang Pedoman Pelayanan Informasi di Pengadilan.

Selanjutnya

Bantuan Hukum Untuk Masyarakat Tidak Mampu

Colors Sebagaimana Peraturan Mahkamah Agung RI Nomor 1 Tahun 2014 Tentang Pedoman Pemberian Layanan Hukum Bagi Masyarakat Tidak Mampu di Pengadilan, Pengadilan Agama Bintuhan memberikan layanan hukum bagi masyarakat tidak mampu yang meliputi Layanan Pembebasan Biaya Perkara, Sidang di Luar Gedung Pengadilan, dan Pos Bantuan Hukum (Posbakum).

Lebih Lanjut

Pelayanan Prima, Putusan Berkualitas

Pencarian

Pilihan Bahasa

Informasi Cepat

Direktori Putusan Mahkamah Agung

Penelusuran Putusan Perkara PA Bintuhan

Kunjungi

Bantuan Hukum

Informasi bantuan hukum untuk pencari keadilan

Kunjungi

Informasi Pendaftaran Perkara

Unduh formulir pengajuan perkara.

Kunjungi

Statistik Pengadilan

Data Perkara dan Putusan di Pengadilan Agama Bintuhan.

Kunjungi

Pengaduan Pelayanan Pengadilan

Prosedur Pengaduan Pelayanan Pengadilan.

Kunjungi

Kegiatan Pengadilan

29-31JAN

Rapat Koordinasi Ditjen Badilag Tahun 2020
Dynasty Resort, Jl. Kartika Plaza, Kuta, Bali

6-7FEB

Rapat Kerja Daerah
Aula PTA Bengkulu

Tautan

Mahkamah Agung
Republik Indonesia

Direktorat Jenderal
Badan Peradilan Agama

Pengadilan Tinggi Agama
PTA Bengkulu

Pengadilan Agama
PA Bengkulu Kelas IA

Pengadilan Agama
PA Curup Kelas IB

Pengadilan Agama
PA Argamakmur Kelas IB

Pengadilan Agama
PA Manna Kelas II

Pengadilan Agama
PA Lebong Kelas II

Pengadilan Agama
PA Tais Kelas II

Pengadilan Agama
PA Kepahiang Kelas II

Pengadilan Agama
PA Mukomuko Kelas II

Pemerintah Daerah
Pemda Kabupaten Kaur

Statistik Pengunjung

0333552

Hari ini

Minggu ini

Bulan ini

Jumlah

112

1825

4362

333552

12.36%

19.63%

6.33%

1.04%

0.13%

60.51%

Online (60 minutes ago):7

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 15.73 ms / 15.73 ms Memory: 0.736 MB / 0.97 MB Application: afterLoad

Time: 579.54 ms / 595.26 ms Memory: 8.013 MB / 8.98 MB Application: afterInitialise

Time: 20.50 ms / 615.77 ms Memory: 0.968 MB / 9.95 MB Application: afterRoute

Time: 10.09 ms / 625.85 ms Memory: 0.351 MB / 10.30 MB Application: beforeRenderComponent com_content

Time: 8.51 ms / 634.37 ms Memory: 0.620 MB / 10.92 MB Application: Before JAccess::preloadComponents (all components)

Time: 3.54 ms / 637.90 ms Memory: 0.089 MB / 11.01 MB Application: After JAccess::preloadComponents (all components)

Time: 0.09 ms / 637.99 ms Memory: 0.000 MB / 11.00 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Time: 1.09 ms / 639.08 ms Memory: 0.043 MB / 11.05 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Time: 58.67 ms / 697.76 ms Memory: 2.601 MB / 13.65 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Time: 0.13 ms / 697.89 ms Memory: 0.009 MB / 13.65 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Time: 26.83 ms / 724.72 ms Memory: 1.663 MB / 15.32 MB Application: afterRenderComponent com_content

Time: 47.53 ms / 772.25 ms Memory: 1.633 MB / 16.95 MB Application: afterDispatch

Time: 12.46 ms / 784.71 ms Memory: 0.303 MB / 17.25 MB Application: beforeRenderModule mod_custom (Tautan)

Time: 8.07 ms / 792.79 ms Memory: 0.098 MB / 17.35 MB Application: afterRenderModule mod_custom (Tautan)

Time: 0.11 ms / 792.90 ms Memory: 0.002 MB / 17.35 MB Application: beforeRenderModule mod_zt_visitor_counter (Statistik Pengunjung)

Time: 6.75 ms / 799.65 ms Memory: 0.157 MB / 17.51 MB Application: afterRenderModule mod_zt_visitor_counter (Statistik Pengunjung)

Time: 0.19 ms / 799.83 ms Memory: 0.000 MB / 17.49 MB Application: beforeRenderModule mod_custom (Informasi Cepat)

Time: 4.19 ms / 804.02 ms Memory: 0.008 MB / 17.50 MB Application: afterRenderModule mod_custom (Informasi Cepat)

Time: 0.08 ms / 804.10 ms Memory: 0.000 MB / 17.49 MB Application: beforeRenderModule mod_custom (Kegiatan Pengadilan)

Time: 7.89 ms / 811.99 ms Memory: 0.000 MB / 17.49 MB Application: afterRenderModule mod_custom (Kegiatan Pengadilan)

Time: 0.16 ms / 812.16 ms Memory: 0.000 MB / 17.49 MB Application: beforeRenderModule mod_custom (Pencarian)

Time: 4.89 ms / 817.04 ms Memory: 0.004 MB / 17.49 MB Application: afterRenderModule mod_custom (Pencarian)

Time: 0.13 ms / 817.18 ms Memory: 0.016 MB / 17.51 MB Application: beforeRenderModule mod_gtranslate (GTranslate)

Time: 4.42 ms / 821.60 ms Memory: 0.210 MB / 17.72 MB Application: afterRenderModule mod_gtranslate (GTranslate)

Time: 0.24 ms / 821.84 ms Memory: 0.000 MB / 17.55 MB Application: beforeRenderModule mod_custom (Tabs Prosedur Permohonan Informasi dan Prosedur Bantuan Hukum)

Time: 7.37 ms / 829.21 ms Memory: 0.009 MB / 17.56 MB Application: afterRenderModule mod_custom (Tabs Prosedur Permohonan Informasi dan Prosedur Bantuan Hukum)

Time: 0.16 ms / 829.37 ms Memory: 0.013 MB / 17.57 MB Application: beforeRenderModule mod_custom (Pengumuman, Berita Pengadilan, Jadwal Sidang, dan Penelusuran Perkara)

Time: 3.66 ms / 833.03 ms Memory: 0.077 MB / 17.65 MB Application: beforeRenderModule mod_articles_category (Pengumuman Pengadilan)

Time: 20.59 ms / 853.62 ms Memory: 0.633 MB / 18.28 MB Application: afterRenderModule mod_articles_category (Pengumuman Pengadilan)

Time: 0.48 ms / 854.10 ms Memory: 0.000 MB / 18.06 MB Application: beforeRenderModule mod_junewsultra (Berita Pengadilan)

Time: 25.44 ms / 879.54 ms Memory: 0.594 MB / 18.65 MB Application: afterRenderModule mod_junewsultra (Berita Pengadilan)

Time: 0.68 ms / 880.22 ms Memory: 0.000 MB / 18.46 MB Application: afterRenderModule mod_custom (Pengumuman, Berita Pengadilan, Jadwal Sidang, dan Penelusuran Perkara)

Time: 0.21 ms / 880.43 ms Memory: 0.003 MB / 18.46 MB Application: beforeRenderModule mod_custom (Banner Spot)

Time: 0.86 ms / 881.28 ms Memory: 0.010 MB / 18.47 MB Application: afterRenderModule mod_custom (Banner Spot)

Time: 0.11 ms / 881.40 ms Memory: 0.004 MB / 18.47 MB Application: beforeRenderModule mod_marqueeaholic (MarqueeAholic - Teks Berjalan)

Time: 1.13 ms / 882.53 ms Memory: 0.025 MB / 18.50 MB Application: afterRenderModule mod_marqueeaholic (MarqueeAholic - Teks Berjalan)

Time: 0.09 ms / 882.62 ms Memory: 0.000 MB / 18.48 MB Application: beforeRenderModule mod_wrapper (SLIDE SIDANG)

Time: 1.92 ms / 884.54 ms Memory: 0.030 MB / 18.51 MB Application: afterRenderModule mod_wrapper (SLIDE SIDANG)

Time: 0.16 ms / 884.70 ms Memory: 0.000 MB / 18.50 MB Application: beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs)

Time: 1.35 ms / 886.05 ms Memory: 0.037 MB / 18.54 MB Application: afterRenderModule mod_breadcrumbs_adv (Breadcrumbs)

Time: 0.21 ms / 886.25 ms Memory: 0.005 MB / 18.54 MB Application: beforeRenderModule mod_sp_smart_slider (SP Smart Slider)

Time: 3.99 ms / 890.24 ms Memory: 0.174 MB / 18.71 MB Application: afterRenderModule mod_sp_smart_slider (SP Smart Slider)

Time: 0.21 ms / 890.45 ms Memory: 0.000 MB / 18.67 MB Application: beforeRenderModule mod_gruemenu (TheGrue Menu)

Time: 55.65 ms / 946.10 ms Memory: 1.074 MB / 19.75 MB Application: afterRenderModule mod_gruemenu (TheGrue Menu)

Time: 0.29 ms / 946.39 ms Memory: 0.000 MB / 19.73 MB Application: beforeRenderModule mod_custom (Banner Pengadilan)

Time: 0.86 ms / 947.26 ms Memory: 0.009 MB / 19.74 MB Application: afterRenderModule mod_custom (Banner Pengadilan)

Time: 25.73 ms / 972.98 ms Memory: 0.342 MB / 20.08 MB Application: afterRender

Database queries total: 526.39 ms

Memory Usage

Database Queries

44 Queries Logged 526.39 ms

4 duplicate found!

2 duplicates: #10 #11

2 duplicates: #32 #44

Query Time: 1.28 ms Query memory: 0.008 MB Memory before query: 3.026 MB

DELETE 

  FROM `ydfui_session`

  WHERE `time` < '1581918507'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_session	range	time	time	59	NULL	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.74 ms After last query: 0.78 ms Query memory: 0.019 MB Memory before query: 3.056 MB Rows returned: 0

SELECT `data`

  FROM `ydfui_session`

  WHERE `session_id` = '1o1degsdsneded12s6fq2o1200'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_session	const	PRIMARY	PRIMARY	766	const	1	100.00

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.69 ms After last query: 1.95 ms Query memory: 0.010 MB Memory before query: 3.199 MB Rows returned: 0

SELECT `session_id`

  FROM `ydfui_session`

  WHERE `session_id` = '1o1degsdsneded12s6fq2o1200' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 1.66 ms After last query: 0.25 ms Query memory: 0.009 MB Memory before query: 3.214 MB

INSERT INTO `ydfui_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('1o1degsdsneded12s6fq2o1200', 1, '1581919407', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `ydfui_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('1o1degsdsneded12s6fq2o1200', 1, '1581919407', 0, '', 0)

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
update	0.30 ms
end	0.02 ms
query end	0.77 ms
closing tables	0.02 ms
Unlocking tables	0.06 ms
freeing items	0.06 ms
updating status	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 3.26 ms After last query: 5.75 ms Query memory: 0.013 MB Memory before query: 3.462 MB Rows returned: 36

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ydfui_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_extensions	ref	extension	extension	82	const	36	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
9	JComponentHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 4.55 ms Query memory: 0.012 MB Memory before query: 3.743 MB Rows returned: 5

SELECT id, rules

  FROM `ydfui_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.08 ms After last query: 0.26 ms Query memory: 0.014 MB Memory before query: 3.767 MB Rows returned: 2

SELECT b.id

  FROM ydfui_usergroups AS a

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

  WHERE a.id = 13

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.15 ms After last query: 1.22 ms Query memory: 0.013 MB Memory before query: 3.861 MB Rows returned: 103

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM ydfui_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_extensions	ref	extension	extension	82	const	103	100.00	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
9	JPluginHelper::{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.57 ms After last query: 2.14 ms Query memory: 0.009 MB Memory before query: 4.031 MB Rows returned: 1

SELECT *

  FROM ydfui_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/joomla/language/helper.php:65
4	JLanguageHelper::detectLanguage()	JROOT/libraries/cms/application/site.php:652
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.17 ms After last query: 23.41 ms Query memory: 0.017 MB Memory before query: 5.580 MB Rows returned: 1

Duplicate queries: #11

SELECT template

  FROM ydfui_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 0.20 ms Query memory: 0.019 MB Memory before query: 5.599 MB Rows returned: 1

Duplicate queries: #10

SELECT template

  FROM ydfui_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 7.78 ms Query memory: 0.012 MB Memory before query: 5.926 MB Rows returned: 2

SELECT extension, file, type

  FROM ydfui_rokcommon_configs

  ORDER BY priority

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_rokcommon_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using filesort

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.27 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.08 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.98 ms After last query: 15.15 ms Query memory: 0.012 MB Memory before query: 6.925 MB Rows returned: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `ydfui_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_extensions	ref	extension	extension	82	const	6	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:271
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 431.13 ms After last query: 10.59 ms Query memory: 0.014 MB Memory before query: 7.620 MB Rows returned: 0

SELECT timestamp

  FROM ydfui_zt_visitor_counter

  WHERE ipaddress = '3.234.245.125' 
  AND useragent LIKE "%other%"

  ORDER BY timestamp DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_zt_visitor_counter	index	NULL	timestamp	4	NULL	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/zt_visitor_counter/helper.php:65
10	plgZTVisitorCounterHelper::getLastVisit()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42
9	plgSystemZT_Visitor_Counter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 6.71 ms After last query: 0.50 ms Query memory: 0.014 MB Memory before query: 7.636 MB

INSERT INTO `ydfui_zt_visitor_counter`
(`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) 
  VALUES 
(null, '1581920307', 1 , 1 , '3.234.245.125', 'other')

Explain

EXPLAIN not possible on query: INSERT INTO `ydfui_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) VALUES (null, '1581920307', 1 , 1 , '3.234.245.125', 'other')

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
update	0.20 ms
end	0.02 ms
query end	5.35 ms
closing tables	0.04 ms
Unlocking tables	0.07 ms
freeing items	0.08 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/plugins/system/zt_visitor_counter/helper.php:31
10	plgZTVisitorCounterHelper::addVisits()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:46
9	plgSystemZT_Visitor_Counter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.91 ms After last query: 7.54 ms Query memory: 0.027 MB Memory before query: 8.141 MB Rows returned: 97

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM ydfui_menu AS m

  LEFT JOIN ydfui_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	133	78.95	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	pabi4654_pabhn.m.component_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
22	JMenuSite->{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
20	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.13 ms After last query: 29.11 ms Query memory: 0.018 MB Memory before query: 9.998 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ydfui_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
13	JLibraryHelper::{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.63 ms After last query: 0.38 ms Query memory: 0.012 MB Memory before query: 10.000 MB

UPDATE `ydfui_extensions`

  SET `params` = '{\"mediaversion\":\"9908e0b1050ba774d7a4d98390b950ad\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.19 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.09 ms
updating	0.21 ms
end	0.02 ms
query end	0.73 ms
closing tables	0.02 ms
Unlocking tables	0.06 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.08 ms After last query: 3.64 ms Query memory: 0.008 MB Memory before query: 10.288 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM ydfui_template_styles as s

  LEFT JOIN ydfui_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	pabi4654_pabhn.s.template,const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.87 ms After last query: 9.21 ms Query memory: 0.022 MB Memory before query: 10.925 MB Rows returned: 36

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

  FROM `ydfui_assets`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_assets	range	idx_asset_name	idx_asset_name	202	NULL	37	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.51 ms After last query: 3.04 ms Query memory: 0.020 MB Memory before query: 11.124 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `ydfui_content`

Explain

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

Profile

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
closing tables	0.02 ms
Opening tables	0.48 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	1.13 ms
After opening tables	0.02 ms
checking permissions	0.09 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.02 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.23 ms
closing tables	0.02 ms
Unlocking tables	0.06 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.29 ms After last query: 6.67 ms Query memory: 0.015 MB Memory before query: 11.512 MB Rows returned: 1

SELECT *

  FROM ydfui_content

  WHERE `id` = '116'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_content	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.41 ms After last query: 0.36 ms Query memory: 0.014 MB Memory before query: 11.526 MB

UPDATE ydfui_content

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

  WHERE `id` = '116'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_content	range	PRIMARY	PRIMARY	4	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.06 ms
updating	0.21 ms
end	0.03 ms
query end	0.77 ms
closing tables	0.02 ms
Unlocking tables	0.06 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
10	JTable->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.52 ms After last query: 3.56 ms Query memory: 0.017 MB Memory before query: 11.734 MB Rows returned: 1

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

  FROM ydfui_content AS a

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

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

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

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

  WHERE a.id = 116 
  AND c.published > 0 
  AND a.language in ('en-GB','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-02-17 06:03:28') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-02-17 06:03:28') 
  AND (a.state = 1 OR a.state =2)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.35 ms After last query: 5.51 ms Query memory: 0.027 MB Memory before query: 12.030 MB Rows returned: 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 ydfui_categories as c

  LEFT JOIN ydfui_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=109

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
20	JCategories->get()	JROOT/components/com_content/router.php:72
19	ContentRouter->getCategorySegment()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
17	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
16	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
15	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.60 ms After last query: 1.10 ms Query memory: 0.016 MB Memory before query: 12.086 MB Rows returned: 0

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

  FROM `ydfui_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 116 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	20	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	pabi4654_pabhn.m.tag_id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 1.96 ms Query memory: 0.021 MB Memory before query: 12.179 MB

CREATE TABLE IF NOT EXISTS `ydfui_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Explain

EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS `ydfui_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.04 ms
After create	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.08 ms
freeing items	0.06 ms
updating status	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
16	JDatabase->query()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:116
15	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:93
14	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:163
13	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/cms/plugin/helper.php:252
12	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
11	JPluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:189
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.30 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 12.200 MB Rows returned: 1

SELECT value 
  FROM ydfui_powr 
  WHERE data_type = 'powr_token'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_powr	const	PRIMARY	PRIMARY	152	const	1	100.00

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
16	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:121
15	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:93
14	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:163
13	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/cms/plugin/helper.php:252
12	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
11	JPluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:189
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 4.80 ms After last query: 28.66 ms Query memory: 0.024 MB Memory before query: 14.301 MB Rows returned: 0

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

  FROM ydfui_fields AS a

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

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

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

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

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

  LEFT JOIN `ydfui_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 (109,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.19 ms After last query: 18.85 ms Query memory: 0.019 MB Memory before query: 15.569 MB Rows returned: 1

SELECT params 
  FROM ydfui_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:264
14	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
13	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
12	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
11	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
10	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
8	plgSystemWidgetkit_System->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.22 ms After last query: 26.30 ms Query memory: 0.013 MB Memory before query: 16.605 MB Rows returned: 1

SELECT language,id

  FROM `ydfui_menu`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	133	79.70	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.82 ms After last query: 0.64 ms Query memory: 0.022 MB Memory before query: 16.624 MB Rows returned: 1

Duplicate queries: #44

SELECT `alias`

  FROM `ydfui_content`

  WHERE id = '116'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_content	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:729
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.66 ms After last query: 0.33 ms Query memory: 0.024 MB Memory before query: 16.652 MB Rows returned: 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 ydfui_categories as c

  LEFT JOIN ydfui_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=116

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
18	JCategories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:121
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:729
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.33 ms After last query: 2.27 ms Query memory: 0.014 MB Memory before query: 16.746 MB Rows returned: 0

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

  FROM `ydfui_menu` AS `c`

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

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

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

  WHERE c.id = 435

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:735
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.05 ms After last query: 1.54 ms Query memory: 0.015 MB Memory before query: 16.787 MB Rows returned: 0

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

  FROM `ydfui_content` AS `c`

  INNER JOIN `ydfui_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

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

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

  INNER JOIN `ydfui_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 116

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
10	ContentHelperAssociation::getAssociations()	Same as call in the line below.
9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:750
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.26 ms After last query: 6.48 ms Query memory: 0.018 MB Memory before query: 17.122 MB Rows returned: 24

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

  FROM ydfui_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-02-17 06:03:28') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-02-17 06:03:28') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 435 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
8	JDocumentHtml->countModules()	JROOT/templates/standart_ma/index.php:78
7	require JROOT/templates/standart_ma/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.47 ms After last query: 9.19 ms Query memory: 0.028 MB Memory before query: 17.328 MB Rows returned: 0

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

  FROM ydfui_fields AS a

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

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

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

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

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

  LEFT JOIN `ydfui_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'mod_custom.content' 
  AND (fc.category_id IS NULL OR fc.category_id IN (109,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
22	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
21	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
20	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
18	PlgSystemFields->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.79 ms After last query: 3.76 ms Query memory: 0.016 MB Memory before query: 17.521 MB Rows returned: 1

SELECT SUM(visits)

  FROM ydfui_zt_visitor_counter

  WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
  AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_zt_visitor_counter	range	timestamp	timestamp	4	NULL	88	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:32
11	modZTCounterHelper->getTodayVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:57
10	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 1.12 ms Query memory: 0.016 MB Memory before query: 17.544 MB Rows returned: 7

SELECT guest, client_id

  FROM ydfui_session

  WHERE client_id = 0 
  AND `time` BETWEEN 1581915808 
  AND 1581919408

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_session	ALL	time	NO INDEX KEY COULD BE USED	NULL	NULL	8	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zt_visitor_counter/helper.php:309
11	modZTCounterHelper->getOnline()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:139
10	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 4.42 ms After last query: 39.39 ms Query memory: 0.035 MB Memory before query: 17.999 MB Rows returned: 8

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,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,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM ydfui_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (114) 
  AND a.created_by IN (0,842) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-02-17 06:03:28') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-02-17 06:03:28') 
  AND a.language in ('en-GB','*')

  ORDER BY a.created DESC 
  LIMIT 8

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid,idx_createdby,idx_language	idx_catid,idx_state	4,1	NULL	28	75.00	Using intersect(idx_catid,idx_state); Using where; Using filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	pabi4654_pabhn.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	pabi4654_pabhn.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	pabi4654_pabhn.a.id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
29	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
28	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
27	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:228
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:551
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:198
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
19	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.78 ms After last query: 3.30 ms Query memory: 0.044 MB Memory before query: 18.264 MB Rows returned: 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 ydfui_categories as c

  LEFT JOIN ydfui_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=114

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
37	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
36	JCategories->get()	JROOT/components/com_content/router.php:72
35	ContentRouter->getCategorySegment()	Same as call in the line below.
34	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
33	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
32	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
31	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
30	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
29	JRouter->build()	JROOT/libraries/cms/router/site.php:149
28	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
27	JRoute::_()	JROOT/modules/mod_articles_category/helper.php:264
26	ModArticlesCategoryHelper::getList()	Same as call in the line below.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:551
23	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
22	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/cms/module/helper.php:198
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
19	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 9.54 ms After last query: 11.90 ms Query memory: 0.029 MB Memory before query: 18.529 MB Rows returned: 6

SELECT a.id, a.state, a.alias, a.publish_up, a.publish_down,a.title,a.introtext,a.fulltext,a.language,a.created,a.modified_by,a.featured,a.created_by,a.catid

  FROM ydfui_content AS a

  WHERE a.state = 1 
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up < '2020-02-17 06:03:28' ) 
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down > '2020-02-17 06:03:28' ) 
  AND a.catid IN (115) 
  AND a.language in ('en-GB','*')

  ORDER BY a.created DESC 
  LIMIT 6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_catid,idx_language	idx_catid	4	const	189	100.00	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_junewsultra/helper/com_content.php:436
23	com_content::getList()	JROOT/modules/mod_junewsultra/mod_junewsultra.php:94
22	include JROOT/modules/mod_junewsultra/mod_junewsultra.php	JROOT/libraries/cms/module/helper.php:198
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
19	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.66 ms After last query: 0.99 ms Query memory: 0.041 MB Memory before query: 18.609 MB Rows returned: 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 ydfui_categories as c

  LEFT JOIN ydfui_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=115

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
35	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
34	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
33	JCategories->get()	JROOT/components/com_content/router.php:72
32	ContentRouter->getCategorySegment()	Same as call in the line below.
31	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
30	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
29	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
28	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
27	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
26	JRouter->build()	JROOT/libraries/cms/router/site.php:149
25	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
24	JRoute::_()	JROOT/modules/mod_junewsultra/helper/com_content.php:524
23	com_content::getList()	JROOT/modules/mod_junewsultra/mod_junewsultra.php:94
22	include JROOT/modules/mod_junewsultra/mod_junewsultra.php	JROOT/libraries/cms/module/helper.php:198
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
19	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.18 ms After last query: 5.34 ms Query memory: 0.038 MB Memory before query: 18.702 MB Rows returned: 1

Duplicate queries: #32

SELECT `alias`

  FROM `ydfui_content`

  WHERE id = '116'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ydfui_content	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

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

Call Stack

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
32	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
31	ContentRouter->getArticleSegment()	Same as call in the line below.
30	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
29	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
28	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
27	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
26	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
25	JRouter->build()	JROOT/libraries/cms/router/site.php:149
24	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
23	JRoute::_()	JROOT/modules/mod_junewsultra/mod_junewsultra.php:159
22	include JROOT/modules/mod_junewsultra/mod_junewsultra.php	JROOT/libraries/cms/module/helper.php:198
21	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
20	JDocumentRendererHtmlModule->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
19	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
18	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

2 × SELECT `alias` 
  FROM `ydfui_content`

2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM ydfui_fields AS a 
  LEFT JOIN `ydfui_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ydfui_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ydfui_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ydfui_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ydfui_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ydfui_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × SELECT template 
  FROM ydfui_template_styles as s

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `ydfui_extensions`

1 × SELECT language,id 
  FROM `ydfui_menu`

1 × SELECT params 
  FROM ydfui_extensions AS e

```
1 × SELECT value 
  FROM ydfui_powr
```

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

1 × SELECT a.id, a.state, a.alias, a.publish_up, a.publish_down,a.title,a.introtext,a.fulltext,a.language,a.created,a.modified_by,a.featured,a.created_by,a.catid 
  FROM ydfui_content AS a

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

1 × SELECT SUM(visits) 
  FROM ydfui_zt_visitor_counter

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,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,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,         COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM ydfui_content AS a 
  LEFT JOIN ydfui_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ydfui_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ydfui_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ydfui_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ydfui_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `ydfui_content` AS `c` 
  INNER JOIN `ydfui_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `ydfui_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `ydfui_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `ydfui_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT guest, client_id 
  FROM ydfui_session

```
1 × SELECT * 
  FROM ydfui_content
```

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM ydfui_extensions

```
1 × SELECT * 
  FROM ydfui_languages
```

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

1 × SELECT id, rules 
  FROM `ydfui_viewlevels

1 × SELECT `session_id` 
  FROM `ydfui_session`

1 × SELECT extension, file, type 
  FROM ydfui_rokcommon_configs

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `ydfui_extensions`

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

1 × SELECT `data` 
  FROM `ydfui_session`

1 × SELECT id, home, template, s.params 
  FROM ydfui_template_styles as s 
  LEFT JOIN ydfui_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM ydfui_menu AS m 
  LEFT JOIN ydfui_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT timestamp 
  FROM ydfui_zt_visitor_counter

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

OTHER Tables:

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

1 × CREATE TABLE IF NOT EXISTS `ydfui_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 × SHOW FULL COLUMNS 
  FROM `ydfui_content

1 × UPDATE `ydfui_extensions` 
  SET `params` = '{\"mediaversion\":\"9908e0b1050ba774d7a4d98390b950ad\"}'

1 × INSERT INTO `ydfui_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('1o1degsdsneded12s6fq2o1200', 1, '1581919407', 0, '', 0

1 × INSERT INTO `ydfui_zt_visitor_counter` (`id`,`timestamp`,`visits`,`guests`,`ipaddress`,`useragent`) 
  VALUES  (null, '1581920307', 1 , 1 , '3.234.245.125', 'other'

```
1 × DELETE  
  FROM `ydfui_session`
```

Template Web Pengadilan Agama Bintuhan

Aplikasi SIPP 3.3.0

SIWAS

e-Court Mahkamah Agung RI

Pengumuman

Berita Pengadilan

Ada Seragam Olga Baru di PA Bintuhan

Ketua PA Bintuhan Dapat Oleh-oleh dari Hakim Agung

Di Bali PA Bintuhan Raih Akreditasi A

Bagaimana Membantu Masyarakat Pencari Keadilan?

Pernikahan Dini Dikaji Dalam Diskusi Perdana 2020 PA Bintuhan

Biru Ceria di PA Bintuhan

Jadwal Sidang

Penelusuran Perkara

Bagaimana Cara Mendapatkan Pelayanan Informasi?

Bantuan Hukum Untuk Masyarakat Tidak Mampu

Pencarian

Pilihan Bahasa

Informasi Cepat

Direktori Putusan Mahkamah Agung

Bantuan Hukum

Informasi Pendaftaran Perkara

Statistik Pengadilan

Pengaduan Pelayanan Pengadilan

Kegiatan Pengadilan

Tautan

Statistik Pengunjung

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 526.39 ms

4 duplicate found!

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: