Vaginosis Bakterialis / Bakterial Vaginosis / VB

Rabu, 17 Mei 2017 22:05

Vaginosis Bakterialis / Bakterial Vaginosis / VB

Written by Mimin

font size decrease font size increase font size
Print
Email
Be the first to comment!

Rate this item

(0 votes)

Kompetensi	:	4A
Sistem Terkait	:	Reproduksi
Fisiologi Terkait	:
Anatomi Terkait	:
Keyword	:	Infeksi

Definisi

Vaginosis Bakterialis adalah sindrom klinik akibat pergantian Lactobacillus Spp penghasil hidrogen peroksida (H2O2) yang merupakan flora normal vagina dengan bakteri anaerob dalam konsentrasi tinggi

(contoh : Bacteroides Spp,Mobilincus Spp), Gardnerella vaginalis, dan Mycoplasma hominis.
Jadi, bakterial vaginosis bukan suatu infeksi yang disebabkan oleh suatu organisme, tetapi timbul akibat perubahan kimiawi dan pertumbuhan berlebih dari bakteri yang berkolonisasi di vagina.
Vaginosis Bakterialis adalah sindrom klinik akibat pergantian Lactobacillus Spp penghasil hidrogen peroksida (H2O2) yang merupakan flora normal vagina dengan bakteri anaerob dalam konsentrasi tinggi
bakterial vaginosis bukan suatu infeksi yang disebabkan oleh suatu organisme, tetapi timbul akibat perubahan kimiawi dan pertumbuhan berlebih dari bakteri yang berkolonisasi di vagina.

Epidemiologi :

Etiologi

Etiologi :

akibat pergantian Lactobacillus Spp penghasil hidrogen peroksida (H2O2) yang merupakan flora normal vagina dengan bakteri anaerob dalam konsentrasi tinggi
(contoh : Bacteroides Spp,Mobilincus Spp), Gardnerella vaginalis, dan Mycoplasma hominis.
Pergantian Lactobacillus Spp penghasil hidrogen peroksida (H2O2) yang merupakan flora normal vagina dengan bakteri anaerob dalam konsentrasi tinggi ¹

Mikroorganisme : Gardnerella vaginalis ¹

Mycoplasma hominis¹
Prevotella sp.
Mobiluncus Sp.
Mycoplasma, Bacteroides
Peptostreptococcus
Ureaplasma urealyticum
Eubacterium
Fusobacterium
Veilonella
Streptococcus viridans
Atopobium vaginae

Faktor resiko

BV berhubungan dengan seks multipartner
Douching
Jumlah lactobacillus (flora normal vagina) turun
Semakin sering berhubungan seks → semakin beresiko
Semakin jarang berhubungan seks → semakin rendah resiko

Klasifikasi

Patogenesis

//Gambar Patogenesis//

Patofisiologi

//Gambar Patofisiologi//

Diagnosis

