Adalar Vakfı Site Haritası

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

Süre

Bellek

67 Sorgu Kaydedildi 306.95 ms

1. Sorgu Süresi: 15.76 ms

   SHOW VARIABLES LIKE 'query_cache_type'

   Açıkla

   Şu sorgudaki olamayacakları AÇIKLA: SHOW VARIABLES LIKE 'query_cache_type'

   Profil

   Status	Duration
   starting	0.29 ms
   Executing hook on transaction	0.04 ms
   starting	0.08 ms
   checking permissions	0.06 ms
   Opening tables	0.34 ms
   init	0.18 ms
   System lock	0.09 ms
   optimizing	0.07 ms
   statistics	0.54 ms
   executing	0.08 ms
   end	0.04 ms
   query end	0.02 ms
   waiting for handler commit	0.09 ms
   closing tables	0.16 ms
   freeing items	0.11 ms
   cleaning up	0.04 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
   11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:604
   10	JDatabaseDriverPdomysql->hasQueryCacheEnabled()	JROOT/libraries/joomla/database/driver/pdomysql.php:160
   9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
   8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
   7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
   6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
   5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

2. Sorgu Süresi: 3.92 ms Son sorgudan sonra: 0.33 ms

   SHOW VARIABLES LIKE 'have_profiling'

   Açıkla

   Şu sorgudaki olamayacakları AÇIKLA: SHOW VARIABLES LIKE 'have_profiling'

   Profil

   Status	Duration
   starting	0.16 ms
   Executing hook on transaction	0.04 ms
   starting	0.07 ms
   checking permissions	0.04 ms
   Opening tables	0.10 ms
   init	0.07 ms
   System lock	0.06 ms
   update	1.45 ms
   end	0.05 ms
   query end	0.03 ms
   waiting for handler commit	3.01 ms
   closing tables	0.05 ms
   freeing items	0.10 ms
   cleaning up	0.04 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
   11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:590
   10	JDatabaseDriverPdomysql->hasProfiling()	JROOT/libraries/joomla/database/driver/pdomysql.php:165
   9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
   8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
   7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
   6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
   5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

3. Sorgu Süresi: 2.55 ms Son sorgudan sonra: 30.74 ms

   SELECT `session_id`
   
     FROM `jpom_session`
   
     WHERE `session_id` = X'3331613764663066623735306431646637313332646632366338666235326332' 
     LIMIT 1

   Açıkla

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

   Profil

   Status	Duration
   starting	0.22 ms
   Executing hook on transaction	0.06 ms
   starting	0.05 ms
   checking permissions	0.05 ms
   Opening tables	1.25 ms
   init	0.06 ms
   System lock	0.13 ms
   optimizing	0.12 ms
   statistics	0.55 ms
   preparing	0.13 ms
   executing	1.41 ms
   end	0.06 ms
   query end	0.05 ms
   waiting for handler commit	0.05 ms
   closing tables	0.29 ms
   freeing items	0.14 ms
   cleaning up	0.04 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

4. Sorgu Süresi: 5.56 ms Son sorgudan sonra: 0.49 ms

   INSERT INTO `jpom_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3331613764663066623735306431646637313332646632366338666235326332', 1, 1751425640, 0, '', 0)

   Açıkla

   Şu sorgudaki olamayacakları AÇIKLA: INSERT INTO `jpom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3331613764663066623735306431646637313332646632366338666235326332', 1, 1751425640, 0, '', 0)

   Profil

   Status	Duration
   starting	0.28 ms
   Executing hook on transaction	0.05 ms
   starting	0.13 ms
   checking permissions	0.04 ms
   Opening tables	0.33 ms
   init	0.06 ms
   System lock	0.09 ms
   optimizing	0.04 ms
   statistics	0.10 ms
   preparing	0.08 ms
   executing	0.57 ms
   end	0.05 ms
   query end	0.04 ms
   waiting for handler commit	0.05 ms
   closing tables	0.06 ms
   freeing items	0.11 ms
   cleaning up	0.04 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   8	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

5. Sorgu Süresi: 4.94 ms Son sorgudan sonra: 15.56 ms

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jpom_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Açıkla

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

   Profil

   Status	Duration
   starting	0.20 ms
   Executing hook on transaction	0.04 ms
   starting	0.05 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   Opening tables	0.50 ms
   init	0.10 ms
   System lock	0.09 ms
   optimizing	0.08 ms
   statistics	0.61 ms
   preparing	0.14 ms
   executing	0.18 ms
   end	0.03 ms
   query end	0.03 ms
   waiting for handler commit	0.05 ms
   closing tables	0.05 ms
   freeing items	0.10 ms
   cleaning up	0.04 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

6. Sorgu Süresi: 2.37 ms Son sorgudan sonra: 13.42 ms

   SELECT id, rules
   
     FROM `jpom_viewlevels`

   Açıkla

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jpom_viewlevels	NULL	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	5	100.00	NULL

   Profil

   Status	Duration
   starting	0.24 ms
   Executing hook on transaction	0.04 ms
   starting	0.05 ms
   checking permissions	0.04 ms
   Opening tables	0.19 ms
   init	0.08 ms
   System lock	0.10 ms
   optimizing	0.14 ms
   statistics	0.21 ms
   preparing	0.13 ms
   executing	3.75 ms
   end	0.05 ms
   query end	0.04 ms
   waiting for handler commit	0.06 ms
   closing tables	0.07 ms
   freeing items	0.11 ms
   cleaning up	0.04 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

7. Sorgu Süresi: 2.62 ms Son sorgudan sonra: 0.42 ms

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

   Açıkla

   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.33 ms
   Executing hook on transaction	0.03 ms
   starting	0.06 ms
   checking permissions	0.03 ms
   Opening tables	0.33 ms
   init	0.06 ms
   System lock	0.07 ms
   optimizing	0.12 ms
   statistics	0.36 ms
   preparing	0.09 ms
   executing	0.07 ms
   end	0.02 ms
   query end	0.03 ms
   waiting for handler commit	0.10 ms
   closing tables	0.14 ms
   freeing items	0.15 ms
   cleaning up	0.03 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

8. Sorgu Süresi: 5.69 ms Son sorgudan sonra: 2.61 ms

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

   Açıkla

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jpom_extensions	NULL	ref	extension	extension	82	const	155	0.60	Using where; Dosya sıralama kullanılıyor

   Profil

   Status	Duration
   starting	0.35 ms
   Executing hook on transaction	0.06 ms
   starting	0.07 ms
   checking permissions	0.06 ms
   Opening tables	0.46 ms
   init	0.12 ms
   System lock	0.10 ms
   optimizing	0.08 ms
   statistics	0.22 ms
   preparing	0.23 ms
   executing	0.67 ms
   end	0.06 ms
   query end	0.07 ms
   waiting for handler commit	0.13 ms
   closing tables	0.10 ms
   freeing items	0.14 ms
   cleaning up	0.07 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
   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:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

9. Sorgu Süresi: 2.38 ms Son sorgudan sonra: 127.62 ms

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

   Açıkla

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

   Profil

   Status	Duration
   starting	0.14 ms
   Executing hook on transaction	0.05 ms
   starting	0.04 ms
   checking permissions	0.04 ms
   Opening tables	1.12 ms
   init	0.12 ms
   System lock	0.07 ms
   optimizing	0.05 ms
   statistics	0.12 ms
   preparing	0.10 ms
   executing	0.37 ms
   end	0.06 ms
   query end	0.03 ms
   waiting for handler commit	0.05 ms
   closing tables	0.06 ms
   freeing items	0.14 ms
   cleaning up	0.05 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

   ---

