Joomla Hata Ayıklama Konsolu

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1758228387,
                "last": 1758228387,
                "now": 1758228387
            },
            "client": {
                "forwarded": "10.2.109.7"
            },
            "token": "ySFQzZFd6O1Asm5YkU2MXwDVY7BHaabg"
        },
        "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
        }
    }
}

Süre

Bellek

54 Sorgu Kaydedildi 21.50 ms

1. Sorgu Süresi: 0.38 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 2.969 MB Dönen satır: 0

   SELECT `data`
   
     FROM `k0o5r_session`
   
     WHERE `session_id` = 'a0bd46a9765a628deccd4eb41d6004d0'

   Açıkla

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	k0o5r_session	const	PRIMARY	PRIMARY	602	const	1

   Profil

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.00 ms
   Query end	0.02 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Aşağıdaki satırda bulunan çağrı gibi.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:42

   [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: 0.44 ms Son sorgudan sonra: 2.07 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 3.176 MB

   DELETE 
   
     FROM `k0o5r_session`
   
     WHERE `time` < '1758227487'

   Açıkla

   Şu sorgudaki olamayacakları AÇIKLA: DELETE FROM `k0o5r_session` WHERE `time` < '1758227487'

   Profil

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.05 ms
   Updating	0.10 ms
   End of update loop	0.00 ms
   Waiting for query cache lock	0.00 ms
   End of update loop	0.03 ms
   Query end	0.00 ms
   Commit	0.05 ms
   Writing to binlog	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:42

   [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: 0.52 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.012 MB belleği şu sorgudan önce: 3.188 MB Dönen satır: 0

   SELECT `session_id`
   
     FROM `k0o5r_session`
   
     WHERE `session_id` = 'a0bd46a9765a628deccd4eb41d6004d0' 
     LIMIT 1

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   Waiting for query cache lock	0.27 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.00 ms
   Executing	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:42

   [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: 0.24 ms Son sorgudan sonra: 0.14 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 3.203 MB

   INSERT INTO `k0o5r_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('a0bd46a9765a628deccd4eb41d6004d0', 0, 1, '1758228387', 0, '')

   Açıkla

   Şu sorgudaki olamayacakları AÇIKLA: INSERT INTO `k0o5r_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('a0bd46a9765a628deccd4eb41d6004d0', 0, 1, '1758228387', 0, '')

   Profil

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init for update	0.01 ms
   Update	0.04 ms
   Waiting for query cache lock	0.00 ms
   Update	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.02 ms
   Writing to binlog	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:42

   [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: 0.52 ms Son sorgudan sonra: 3.56 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 3.646 MB Dönen satır: 37

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

   Açıkla

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	k0o5r_extensions	ref	extension	extension	62	const	37	Using index condition

   Profil

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.07 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.08 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Aşağıdaki satırda bulunan çağrı gibi.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

   [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: 0.22 ms Son sorgudan sonra: 6.78 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 3.872 MB Dönen satır: 5

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

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.02 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

   [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: 0.18 ms Son sorgudan sonra: 0.97 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 3.949 MB Dönen satır: 13
   Sorguları çoğalt: #13

   SELECT id, rules
   
     FROM `k0o5r_viewlevels`

   Açıkla

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	k0o5r_viewlevels	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	13

   Profil

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.01 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

   [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: 0.93 ms Son sorgudan sonra: 0.74 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 3.973 MB Dönen satır: 50

   SELECT folder AS type, element AS name, params
   
     FROM k0o5r_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,2,3,7,8,9)
   
     ORDER BY ordering

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.07 ms
   Preparing	0.03 ms
   Sorting result	0.02 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.33 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

   [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: 0.44 ms Son sorgudan sonra: 14.34 ms Sorgu belleği: 0.016 MB belleği şu sorgudan önce: 5.114 MB Dönen satır: 1

   SELECT time 
     FROM k0o5r_vvisit_counter USE INDEX(time) 
     ORDER BY time DESC 
     LIMIT 1;

   Açıkla

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	k0o5r_vvisit_counter	index	NULL	time	4	NULL	1	Using index

   Profil

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.08 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   11	JDatabaseDriver->loadResult()	JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:31
   10	plgVVisitCounterHelper::getLastTime()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:37
   9	plgSystemVVisit_Counter->onAfterInitialise()	Aşağıdaki satırda bulunan çağrı gibi.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

   [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: 0.38 ms Son sorgudan sonra: 0.24 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 5.130 MB

    INSERT INTO k0o5r_vvisit_counter (time, visits, guests) 
      VALUES (1758228388, 1, 1) 
      ON DUPLICATE KEY UPDATE visits=visits+1, guests=guests+1;

    Açıkla

    Şu sorgudaki olamayacakları AÇIKLA: INSERT INTO k0o5r_vvisit_counter (time, visits, guests) VALUES (1758228388, 1, 1) ON DUPLICATE KEY UPDATE visits=visits+1, guests=guests+1;

    Profil

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Update	0.06 ms
    Waiting for query cache lock	0.00 ms
    Update	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Writing to binlog	0.03 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    Waiting for query cache lock	0.00 ms
    Unlocking tables	0.02 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    11	JDatabase->query()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:99
    10	plgSystemVVisit_Counter::_insertRecord()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:47
    9	plgSystemVVisit_Counter->onAfterInitialise()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.39 ms Son sorgudan sonra: 0.90 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 5.201 MB Dönen satır: 1

    SELECT * 
      FROM k0o5r_virtualdomain
    				
      WHERE `domain` = 'konuksever.net'

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    11	JDatabaseDriver->loadObject()	JROOT/plugins/system/virtualdomains/virtualdomains.php:253
    10	plgSystemVirtualdomains->_getCurrentDomain()	JROOT/plugins/system/virtualdomains/virtualdomains.php:114
    9	plgSystemVirtualdomains->onAfterInitialise()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.81 ms Son sorgudan sonra: 2.25 ms Sorgu belleği: 0.034 MB belleği şu sorgudan önce: 5.425 MB Dönen satır: 18

    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 k0o5r_menu AS m
    
      LEFT JOIN k0o5r_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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language,published,parent_id	idx_client_id_parent_id_alias_language	1	const	21	Using index condition; Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.m.component_id	1	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.24 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.05 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    20	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    19	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    18	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    17	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    16	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    15	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    14	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    13	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    12	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    11	JApplicationSite::getRouter()	JROOT/plugins/system/virtualdomains/virtualdomains.php:268
    10	plgSystemVirtualdomains->_getCurrentDomain()	JROOT/plugins/system/virtualdomains/virtualdomains.php:114
    9	plgSystemVirtualdomains->onAfterInitialise()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.20 ms Son sorgudan sonra: 7.63 ms Sorgu belleği: 0.016 MB belleği şu sorgudan önce: 6.072 MB Dönen satır: 13
    Sorguları çoğalt: #7

    SELECT id, rules
    
      FROM `k0o5r_viewlevels`

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_viewlevels	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	13

    Profil

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/virtualdomains/virtualdomains.php:723
    10	vdJAccess::addAuthorisedViewLevels()	JROOT/plugins/system/virtualdomains/virtualdomains.php:129
    9	plgSystemVirtualdomains->onAfterInitialise()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.29 ms Son sorgudan sonra: 0.26 ms Sorgu belleği: 0.017 MB belleği şu sorgudan önce: 6.086 MB Dönen satır: 0

    Select * 
      From k0o5r_virtualdomain_params 
      Where 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_virtualdomain_params	system	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	0	Const row not found

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/virtualdomains/virtualdomains.php:480
    10	plgSystemVirtualdomains->setActions()	JROOT/plugins/system/virtualdomains/virtualdomains.php:144
    9	plgSystemVirtualdomains->onAfterInitialise()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.50 ms Son sorgudan sonra: 3.21 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 6.297 MB Dönen satır: 1

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	Aşağıdaki satırda bulunan çağrı gibi.
    17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
    9	plgSystemJComments->onAfterRoute()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.46 ms Son sorgudan sonra: 0.72 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 6.304 MB

    UPDATE `k0o5r_extensions`
    
      SET `params` = '{\"mediaversion\":\"df510b8328de235d9013078030491c9f\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init for update	0.06 ms
    Updating	0.07 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.08 ms
    Query end	0.00 ms
    Commit	0.05 ms
    Writing to binlog	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
    9	plgSystemJComments->onAfterRoute()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.44 ms Son sorgudan sonra: 3.78 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.658 MB Dönen satır: 97

    SELECT *
    
      FROM `k0o5r_jcomments_settings`
    
      WHERE `lang` = '' 
      AND `component` = ''

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_jcomments_settings	ALL	PRIMARY	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	97	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
    15	JCommentsCfg::_load()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/components/com_jcomments/classes/config.php:159
    12	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
    11	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
    10	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
    9	plgSystemJComments->onAfterRoute()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.52 ms Son sorgudan sonra: 1.46 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 6.685 MB Dönen satır: 12

    SELECT id, home, template, s.params
    
      FROM k0o5r_template_styles as s
    
      LEFT JOIN k0o5r_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	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	14	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	d0194bbb.s.template,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.11 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    11	JApplicationSite->getTemplate()	JROOT/components/com_jcomments/helpers/system.php:46
    10	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
    9	plgSystemJComments->onAfterRoute()	Aşağıdaki satırda bulunan çağrı gibi.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.35 ms Son sorgudan sonra: 2.30 ms Sorgu belleği: 0.013 MB belleği şu sorgudan önce: 6.764 MB Dönen satır: 1

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.67 ms Son sorgudan sonra: 10.54 ms Sorgu belleği: 0.034 MB belleği şu sorgudan önce: 8.058 MB Dönen satır: 8

    SHOW FULL COLUMNS 
      FROM `k0o5r_assets`

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.20 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    checking permissions	0.05 ms
    closing tables	0.01 ms
    checking permissions	0.00 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.08 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    21	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    20	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    19	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    16	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.11 ms Son sorgudan sonra: 0.80 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.135 MB Dönen satır: 1

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

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_assets	const	PRIMARY	PRIMARY	4	const	1

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    19	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    16	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.09 ms Son sorgudan sonra: 0.17 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 8.158 MB Dönen satır: 1

    SELECT a.rules
    
      FROM k0o5r_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    16	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.39 ms Son sorgudan sonra: 0.65 ms Sorgu belleği: 0.028 MB belleği şu sorgudan önce: 8.218 MB Dönen satır: 37

    SELECT element
    
      FROM k0o5r_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_extensions	ref	extension	extension	62	const	37	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    16	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.13 ms Son sorgudan sonra: 0.23 ms Sorgu belleği: 0.028 MB belleği şu sorgudan önce: 8.253 MB Dönen satır: 37

    SELECT a.name, a.rules
    
      FROM k0o5r_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easybookreloaded','com_extplorer','com_finder','com_installer','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sptransfer','com_tags','com_templates','com_users','com_virtualdomains','com_weblinks','com_wrapper') OR a.name = 'root.1')

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	idx_asset_name	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	142	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    20	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    16	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    14	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 1.23 ms Son sorgudan sonra: 2.70 ms Sorgu belleği: 0.052 MB belleği şu sorgudan önce: 8.602 MB Dönen satır: 6

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM k0o5r_content AS a
    
      LEFT JOIN k0o5r_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN k0o5r_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN k0o5r_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN k0o5r_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN k0o5r_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM k0o5r_categories AS cat JOIN k0o5r_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.featured = 1 
      AND a.access IN (1,1,2,3,7,8,9,11) 
      AND c.access IN (1,1,2,3,7,8,9,11) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2)
    
      ORDER BY  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 6, 6

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	range	idx_access,idx_catid,idx_featured_catid	idx_featured_catid	1	NULL	21	Using index condition; Using where; Dosya sıralama kullanılıyor
    1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	d0194bbb.a.catid	1	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.a.created_by	1	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.a.modified_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.c.parent_id	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	d0194bbb.c.id	3	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right,published	published	1	NULL	2	Using index condition; Using where; Using temporary; Dosya sıralama kullanılıyor
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	15	Using where; Using index; Using join buffer (flat, BNL join)

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.17 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.09 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.12 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.24 ms
    Waiting for query cache lock	0.00 ms
    Creating sort index	0.02 ms
    Waiting for query cache lock	0.00 ms
    Creating sort index	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.39 ms Son sorgudan sonra: 1.78 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.957 MB Dönen satır: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `k0o5r_contentitem_tag_map` AS m 
    
      INNER JOIN `k0o5r_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 8 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,2,3,7,8,9,11)

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d0194bbb.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.30 ms Son sorgudan sonra: 0.37 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.996 MB Dönen satır: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `k0o5r_contentitem_tag_map` AS m 
    
      INNER JOIN `k0o5r_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 7 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,2,3,7,8,9,11)

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d0194bbb.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.32 ms Son sorgudan sonra: 0.36 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.035 MB Dönen satır: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `k0o5r_contentitem_tag_map` AS m 
    
      INNER JOIN `k0o5r_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 17 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,2,3,7,8,9,11)

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d0194bbb.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.32 ms Son sorgudan sonra: 0.34 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.075 MB Dönen satır: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `k0o5r_contentitem_tag_map` AS m 
    
      INNER JOIN `k0o5r_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 18 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,2,3,7,8,9,11)

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d0194bbb.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.29 ms Son sorgudan sonra: 0.35 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.114 MB Dönen satır: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `k0o5r_contentitem_tag_map` AS m 
    
      INNER JOIN `k0o5r_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 21 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,2,3,7,8,9,11)

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d0194bbb.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.32 ms Son sorgudan sonra: 0.34 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.154 MB Dönen satır: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `k0o5r_contentitem_tag_map` AS m 
    
      INNER JOIN `k0o5r_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 16 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,2,3,7,8,9,11)

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type,idx_tag	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d0194bbb.m.tag_id	1	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    13	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.74 ms Son sorgudan sonra: 1.07 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 9.283 MB Dönen satır: 1

    SELECT COUNT(*)
    
      FROM k0o5r_content AS a
    
      LEFT JOIN k0o5r_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN k0o5r_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN k0o5r_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN k0o5r_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN k0o5r_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM k0o5r_categories AS cat JOIN k0o5r_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.featured = 1 
      AND a.access IN (1,1,2,3,7,8,9,11) 
      AND c.access IN (1,1,2,3,7,8,9,11) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2)

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	PRIMARY,idx_access	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	15	Using where
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_featured_catid	idx_featured_catid	5	const,d0194bbb.c.id	1	Using index condition; Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	d0194bbb.c.id	3	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right,published	published	1	NULL	2	Using index condition; Using where; Using temporary; Dosya sıralama kullanılıyor
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	15	Using where; Using index; Using join buffer (flat, BNL join)

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.07 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.09 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    16	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
    15	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
    14	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
    13	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 1.59 ms Son sorgudan sonra: 11.78 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.249 MB Dönen satır: 2

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

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Dosya sıralama kullanılıyor
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,published	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	15	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	d0194bbb.c.id	3	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right,published	published	1	NULL	2	Using index condition; Using where; Using temporary; Dosya sıralama kullanılıyor
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	15	Using where; Using index; Using join buffer (flat, BNL join)

    Profil

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.10 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.09 ms
    Statistics	0.34 ms
    Preparing	0.04 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.29 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.07 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    17	ContentHelperRoute::getArticleRoute()	JROOT/plugins/content/jcomments/jcomments.php:94
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.39 ms Son sorgudan sonra: 2.20 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.501 MB Dönen satır: 1

    SELECT count(*)
    
      FROM k0o5r_jcomments AS c
    
      WHERE c.object_id = 8 
      AND c.object_group = 'com_content' 
      AND c.published = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    17	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 1.15 ms Son sorgudan sonra: 0.92 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.535 MB Dönen satır: 2

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

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Dosya sıralama kullanılıyor
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,published	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	15	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	d0194bbb.c.id	3	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right,published	published	1	NULL	2	Using index condition; Using where; Using temporary; Dosya sıralama kullanılıyor
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	15	Using where; Using index; Using join buffer (flat, BNL join)

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.11 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.08 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Statistics	0.10 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.28 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.07 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    17	ContentHelperRoute::getArticleRoute()	JROOT/plugins/content/jcomments/jcomments.php:94
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.29 ms Son sorgudan sonra: 0.50 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.567 MB Dönen satır: 1

    SELECT count(*)
    
      FROM k0o5r_jcomments AS c
    
      WHERE c.object_id = 7 
      AND c.object_group = 'com_content' 
      AND c.published = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.01 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    17	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.97 ms Son sorgudan sonra: 0.82 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.598 MB Dönen satır: 2

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

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Dosya sıralama kullanılıyor
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,published	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	15	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	d0194bbb.c.id	3	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right,published	published	1	NULL	2	Using index condition; Using where; Using temporary; Dosya sıralama kullanılıyor
    2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	15	Using where; Using index; Using join buffer (flat, BNL join)

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.09 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.07 ms
    Optimizing	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.21 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    17	ContentHelperRoute::getArticleRoute()	JROOT/plugins/content/jcomments/jcomments.php:94
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.26 ms Son sorgudan sonra: 0.47 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.630 MB Dönen satır: 1

    SELECT count(*)
    
      FROM k0o5r_jcomments AS c
    
      WHERE c.object_id = 17 
      AND c.object_group = 'com_content' 
      AND c.published = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    17	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.22 ms Son sorgudan sonra: 0.95 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.659 MB Dönen satır: 1

    SELECT count(*)
    
      FROM k0o5r_jcomments AS c
    
      WHERE c.object_id = 18 
      AND c.object_group = 'com_content' 
      AND c.published = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    17	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.21 ms Son sorgudan sonra: 0.84 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.686 MB Dönen satır: 1

    SELECT count(*)
    
      FROM k0o5r_jcomments AS c
    
      WHERE c.object_id = 21 
      AND c.object_group = 'com_content' 
      AND c.published = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.02 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    17	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.27 ms Son sorgudan sonra: 0.92 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.731 MB Dönen satır: 1

    SELECT count(*)
    
      FROM k0o5r_jcomments AS c
    
      WHERE c.object_id = 16 
      AND c.object_group = 'com_content' 
      AND c.published = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
    17	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
    16	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
    15	plgContentJComments->onContentBeforeDisplay()	Aşağıdaki satırda bulunan çağrı gibi.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:105
    11	ContentViewFeatured->display()	JROOT/libraries/joomla/cache/controller/view.php:95
    10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.94 ms Son sorgudan sonra: 13.83 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 12.720 MB Dönen satır: 19

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM k0o5r_modules AS m
    
      LEFT JOIN k0o5r_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN k0o5r_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-09-18 20:46:27') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-09-18 20:46:27') 
      AND m.access IN (1,1,2,3,7,8,9,11) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	38	Using index condition; Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	d0194bbb.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	d0194bbb.m.module,const	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.07 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.04 ms
    Optimizing	0.09 ms
    Statistics	0.14 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.28 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	Aşağıdaki satırda bulunan çağrı gibi.
    13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/skol_white_shadow_logo_mgrey_v103/index.php:47
    7	require JROOT/templates/skol_white_shadow_logo_mgrey_v103/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.14 ms Son sorgudan sonra: 80.88 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 16.228 MB Dönen satır: 3

    SELECT * 
      FROM `k0o5r_easybook` 
      WHERE `published` = 1 
      ORDER BY `gbdate` DESC 
      LIMIT 0, 3

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_easybook	range	published	published	1	NULL	9	Using index condition; Dosya sıralama kullanılıyor

    Profil

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    12	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_ebrlatestentries/helper.php:58
    11	ModEbrLatestEntriesHelper->getPosts()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:38
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.13 ms Son sorgudan sonra: 0.16 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 16.257 MB Dönen satır: 1
    Sorguları çoğalt: #45  #48  #51

    SELECT `id` 
      FROM `k0o5r_menu` 
      WHERE `link` = 'index.php?option=com_easybookreloaded&view=easybookreloaded' 
      AND `published` = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_menu	ALL	published	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	71	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/modules/mod_ebrlatestentries/helper.php:68
    11	ModEbrLatestEntriesHelper->getPosts()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:38
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.08 ms Son sorgudan sonra: 0.51 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 16.299 MB Dönen satır: 1
    Sorguları çoğalt: #44  #48  #51

    SELECT `id` 
      FROM `k0o5r_menu` 
      WHERE `link` = 'index.php?option=com_easybookreloaded&view=easybookreloaded' 
      AND `published` = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_menu	ALL	published	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	71	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/components/com_easybookreloaded/helpers/route.php:114
    13	EasybookReloadedHelperRoute::getItemId()	JROOT/components/com_easybookreloaded/helpers/route.php:35
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.06 ms Son sorgudan sonra: 0.14 ms Sorgu belleği: 0.027 MB belleği şu sorgudan önce: 16.319 MB Dönen satır: 9
    Sorguları çoğalt: #47  #49  #50  #52  #53

    SELECT * 
      FROM `k0o5r_easybook` 
      WHERE `published` = 1 
      ORDER BY `id` DESC

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/components/com_easybookreloaded/helpers/route.php:88
    13	EasybookReloadedHelperRoute::getLimitstart()	JROOT/components/com_easybookreloaded/helpers/route.php:36
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.15 ms Son sorgudan sonra: 0.08 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 16.340 MB Dönen satır: 9
    Sorguları çoğalt: #46  #49  #50  #52  #53

    SELECT * 
      FROM `k0o5r_easybook` 
      WHERE `published` = 1 
      ORDER BY `id` DESC

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1799
    14	JDatabaseDriver->loadRowList()	JROOT/components/com_easybookreloaded/helpers/route.php:89
    13	EasybookReloadedHelperRoute::getLimitstart()	JROOT/components/com_easybookreloaded/helpers/route.php:36
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.10 ms Son sorgudan sonra: 0.29 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 16.361 MB Dönen satır: 1
    Sorguları çoğalt: #44  #45  #51

    SELECT `id` 
      FROM `k0o5r_menu` 
      WHERE `link` = 'index.php?option=com_easybookreloaded&view=easybookreloaded' 
      AND `published` = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_menu	ALL	published	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	71	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/components/com_easybookreloaded/helpers/route.php:114
    13	EasybookReloadedHelperRoute::getItemId()	JROOT/components/com_easybookreloaded/helpers/route.php:35
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.09 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 16.381 MB Dönen satır: 9
    Sorguları çoğalt: #46  #47  #50  #52  #53

    SELECT * 
      FROM `k0o5r_easybook` 
      WHERE `published` = 1 
      ORDER BY `id` DESC

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/components/com_easybookreloaded/helpers/route.php:88
    13	EasybookReloadedHelperRoute::getLimitstart()	JROOT/components/com_easybookreloaded/helpers/route.php:36
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.10 ms Son sorgudan sonra: 0.07 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 16.401 MB Dönen satır: 9
    Sorguları çoğalt: #46  #47  #49  #52  #53

    SELECT * 
      FROM `k0o5r_easybook` 
      WHERE `published` = 1 
      ORDER BY `id` DESC

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1799
    14	JDatabaseDriver->loadRowList()	JROOT/components/com_easybookreloaded/helpers/route.php:89
    13	EasybookReloadedHelperRoute::getLimitstart()	JROOT/components/com_easybookreloaded/helpers/route.php:36
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.08 ms Son sorgudan sonra: 0.24 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 16.422 MB Dönen satır: 1
    Sorguları çoğalt: #44  #45  #48

    SELECT `id` 
      FROM `k0o5r_menu` 
      WHERE `link` = 'index.php?option=com_easybookreloaded&view=easybookreloaded' 
      AND `published` = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_menu	ALL	published	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	71	Using where

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/components/com_easybookreloaded/helpers/route.php:114
    13	EasybookReloadedHelperRoute::getItemId()	JROOT/components/com_easybookreloaded/helpers/route.php:35
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.08 ms Son sorgudan sonra: 0.11 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 16.441 MB Dönen satır: 9
    Sorguları çoğalt: #46  #47  #49  #50  #53

    SELECT * 
      FROM `k0o5r_easybook` 
      WHERE `published` = 1 
      ORDER BY `id` DESC

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    14	JDatabase->query()	JROOT/components/com_easybookreloaded/helpers/route.php:88
    13	EasybookReloadedHelperRoute::getLimitstart()	JROOT/components/com_easybookreloaded/helpers/route.php:36
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.09 ms Son sorgudan sonra: 0.06 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 16.461 MB Dönen satır: 9
    Sorguları çoğalt: #46  #47  #49  #50  #52

    SELECT * 
      FROM `k0o5r_easybook` 
      WHERE `published` = 1 
      ORDER BY `id` DESC

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.01 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1799
    14	JDatabaseDriver->loadRowList()	JROOT/components/com_easybookreloaded/helpers/route.php:89
    13	EasybookReloadedHelperRoute::getLimitstart()	JROOT/components/com_easybookreloaded/helpers/route.php:36
    12	EasybookReloadedHelperRoute::getEasybookReloadedRoute()	JROOT/modules/mod_ebrlatestentries/helper.php:188
    11	ModEbrLatestEntriesHelper->entryLink()	JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php:79
    10	include JROOT/modules/mod_ebrlatestentries/mod_ebrlatestentries.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

    [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: 0.58 ms Son sorgudan sonra: 3.85 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 16.920 MB Dönen satır: 3

    SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner 
      FROM k0o5r_jcomments AS c JOIN k0o5r_jcomments_objects AS o 
      ON c.object_id = o.object_id 
      AND c.object_group = o.object_group 
      AND c.lang = o.lang 
      WHERE  c.published = 1 
      AND c.deleted = 0 
      AND o.link <> '' 
      AND o.access IN (1,2,3,7,8,9,11,0) 
      AND c.object_group in ('com_content','com_jcomments') 
      ORDER BY c.date DESC 
      LIMIT 0, 3

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ALL	idx_lang,idx_object	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	13	Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	o	ref	idx_object	idx_object	833	d0194bbb.c.object_id,d0194bbb.c.object_group,d0194bbb.c.lang	1	Using index condition; Using where

    Profil

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.09 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.00 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jcomments_latest/helper.php:137
    14	modJCommentsLatestHelper::getList()	JROOT/modules/mod_jcomments_latest/mod_jcomments_latest.php:40
    13	include JROOT/modules/mod_jcomments_latest/mod_jcomments_latest.php	JROOT/libraries/cms/module/helper.php:199
    12	JModuleHelper::renderModule()	Aşağıdaki satırda bulunan çağrı gibi.
    11	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:614
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---