Anamnesis	Keluhan gatal-gatal Keputihan yang abnormal Perih pada perineum saat BAK
Pemeriksaan Fisik	Keputihan Encer dan bau amis Pemeriksaan pH > 4,5 Didapatkan keputihan yang homogen Labia, introitas, serviks dapat normal maupun didapatkan tanda servisitis. Keputihan biasanya terdapat banyak di fornix posterior Dapat ditemukan gelembung pada keputihan
Differential Diagnosis	Candidiasis Sifilis Kondiloma Akuminata Tricomonas
Pemeriksaan Penunjang	Pemeriksaan Gram (Pemeriksaan Gram) Pemeriksaan Mikroskopis Khas : Clue cell Pemeriksaan mikroskopis cairan keputihan harus memenuhi 3 dari 4 kriteria Amsel untuk menegakkan diagnosis bakterial vaginosis IMF test : untuk bau amisnya Kultur bakteri didapatkan bakteri Bakteri gram negatif, fakultatif anaerob berada di vagina karena lactobacillus menurun
Pendekatan Diagnosis	Kriteria Amsel : Terpenuhi 3 dari 4 Duh tubuh homogen putih keabuan Sediaan basah dengan larutan NaCI fisiologis atau sediaan apus dengan pewarnaan Gram ditemukan clue cells pH vagina >4.5 Whiff test (+): Duh tubuh berbau amis (fishy odor sebelum atau sesudah ditetesi KOH 10%, sebagai akibat dari pelepasan amina yang merupakan produk metabolisme bakteri Komplikasi Umum Endometritis, penyakit radang panggul, sepsis paskaaborsi, infeksi paskabedah, infeksi paskahisterektomi, peningkatan risiko penularan HIV dan IMS lain Komplikasi obstetrik** Keguguran, lahir mati, perdarahan, kelahiran prematur, persalinan prematur, ketuban pecah dini, infeksi cairan ketuban, endometritis paskapersalinan dan kejadian infeksi daerah operasi (IDO)

Gambar 3. Tatalakasana

dd vb

	Candidiasis	Vaginosis Bakterialis	Sifilis	Kondiloma Akumimnata	Tricomonas
Etiologi	Candida Sp	Gardnerella Baginalis	Treponema palidum	HPV	Trivomonas vaginalis
Gejala	Keluar cairan putih, kental , bregumpal pH vagina <4,5 Rasa gatal Tidak bau Disurra Laki laki : gland penis merah	Cairan homogen putih keabuan pH > 4,5 tidak ada rasa gatal bau amims Clue cell	Klasifikasi : 1. Primer : ada ulkus durum nyeri batas tegas 2. Sekuner Limpa deropati generalisat Lesi mukokuran 3. Laten Pemeriksaan reaktif gejala tidak ada	Terdapat erupsi : vili formis (bunga kol, warna kulit keabuabuan)	Keluar cairan hijau-kuning ada busa pH >5 eritem, edem rasa gatal strawberry serviks berbau
Diagnosis	Pemeriksaan mikroskopis : miselium, pseudo hifa spesimen diambil dari kerukan kulit → teteskan KOH	Pemeriksaan Mikroskopis Clue sell (tidak rata bentuknya) Pemeriksaan pH IMF test untuk bau ammisnya kultur bakteri	Klasifikasi 1. Stadium dini Primer Sekunder (stadium II) laten 2. Stadium lanjut tersier cardilovaskular konginital dini & lanjut jantung pembuluh darah (lesi di aorta)	Pemeriksaan aseta 5% (dioleskan di lesinya + (putih) coposcopi (subkllinis) gunakan cahaya lensa binokular untuk identifikasi KA ada bertukar kutil merah / pink	Pemeriksaan mikroskopis : Flagelata
Tatalaksana	Beri kotrimazol 200mg secara intra vagina (selama 3 hari) mikonazol 200 mg dosis tunggal 500 mg ketokonazol 200 mg diberir setelah makan pada pagi hari (selama 10 hari	Metronidazol 500 mg (selama 7-10 hari)	Bentazin penisilin 6 2,4 juta IU secara IM	Kemmoterapi : Pedovilin imunoterapi tindakan bedah	Metronidazol 500 mg 2x sehari (selama 7-10 hari TInidazol 500 mg 2x selama 7 hari

Tatalaksana

Prinsip
Non-Farmakoterapi
Farmakoterapi	Tatalaksana :² Metronidazol 2x500 mg/hari selama 7 hari, ATAU Metronidazol 2 gram per oral dosis tunggal, ATAU Obat alternatif: Klindamisin 2x300 mg/hari per oral selama 7 hari Catatan: Pasien dianjurkan untuk tidak mengkonsumsi alkohol selama pengobatan dengan metronidazol berlangsung sampai 48 jam sesudahnya untuk menghindari disulfiram-like reaction4
Tatalaksana Lain
Respon Terapi

Prognosis

Prognosis

Quo Ad vitam :
Quo Ad functionam :
Quo Ad sanationam :

Sumber

PPK PERDOSKI 2017
Bacterial Vaginosis: Practice Essentials, Background, Pathophysiology (medscape.com)

Read 1712 times Last modified on Jumat, 16 Juli 2021 03:42

Published in Kompetensi 4A

Mimin

Latest from Mimin

Related items

More in this category: « HIV AIDS Tanpa Komplikasi Anemia Sideroblastik »

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Konsol Debug Joomla!

Sesi

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1716065427,
                "last": 1716065445,
                "now": 1716065455
            },
            "token": "SUSaZyznuXSfsPjKU0mPWpGCFPGJBiJ7"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "e587ca89561db6c4493b63eeb4ddda49ffd80ba3",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "fc80841c260c34edc24d2c7d501c61693fe9fbdd": {
                    "link": "http:\/\/koasbuyan.com\/index.php?option=com_k2&view=item&id=190:vaginosis-bakterialis&Itemid=179",
                    "expiry": 1716065455
                }
            }
        }
    }
}

Informasi Profil

Waktu

Memori

Waktu: 14.68 ms / 14.68 ms Memori: 1.780 MB / 2.16 MB Application: afterLoad

Waktu: 64.00 ms / 78.67 ms Memori: 5.270 MB / 7.43 MB Application: afterInitialise

Waktu: 27.17 ms / 105.84 ms Memori: 1.422 MB / 8.86 MB Application: afterRoute

Waktu: 1.27 ms / 107.11 ms Memori: 0.060 MB / 8.92 MB Application: beforeRenderComponent com_k2