10. Sorgu Süresi: 3.18 ms Son sorgudan sonra: 6.65 ms

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

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_languages	NULL	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	2	50.00	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.49 ms
    Executing hook on transaction	0.06 ms
    starting	0.05 ms
    checking permissions	0.06 ms
    Opening tables	1.16 ms
    init	0.05 ms
    System lock	0.08 ms
    optimizing	0.10 ms
    statistics	0.81 ms
    preparing	0.20 ms
    executing	3.39 ms
    end	0.05 ms
    query end	0.05 ms
    waiting for handler commit	0.06 ms
    closing tables	0.08 ms
    freeing items	0.13 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    11	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/admintools/admintools/main.php:700
    10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
    9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    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:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

11. Sorgu Süresi: 2.86 ms Son sorgudan sonra: 0.41 ms

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

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_admintools_wafexceptions	NULL	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.32 ms
    Executing hook on transaction	0.06 ms
    starting	0.04 ms
    checking permissions	0.06 ms
    Opening tables	0.27 ms
    init	0.12 ms
    System lock	0.10 ms
    optimizing	0.11 ms
    statistics	0.43 ms
    preparing	0.14 ms
    executing	0.30 ms
    end	0.07 ms
    query end	0.07 ms
    waiting for handler commit	0.06 ms
    closing tables	0.06 ms
    freeing items	0.11 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
    11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
    10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
    9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    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:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

12. Sorgu Süresi: 7.47 ms Son sorgudan sonra: 88.15 ms

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jpom_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebsociallinks','com_config','com_contact','com_content','com_contenthistory','com_contenttemplater','com_cpanel','com_dbreplacer','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_lscache','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_assets	NULL	ALL	idx_asset_name	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	146	31.51	Using where

    Profil

    Status	Duration
    starting	0.47 ms
    Executing hook on transaction	0.05 ms
    starting	0.05 ms
    checking permissions	0.05 ms
    Opening tables	0.35 ms
    init	0.06 ms
    System lock	0.13 ms
    optimizing	0.21 ms
    statistics	0.17 ms
    preparing	0.16 ms
    executing	0.37 ms
    end	0.06 ms
    query end	0.04 ms
    waiting for handler commit	0.14 ms
    closing tables	0.07 ms
    freeing items	0.12 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    12	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    11	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    10	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    9	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    8	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/admin8/admin8.php:29
    7	plgSystemAdmin8->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    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:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

13. Sorgu Süresi: 2.83 ms Son sorgudan sonra: 31.95 ms

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

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

    Profil

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.05 ms
    starting	0.05 ms
    checking permissions	0.05 ms
    Opening tables	1.02 ms
    init	0.05 ms
    System lock	0.15 ms
    optimizing	0.15 ms
    executing	0.08 ms
    end	0.03 ms
    query end	0.05 ms
    closing tables	0.05 ms
    freeing items	0.10 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
    8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
    7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    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:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

