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

Waktu

Memori

49 Queries Pencatatan 994.51 ms

1. Waktu Query: 0.19 ms

   SELECT `data`
   
     FROM `j17_session`
   
     WHERE `session_id` = '732cc83ec4b61d68d45f928b6641660f'

   Penjelasan

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j17_session	const	PRIMARY	PRIMARY	766	const	1

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Sama seperti panggilan di dalam baris dibawah.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Waktu Query: 0.14 ms Setelah query terakhir: 2.18 ms

   DELETE 
   
     FROM `j17_session`
   
     WHERE `time` < '1614829569'

   Penjelasan

   PENJELASAN tidak mungkin pada query: DELETE FROM `j17_session` WHERE `time` < '1614829569'

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   6	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Waktu Query: 0.12 ms Setelah query terakhir: 0.12 ms

   SELECT `session_id`
   
     FROM `j17_session`
   
     WHERE `session_id` = '732cc83ec4b61d68d45f928b6641660f' 
     LIMIT 1

   Penjelasan

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

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Waktu Query: 58.81 ms Setelah query terakhir: 0.16 ms

   INSERT INTO `j17_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('732cc83ec4b61d68d45f928b6641660f', 0, 1, '1614831369', 0, '')

   Penjelasan

   PENJELASAN tidak mungkin pada query: INSERT INTO `j17_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('732cc83ec4b61d68d45f928b6641660f', 0, 1, '1614831369', 0, '')

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   7	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