Waktu: 0.29 ms / 107.41 ms Memori: 0.027 MB / 8.94 MB Application: Before Access::preloadComponents (all components)

Waktu: 1.35 ms / 108.76 ms Memori: 0.070 MB / 9.01 MB Application: After Access::preloadComponents (all components)

Waktu: 0.04 ms / 108.80 ms Memori: -0.003 MB / 9.01 MB Application: Before Access::getAssetRules (id:55 name:com_k2)

Waktu: 0.61 ms / 109.41 ms Memori: 0.027 MB / 9.04 MB Application: After Access::getAssetRules (id:55 name:com_k2)

Waktu: 443.78 ms / 553.18 ms Memori: 4.643 MB / 13.68 MB Application: afterRenderComponent com_k2

Waktu: 2.47 ms / 555.65 ms Memori: 0.098 MB / 13.78 MB Application: afterDispatch

Waktu: 164.25 ms / 719.90 ms Memori: 2.102 MB / 15.88 MB Application: beforeRenderModule mod_menu (Main Menu)

Waktu: 3.88 ms / 723.78 ms Memori: 0.079 MB / 15.96 MB Application: afterRenderModule mod_menu (Main Menu)

Waktu: 0.15 ms / 723.93 ms Memori: -0.009 MB / 15.95 MB Application: beforeRenderModule mod_je_accordionmenu (MedShop)

Waktu: 1.01 ms / 724.94 ms Memori: 0.029 MB / 15.98 MB Application: afterRenderModule mod_je_accordionmenu (MedShop)

Waktu: 0.10 ms / 725.03 ms Memori: -0.003 MB / 15.97 MB Application: beforeRenderModule mod_finder (Search)

Waktu: 13.43 ms / 738.46 ms Memori: 0.357 MB / 16.33 MB Application: afterRenderModule mod_finder (Search)

Waktu: 0.09 ms / 738.55 ms Memori: -0.007 MB / 16.32 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Waktu: 1.30 ms / 739.85 ms Memori: 0.023 MB / 16.35 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Waktu: 8.41 ms / 748.26 ms Memori: 0.389 MB / 16.74 MB Application: afterRender

Total database queries: 404.64 ms

Penggunaan Memori

Queri Database

52 Queries Pencatatan 404.64 ms

Waktu Query: 1.84 ms Memori Query: 0.007 MB Memori sebelum query: 3.839 MB Kolom dikembalikan: 1

SELECT `data`

  FROM `on4ct_session`

  WHERE `session_id` = X'3538643335656439326564666538326533326338393436383763643338373933'

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_session	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	142	Using where

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Sama seperti panggilan di dalam baris dibawah.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:804
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.96 ms Setelah query terakhir: 3.60 ms Memori Query: 0.006 MB Memori sebelum query: 4.205 MB Kolom dikembalikan: 43

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

  FROM `on4ct_extensions`

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

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_extensions	ref	extension	extension	82	const	34	Using index condition; Using where

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.31 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Sama seperti panggilan di dalam baris dibawah.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.56 ms Setelah query terakhir: 2.17 ms Memori Query: 0.005 MB Memori sebelum query: 4.421 MB Kolom dikembalikan: 5

SELECT id, rules

  FROM `on4ct_viewlevels`

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_viewlevels	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	5

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.62 ms Setelah query terakhir: 0.15 ms Memori Query: 0.005 MB Memori sebelum query: 4.433 MB Kolom dikembalikan: 2

SELECT b.id

  FROM on4ct_usergroups AS a

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

  WHERE a.id = 9

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	8	Using where
1	SIMPLE	b	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	8	Using where; Using join buffer (flat, BNL join)

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 2.54 ms Setelah query terakhir: 0.65 ms Memori Query: 0.005 MB Memori sebelum query: 4.502 MB Kolom dikembalikan: 108

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

  FROM on4ct_extensions

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

  ORDER BY ordering

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_extensions	ref	extension	extension	82	const	260	Using index condition; Using where; Menggunakan pemilah berkas

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.76 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Sama seperti panggilan di dalam baris dibawah.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.90 ms Setelah query terakhir: 24.76 ms Memori Query: 0.009 MB Memori sebelum query: 6.919 MB Kolom dikembalikan: 1

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

  FROM `on4ct_extensions`

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

Penjelasan

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

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Sama seperti panggilan di dalam baris dibawah.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.58 ms Setelah query terakhir: 0.18 ms Memori Query: 0.006 MB Memori sebelum query: 6.912 MB

UPDATE `on4ct_extensions`

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

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

Penjelasan