14. Sorgu Süresi: 2.93 ms Son sorgudan sonra: 105.88 ms

    SELECT `source`,`keepurlparams`
    
      FROM `jpom_admintools_redirects`
    
      WHERE ((`dest` = 'tr/site-haritasi') OR (`dest` = 'tr/site-haritasi') OR ('tr/site-haritasi' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_admintools_redirects	NULL	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	100.00	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.24 ms
    Executing hook on transaction	0.03 ms
    starting	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.12 ms
    init	0.05 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.20 ms
    preparing	0.09 ms
    executing	0.06 ms
    end	0.03 ms
    query end	0.07 ms
    closing tables	0.05 ms
    freeing items	0.08 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1773
    11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

15. Sorgu Süresi: 2.27 ms Son sorgudan sonra: 0.83 ms

    SELECT count(*)
    
      FROM `jpom_cwgears_schedule`

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	NULL	Select tables optimized away

    Profil

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.03 ms
    starting	0.07 ms
    checking permissions	0.04 ms
    Opening tables	0.28 ms
    init	0.06 ms
    System lock	0.11 ms
    updating	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.11 ms
    freeing items	0.08 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
    8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

16. Sorgu Süresi: 1.50 ms Son sorgudan sonra: 0.27 ms

    SELECT count(*)
    
      FROM `jpom_cwgears_schedule`
    
      WHERE time + '3600'<'1751425640'

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.04 ms
    starting	0.05 ms
    checking permissions	0.05 ms
    Opening tables	0.11 ms
    init	0.03 ms
    System lock	0.09 ms
    updating	0.30 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.92 ms
    freeing items	0.08 ms
    cleaning up	0.09 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
    8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

17. Sorgu Süresi: 1.29 ms Son sorgudan sonra: 0.25 ms

    DELETE 
    
      FROM `jpom_cwgears`
    
      WHERE time + '3600'<'1751425640'

    Açıkla

    Şu sorgudaki olamayacakları AÇIKLA: DELETE FROM `jpom_cwgears` WHERE time + '3600'<'1751425640'

    Profil

    Status	Duration
    starting	0.37 ms
    Executing hook on transaction	0.05 ms
    starting	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.49 ms
    init	0.08 ms
    System lock	0.10 ms
    optimizing	0.10 ms
    statistics	0.67 ms
    preparing	0.24 ms
    executing	2.01 ms
    end	0.05 ms
    query end	0.04 ms
    waiting for handler commit	0.09 ms
    closing tables	0.14 ms
    freeing items	0.11 ms
    cleaning up	0.08 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    9	JDatabaseDriverPdo->execute()	JROOT/plugins/system/cwgears/cwgears.php:166
    8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

18. Sorgu Süresi: 2.16 ms Son sorgudan sonra: 0.29 ms

    UPDATE `jpom_cwgears_schedule`
    
      SET time = '1751425640'

    Açıkla

    Şu sorgudaki olamayacakları AÇIKLA: UPDATE `jpom_cwgears_schedule` SET time = '1751425640'

    Profil

    Status	Duration
    starting	0.44 ms
    Executing hook on transaction	0.09 ms
    starting	0.09 ms
    checking permissions	0.04 ms
    Opening tables	0.28 ms
    init	0.04 ms
    System lock	0.06 ms
    optimizing	0.08 ms
    statistics	0.65 ms
    preparing	0.13 ms
    executing	0.26 ms
    end	0.06 ms
    query end	0.04 ms
    waiting for handler commit	0.06 ms
    closing tables	0.06 ms
    freeing items	0.20 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    9	JDatabaseDriverPdo->execute()	JROOT/plugins/system/cwgears/cwgears.php:182
    8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

19. Sorgu Süresi: 5.29 ms Son sorgudan sonra: 16.53 ms

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM jpom_menu AS m
    
      LEFT JOIN jpom_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

    Açıkla

    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	13	10.00	Using index condition; Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.m.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	1.12 ms
    Executing hook on transaction	0.07 ms
    starting	0.07 ms
    checking permissions	0.09 ms
    Opening tables	0.13 ms
    init	0.06 ms
    System lock	0.24 ms
    updating	0.73 ms
    end	0.05 ms
    query end	0.03 ms
    waiting for handler commit	5.91 ms
    closing tables	0.11 ms
    freeing items	0.15 ms
    cleaning up	0.08 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
    8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

20. Sorgu Süresi: 3.02 ms Son sorgudan sonra: 60.97 ms

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

    Açıkla

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

    Profil

    Status	Duration
    starting	0.41 ms
    Executing hook on transaction	0.06 ms
    starting	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.28 ms
    init	0.04 ms
    System lock	0.05 ms
    optimizing	0.09 ms
    statistics	0.60 ms
    preparing	0.15 ms
    executing	0.68 ms
    end	0.07 ms
    query end	0.06 ms
    waiting for handler commit	0.06 ms
    closing tables	0.09 ms
    freeing items	0.15 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:200
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

21. Sorgu Süresi: 9.12 ms Son sorgudan sonra: 0.66 ms

    UPDATE `jpom_extensions`
    
      SET `params` = '{\"mediaversion\":\"8dcbe27e76e741da7fdba0489a3db5f0\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Açıkla

    Şu sorgudaki olamayacakları AÇIKLA: UPDATE `jpom_extensions` SET `params` = '{\"mediaversion\":\"8dcbe27e76e741da7fdba0489a3db5f0\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profil

    Status	Duration
    starting	0.37 ms
    Executing hook on transaction	0.05 ms
    starting	0.09 ms
    checking permissions	0.10 ms
    Opening tables	0.21 ms
    init	0.04 ms
    System lock	0.10 ms
    optimizing	0.08 ms
    statistics	0.42 ms
    preparing	0.11 ms
    executing	0.25 ms
    end	0.04 ms
    query end	0.09 ms
    waiting for handler commit	0.05 ms
    closing tables	0.05 ms
    freeing items	0.12 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    14	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:200
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

22. Sorgu Süresi: 3.33 ms Son sorgudan sonra: 11.51 ms

    SELECT id, home, template, s.params
    
      FROM jpom_template_styles as s
    
      LEFT JOIN jpom_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

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	adalarva_P47.e.element	1	80.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.36 ms
    Executing hook on transaction	0.06 ms
    starting	14.23 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    Opening tables	2.93 ms
    init	0.05 ms
    System lock	0.08 ms
    optimizing	0.13 ms
    statistics	0.52 ms
    preparing	0.17 ms
    Creating tmp table	0.28 ms
    executing	1.78 ms
    checking permissions	0.53 ms
    checking permissions	0.26 ms
    checking permissions	0.14 ms
    checking permissions	0.13 ms
    checking permissions	0.12 ms
    checking permissions	0.18 ms
    checking permissions	0.20 ms
    checking permissions	0.08 ms
    checking permissions	0.22 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.07 ms
    closing tables	0.09 ms
    freeing items	0.17 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
    8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

23. Sorgu Süresi: 2.57 ms Son sorgudan sonra: 84.11 ms

    SELECT `extension_id`,`name`,`enabled`,`params`
    
      FROM jpom_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_osmap'

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profil

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.04 ms
    Opening tables	1.85 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	2.14 ms
    preparing	0.06 ms
    executing	0.08 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170
    18	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140
    17	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62
    16	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:63
    15	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/TraitAllediaView.php:67
    14	Alledia\Framework\Joomla\AbstractView->setup()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:60
    13	Alledia\Framework\Joomla\AbstractView->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:89
    12	Alledia\OSMap\View\Site\AbstractList->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
    11	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
    10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
    9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/libraries/src/MVC/Controller/BaseController.php:613
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

24. Sorgu Süresi: 23.34 ms Son sorgudan sonra: 13.34 ms

    SHOW FULL COLUMNS 
      FROM `jpom_osmap_sitemaps`

    Açıkla

    Şu sorgudaki olamayacakları AÇIKLA: SHOW FULL COLUMNS FROM `jpom_osmap_sitemaps`

    Profil

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.09 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	3.94 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	3.50 ms
    preparing	0.10 ms
    executing	0.25 ms
    end	0.05 ms
    query end	0.05 ms
    waiting for handler commit	0.06 ms
    closing tables	0.12 ms
    freeing items	0.11 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
    17	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_osmap/tables/sitemap.php:94
    14	OSMapTableSitemap->__construct()	JROOT/libraries/src/Table/Table.php:328
    13	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Factory.php:105
    12	Alledia\OSMap\Factory::getTable()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:99
    11	Alledia\OSMap\Sitemap\Standard->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Factory.php:81
    10	Alledia\OSMap\Factory::getSitemap()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:114
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

25. Sorgu Süresi: 5.17 ms Son sorgudan sonra: 3.92 ms

    SELECT *
    
      FROM jpom_osmap_sitemaps
    
      WHERE `id` = '1'

    Açıkla

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

    Profil

    Status	Duration
    starting	0.53 ms
    Executing hook on transaction	0.13 ms
    starting	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Opening tables	5.92 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.06 ms
    statistics	0.28 ms
    preparing	0.18 ms
    executing	1.87 ms
    end	0.06 ms
    query end	0.02 ms
    waiting for handler commit	0.04 ms
    closing tables	0.03 ms
    freeing items	0.12 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_osmap/tables/sitemap.php:265
    12	OSMapTableSitemap->load()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:100
    11	Alledia\OSMap\Sitemap\Standard->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Factory.php:81
    10	Alledia\OSMap\Factory::getSitemap()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:114
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

26. Sorgu Süresi: 8.83 ms Son sorgudan sonra: 0.53 ms

    SELECT *
    
      FROM jpom_osmap_sitemap_menus
    
      WHERE sitemap_id = 1
    
      ORDER BY ordering

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_osmap_sitemap_menus	NULL	ref	PRIMARY,idx_sitemaps_id	PRIMARY	4	const	1	100.00	Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.21 ms
    Executing hook on transaction	0.04 ms
    starting	0.08 ms
    checking permissions	0.05 ms
    Opening tables	5.83 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.11 ms
    statistics	2.66 ms
    preparing	0.10 ms
    executing	0.29 ms
    end	0.06 ms
    query end	0.03 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.13 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmap/tables/sitemap.php:276
    12	OSMapTableSitemap->load()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:100
    11	Alledia\OSMap\Sitemap\Standard->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Factory.php:81
    10	Alledia\OSMap\Factory::getSitemap()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:114
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

27. Sorgu Süresi: 9.92 ms Son sorgudan sonra: 22.67 ms

    SELECT mt.id,mt.title AS `name`,mt.menutype,osm.changefreq,osm.priority,osm.ordering
    
      FROM jpom_osmap_sitemap_menus AS osm
    
      LEFT JOIN jpom_menu_types AS mt 
      ON (osm.menutype_id = mt.id)
    
      WHERE osm.sitemap_id = '1'
    
      ORDER BY osm.ordering

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	osm	NULL	ref	PRIMARY,idx_sitemaps_id	PRIMARY	4	const	1	100.00	Dosya sıralama kullanılıyor
    1	SIMPLE	mt	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.osm.menutype_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.26 ms
    Executing hook on transaction	0.05 ms
    starting	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.28 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.07 ms
    statistics	0.16 ms
    preparing	0.09 ms
    executing	0.14 ms
    end	0.03 ms
    query end	0.04 ms
    waiting for handler commit	0.05 ms
    closing tables	0.06 ms
    freeing items	0.10 ms
    cleaning up	0.08 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:335
    18	Alledia\OSMap\Sitemap\Collector->getSitemapMenus()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:183
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

28. Sorgu Süresi: 10.07 ms Son sorgudan sonra: 0.43 ms

    SELECT *
    
      FROM jpom_osmap_items_settings
    
      WHERE sitemap_id = '1' 
      AND `format` IS NULL

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_osmap_items_settings	NULL	ref	PRIMARY,idx_sitemap_id	PRIMARY	4	const	10	10.00	Using where

    Profil

    Status	Duration
    starting	0.26 ms
    Executing hook on transaction	0.05 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Opening tables	0.36 ms
    init	0.05 ms
    System lock	0.05 ms
    optimizing	0.12 ms
    statistics	2.55 ms
    preparing	0.12 ms
    executing	0.68 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.05 ms
    closing tables	0.06 ms
    freeing items	0.19 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:669
    18	Alledia\OSMap\Sitemap\Collector->getLegacyItemsSettings()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:187
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

29. Sorgu Süresi: 1.85 ms Son sorgudan sonra: 0.67 ms

    SELECT *,IF (IFNULL(settings_hash, '') = '', uid, CONCAT(uid, ':', settings_hash)) AS `key`
    
      FROM jpom_osmap_items_settings
    
      WHERE sitemap_id = '1' 
      AND `format` = 2

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_osmap_items_settings	NULL	ref	PRIMARY,idx_sitemap_id	PRIMARY	4	const	10	10.00	Using where

    Profil

    Status	Duration
    starting	0.23 ms
    Executing hook on transaction	0.04 ms
    starting	0.07 ms
    checking permissions	0.07 ms
    Opening tables	0.15 ms
    init	0.04 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.21 ms
    preparing	0.09 ms
    executing	0.65 ms
    end	0.06 ms
    query end	0.02 ms
    waiting for handler commit	0.09 ms
    closing tables	0.06 ms
    freeing items	0.09 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:630
    18	Alledia\OSMap\Sitemap\Collector->getItemsSettings()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:188
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

30. Sorgu Süresi: 5.08 ms Son sorgudan sonra: 0.75 ms

    SELECT m.id,m.title AS `name`,m.alias,m.path,m.level,m.type,m.home,m.params,m.parent_id,m.browserNav,m.link,1 AS `isMenuItem`,0 AS `ignore`
    
      FROM jpom_menu AS m
    
      INNER JOIN jpom_menu AS p 
      ON (p.lft = 0)
    
      WHERE m.menutype = 'anamenu-tr' 
      AND m.published = 1 
      AND m.access IN (1,1,5) 
      AND m.lft > p.lft 
      AND m.lft < p.rgt 
      AND m.language IN ('tr-TR','*')
    
      ORDER BY m.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	idx_menutype,idx_left_right,idx_language	idx_menutype	98	const	8	1.75	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	p	NULL	ref	idx_left_right	idx_left_right	4	const	1	33.33	Using where; Using index

    Profil

    Status	Duration
    starting	0.22 ms
    Executing hook on transaction	0.03 ms
    starting	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.16 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.06 ms
    statistics	0.21 ms
    preparing	0.12 ms
    executing	0.60 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.06 ms
    freeing items	0.09 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:387
    18	Alledia\OSMap\Sitemap\Collector->getMenuItems()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:193
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

31. Sorgu Süresi: 2.30 ms Son sorgudan sonra: 9.68 ms

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

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	14	1.75	Using where

    Profil

    Status	Duration
    starting	0.31 ms
    Executing hook on transaction	0.03 ms
    starting	0.12 ms
    checking permissions	0.05 ms
    Opening tables	0.42 ms
    init	0.07 ms
    System lock	0.06 ms
    optimizing	0.12 ms
    statistics	2.84 ms
    preparing	0.20 ms
    executing	1.20 ms
    end	0.05 ms
    query end	0.02 ms
    waiting for handler commit	0.05 ms
    closing tables	0.09 ms
    freeing items	0.10 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    21	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:452
    20	Alledia\OSMap\Sitemap\Item->setFullLink()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:272
    19	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:268
    18	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:219
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

32. Sorgu Süresi: 2.12 ms Son sorgudan sonra: 3.81 ms

    SELECT folder,params,element
    
      FROM jpom_extensions
    
      WHERE type = 'plugin' 
      AND folder IN ('osmap','xmap') 
      AND enabled = 1
    
      ORDER BY folder DESC, ordering

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_extensions	NULL	ref	extension	extension	82	const	155	2.00	Using index condition; Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.48 ms
    Executing hook on transaction	0.04 ms
    starting	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    Opening tables	0.44 ms
    init	0.05 ms
    System lock	0.05 ms
    optimizing	0.16 ms
    statistics	1.39 ms
    preparing	0.17 ms
    executing	0.77 ms
    end	0.05 ms
    query end	0.05 ms
    waiting for handler commit	0.06 ms
    closing tables	0.11 ms
    freeing items	0.12 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:147
    21	Alledia\OSMap\Helper\General::getPluginsFromDatabase()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:221
    20	Alledia\OSMap\Helper\General::getPluginsForComponent()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:482
    19	Alledia\OSMap\Sitemap\Collector->callPluginsPreparingTheItem()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:272
    18	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:219
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

33. Sorgu Süresi: 6.25 ms Son sorgudan sonra: 4.81 ms
    Sorguları çoğalt: #42

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 15 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.37 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.09 ms
    Opening tables	0.21 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.12 ms
    statistics	0.47 ms
    preparing	0.15 ms
    executing	0.47 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.09 ms
    freeing items	0.11 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

34. Sorgu Süresi: 4.55 ms Son sorgudan sonra: 10.55 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jpom_categories` AS `s`
    
      INNER JOIN `jpom_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('tr-TR','*')) 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 = 19
    
      ORDER BY c.lft

    Açıkla

    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	Dosya sıralama kullanılıyor
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	25.35	Using where

    Profil

    Status	Duration
    starting	0.38 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    Opening tables	0.26 ms
    init	0.04 ms
    System lock	0.05 ms
    optimizing	0.10 ms
    statistics	0.50 ms
    preparing	0.11 ms
    executing	0.54 ms
    end	0.05 ms
    query end	0.02 ms
    waiting for handler commit	0.06 ms
    closing tables	0.13 ms
    freeing items	0.13 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    40	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    39	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    38	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    37	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    36	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    35	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    34	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    33	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    32	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    31	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    30	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    29	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    28	Joomla\CMS\Router\Route::link()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Router.php:54
    27	Alledia\OSMap\Router->routeURL()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:521
    26	Alledia\OSMap\Sitemap\Item->setFullLink()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:272
    25	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:268
    24	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:603
    23	Alledia\OSMap\Sitemap\Collector->printNode()	JROOT/plugins/osmap/joomla/joomla.php:459
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

35. Sorgu Süresi: 2.83 ms Son sorgudan sonra: 4.30 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jpom_categories` AS `s`
    
      INNER JOIN `jpom_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('tr-TR','*')) 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 = 20
    
      ORDER BY c.lft

    Açıkla

    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	Dosya sıralama kullanılıyor
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	27.65	Using where

    Profil

    Status	Duration
    starting	0.37 ms
    Executing hook on transaction	0.03 ms
    starting	0.04 ms
    checking permissions	0.11 ms
    checking permissions	0.04 ms
    Opening tables	0.21 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.12 ms
    statistics	0.40 ms
    preparing	0.18 ms
    executing	0.52 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.06 ms
    freeing items	0.09 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    40	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    39	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    38	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    37	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    36	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    35	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    34	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    33	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    32	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    31	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    30	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    29	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    28	Joomla\CMS\Router\Route::link()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Router.php:54
    27	Alledia\OSMap\Router->routeURL()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:521
    26	Alledia\OSMap\Sitemap\Item->setFullLink()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:272
    25	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:268
    24	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:603
    23	Alledia\OSMap\Sitemap\Collector->printNode()	JROOT/plugins/osmap/joomla/joomla.php:459
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