5. Waktu Query: 0.20 ms Setelah query terakhir: 5.15 ms

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

   Penjelasan

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

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Waktu Query: 0.13 ms Setelah query terakhir: 0.66 ms

   SELECT id, rules
   
     FROM `j17_viewlevels`

   Penjelasan

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

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Waktu Query: 0.21 ms Setelah query terakhir: 23.82 ms

   SELECT element
   
     FROM j17_extensions
   
     WHERE type = 'language' 
     AND client_id = 0 
     AND enabled = 1

   Penjelasan

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	j17_extensions	ref	extension	extension	82	const	4	Using where

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
   8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Waktu Query: 2.09 ms Setelah query terakhir: 10.22 ms

   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 j17_menu AS m
   
     LEFT JOIN j17_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	243	Using where; Menggunakan pemilah berkas
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	perpus_2014.m.component_id	1

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
   20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
   9	PlgSystemLanguageFilter->onAfterInitialise()	Sama seperti panggilan di dalam baris dibawah.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Waktu Query: 685.66 ms Setelah query terakhir: 243.93 ms

   UPDATE `j17_extensions`
   
     SET `params` = '{\"mediaversion\":\"5eae63f9496665260223b3c74d0004b6\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Penjelasan

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

   Profil

   Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/library/helper.php:119
   9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
   8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Waktu Query: 20.93 ms Setelah query terakhir: 192.52 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN `j17_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1 
      AND (i.language = '*' OR i.language = 'id-ID')
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND c.language in ('id-ID','*')
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where; Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    1	PRIMARY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	perpus_2014.c.id	19
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    14	JCategories->get()	JROOT/components/com_content/models/categories.php:115
    13	ContentModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/categories.php:55
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Waktu Query: 0.19 ms Setelah query terakhir: 46.45 ms

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

    Penjelasan

    PENJELASAN tidak mungkin pada query: CREATE TABLE IF NOT EXISTS `j17_powr` ( `data_type` VARCHAR(50) NOT NULL, `value` VARCHAR(50) NOT NULL, PRIMARY KEY (`data_type`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    27	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/database.php:33
    26	JDatabase->query()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:116
    25	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:93
    24	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:163
    23	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/cms/plugin/helper.php:230
    22	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    21	JPluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
    20	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    19	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    17	JHtml::_()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:27
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Waktu Query: 0.19 ms Setelah query terakhir: 0.10 ms

    SELECT value 
      FROM j17_powr 
      WHERE data_type = 'powr_token'

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j17_powr	const	PRIMARY	PRIMARY	152	const	1

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    27	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1453
    26	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:121
    25	PowrHelper->get_powr_token()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:93
    24	PowrHelper->__construct()	JROOT/plugins/content/powrshortcodes/powrshortcodes.php:163
    23	require_once JROOT/plugins/content/powrshortcodes/powrshortcodes.php	JROOT/libraries/cms/plugin/helper.php:230
    22	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    21	JPluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
    20	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    19	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    17	JHtml::_()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:27
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Waktu Query: 0.42 ms Setelah query terakhir: 4.15 ms

    SELECT MAX(ordering)
    
      FROM `j17_extensions`
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'content'

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j17_extensions	ref	extension	extension	82	const	125	Using where

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1728
    24	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
    23	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    22	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    21	JPluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
    20	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    19	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    17	JHtml::_()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:27
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Waktu Query: 0.19 ms Setelah query terakhir: 0.14 ms

    SELECT `ordering`
    
      FROM `j17_extensions`
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'content' 
      AND `element` = 'perfect_everything_in_everyway'

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j17_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using where

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1728
    24	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
    23	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    22	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    21	JPluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
    20	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    19	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    17	JHtml::_()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:27
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Waktu Query: 0.20 ms Setelah query terakhir: 1.10 ms

    SELECT * 
      FROM j17_fsj_plg_plugin 
      WHERE type = 'include'

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j17_fsj_plg_plugin	ref	idx_name,Main	idx_name	152	const	1	Using where

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/fsj_core/lib/utils/plugin_handler.php:31
    27	FSJ_Plugin_Handler::GetPlugins()	JROOT/plugins/content/fsj_include/fsj_include.php:31
    26	plgContentFSJ_Include->LoadPlugins()	JROOT/plugins/content/fsj_include/fsj_include.php:53
    25	plgContentFSJ_Include->Process()	JROOT/plugins/content/fsj_include/fsj_include.php:22
    24	plgContentFSJ_Include->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    23	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    20	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    19	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    17	JHtml::_()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:27
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Waktu Query: 0.11 ms Setelah query terakhir: 0.13 ms

    SELECT * 
      FROM j17_fsj_includes_alias 
      WHERE state = 1

    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

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    28	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    27	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/fsj_include/fsj_include.php:43
    26	plgContentFSJ_Include->LoadAliases()	JROOT/plugins/content/fsj_include/fsj_include.php:54
    25	plgContentFSJ_Include->Process()	JROOT/plugins/content/fsj_include/fsj_include.php:22
    24	plgContentFSJ_Include->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    23	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    20	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    19	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    18	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    17	JHtml::_()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:27
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Waktu Query: 1.83 ms Setelah query terakhir: 0.91 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=2
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Waktu Query: 1.73 ms Setelah query terakhir: 1.42 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=8
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Waktu Query: 1.68 ms Setelah query terakhir: 1.41 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=26
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Waktu Query: 1.70 ms Setelah query terakhir: 0.76 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=28
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Waktu Query: 1.73 ms Setelah query terakhir: 1.08 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=33
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Waktu Query: 1.63 ms Setelah query terakhir: 1.25 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=47
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Waktu Query: 1.75 ms Setelah query terakhir: 0.74 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=49
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Waktu Query: 1.65 ms Setelah query terakhir: 1.41 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=53
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Waktu Query: 1.66 ms Setelah query terakhir: 0.56 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=55
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Waktu Query: 1.73 ms Setelah query terakhir: 0.92 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=58
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Waktu Query: 1.64 ms Setelah query terakhir: 1.26 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=63
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Waktu Query: 1.68 ms Setelah query terakhir: 0.72 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=65
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Waktu Query: 1.64 ms Setelah query terakhir: 0.89 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=68
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Waktu Query: 1.64 ms Setelah query terakhir: 0.73 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=70
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Waktu Query: 1.65 ms Setelah query terakhir: 0.54 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=74
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Waktu Query: 1.64 ms Setelah query terakhir: 0.72 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=76
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Waktu Query: 1.67 ms Setelah query terakhir: 0.74 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=78
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Waktu Query: 1.64 ms Setelah query terakhir: 0.73 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=94
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Waktu Query: 1.73 ms Setelah query terakhir: 0.57 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=29
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Tidak ada TAMPILKAN PROFIL (mungkina karena ada lebih dari 100 queries)

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Waktu Query: 1.65 ms Setelah query terakhir: 0.75 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=96
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.48 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    init	0.06 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Creating tmp table	0.29 ms
    executing	0.00 ms
    Copying to tmp table	0.30 ms
    Sorting result	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Waktu Query: 1.67 ms Setelah query terakhir: 0.56 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=104
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.45 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    init	0.06 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Creating tmp table	0.29 ms
    executing	0.00 ms
    Copying to tmp table	0.35 ms
    Sorting result	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Waktu Query: 1.61 ms Setelah query terakhir: 0.60 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=133
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.47 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    init	0.06 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Creating tmp table	0.30 ms
    executing	0.00 ms
    Copying to tmp table	0.28 ms
    Sorting result	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Waktu Query: 1.62 ms Setelah query terakhir: 0.57 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=140
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    executing	0.00 ms
    Copying to tmp table	0.47 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    init	0.07 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Creating tmp table	0.27 ms
    executing	0.00 ms
    Copying to tmp table	0.30 ms
    Sorting result	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Waktu Query: 2.15 ms Setelah query terakhir: 0.57 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM j17_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN j17_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('id-ID','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=143
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Menggunakan pemilah berkas
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	281	Using where
    1	PRIMARY	<derived2>	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	32	Using where; Not exists
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	32	Using where; Using temporary; Menggunakan pemilah berkas
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	281	Using where; Using index; Using join buffer

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    executing	0.00 ms
    Copying to tmp table	0.48 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    removing tmp table	0.00 ms
    Sending data	0.00 ms
    init	0.06 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Creating tmp table	0.28 ms
    executing	0.00 ms
    Copying to tmp table	0.37 ms
    Sorting result	0.01 ms
    Sending data	0.05 ms
    end	0.00 ms
    removing tmp table	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.42 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:88
    17	ContentHelperRoute::getCategoryRoute()	JROOT/templates/unair-joomla/html/com_content/categories/default_items.php:46
    16	include JROOT/templates/unair-joomla/html/com_content/categories/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15	JViewLegacy->loadTemplate()	JROOT/templates/unair-joomla/html/com_content/categories/default.php:18
    14	include JROOT/templates/unair-joomla/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12	JViewLegacy->display()	JROOT/libraries/legacy/view/categories.php:96
    11	JViewCategories->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. Waktu Query: 0.44 ms Setelah query terakhir: 1.58 ms

    SELECT language,id
    
      FROM `j17_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	j17_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	244	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.29 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
    8	PlgSystemLanguageFilter->onAfterDispatch()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