PENJELASAN tidak mungkin pada query: UPDATE `on4ct_extensions` SET `params` = '{\"mediaversion\":\"cfd6059cb2cd3e94c69e2ebddafbdf33\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.15 ms
Updating	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.48 ms Setelah query terakhir: 10.16 ms Memori Query: 0.009 MB Memori sebelum query: 7.618 MB Kolom dikembalikan: 42

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 on4ct_menu AS m

  LEFT JOIN on4ct_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

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	Using index condition; Using where; Menggunakan pemilah berkas
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 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.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.81 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama seperti panggilan di dalam baris dibawah.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:395
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:511
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.58 ms Setelah query terakhir: 15.73 ms Memori Query: 0.007 MB Memori sebelum query: 8.568 MB Kolom dikembalikan: 1

SELECT *

  FROM on4ct_languages

  WHERE published=1

  ORDER BY ordering ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_languages	system	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:235
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.99 ms Setelah query terakhir: 3.21 ms Memori Query: 0.009 MB Memori sebelum query: 8.807 MB Kolom dikembalikan: 4

SELECT id, home, template, s.params

  FROM on4ct_template_styles as s

  LEFT JOIN on4ct_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

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	tbhuoblc_koasbuyan.s.template,const	1	Using index condition; Using where

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Sama seperti panggilan di dalam baris dibawah.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Sama seperti panggilan di dalam baris dibawah.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:259
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.09 ms Setelah query terakhir: 3.56 ms Memori Query: 0.006 MB Memori sebelum query: 8.947 MB Kolom dikembalikan: 43

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

  FROM `on4ct_assets`

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

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_assets	ALL	idx_asset_name	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	222	Using where

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.09 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.37 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 2.31 ms Setelah query terakhir: 14.63 ms Memori Query: 0.007 MB Memori sebelum query: 10.012 MB Kolom dikembalikan: 313

SELECT id 
  FROM on4ct_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_categories	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	1.69 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 3.84 ms Setelah query terakhir: 0.31 ms Memori Query: 0.007 MB Memori sebelum query: 10.019 MB Kolom dikembalikan: 1

SELECT * 
  FROM on4ct_k2_items 
  WHERE id=190 
  LIMIT 0, 1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_items	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	936	Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	3.34 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.13 ms Setelah query terakhir: 1.06 ms Memori Query: 0.009 MB Memori sebelum query: 10.144 MB Kolom dikembalikan: 14

SHOW FULL COLUMNS 
  FROM `on4ct_k2_categories`

Penjelasan

PENJELASAN tidak mungkin pada query: SHOW FULL COLUMNS FROM `on4ct_k2_categories`

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.31 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.09 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.11 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.53 ms Setelah query terakhir: 0.64 ms Memori Query: 0.007 MB Memori sebelum query: 10.186 MB Kolom dikembalikan: 1

SELECT * 
  FROM on4ct_k2_categories 
  WHERE id = '2'

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_categories	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	1.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.10 ms Setelah query terakhir: 2.46 ms Memori Query: 0.007 MB Memori sebelum query: 10.354 MB Kolom dikembalikan: 1

SELECT * 
  FROM on4ct_k2_categories 
  WHERE id = '44'

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_categories	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.59 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:85
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 2.16 ms Setelah query terakhir: 0.36 ms Memori Query: 0.008 MB Memori sebelum query: 10.377 MB Kolom dikembalikan: 2

SELECT tag.*
            
  FROM on4ct_k2_tags AS tag
            JOIN on4ct_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 190
            
  ORDER BY xref.id ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	400	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	xref	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2394	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	1.51 ms
Creating sort index	0.03 ms
Removing tmp table	0.03 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1190
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:104
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.52 ms Setelah query terakhir: 0.47 ms Memori Query: 0.007 MB Memori sebelum query: 10.389 MB Kolom dikembalikan: 0

SELECT * 
  FROM on4ct_k2_attachments 
  WHERE itemID=190

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_attachments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1418
13	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:156
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.48 ms Setelah query terakhir: 0.07 ms Memori Query: 0.007 MB Memori sebelum query: 10.396 MB Kolom dikembalikan: 0

SELECT * 
  FROM on4ct_k2_rating 
  WHERE itemID = 190

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_rating	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:887
14	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:931
13	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:161
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.33 ms Setelah query terakhir: 1.80 ms Memori Query: 0.011 MB Memori sebelum query: 10.507 MB Kolom dikembalikan: 16

SHOW FULL COLUMNS 
  FROM `on4ct_users`

Penjelasan

PENJELASAN tidak mungkin pada query: SHOW FULL COLUMNS FROM `on4ct_users`

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.40 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.09 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.11 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.48 ms Setelah query terakhir: 0.16 ms Memori Query: 0.009 MB Memori sebelum query: 10.542 MB Kolom dikembalikan: 1