36. Sorgu Süresi: 2.88 ms Son sorgudan sonra: 2.37 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jpom_categories` AS `s`
    
      INNER JOIN `jpom_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('tr-TR','*')) 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 = 21
    
      ORDER BY c.lft

    Açıkla

    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	Dosya sıralama kullanılıyor
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	29.96	Using where

    Profil

    Status	Duration
    starting	0.30 ms
    Executing hook on transaction	0.07 ms
    starting	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.71 ms
    init	0.04 ms
    System lock	0.06 ms
    optimizing	0.15 ms
    statistics	4.16 ms
    preparing	0.18 ms
    executing	4.50 ms
    end	0.06 ms
    query end	0.04 ms
    waiting for handler commit	0.05 ms
    closing tables	0.23 ms
    freeing items	0.15 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    40	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    39	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    38	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    37	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    36	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    35	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    34	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    33	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    32	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    31	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    30	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    29	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    28	Joomla\CMS\Router\Route::link()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Router.php:54
    27	Alledia\OSMap\Router->routeURL()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:521
    26	Alledia\OSMap\Sitemap\Item->setFullLink()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:272
    25	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:268
    24	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:603
    23	Alledia\OSMap\Sitemap\Collector->printNode()	JROOT/plugins/osmap/joomla/joomla.php:459
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