42. Waktu Query: 0.21 ms Setelah query terakhir: 1.03 ms

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `j17_menu` AS `c`
    
      INNER JOIN `j17_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `j17_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `j17_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 311

    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.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.00 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
    9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
    8	PlgSystemLanguageFilter->onAfterDispatch()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. Waktu Query: 1.64 ms Setelah query terakhir: 10.28 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM j17_modules AS m
    
      LEFT JOIN j17_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN j17_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 <= '2021-03-04 04:16:11') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-04 04:16:11') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 311 OR mm.menuid <= 0) 
      AND m.language IN ('id-ID','*')
    
      ORDER BY m.position, m.ordering

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	58	Using where; Menggunakan pemilah berkas
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	perpus_2014.m.module,const	1	Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	perpus_2014.m.id	2	Using where; Using index

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.28 ms
    Sending data	1.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	Sama seperti panggilan di dalam baris dibawah.
    18	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    17	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:446
    16	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:382
    15	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:84
    14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:633
    12	T3Template->countModules()	JROOT/templates/unair-joomla/tpls/blocks/header.php:22
    11	include JROOT/templates/unair-joomla/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:195
    10	T3Template->loadBlock()	JROOT/templates/unair-joomla/tpls/default-content-left.php:32
    9	include JROOT/templates/unair-joomla/tpls/default-content-left.php	JROOT/plugins/system/t3/includes/core/template.php:221
    8	T3Template->loadLayout()	JROOT/templates/unair-joomla/index.php:50
    7	require JROOT/templates/unair-joomla/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

44. Waktu Query: 0.20 ms Setelah query terakhir: 23.55 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM j17_modules AS m
    
      WHERE m.id = 306 
      AND m.published = 1 
      AND m.access IN (1,1)

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:333
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:305
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:260
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:235
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:188
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:86
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

45. Waktu Query: 0.15 ms Setelah query terakhir: 6.74 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM j17_modules AS m
    
      WHERE m.id = 305 
      AND m.published = 1 
      AND m.access IN (1,1)

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:333
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:305
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:260
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:235
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:188
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:86
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

46. Waktu Query: 0.10 ms Setelah query terakhir: 13.70 ms

    LOCK TABLES `j17_extensions` WRITE

    Penjelasan

    PENJELASAN tidak mungkin pada query: LOCK TABLES `j17_extensions` WRITE

    Profil

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:543
    9	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:79
    8	PlgSystemUpdatenotification->onAfterRender()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

47. Waktu Query: 180.69 ms Setelah query terakhir: 0.08 ms

    UPDATE `j17_extensions`
    
      SET `params` = '{\"lastrun\":1614831371}'
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'system' 
      AND `element` = 'updatenotification'

    Penjelasan

    PENJELASAN tidak mungkin pada query: UPDATE `j17_extensions` SET `params` = '{\"lastrun\":1614831371}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.00 ms
    init	0.07 ms
    Updating	0.05 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	180.47 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    9	JDatabaseDriverMysql->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:90
    8	PlgSystemUpdatenotification->onAfterRender()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. Waktu Query: 0.06 ms Setelah query terakhir: 0.44 ms

    UNLOCK TABLES

    Penjelasan

    PENJELASAN tidak mungkin pada query: UNLOCK TABLES

    Profil

    Status	Duration
    starting	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:918
    9	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:104
    8	PlgSystemUpdatenotification->onAfterRender()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. Waktu Query: 0.53 ms Setelah query terakhir: 0.62 ms

    SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
    
      FROM `j17_update_sites` AS `a`
    
      INNER JOIN j17_update_sites_extensions AS b 
      ON a.update_site_id = b.update_site_id
    
      WHERE a.enabled = 1 
      AND b.extension_id IN (700)

    Penjelasan

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	index	PRIMARY	PRIMARY	8	NULL	64	Using where; Using index; Using temporary
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	perpus_2014.b.update_site_id	1	Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.25 ms
    executing	0.00 ms
    Copying to tmp table	0.04 ms
    Sending data	0.01 ms
    end	0.00 ms
    removing tmp table	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1494
    11	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/updater/updater.php:229
    10	JUpdater->getUpdateSites()	JROOT/libraries/joomla/updater/updater.php:119
    9	JUpdater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:123
    8	PlgSystemUpdatenotification->onAfterRender()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---