SELECT *

  FROM `on4ct_users`

  WHERE `id` = 741

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_users	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.57 ms Setelah query terakhir: 3.84 ms Memori Query: 0.009 MB Memori sebelum query: 11.296 MB Kolom dikembalikan: 1

SELECT `g`.`id`,`g`.`title`

  FROM `on4ct_usergroups` AS g

  INNER JOIN `on4ct_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 741

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	3	Using where
1	SIMPLE	g	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	8	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.57 ms Setelah query terakhir: 1.44 ms Memori Query: 0.007 MB Memori sebelum query: 11.304 MB Kolom dikembalikan: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM on4ct_k2_users 
  WHERE userID=741

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_users	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1668
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:204
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.55 ms Setelah query terakhir: 0.48 ms Memori Query: 0.007 MB Memori sebelum query: 11.312 MB Kolom dikembalikan: 1

SELECT COUNT(*) 
  FROM on4ct_k2_comments 
  WHERE itemID=190 
  AND published=1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_comments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	23	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1457
13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.69 ms Setelah query terakhir: 10.99 ms Memori Query: 0.010 MB Memori sebelum query: 11.994 MB Kolom dikembalikan: 0

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

  FROM on4ct_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	l	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ag	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	5	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ua	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.19 ms
Checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.18 ms
Preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.38 ms
Creating sort index	0.14 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:579
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.37 ms Setelah query terakhir: 1.13 ms Memori Query: 0.010 MB Memori sebelum query: 12.059 MB Kolom dikembalikan: 0

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

  FROM on4ct_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	l	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ag	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	5	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ua	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.32 ms
Creating sort index	0.07 ms
Removing tmp table	0.09 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.42 ms Setelah query terakhir: 9.53 ms Memori Query: 0.009 MB Memori sebelum query: 12.606 MB Kolom dikembalikan: 36

SHOW FULL COLUMNS 
  FROM `on4ct_k2_items`

Penjelasan

PENJELASAN tidak mungkin pada query: SHOW FULL COLUMNS FROM `on4ct_k2_items`

Profil

Status	Duration
Starting	0.18 ms
Checking permissions	0.03 ms
Closing tables	0.08 ms
Opening tables	0.30 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.13 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
14	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:812
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 17.04 ms Setelah query terakhir: 0.28 ms Memori Query: 0.006 MB Memori sebelum query: 12.665 MB

UPDATE on4ct_k2_items

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

  WHERE `id` = '190'

Penjelasan

PENJELASAN tidak mungkin pada query: UPDATE on4ct_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '190'

Profil

Status	Duration
Starting	0.07 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 for update	0.04 ms
Updating	16.12 ms
End of update loop	0.04 ms
Query end	0.02 ms
Commit	0.45 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:813
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.70 ms Setelah query terakhir: 0.33 ms Memori Query: 0.007 MB Memori sebelum query: 12.670 MB Kolom dikembalikan: 0

SELECT * 
  FROM on4ct_k2_comments 
  WHERE itemID=190 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 5

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_comments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	23	Using where; Menggunakan pemilah berkas

Profil

Status	Duration
Starting	0.10 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.03 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1439
12	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:241
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 231.69 ms Setelah query terakhir: 1.36 ms Memori Query: 0.007 MB Memori sebelum query: 12.760 MB Kolom dikembalikan: 5

SELECT i.*, c.alias AS categoryalias
            
  FROM on4ct_k2_items AS i
            
  LEFT JOIN on4ct_k2_categories c 
  ON c.id = i.catid
            
  WHERE i.id != 190
                
  AND i.published = 1
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-18 20:50:55')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-18 20:50:55') 
  AND i.access IN(1,1,5) 
  AND i.trash = 0
            
  AND i.created_by = 741
            
  AND i.created_by_alias=''
            
  AND c.published = 1 
  AND c.access IN(1,1,5) 
  AND c.trash = 0
            
  ORDER BY i.created DESC 
  LIMIT 0, 5

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	936	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	c	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where; Using join buffer (flat, BNL join)

Profil

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.07 ms
Optimizing	0.06 ms
Statistics	0.03 ms
Preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	211.68 ms
Creating sort index	3.76 ms
Removing tmp table	15.27 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:553
12	K2ModelItemlist->getAuthorLatest()	JROOT/components/com_k2/views/item/view.html.php:280
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.28 ms Setelah query terakhir: 0.57 ms Memori Query: 0.007 MB Memori sebelum query: 12.804 MB Kolom dikembalikan: 313

SELECT id, name, parent 
  FROM on4ct_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5) 
  ORDER BY parent

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_categories	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where; Menggunakan pemilah berkas

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.74 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:897
14	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:252
13	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:39
12	K2HelperRoute::getItemRoute()	JROOT/components/com_k2/views/item/view.html.php:283
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 3.08 ms Setelah query terakhir: 10.51 ms Memori Query: 0.007 MB Memori sebelum query: 13.045 MB Kolom dikembalikan: 188

SELECT itemID
            
  FROM on4ct_k2_tags_xref
            
  WHERE tagID IN (8,345)
                
  AND itemID != 190
            
  GROUP BY itemID

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_tags_xref	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2394	Using where; Using temporary; Menggunakan pemilah berkas

Profil

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.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	2.03 ms
Creating sort index	0.15 ms
Removing tmp table	0.04 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.09 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:617
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 61.05 ms Setelah query terakhir: 0.18 ms Memori Query: 0.008 MB Memori sebelum query: 13.079 MB Kolom dikembalikan: 5

SELECT i.*, c.alias AS categoryalias
            
  FROM on4ct_k2_items AS i
            
  LEFT JOIN on4ct_k2_categories AS c 
  ON c.id = i.catid
            
  WHERE i.published = 1
                
  AND i.trash = 0
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-18 20:50:55')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-18 20:50:55') 
  AND i.access IN(1,1,5) 
  AND c.access IN(1,1,5) 
  AND c.published = 1 
  AND c.trash = 0 
  AND i.id IN(22,23,25,26,27,28,98,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,144,145,147,148,149,150,152,155,156,157,158,159,160,161,163,165,166,167,168,169,170,171,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,189,191,192,208,232,234,236,241,242,244,606,657,685,714,715,716,717,718,719,720,721,726,728,732,733,734,736,748,749,750,752,753,754,755,756,758,760,761,768,781,782,783,824,838,839,840,866,897,925,932,947,1018,1019,1023,1024,1025,1026,1027,1028,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1121,1145,1205,1233,1254) 
  ORDER BY i.id DESC 
  LIMIT 0, 5

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	936	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	c	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.27 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.09 ms
Statistics	0.05 ms
Preparing	0.07 ms
Creating tmp table	0.10 ms
Sorting result	0.05 ms
Executing	0.02 ms
Sending data	54.86 ms
Creating sort index	1.15 ms
Removing tmp table	3.79 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.10 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:654
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.59 ms Setelah query terakhir: 0.37 ms Memori Query: 0.007 MB Memori sebelum query: 13.163 MB Kolom dikembalikan: 1

SELECT * 
  FROM on4ct_k2_categories 
  WHERE id = '4'

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_categories	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where

Profil

Status	Duration
Starting	0.13 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.04 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.91 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.67 ms Setelah query terakhir: 3.43 ms Memori Query: 0.007 MB Memori sebelum query: 13.279 MB Kolom dikembalikan: 1

SELECT COUNT(*) 
  FROM on4ct_k2_comments 
  WHERE itemID=1254 
  AND published=1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_comments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	23	Using where

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1457
14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.84 ms Setelah query terakhir: 0.53 ms Memori Query: 0.010 MB Memori sebelum query: 13.261 MB Kolom dikembalikan: 0

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

  FROM on4ct_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.relatedByTag-media' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	l	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ag	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	5	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ua	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.24 ms
Checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.05 ms
Executing	0.01 ms
Sending data	0.40 ms
Creating sort index	0.12 ms
Removing tmp table	0.10 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:579
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:665
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.66 ms Setelah query terakhir: 0.57 ms Memori Query: 0.010 MB Memori sebelum query: 13.274 MB Kolom dikembalikan: 0

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

  FROM on4ct_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (4,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	l	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ag	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	5	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ua	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.18 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.05 ms
Executing	0.02 ms
Sending data	0.40 ms
Creating sort index	0.09 ms
Removing tmp table	0.09 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.08 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:665
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.70 ms Setelah query terakhir: 3.06 ms Memori Query: 0.007 MB Memori sebelum query: 13.337 MB Kolom dikembalikan: 1

SELECT COUNT(*) 
  FROM on4ct_k2_comments 
  WHERE itemID=1233 
  AND published=1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_comments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	23	Using where

Profil

Status	Duration
Starting	0.10 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.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1457
14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.58 ms Setelah query terakhir: 0.72 ms Memori Query: 0.007 MB Memori sebelum query: 13.311 MB Kolom dikembalikan: 1

SELECT * 
  FROM on4ct_k2_categories 
  WHERE id = '5'

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_categories	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where

Profil

Status	Duration
Starting	0.10 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.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.95 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.67 ms Setelah query terakhir: 2.66 ms Memori Query: 0.007 MB Memori sebelum query: 13.412 MB Kolom dikembalikan: 1

SELECT COUNT(*) 
  FROM on4ct_k2_comments 
  WHERE itemID=1205 
  AND published=1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_comments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	23	Using where

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 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
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1457
14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.74 ms Setelah query terakhir: 0.62 ms Memori Query: 0.010 MB Memori sebelum query: 13.403 MB Kolom dikembalikan: 0

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

  FROM on4ct_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (5,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	l	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ag	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	5	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ua	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.23 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.07 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.06 ms
Creating tmp table	0.06 ms
Sorting result	0.05 ms
Executing	0.01 ms
Sending data	0.40 ms
Creating sort index	0.13 ms
Removing tmp table	0.09 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:665
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.43 ms Setelah query terakhir: 0.43 ms Memori Query: 0.007 MB Memori sebelum query: 13.405 MB Kolom dikembalikan: 1

SELECT * 
  FROM on4ct_k2_categories 
  WHERE id = '6'

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_categories	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	323	Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.88 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.62 ms Setelah query terakhir: 2.64 ms Memori Query: 0.007 MB Memori sebelum query: 13.541 MB Kolom dikembalikan: 1

SELECT COUNT(*) 
  FROM on4ct_k2_comments 
  WHERE itemID=1145 
  AND published=1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_comments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	23	Using where

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1457
14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.71 ms Setelah query terakhir: 0.60 ms Memori Query: 0.010 MB Memori sebelum query: 13.525 MB Kolom dikembalikan: 0

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

  FROM on4ct_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (6,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	l	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ag	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	5	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	ua	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	Using where; Using join buffer (incremental, BNL join)
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	tbhuoblc_koasbuyan.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.18 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.07 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.07 ms
Creating tmp table	0.06 ms
Sorting result	0.05 ms
Executing	0.01 ms
Sending data	0.38 ms
Creating sort index	0.14 ms
Removing tmp table	0.09 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.09 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:665
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.80 ms Setelah query terakhir: 2.63 ms Memori Query: 0.007 MB Memori sebelum query: 13.588 MB Kolom dikembalikan: 1

SELECT COUNT(*) 
  FROM on4ct_k2_comments 
  WHERE itemID=1121 
  AND published=1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_comments	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	23	Using where

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1457
14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:218
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:664
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:292
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 2.57 ms Setelah query terakhir: 0.81 ms Memori Query: 0.007 MB Memori sebelum query: 13.541 MB Kolom dikembalikan: 1

SELECT *
                
  FROM on4ct_k2_items
                
  WHERE id != 190
                    
  AND catid = 2
                    
  AND ordering > 2
                    
  AND published = 1
                    
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-18 20:50:55')
                    
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-18 20:50:55')
                    
  AND access IN (1,1,5)
                    
  AND trash = 0
                    
                
  ORDER BY ordering ASC 
  LIMIT 0, 1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_items	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	936	Using where; Menggunakan pemilah berkas

Profil

Status	Duration
Starting	0.13 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.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.81 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1650
12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:305
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 2.17 ms Setelah query terakhir: 0.38 ms Memori Query: 0.007 MB Memori sebelum query: 13.564 MB Kolom dikembalikan: 1

SELECT *
                
  FROM on4ct_k2_items
                
  WHERE id != 190
                    
  AND catid = 2
                    
  AND ordering < 2
                    
  AND published = 1
                    
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-18 20:50:55')
                    
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-18 20:50:55')
                    
  AND access IN (1,1,5)
                    
  AND trash = 0
                    
                
  ORDER BY ordering DESC 
  LIMIT 0, 1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_k2_items	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	936	Using where; Menggunakan pemilah berkas

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.02 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.46 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1592
12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:341
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 33.11 ms Setelah query terakhir: 130.15 ms Memori Query: 0.009 MB Memori sebelum query: 15.826 MB Kolom dikembalikan: 6

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

  FROM on4ct_modules AS m

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

  LEFT JOIN on4ct_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 <= '2024-05-18 20:50:55') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-18 20:50:55') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 179 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	137	Using where; Using temporary; Menggunakan pemilah berkas
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	tbhuoblc_koasbuyan.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1088	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.29 ms
Checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.08 ms
Statistics	0.07 ms
Preparing	0.08 ms
Creating tmp table	0.06 ms
Sorting result	0.06 ms
Executing	0.02 ms
Sending data	31.64 ms
Creating sort index	0.09 ms
Removing tmp table	0.15 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.08 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	Sama seperti panggilan di dalam baris dibawah.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:507
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:454
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:263
8	Helix3::generatelayout()	JROOT/templates/shaper_helix3/index.php:174
7	require JROOT/templates/shaper_helix3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.18 ms Setelah query terakhir: 17.39 ms Memori Query: 0.006 MB Memori sebelum query: 16.040 MB Kolom dikembalikan: 7

SELECT `name`,`element`

  FROM `on4ct_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'finder' 
  AND `enabled` = 1

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_extensions	ref	extension	extension	82	const	260	Using index condition; Using where