37. Sorgu Süresi: 2.83 ms Son sorgudan sonra: 2.92 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jpom_categories` AS `s`
    
      INNER JOIN `jpom_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('tr-TR','*')) 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 = 22
    
      ORDER BY c.lft

    Açıkla

    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	Dosya sıralama kullanılıyor
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	32.26	Using where

    Profil

    Status	Duration
    starting	0.34 ms
    Executing hook on transaction	0.03 ms
    starting	0.06 ms
    checking permissions	0.04 ms
    Opening tables	0.13 ms
    init	0.03 ms
    System lock	0.06 ms
    optimizing	0.16 ms
    statistics	0.29 ms
    preparing	0.16 ms
    executing	0.30 ms
    end	0.03 ms
    query end	0.04 ms
    waiting for handler commit	0.04 ms
    closing tables	0.07 ms
    freeing items	0.18 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    40	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    39	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    38	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    37	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    36	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    35	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    34	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    33	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    32	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    31	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    30	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    29	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    28	Joomla\CMS\Router\Route::link()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Router.php:54
    27	Alledia\OSMap\Router->routeURL()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:521
    26	Alledia\OSMap\Sitemap\Item->setFullLink()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:272
    25	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:268
    24	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:603
    23	Alledia\OSMap\Sitemap\Collector->printNode()	JROOT/plugins/osmap/joomla/joomla.php:459
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

38. Sorgu Süresi: 11.51 ms Son sorgudan sonra: 1.80 ms
    Sorguları çoğalt: #43

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=15 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	1	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.29 ms
    Executing hook on transaction	0.07 ms
    starting	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.16 ms
    init	0.04 ms
    System lock	0.07 ms
    optimizing	0.15 ms
    statistics	0.36 ms
    preparing	0.18 ms
    executing	4.97 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.06 ms
    closing tables	0.06 ms
    freeing items	0.19 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

39. Sorgu Süresi: 2.35 ms Son sorgudan sonra: 6.47 ms

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 14 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.32 ms
    Executing hook on transaction	0.10 ms
    starting	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    Opening tables	0.18 ms
    init	0.10 ms
    System lock	0.08 ms
    optimizing	0.09 ms
    statistics	0.41 ms
    preparing	0.12 ms
    executing	0.42 ms
    end	0.04 ms
    query end	0.03 ms
    waiting for handler commit	0.03 ms
    closing tables	0.05 ms
    freeing items	0.11 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

40. Sorgu Süresi: 7.31 ms Son sorgudan sonra: 0.67 ms

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=14 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	5	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.39 ms
    Executing hook on transaction	0.07 ms
    starting	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.20 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.08 ms
    statistics	0.40 ms
    preparing	0.17 ms
    executing	0.40 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.04 ms
    closing tables	0.04 ms
    freeing items	0.14 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

41. Sorgu Süresi: 2.76 ms Son sorgudan sonra: 2.77 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jpom_categories` AS `s`
    
      INNER JOIN `jpom_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('tr-TR','*')) 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 = 14
    
      ORDER BY c.lft

    Açıkla

    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	9	41.48	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.32 ms
    Executing hook on transaction	0.07 ms
    starting	0.07 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.30 ms
    init	0.08 ms
    System lock	0.04 ms
    optimizing	0.12 ms
    statistics	0.41 ms
    preparing	0.16 ms
    executing	0.28 ms
    end	0.04 ms
    query end	0.04 ms
    waiting for handler commit	0.04 ms
    closing tables	0.06 ms
    freeing items	0.11 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    41	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    40	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    39	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    38	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    37	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    36	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    35	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    34	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    33	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    32	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    31	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    30	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    29	Joomla\CMS\Router\Route::link()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Router.php:54
    28	Alledia\OSMap\Router->routeURL()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:521
    27	Alledia\OSMap\Sitemap\Item->setFullLink()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:272
    26	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:268
    25	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:603
    24	Alledia\OSMap\Sitemap\Collector->printNode()	JROOT/plugins/osmap/joomla/joomla.php:668
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

42. Sorgu Süresi: 2.51 ms Son sorgudan sonra: 23.89 ms
    Sorguları çoğalt: #33

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 15 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.21 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.04 ms
    Opening tables	0.17 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.20 ms
    preparing	0.12 ms
    executing	0.31 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.15 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

43. Sorgu Süresi: 2.65 ms Son sorgudan sonra: 8.19 ms
    Sorguları çoğalt: #38

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=15 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	1	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.28 ms
    Executing hook on transaction	0.05 ms
    starting	0.04 ms
    checking permissions	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.16 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.10 ms
    statistics	0.25 ms
    preparing	0.14 ms
    executing	2.44 ms
    end	0.07 ms
    query end	0.03 ms
    waiting for handler commit	0.08 ms
    closing tables	0.07 ms
    freeing items	0.15 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

44. Sorgu Süresi: 1.75 ms Son sorgudan sonra: 3.42 ms

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 19 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.29 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.12 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.15 ms
    statistics	0.27 ms
    preparing	0.18 ms
    executing	0.20 ms
    end	0.03 ms
    query end	0.05 ms
    waiting for handler commit	0.03 ms
    closing tables	0.04 ms
    freeing items	0.10 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

45. Sorgu Süresi: 4.45 ms Son sorgudan sonra: 0.37 ms

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=19 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	1	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.25 ms
    Executing hook on transaction	0.06 ms
    starting	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Opening tables	0.24 ms
    init	0.05 ms
    System lock	0.05 ms
    optimizing	0.12 ms
    statistics	0.31 ms
    preparing	0.12 ms
    executing	0.34 ms
    end	0.07 ms
    query end	0.02 ms
    waiting for handler commit	0.05 ms
    closing tables	0.04 ms
    freeing items	0.11 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

