CARA PALING MUDAH MENEMUKAN PROPERTI

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728966042,
                "last": 1728966042,
                "now": 1728966042
            }
        },
        "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

44 Queries Pencatatan 59.81 ms

1. Waktu Query: 0.54 ms Memori Query: 0.021 MB Memori sebelum query: 4.362 MB Kolom dikembalikan: 0

   SELECT `data`
   
     FROM `vebxl_session`
   
     WHERE `session_id` = 'fd1f336c5e4c38ab43d3a135a6f0f339'

   Penjelasan

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

   Profil

   Status	Duration
   starting	0.11 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Tumpukan Panggilan

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

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

   ---

2. Waktu Query: 0.41 ms Setelah query terakhir: 1.48 ms Memori Query: 0.013 MB Memori sebelum query: 4.538 MB Kolom dikembalikan: 0

   SELECT `session_id`
   
     FROM `vebxl_session`
   
     WHERE `session_id` = 'fd1f336c5e4c38ab43d3a135a6f0f339' 
     LIMIT 1

   Penjelasan

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

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:47

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

   ---

3. Waktu Query: 2.99 ms Setelah query terakhir: 0.14 ms Memori Query: 0.010 MB Memori sebelum query: 4.555 MB

   INSERT INTO `vebxl_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('fd1f336c5e4c38ab43d3a135a6f0f339', 1, '1728966042', 0, '', 0)

   Penjelasan

   PENJELASAN tidak mungkin pada query: INSERT INTO `vebxl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('fd1f336c5e4c38ab43d3a135a6f0f339', 1, '1728966042', 0, '', 0)

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.15 ms
   end	0.01 ms
   query end	2.48 ms
   closing tables	0.03 ms
   freeing items	0.07 ms
   cleaning up	0.03 ms

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:47

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

   ---

4. Waktu Query: 0.89 ms Setelah query terakhir: 2.57 ms Memori Query: 0.021 MB Memori sebelum query: 4.881 MB Kolom dikembalikan: 38

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `vebxl_extensions`
   
     WHERE `type` = 'component'

   Penjelasan

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	vebxl_extensions	NULL	ref	extension	extension	82	const	38	100.00	NULL

   Profil

   Status	Duration
   starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.22 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.02 ms

   Tumpukan Panggilan

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

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

   ---

5. Waktu Query: 0.57 ms Setelah query terakhir: 2.14 ms Memori Query: 0.015 MB Memori sebelum query: 5.182 MB Kolom dikembalikan: 4

   SELECT id, rules
   
     FROM `vebxl_viewlevels`

   Penjelasan

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	vebxl_viewlevels	NULL	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	4	100.00	NULL

   Profil

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

   Tumpukan Panggilan

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

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

   ---

6. Waktu Query: 0.58 ms Setelah query terakhir: 0.12 ms Memori Query: 0.016 MB Memori sebelum query: 5.206 MB Kolom dikembalikan: 2

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

   Penjelasan

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

   Profil

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

   Tumpukan Panggilan

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

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

   ---

7. Waktu Query: 1.61 ms Setelah query terakhir: 0.68 ms Memori Query: 0.023 MB Memori sebelum query: 5.313 MB Kolom dikembalikan: 77

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM vebxl_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Penjelasan

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	vebxl_extensions	NULL	ref	extension	extension	82	const	98	0.60	Using index condition; Using where; Menggunakan pemilah berkas

   Profil

   Status	Duration
   starting	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.05 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	0.89 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.02 ms

   Tumpukan Panggilan

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

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

   ---

8. Waktu Query: 0.64 ms Setelah query terakhir: 1.16 ms Memori Query: 0.014 MB Memori sebelum query: 5.486 MB Kolom dikembalikan: 2

   SELECT *
   
     FROM vebxl_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Penjelasan

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	vebxl_languages	NULL	ALL	NULL	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	2	50.00	Using where; Menggunakan pemilah berkas

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.07 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	0.09 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
   4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:655
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

   ---

9. Waktu Query: 0.83 ms Setelah query terakhir: 7.93 ms Memori Query: 0.019 MB Memori sebelum query: 6.923 MB Kolom dikembalikan: 0
   Duplikasi queries: #10

   SELECT `manifest_cache`
   
     FROM `vebxl_extensions`
   
     WHERE `type` = 'component' 
     AND `name` = 'com_admintools'

   Penjelasan

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	vebxl_extensions	NULL	ref	extension	extension	82	const	38	10.00	Using where

   Profil

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.16 ms
   end	0.03 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.02 ms

   Tumpukan Panggilan

   #	Pemanggil	Berkas dan angka baris
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
   12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
   11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
   10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
   9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

   ---