Profil

Status	Duration
Starting	0.10 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.04 ms
Statistics	0.13 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.43 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:126
11	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.80 ms Setelah query terakhir: 5.96 ms Memori Query: 0.007 MB Memori sebelum query: 16.251 MB Kolom dikembalikan: 8

SELECT `title`

  FROM `on4ct_finder_taxonomy`

  WHERE `parent_id` = 1 
  AND `state` = 1 
  AND `access` IN (1,1,5)

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	on4ct_finder_taxonomy	range	parent_id,state,access,idx_parent_published	idx_parent_published	6	NULL	6	Using index condition

Profil

Status	Duration
Starting	0.12 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.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
14	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
13	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
12	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
11	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 1.25 ms Setelah query terakhir: 7.35 ms Memori Query: 0.010 MB Memori sebelum query: 16.453 MB Kolom dikembalikan: 2

SHOW FULL COLUMNS 
  FROM `on4ct_gsd_config`

Penjelasan

PENJELASAN tidak mungkin pada query: SHOW FULL COLUMNS FROM `on4ct_gsd_config`

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.32 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.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.07 ms
Closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.12 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:26
18	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:414
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:363
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:391
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

Waktu Query: 0.55 ms Setelah query terakhir: 0.14 ms Memori Query: 0.009 MB Memori sebelum query: 16.469 MB Kolom dikembalikan: 0