46. Sorgu Süresi: 1.99 ms Son sorgudan sonra: 5.72 ms

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 20 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.05 ms
    starting	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.14 ms
    init	0.04 ms
    System lock	0.09 ms
    optimizing	0.05 ms
    statistics	0.23 ms
    preparing	0.10 ms
    executing	0.25 ms
    end	0.06 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.09 ms
    cleaning up	0.07 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

47. Sorgu Süresi: 2.40 ms Son sorgudan sonra: 0.45 ms

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=20 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	1	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.32 ms
    Executing hook on transaction	0.05 ms
    starting	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.14 ms
    init	0.06 ms
    System lock	0.03 ms
    optimizing	0.11 ms
    statistics	0.26 ms
    preparing	0.14 ms
    executing	0.68 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.06 ms
    freeing items	0.10 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

48. Sorgu Süresi: 1.81 ms Son sorgudan sonra: 2.65 ms

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 21 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.22 ms
    Executing hook on transaction	0.04 ms
    starting	0.03 ms
    checking permissions	0.06 ms
    Opening tables	0.14 ms
    init	0.05 ms
    System lock	0.04 ms
    optimizing	0.07 ms
    statistics	0.40 ms
    preparing	0.13 ms
    executing	0.29 ms
    end	0.11 ms
    query end	0.04 ms
    waiting for handler commit	0.04 ms
    closing tables	0.07 ms
    freeing items	0.11 ms
    cleaning up	0.11 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

49. Sorgu Süresi: 2.59 ms Son sorgudan sonra: 0.42 ms

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=21 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	2	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.41 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.06 ms
    checking permissions	0.04 ms
    checking permissions	0.06 ms
    Opening tables	0.20 ms
    init	0.09 ms
    System lock	0.06 ms
    optimizing	0.14 ms
    statistics	0.50 ms
    preparing	0.20 ms
    executing	0.38 ms
    end	0.10 ms
    query end	0.05 ms
    waiting for handler commit	0.04 ms
    closing tables	0.06 ms
    freeing items	0.09 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

50. Sorgu Süresi: 2.23 ms Son sorgudan sonra: 2.78 ms

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 22 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.04 ms
    Opening tables	0.12 ms
    init	0.03 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.40 ms
    preparing	0.14 ms
    executing	0.35 ms
    end	0.06 ms
    query end	0.03 ms
    waiting for handler commit	0.05 ms
    closing tables	0.07 ms
    freeing items	0.16 ms
    cleaning up	0.06 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

51. Sorgu Süresi: 2.88 ms Son sorgudan sonra: 0.49 ms

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=22 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	1	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.39 ms
    Executing hook on transaction	0.04 ms
    starting	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.25 ms
    init	0.05 ms
    System lock	0.10 ms
    optimizing	0.14 ms
    statistics	0.43 ms
    preparing	0.15 ms
    executing	0.56 ms
    end	0.06 ms
    query end	0.05 ms
    waiting for handler commit	0.05 ms
    closing tables	0.06 ms
    freeing items	0.18 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

52. Sorgu Süresi: 2.13 ms Son sorgudan sonra: 2.71 ms

    SELECT a.id,a.title,a.alias,a.access,a.path AS route,a.created_time AS created,a.modified_time AS modified,a.params,a.metadata,a.metakey
    
      FROM jpom_categories AS a
    
      WHERE a.parent_id = 23 
      AND a.published = 1 
      AND a.extension='com_content' 
      AND a.access IN (1,1,5) 
    
      ORDER BY a.lft

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	cat_idx,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	7.78	Using where; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    starting	0.33 ms
    Executing hook on transaction	0.07 ms
    starting	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Opening tables	0.22 ms
    init	0.04 ms
    System lock	0.04 ms
    optimizing	0.07 ms
    statistics	0.40 ms
    preparing	0.19 ms
    executing	0.38 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.04 ms
    freeing items	0.16 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:413
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