10. Waktu Query: 0.74 ms Setelah query terakhir: 3.28 ms Memori Query: 0.019 MB Memori sebelum query: 7.387 MB Kolom dikembalikan: 0
    Duplikasi queries: #9

    SELECT `manifest_cache`
    
      FROM `vebxl_extensions`
    
      WHERE `type` = 'component' 
      AND `name` = 'com_admintools'

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	vebxl_extensions	NULL	ref	extension	extension	82	const	38	10.00	Using where

    Profil

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

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
    12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
    11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
    10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
    9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

11. Waktu Query: 0.94 ms Setelah query terakhir: 0.29 ms Memori Query: 0.019 MB Memori sebelum query: 7.426 MB Kolom dikembalikan: 1

    SELECT `value`
    
      FROM `vebxl_admintools_storage`
    
      WHERE `key` = 'cparams'

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	vebxl_admintools_storage	NULL	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.24 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.18 ms
    preparing	0.13 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
    12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
    11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
    10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
    9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

12. Waktu Query: 0.44 ms Setelah query terakhir: 1.15 ms Memori Query: 0.018 MB Memori sebelum query: 7.621 MB Kolom dikembalikan: 0

    SELECT *
    
      FROM `vebxl_admintools_wafexceptions`
    
      WHERE NOT(`option` LIKE 'com_%')

    Penjelasan

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

    Profil

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

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
    11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:549
    10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
    9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

13. Waktu Query: 0.54 ms Setelah query terakhir: 4.54 ms Memori Query: 0.015 MB Memori sebelum query: 8.468 MB Kolom dikembalikan: 6

    SELECT `element`,`name`,`client_id`,`extension_id`
    
      FROM `vebxl_extensions`
    
      WHERE `type` = 'language' 
      AND `state` = 0 
      AND `enabled` = 1

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	vebxl_extensions	NULL	ref	extension	extension	82	const	6	1.00	Using where

    Profil

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

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
    8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

14. Waktu Query: 3.60 ms Setelah query terakhir: 7.50 ms Memori Query: 0.019 MB Memori sebelum query: 9.083 MB Kolom dikembalikan: 1

    SHOW VARIABLES LIKE "collation_database"

    Penjelasan

    PENJELASAN tidak mungkin pada query: SHOW VARIABLES LIKE "collation_database"

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	2.80 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.14 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:327
    12	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    11	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    9	plgSystemAdmintools->onAfterInitialise()	Sama seperti panggilan di dalam baris dibawah.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