SELECT *

  FROM on4ct_gsd_config

  WHERE `name` = 'config'

Penjelasan

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

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

Tumpukan Panggilan

#	Pemanggil	Berkas dan angka baris
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
17	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:415
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:363
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:391
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Tambah xdebug.file_link_format langsung ke berkas php.ini Anda untuk menautkan berkas-berkas]

37 Tipe Queri tercatat, Pilah berdasarkan Kemunculan.

SELECT Tabel:

6 × SELECT COUNT(*) 
  FROM on4ct_k2_comments

5 × SELECT * 
  FROM on4ct_k2_categories

4 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM on4ct_fields AS a 
  LEFT JOIN `on4ct_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN on4ct_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN on4ct_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN on4ct_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN on4ct_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `on4ct_fields_categories` AS fc 
  ON fc.field_id = a.id

2 × SELECT *                 
  FROM on4ct_k2_items

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM on4ct_fields AS a 
  LEFT JOIN `on4ct_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN on4ct_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN on4ct_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN on4ct_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN on4ct_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT `data` 
  FROM `on4ct_session`

1 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM on4ct_k2_users

1 × SELECT `title` 
  FROM `on4ct_finder_taxonomy`

1 × SELECT `name`,`element` 
  FROM `on4ct_extensions`

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

1 × SELECT i.*, c.alias AS categoryalias             
  FROM on4ct_k2_items AS i             
  LEFT JOIN on4ct_k2_categories AS c 
  ON c.id = i.catid