53. Sorgu Süresi: 3.13 ms Son sorgudan sonra: 0.53 ms

    SELECT a.id,a.title,a.alias,a.catid,a.created,a.modified,a.publish_up,a.attribs AS params,a.metadata,a.language,a.metakey,a.images,c.title AS categMetakey,a.introtext,a.fulltext
    
      FROM jpom_content AS a
    
      LEFT JOIN jpom_content_frontpage AS fp 
      ON (a.id = fp.content_id)
    
      LEFT JOIN jpom_categories AS c 
      ON (a.catid = c.id)
    
      WHERE (a.state = 1 or a.state = 2) 
      AND a.catid=23 
      AND a.access IN (1,1,5)  
      AND (ISNULL(a.publish_up) OR a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-02 03:07:21') 
      AND (ISNULL(a.publish_down) OR a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-02 03:07:21')
    
      ORDER BY  a.created ASC

    Açıkla

    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_catid	4	const	2	16.00	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.a.id	1	100.00	Using where; Using index
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.45 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	1.38 ms
    init	0.04 ms
    System lock	0.07 ms
    optimizing	0.08 ms
    statistics	2.71 ms
    preparing	0.27 ms
    executing	9.64 ms
    end	0.08 ms
    query end	0.03 ms
    waiting for handler commit	0.10 ms
    closing tables	0.15 ms
    freeing items	0.14 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/plugins/osmap/joomla/joomla.php:575
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

54. Sorgu Süresi: 2.53 ms Son sorgudan sonra: 1.46 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jpom_categories` AS `s`
    
      INNER JOIN `jpom_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('tr-TR','*')) 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 = 23
    
      ORDER BY c.lft

    Açıkla

    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	Dosya sıralama kullanılıyor
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	34.57	Using where

    Profil

    Status	Duration
    starting	0.25 ms
    Executing hook on transaction	0.06 ms
    starting	0.03 ms
    checking permissions	0.04 ms
    Opening tables	0.10 ms
    init	0.04 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    statistics	1.20 ms
    preparing	0.06 ms
    executing	0.04 ms
    end	0.03 ms
    query end	0.03 ms
    waiting for handler commit	0.10 ms
    closing tables	0.06 ms
    freeing items	0.13 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    41	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    40	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    39	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    38	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    37	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    36	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    35	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    34	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    33	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    32	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    31	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    30	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    29	Joomla\CMS\Router\Route::link()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Router.php:54
    28	Alledia\OSMap\Router->routeURL()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:521
    27	Alledia\OSMap\Sitemap\Item->setFullLink()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Item.php:272
    26	Alledia\OSMap\Sitemap\Item->__construct()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:268
    25	Alledia\OSMap\Sitemap\Collector->submitItemToCallback()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:603
    24	Alledia\OSMap\Sitemap\Collector->printNode()	JROOT/plugins/osmap/joomla/joomla.php:668
    23	PlgOSMapJoomla::includeCategoryContent()	JROOT/plugins/osmap/joomla/joomla.php:469
    22	PlgOSMapJoomla::expandCategory()	JROOT/plugins/osmap/joomla/joomla.php:293
    21	PlgOSMapJoomla::getTree()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Helper/General.php:394
    19	Alledia\OSMap\Helper\General::callUserFunc()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:554
    18	Alledia\OSMap\Sitemap\Collector->callPluginsGetItemTree()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Collector.php:225
    17	Alledia\OSMap\Sitemap\Collector->fetch()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/Sitemap/Standard.php:148
    16	Alledia\OSMap\Sitemap\Standard->traverse()	JROOT/components/com_osmap/views/html/tmpl/default_items.php:38
    15	include JROOT/components/com_osmap/views/html/tmpl/default_items.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    14	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/components/com_osmap/views/html/tmpl/default.php:70
    13	include JROOT/components/com_osmap/views/html/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
    12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
    11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/libraries/allediaframework/Framework/Joomla/AbstractView.php:87
    10	Alledia\Framework\Joomla\AbstractView->display()	JROOT/administrator/components/com_osmap/library/Alledia/OSMap/View/Site/AbstractList.php:143
    9	Alledia\OSMap\View\Site\AbstractList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osmap/osmap.php:35
    6	require_once JROOT/components/com_osmap/osmap.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

55. Sorgu Süresi: 15.69 ms Son sorgudan sonra: 53.84 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM jpom_modules AS m
    
      LEFT JOIN jpom_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      LEFT JOIN jpom_advancedmodules as am 
      ON am.moduleid = m.id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND m.language IN ('tr-TR','*')
    
      ORDER BY m.position, m.ordering

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	published,newsfeeds,idx_language	published	5	NULL	23	9.80	Using index condition; Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	adalarva_P47.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	adalarva_P47.m.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    init	0.13 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.13 ms
    preparing	0.05 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.05 ms
    closing tables	0.03 ms
    freeing items	0.09 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
    21	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
    20	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    19	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    18	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:366
    17	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    16	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    15	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:653
    14	T3Template->countModules()	JROOT/templates/ja_mono/tpls/blocks/off-canvas.php:58
    13	include JROOT/templates/ja_mono/tpls/blocks/off-canvas.php	JROOT/plugins/system/t3/includes/core/template.php:200
    12	T3Template->loadBlock()	JROOT/templates/ja_mono/tpls/blocks/header.php:50
    11	include JROOT/templates/ja_mono/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:200
    10	T3Template->loadBlock()	JROOT/templates/ja_mono/tpls/default.php:31
    9	include JROOT/templates/ja_mono/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:226
    8	T3Template->loadLayout()	JROOT/templates/ja_mono/index.php:33
    7	require JROOT/templates/ja_mono/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

56. Sorgu Süresi: 2.55 ms Son sorgudan sonra: 12.29 ms

    SELECT t.parent_id
    
      FROM jpom_menu as t
    
      WHERE t.id = 183

    Açıkla

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

    Profil

    Status	Duration
    checking permissions	0.10 ms
    checking permissions	0.08 ms
    checking permissions	0.08 ms
    checking permissions	0.15 ms
    checking permissions	0.09 ms
    checking permissions	0.08 ms
    checking permissions	0.11 ms
    checking permissions	0.14 ms
    checking permissions	0.17 ms
    checking permissions	0.14 ms
    checking permissions	0.21 ms
    checking permissions	0.08 ms
    checking permissions	0.06 ms
    checking permissions	0.19 ms
    checking permissions	0.08 ms
    checking permissions	0.09 ms
    checking permissions	0.12 ms
    checking permissions	0.10 ms
    checking permissions	0.09 ms
    checking permissions	0.08 ms
    checking permissions	0.15 ms
    checking permissions	0.08 ms
    checking permissions	0.06 ms
    checking permissions	0.09 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.08 ms
    checking permissions	0.07 ms
    checking permissions	0.08 ms
    checking permissions	0.08 ms
    checking permissions	0.09 ms
    checking permissions	0.07 ms
    checking permissions	0.15 ms
    checking permissions	0.21 ms
    checking permissions	0.10 ms
    checking permissions	0.08 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.12 ms
    checking permissions	0.15 ms
    checking permissions	0.11 ms
    checking permissions	0.09 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.09 ms
    checking permissions	0.07 ms
    checking permissions	0.16 ms
    checking permissions	0.14 ms
    checking permissions	0.08 ms
    checking permissions	0.11 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.11 ms
    checking permissions	0.08 ms
    checking permissions	0.06 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.12 ms
    checking permissions	0.07 ms
    checking permissions	0.11 ms
    checking permissions	0.08 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.20 ms
    checking permissions	0.08 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.06 ms
    checking permissions	0.11 ms
    checking permissions	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.08 ms
    checking permissions	0.10 ms
    checking permissions	0.23 ms
    checking permissions	0.08 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.07 ms
    checking permissions	0.11 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.05 ms
    checking permissions	0.26 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.06 ms
    closing tables	0.08 ms
    freeing items	0.22 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
    26	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:151
    25	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:72
    24	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:54
    23	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:781
    22	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:201
    21	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:111
    20	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    19	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    18	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:366
    17	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    16	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    15	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:653
    14	T3Template->countModules()	JROOT/templates/ja_mono/tpls/blocks/off-canvas.php:58
    13	include JROOT/templates/ja_mono/tpls/blocks/off-canvas.php	JROOT/plugins/system/t3/includes/core/template.php:200
    12	T3Template->loadBlock()	JROOT/templates/ja_mono/tpls/blocks/header.php:50
    11	include JROOT/templates/ja_mono/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:200
    10	T3Template->loadBlock()	JROOT/templates/ja_mono/tpls/default.php:31
    9	include JROOT/templates/ja_mono/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:226
    8	T3Template->loadLayout()	JROOT/templates/ja_mono/index.php:33
    7	require JROOT/templates/ja_mono/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

57. Sorgu Süresi: 1.11 ms Son sorgudan sonra: 0.23 ms

    SELECT t.parent_id
    
      FROM jpom_menu as t
    
      WHERE t.id = 1

    Açıkla

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

    Profil

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.06 ms
    starting	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.29 ms
    init	0.04 ms
    System lock	0.05 ms
    optimizing	0.04 ms
    statistics	0.07 ms
    preparing	0.06 ms
    executing	2.98 ms
    end	0.04 ms
    query end	0.02 ms
    waiting for handler commit	0.05 ms
    closing tables	0.14 ms
    freeing items	0.11 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
    26	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:151
    25	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:72
    24	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:54
    23	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:781
    22	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:201
    21	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:111
    20	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    19	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    18	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:366
    17	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    16	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    15	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:653
    14	T3Template->countModules()	JROOT/templates/ja_mono/tpls/blocks/off-canvas.php:58
    13	include JROOT/templates/ja_mono/tpls/blocks/off-canvas.php	JROOT/plugins/system/t3/includes/core/template.php:200
    12	T3Template->loadBlock()	JROOT/templates/ja_mono/tpls/blocks/header.php:50
    11	include JROOT/templates/ja_mono/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:200
    10	T3Template->loadBlock()	JROOT/templates/ja_mono/tpls/default.php:31
    9	include JROOT/templates/ja_mono/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:226
    8	T3Template->loadLayout()	JROOT/templates/ja_mono/index.php:33
    7	require JROOT/templates/ja_mono/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

58. Sorgu Süresi: 22.36 ms Son sorgudan sonra: 147.16 ms

    SHOW TABLES

    Açıkla

    Şu sorgudaki olamayacakları AÇIKLA: SHOW TABLES

    Profil

    Status	Duration
    starting	0.27 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.06 ms
    Opening tables	0.44 ms
    init	0.11 ms
    System lock	0.07 ms
    optimizing	0.07 ms
    statistics	2.32 ms
    preparing	0.17 ms
    executing	1.01 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.04 ms
    closing tables	0.10 ms
    freeing items	0.10 ms
    cleaning up	0.08 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/pdomysql.php:392
    17	JDatabaseDriverPdomysql->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:552
    16	acymailing_getTableList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:18
    15	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:523
    14	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    13	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:25
    12	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
    11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

59. Sorgu Süresi: 4.68 ms Son sorgudan sonra: 0.64 ms

    SELECT * 
      FROM jpom_acymailing_config

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_acymailing_config	NULL	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	192	100.00	NULL

    Profil

    Status	Duration
    starting	0.37 ms
    Executing hook on transaction	0.03 ms
    starting	0.04 ms
    checking permissions	0.07 ms
    Opening tables	0.42 ms
    init	0.06 ms
    System lock	0.10 ms
    optimizing	0.09 ms
    statistics	1.93 ms
    preparing	0.24 ms
    executing	1.02 ms
    end	0.04 ms
    query end	0.04 ms
    waiting for handler commit	0.07 ms
    closing tables	0.09 ms
    freeing items	0.30 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:478
    16	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:23
    15	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:523
    14	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
    13	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:25
    12	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
    11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

60. Sorgu Süresi: 5.26 ms Son sorgudan sonra: 26.40 ms

    SELECT * 
      FROM jpom_acymailing_list 
      WHERE type = 'list'  
      ORDER BY ordering ASC

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_acymailing_list	NULL	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	3	100.00	NULL

    Profil

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.03 ms
    starting	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.09 ms
    init	0.03 ms
    System lock	0.04 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.06 ms
    executing	0.20 ms
    end	0.03 ms
    query end	0.02 ms
    waiting for handler commit	0.03 ms
    closing tables	0.03 ms
    freeing items	0.07 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:478
    13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
    12	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:149
    11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

61. Sorgu Süresi: 5.42 ms Son sorgudan sonra: 66.53 ms

    SELECT * 
      FROM `jpom_acymailing_fields` as a 
      WHERE a.`published` = 1 
      AND (a.access = 'all' OR a.access LIKE ('%,9,%')) 
      ORDER BY a.`ordering` ASC

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	orderingindex	orderingindex	1	const	3	55.56	Using where

    Profil

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.03 ms
    starting	0.05 ms
    checking permissions	0.02 ms
    checking permissions	0.04 ms
    Opening tables	0.12 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.04 ms
    statistics	0.35 ms
    preparing	0.07 ms
    executing	0.05 ms
    end	0.02 ms
    query end	0.02 ms
    waiting for handler commit	0.05 ms
    closing tables	0.04 ms
    freeing items	0.11 ms
    cleaning up	0.03 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:478
    13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:85
    12	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:245
    11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

62. Sorgu Süresi: 1.19 ms Son sorgudan sonra: 0.34 ms

    SELECT * 
      FROM `jpom_acymailing_fields`

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpom_acymailing_fields	NULL	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	3	100.00	NULL

    Profil

    Status	Duration
    starting	0.30 ms
    Executing hook on transaction	0.08 ms
    starting	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.17 ms
    init	0.07 ms
    System lock	0.05 ms
    optimizing	0.11 ms
    statistics	0.38 ms
    preparing	0.19 ms
    executing	0.48 ms
    end	0.03 ms
    query end	0.03 ms
    waiting for handler commit	0.03 ms
    closing tables	0.06 ms
    freeing items	0.10 ms
    cleaning up	0.05 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:478
    13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:100
    12	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:245
    11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

63. Sorgu Süresi: 1.43 ms Son sorgudan sonra: 0.66 ms

    SELECT a.id,a.alias,a.catid, c.alias as catalias 
      FROM jpom_content as a  
      LEFT JOIN jpom_categories AS c 
      ON c.id = a.catid 
      WHERE a.id = 16 
      LIMIT 1

    Açıkla

    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	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.41 ms
    Executing hook on transaction	0.04 ms
    starting	0.07 ms
    checking permissions	0.03 ms
    Opening tables	0.22 ms
    init	0.04 ms
    System lock	0.05 ms
    optimizing	0.05 ms
    statistics	0.09 ms
    executing	0.05 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.04 ms
    freeing items	0.09 ms
    cleaning up	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_acymailing/compat/joomla.php:485
    13	acymailing_loadObject()	JROOT/modules/mod_acymailing/mod_acymailing.php:38
    12	acymailing_getArticleURL()	JROOT/modules/mod_acymailing/mod_acymailing.php:388
    11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

64. Sorgu Süresi: 2.48 ms Son sorgudan sonra: 0.78 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jpom_categories` AS `s`
    
      INNER JOIN `jpom_categories` AS `c` 
      ON (s.lft < c.lft 
      AND c.lft < s.rgt 
      AND c.language IN ('tr-TR','*')) 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 = 24
    
      ORDER BY c.lft

    Açıkla

    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	Dosya sıralama kullanılıyor
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right,idx_language	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	18	41.48	Using where

    Profil

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.09 ms
    init	0.03 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    executing	0.05 ms
    end	0.06 ms
    query end	0.04 ms
    closing tables	0.05 ms
    freeing items	0.07 ms
    cleaning up	0.07 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    25	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    24	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    23	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    22	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    21	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    20	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    19	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_acymailing/compat/joomla.php:148
    13	acymailing_route()	JROOT/modules/mod_acymailing/mod_acymailing.php:46
    12	acymailing_getArticleURL()	JROOT/modules/mod_acymailing/mod_acymailing.php:388
    11	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

65. Sorgu Süresi: 1.52 ms Son sorgudan sonra: 50.12 ms

    SELECT uikit
    
      FROM `jpom_cwgears`
    
      WHERE url = 'https://adalarvakfi.org/tr/site-haritasi'

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	NULL	no matching row in const table

    Profil

    Status	Duration
    starting	0.40 ms
    Executing hook on transaction	0.03 ms
    starting	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.17 ms
    init	0.04 ms
    System lock	0.06 ms
    optimizing	0.07 ms
    statistics	0.09 ms
    executing	0.05 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.08 ms
    freeing items	0.12 ms
    cleaning up	0.09 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

66. Sorgu Süresi: 1.01 ms Son sorgudan sonra: 0.44 ms

    SELECT uikit_plus
    
      FROM `jpom_cwgears`
    
      WHERE url = 'https://adalarvakfi.org/tr/site-haritasi'

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	NULL	no matching row in const table

    Profil

    Status	Duration
    starting	0.29 ms
    checking permissions	0.10 ms
    Opening tables	0.51 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    optimizing	0.05 ms
    statistics	0.13 ms
    preparing	0.10 ms
    statistics	0.04 ms
    preparing	0.14 ms
    executing	4.14 ms
    end	0.07 ms
    query end	0.05 ms
    closing tables	0.10 ms
    freeing items	0.12 ms
    cleaning up	0.04 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---

67. Sorgu Süresi: 1.60 ms Son sorgudan sonra: 61.43 ms

    SELECT facebook_js
    
      FROM `jpom_cwgears`
    
      WHERE url = 'https://adalarvakfi.org/tr/site-haritasi'

    Açıkla

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	NULL	no matching row in const table

    Profil

    PROFİLİ GÖSTER yok (100 sorgudan fazla olduğu için olabilir)

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    8	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwfacebookjs/cwfacebookjs.php:202
    7	plgSystemCwfacebookjs->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

    ---