15. Waktu Query: 1.11 ms Setelah query terakhir: 0.18 ms Memori Query: 0.017 MB Memori sebelum query: 9.107 MB Kolom dikembalikan: 0

    SELECT `source`,`keepurlparams`
    
      FROM `vebxl_admintools_redirects`
    
      WHERE ((`dest` = 'id/') OR (`dest` = 'id/') OR ('id/' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.48 ms
    Opening tables	0.09 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.06 ms
    end	0.02 ms
    query end	0.03 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1763
    12	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
    11	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    9	plgSystemAdmintools->onAfterInitialise()	Sama seperti panggilan di dalam baris dibawah.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

16. Waktu Query: 1.46 ms Setelah query terakhir: 1.76 ms Memori Query: 0.037 MB Memori sebelum query: 9.445 MB Kolom dikembalikan: 22

    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 vebxl_menu AS m
    
      LEFT JOIN vebxl_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	52	10.00	Using index condition; Using where; Menggunakan pemilah berkas
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.m.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.76 ms
    end	0.02 ms
    query end	0.03 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama seperti panggilan di dalam baris dibawah.
    21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
    15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
    11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
    10	Joomla\CMS\Application\SiteApplication::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:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

17. Waktu Query: 0.65 ms Setelah query terakhir: 12.18 ms Memori Query: 0.020 MB Memori sebelum query: 11.158 MB Kolom dikembalikan: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `vebxl_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	vebxl_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Sama seperti panggilan di dalam baris dibawah.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

18. Waktu Query: 2.76 ms Setelah query terakhir: 0.16 ms Memori Query: 0.013 MB Memori sebelum query: 11.161 MB

    UPDATE `vebxl_extensions`
    
      SET `params` = '{\"mediaversion\":\"3a9537445e1a449cd324f03d1c4f0327\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	vebxl_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.11 ms
    updating	0.13 ms
    end	0.02 ms
    query end	2.16 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

19. Waktu Query: 0.82 ms Setelah query terakhir: 1.58 ms Memori Query: 0.010 MB Memori sebelum query: 11.493 MB Kolom dikembalikan: 5

    SELECT id, home, template, s.params
    
      FROM vebxl_template_styles as s
    
      LEFT JOIN vebxl_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	8	12.50	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	dbs10196940.s.template,const	1	4.64	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.16 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

20. Waktu Query: 1.54 ms Setelah query terakhir: 6.13 ms Memori Query: 0.030 MB Memori sebelum query: 12.606 MB Kolom dikembalikan: 37

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `vebxl_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_estate','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.21 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.26 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.58 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:113
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

21. Waktu Query: 4.77 ms Setelah query terakhir: 1.69 ms Memori Query: 0.033 MB Memori sebelum query: 12.829 MB Kolom dikembalikan: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM vebxl_content AS a
    
      INNER JOIN vebxl_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN vebxl_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN vebxl_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN vebxl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN vebxl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-15 04:20:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 04:20:42') 
      AND a.language IN ('id-ID','*') 
      AND a.catid IN (8)
    
      ORDER BY c.lft, a.featured DESC, fp.ordering,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 1

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Menggunakan pemilah berkas
    1	SIMPLE	a	NULL	ref	PRIMARY,idx_access,idx_state,idx_catid,idx_language,state_access	idx_catid	4	const	2	14.49	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.modified_by	1	100.00	Using where
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.41 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    Opening tables	0.70 ms
    init	0.28 ms
    System lock	0.03 ms
    optimizing	0.49 ms
    statistics	0.52 ms
    preparing	0.08 ms
    Creating tmp table	0.17 ms
    Sorting result	0.03 ms
    executing	0.02 ms
    Sending data	1.00 ms
    Creating sort index	0.20 ms
    end	0.03 ms
    query end	0.03 ms
    removing tmp table	0.27 ms
    query end	0.03 ms
    closing tables	0.05 ms
    freeing items	0.12 ms
    cleaning up	0.05 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

22. Waktu Query: 0.97 ms Setelah query terakhir: 1.63 ms Memori Query: 0.028 MB Memori sebelum query: 13.200 MB Kolom dikembalikan: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `vebxl_contentitem_tag_map` AS m 
    
      INNER JOIN `vebxl_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 228 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dbs10196940.m.tag_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.14 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.07 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

23. Waktu Query: 1.35 ms Setelah query terakhir: 0.89 ms Memori Query: 0.022 MB Memori sebelum query: 13.348 MB Kolom dikembalikan: 1

    SELECT COUNT(*)
    
      FROM vebxl_content AS a
    
      INNER JOIN vebxl_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN vebxl_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN vebxl_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN vebxl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN vebxl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-15 04:20:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 04:20:42') 
      AND a.language IN ('id-ID','*') 
      AND a.catid IN (8)

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	a	NULL	ref	PRIMARY,idx_access,idx_state,idx_catid,idx_language,state_access	idx_catid	4	const	2	14.49	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.created_by	1	100.00	Using where; Using index
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where; Using index
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.08 ms
    statistics	0.41 ms
    preparing	0.06 ms
    executing	0.01 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

24. Waktu Query: 1.87 ms Setelah query terakhir: 5.05 ms Memori Query: 0.035 MB Memori sebelum query: 14.283 MB Kolom dikembalikan: 4

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

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.25 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.10 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.30 ms
    preparing	0.07 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.19 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    14	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

25. Waktu Query: 1.07 ms Setelah query terakhir: 0.57 ms Memori Query: 0.032 MB Memori sebelum query: 14.397 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    init	0.08 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.11 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    14	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

26. Waktu Query: 1.21 ms Setelah query terakhir: 3.36 ms Memori Query: 0.030 MB Memori sebelum query: 15.115 MB Kolom dikembalikan: 14

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM vebxl_modules AS m
    
      LEFT JOIN vebxl_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN vebxl_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-15 04:20:42') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-15 04:20:42') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 215 OR mm.menuid <= 0) 
      AND m.language IN ('id-ID','*')
    
      ORDER BY m.position, m.ordering

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	27	2.44	Using index condition; Using where; Menggunakan pemilah berkas
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	dbs10196940.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dbs10196940.m.id	2	40.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.52 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	Sama seperti panggilan di dalam baris dibawah.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    16	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:137
    15	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
    14	PlgContentLoadmodule->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

27. Waktu Query: 0.63 ms Setelah query terakhir: 6.71 ms Memori Query: 0.015 MB Memori sebelum query: 15.707 MB Kolom dikembalikan: 3

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

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	vebxl_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	53	1.15	Using where

    Profil

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

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
    8	PlgSystemLanguageFilter->onAfterDispatch()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

28. Waktu Query: 0.55 ms Setelah query terakhir: 0.87 ms Memori Query: 0.016 MB Memori sebelum query: 15.835 MB Kolom dikembalikan: 2

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `vebxl_menu` AS `c`
    
      INNER JOIN `vebxl_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `vebxl_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `vebxl_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 215

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	a	NULL	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
    1	SIMPLE	a2	NULL	ref	idx_key	idx_key	128	const	2	100.00	Using index
    1	SIMPLE	c2	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a2.id	1	100.00	NULL

    Profil

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

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:735
    8	PlgSystemLanguageFilter->onAfterDispatch()	Sama seperti panggilan di dalam baris dibawah.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

29. Waktu Query: 0.92 ms Setelah query terakhir: 6.54 ms Memori Query: 0.037 MB Memori sebelum query: 16.274 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_custom.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    18	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

30. Waktu Query: 1.93 ms Setelah query terakhir: 1.30 ms Memori Query: 0.033 MB Memori sebelum query: 16.381 MB Kolom dikembalikan: 3

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM vebxl_content AS a
    
      LEFT JOIN vebxl_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN vebxl_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN vebxl_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN vebxl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN vebxl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (39) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-15 04:20:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 04:20:42') 
      AND a.language IN ('id-ID','*')
    
      ORDER BY a.ordering DESC 
      LIMIT 3

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Menggunakan pemilah berkas
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_language,state_access	idx_catid	4	const	6	14.49	Using index condition; Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.modified_by	1	100.00	Using where
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.28 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.17 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.28 ms
    preparing	0.06 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.52 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:97
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

31. Waktu Query: 1.06 ms Setelah query terakhir: 1.00 ms Memori Query: 0.037 MB Memori sebelum query: 16.502 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.10 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.07 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    19	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    18	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news/helper.php:120
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

32. Waktu Query: 1.04 ms Setelah query terakhir: 0.36 ms Memori Query: 0.034 MB Memori sebelum query: 16.531 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (39,0,8)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.08 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.19 ms
    preparing	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    16	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:130
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

33. Waktu Query: 1.07 ms Setelah query terakhir: 0.72 ms Memori Query: 0.037 MB Memori sebelum query: 16.567 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (39,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.08 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.06 ms
    Sorting result	0.02 ms
    executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    19	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    18	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news/helper.php:120
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

34. Waktu Query: 1.00 ms Setelah query terakhir: 1.76 ms Memori Query: 0.036 MB Memori sebelum query: 16.495 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_custom.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (39,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.08 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.07 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    18	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

35. Waktu Query: 6.41 ms Setelah query terakhir: 130.29 ms Memori Query: 0.033 MB Memori sebelum query: 16.602 MB Kolom dikembalikan: 4

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM vebxl_content AS a
    
      LEFT JOIN vebxl_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN vebxl_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN vebxl_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN vebxl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN vebxl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (31,30,42,43) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-15 04:20:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 04:20:42') 
      AND a.language IN ('id-ID','*')
    
      ORDER BY a.ordering DESC 
      LIMIT 4

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_language,state_access	idx_state	1	const	243	7.10	Using index condition; Using where; Menggunakan pemilah berkas
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	dbs10196940.a.catid	1	10.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.modified_by	1	100.00	Using where
    1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.c.parent_id	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.50 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.10 ms
    init	0.32 ms
    System lock	0.05 ms
    optimizing	0.07 ms
    statistics	0.58 ms
    preparing	0.13 ms
    Sorting result	0.04 ms
    executing	0.02 ms
    Sending data	0.10 ms
    Creating sort index	3.46 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.03 ms
    freeing items	0.12 ms
    cleaning up	0.04 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:97
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

36. Waktu Query: 1.90 ms Setelah query terakhir: 1.02 ms Memori Query: 0.037 MB Memori sebelum query: 16.747 MB Kolom dikembalikan: 3

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

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Menggunakan pemilah berkas
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	45	9.79	Using where

    Profil

    Status	Duration
    starting	0.33 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    init	0.15 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.33 ms
    preparing	0.06 ms
    Sorting result	0.05 ms
    executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.31 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.09 ms
    cleaning up	0.05 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
    22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    20	ContentRouter->getCategorySegment()	Sama seperti panggilan di dalam baris dibawah.
    19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
    15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:110
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

37. Waktu Query: 1.61 ms Setelah query terakhir: 0.67 ms Memori Query: 0.034 MB Memori sebelum query: 16.787 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (31,0,29)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.27 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    init	0.13 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.23 ms
    preparing	0.08 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.13 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.05 ms
    freeing items	0.09 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    16	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:130
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

38. Waktu Query: 0.95 ms Setelah query terakhir: 1.00 ms Memori Query: 0.037 MB Memori sebelum query: 16.822 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (31,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.07 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    19	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    18	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news/helper.php:120
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:17
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

39. Waktu Query: 1.67 ms Setelah query terakhir: 4.21 ms Memori Query: 0.031 MB Memori sebelum query: 16.829 MB Kolom dikembalikan: 2

    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM vebxl_content AS a
    
      LEFT JOIN vebxl_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN vebxl_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN vebxl_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN vebxl_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN vebxl_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (26) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-15 04:20:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-15 04:20:42') 
      AND a.language IN ('id-ID','*')
    
      ORDER BY a.ordering DESC 
      LIMIT 4

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Menggunakan pemilah berkas
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_language,state_access	idx_catid	4	const	8	14.49	Using index condition; Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs10196940.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.22 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.11 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.23 ms
    preparing	0.06 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.28 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    12	ContentModelArticles->getItems()	JROOT/modules/mod_camera_slideshow/helper.php:67
    11	modCameraSlideshowHelper::getList()	JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php:44
    10	include JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

40. Waktu Query: 0.58 ms Setelah query terakhir: 0.59 ms Memori Query: 0.027 MB Memori sebelum query: 16.909 MB Kolom dikembalikan: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `vebxl_contentitem_tag_map` AS m 
    
      INNER JOIN `vebxl_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 196 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dbs10196940.m.tag_id	1	100.00	Using where

    Profil

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

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    12	ContentModelArticles->getItems()	JROOT/modules/mod_camera_slideshow/helper.php:67
    11	modCameraSlideshowHelper::getList()	JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php:44
    10	include JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

41. Waktu Query: 0.57 ms Setelah query terakhir: 0.32 ms Memori Query: 0.027 MB Memori sebelum query: 16.947 MB Kolom dikembalikan: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `vebxl_contentitem_tag_map` AS m 
    
      INNER JOIN `vebxl_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 198 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Penjelasan

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	TIDAK ADA KUNCI INDEKS YANG DAPAT DIGUNAKAN	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	dbs10196940.m.tag_id	1	100.00	Using where

    Profil

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

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    12	ContentModelArticles->getItems()	JROOT/modules/mod_camera_slideshow/helper.php:67
    11	modCameraSlideshowHelper::getList()	JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php:44
    10	include JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

42. Waktu Query: 0.96 ms Setelah query terakhir: 0.45 ms Memori Query: 0.037 MB Memori sebelum query: 16.957 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_camera_slideshow.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (31,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.08 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    19	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    18	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_camera_slideshow/helper.php:85
    11	modCameraSlideshowHelper::getList()	JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php:44
    10	include JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

43. Waktu Query: 1.05 ms Setelah query terakhir: 0.60 ms Memori Query: 0.036 MB Memori sebelum query: 16.985 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (26,0,8)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.07 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:388
    17	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:342
    16	PlgSystemFields->onContentAfterDisplay()	Sama seperti panggilan di dalam baris dibawah.
    15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_camera_slideshow/helper.php:92
    11	modCameraSlideshowHelper::getList()	JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php:44
    10	include JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---

44. Waktu Query: 1.02 ms Setelah query terakhir: 0.81 ms Memori Query: 0.037 MB Memori sebelum query: 17.021 MB Kolom dikembalikan: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM vebxl_fields AS a
    
      LEFT JOIN `vebxl_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN vebxl_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN vebxl_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN vebxl_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN vebxl_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `vebxl_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_camera_slideshow.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (26,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','id-ID')
    
      ORDER BY a.ordering ASC

    Penjelasan

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

    Profil

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.11 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Tumpukan Panggilan

    #	Pemanggil	Berkas dan angka baris
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    19	PlgSystemFields->onContentPrepare()	Sama seperti panggilan di dalam baris dibawah.
    18	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Sama seperti panggilan di dalam baris dibawah.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_camera_slideshow/helper.php:85
    11	modCameraSlideshowHelper::getList()	JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php:44
    10	include JROOT/modules/mod_camera_slideshow/mod_camera_slideshow.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

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

    ---