1 × SELECT itemID             
  FROM on4ct_k2_tags_xref

1 × SELECT id, name, parent 
  FROM on4ct_k2_categories

1 × SELECT i.*, c.alias AS categoryalias             
  FROM on4ct_k2_items AS i             
  LEFT JOIN on4ct_k2_categories c 
  ON c.id = i.catid

1 × SELECT * 
  FROM on4ct_k2_comments

```
1 × SELECT * 
  FROM `on4ct_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `on4ct_usergroups` AS g 
  INNER JOIN `on4ct_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM on4ct_k2_rating
```

1 × SELECT * 
  FROM on4ct_k2_attachments

1 × SELECT tag.*             
  FROM on4ct_k2_tags AS tag             JOIN on4ct_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

```
1 × SELECT * 
  FROM on4ct_k2_items
```

1 × SELECT id 
  FROM on4ct_k2_categories

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

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

```
1 × SELECT * 
  FROM on4ct_languages
```

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 on4ct_menu AS m 
  LEFT JOIN on4ct_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM on4ct_extensions

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

1 × SELECT id, rules 
  FROM `on4ct_viewlevels

```
1 × SELECT * 
  FROM on4ct_gsd_config
```

Tabel LAIN:

1 × UPDATE `on4ct_extensions` 
  SET `params` = '{\"mediaversion\":\"cfd6059cb2cd3e94c69e2ebddafbdf33\"}'

1 × SHOW FULL COLUMNS 
  FROM `on4ct_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `on4ct_users

1 × SHOW FULL COLUMNS 
  FROM `on4ct_k2_items

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

1 × SHOW FULL COLUMNS 
  FROM `on4ct_gsd_config