Joomla Hata Ayıklama Konsolu

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

57 Sorgu Kaydedildi 116.21 ms

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

   SELECT `data`
   
     FROM `k0o5r_session`
   
     WHERE `session_id` = '561c07aae2c734ffacfea3c354817cd8'

   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.04 ms
   checking permissions	0.01 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.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	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	2.86 ms
   Waiting for query cache lock	0.02 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ı
   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.32 ms Son sorgudan sonra: 2.79 ms Sorgu belleği: 0.012 MB belleği şu sorgudan önce: 3.174 MB Dönen satır: 0

   SELECT `session_id`
   
     FROM `k0o5r_session`
   
     WHERE `session_id` = '561c07aae2c734ffacfea3c354817cd8' 
     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.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.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 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.]

   ---

3. Sorgu Süresi: 0.30 ms Son sorgudan sonra: 0.19 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 3.189 MB

   INSERT INTO `k0o5r_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('561c07aae2c734ffacfea3c354817cd8', 0, 1, '1669597750', 0, '')

   Açıkla

   Şu sorgudaki olamayacakları AÇIKLA: INSERT INTO `k0o5r_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('561c07aae2c734ffacfea3c354817cd8', 0, 1, '1669597750', 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.08 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.04 ms
   Writing to binlog	0.00 ms
   Commit	0.01 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	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.]

   ---

4. Sorgu Süresi: 0.48 ms Son sorgudan sonra: 7.30 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 3.836 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.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.02 ms
   Statistics	0.08 ms
   Preparing	0.00 ms
   Unlocking tables	0.02 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.04 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	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.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.01 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.]

   ---

5. Sorgu Süresi: 0.24 ms Son sorgudan sonra: 0.63 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 3.912 MB Dönen satır: 13
   Sorguları çoğalt: #10

   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.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.01 ms
   Optimizing	0.00 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	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.01 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ı
   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.]

   ---

6. Sorgu Süresi: 0.35 ms Son sorgudan sonra: 8.77 ms Sorgu belleği: 0.016 MB belleği şu sorgudan önce: 5.066 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.05 ms
   checking permissions	0.02 ms
   Opening tables	0.02 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.02 ms
   Preparing	0.01 ms
   Sorting result	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
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 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ı
   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.]

   ---

7. Sorgu Süresi: 0.22 ms Son sorgudan sonra: 0.20 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 5.082 MB

   INSERT INTO k0o5r_vvisit_counter (time, visits, guests) 
     VALUES (1669597751, 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 (1669597751, 1, 1) ON DUPLICATE KEY UPDATE visits=visits+1, guests=guests+1;

   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.01 ms
   init for update	0.02 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.00 ms
   Writing to binlog	0.02 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Waiting for query cache lock	0.00 ms
   Unlocking tables	0.01 ms
   closing tables	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ı
   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.]

   ---

8. Sorgu Süresi: 0.24 ms Son sorgudan sonra: 0.63 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 5.154 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.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
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	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ı
   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.]

   ---

9. Sorgu Süresi: 0.66 ms Son sorgudan sonra: 1.64 ms Sorgu belleği: 0.035 MB belleği şu sorgudan önce: 5.378 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|filter	idx_client_id_parent_id_alias_language,published,parent_id	idx_client_id_parent_id_alias_language|published	1|1	const	21 (28%)	Using index condition; Using where; Dosya sıralama kullanılıyor; Using rowid filter
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.m.component_id	1	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.05 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.00 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.07 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.04 ms
   Creating sort index	0.20 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	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.03 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.]

   ---

10. Sorgu Süresi: 0.12 ms Son sorgudan sonra: 5.52 ms Sorgu belleği: 0.016 MB belleği şu sorgudan önce: 6.026 MB Dönen satır: 13
    Sorguları çoğalt: #5

    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.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ı
    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.]

    ---

11. Sorgu Süresi: 0.23 ms Son sorgudan sonra: 0.17 ms Sorgu belleği: 0.017 MB belleği şu sorgudan önce: 6.040 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.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.03 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 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
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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.]

    ---

12. Sorgu Süresi: 0.47 ms Son sorgudan sonra: 3.06 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 6.236 MB

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.09 ms
    Updating	0.06 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.07 ms
    Writing to binlog	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 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.]

    ---

13. Sorgu Süresi: 0.60 ms Son sorgudan sonra: 18.06 ms Sorgu belleği: 0.034 MB belleği şu sorgudan önce: 7.934 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.03 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    Opening tables	0.22 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.01 ms
    After opening tables	0.00 ms
    checking permissions	0.05 ms
    closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.07 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.]

    ---

14. Sorgu Süresi: 0.24 ms Son sorgudan sonra: 0.74 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.011 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.01 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.00 ms
    Unlocking tables	0.01 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
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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.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ı
    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.]

    ---

15. Sorgu Süresi: 0.28 ms Son sorgudan sonra: 0.29 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 8.034 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.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.01 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.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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: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.]

    ---

16. Sorgu Süresi: 0.42 ms Son sorgudan sonra: 0.82 ms Sorgu belleği: 0.028 MB belleği şu sorgudan önce: 8.094 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.02 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.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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.]

    ---

17. Sorgu Süresi: 0.43 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.028 MB belleği şu sorgudan önce: 8.129 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.01 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.01 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.12 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.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.01 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.]

    ---

18. Sorgu Süresi: 1.78 ms Son sorgudan sonra: 4.29 ms Sorgu belleği: 0.057 MB belleği şu sorgudan önce: 8.478 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.16 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.11 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.07 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    Preparing	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.15 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.69 ms
    Waiting for query cache lock	0.00 ms
    Creating sort index	0.03 ms
    Waiting for query cache lock	0.00 ms
    Creating sort index	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	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
    Starting cleanup	0.00 ms
    Freeing items	0.02 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.02 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.]

    ---

19. Sorgu Süresi: 0.45 ms Son sorgudan sonra: 1.97 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.837 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.02 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.04 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.06 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: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.]

    ---

20. Sorgu Süresi: 0.33 ms Son sorgudan sonra: 0.54 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.877 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.01 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
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.02 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.]

    ---

21. Sorgu Süresi: 0.34 ms Son sorgudan sonra: 0.57 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.916 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.03 ms
    Optimizing	0.01 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
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 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.01 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.]

    ---

22. Sorgu Süresi: 0.33 ms Son sorgudan sonra: 0.56 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.956 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.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
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.00 ms
    Reset for next command	0.01 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.]

    ---

23. Sorgu Süresi: 0.36 ms Son sorgudan sonra: 0.55 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.995 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.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.01 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.]

    ---

24. Sorgu Süresi: 0.34 ms Son sorgudan sonra: 0.48 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.034 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
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.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.01 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.]

    ---

25. Sorgu Süresi: 1.08 ms Son sorgudan sonra: 1.91 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 9.164 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.09 ms
    checking permissions	0.01 ms
    Opening tables	0.05 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.08 ms
    Optimizing	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.06 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.18 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	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
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 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.01 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.]

    ---

26. Sorgu Süresi: 1.46 ms Son sorgudan sonra: 20.54 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.128 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.01 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.04 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.07 ms
    Statistics	0.11 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.03 ms
    Creating tmp table	0.04 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.35 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.12 ms
    Creating sort index	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	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
    Starting cleanup	0.00 ms
    Freeing items	0.02 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.01 ms
    Reset for next command	0.01 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.]

    ---

27. Sorgu Süresi: 0.34 ms Son sorgudan sonra: 3.83 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.379 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.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.06 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.03 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.01 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.]

    ---

28. Sorgu Süresi: 1.57 ms Son sorgudan sonra: 1.43 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.414 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.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.04 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Statistics	0.12 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
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.37 ms
    Creating sort index	0.07 ms
    Removing tmp table	0.10 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.01 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.02 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.]

    ---

29. Sorgu Süresi: 0.33 ms Son sorgudan sonra: 0.74 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.445 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.00 ms
    Checking query cache for query	0.04 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.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.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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.06 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.01 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.]

    ---

30. Sorgu Süresi: 1.52 ms Son sorgudan sonra: 1.12 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.477 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.22 ms
    checking permissions	0.01 ms
    Opening tables	0.02 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.11 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.07 ms
    Statistics	0.15 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.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 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.01 ms
    Creating sort index	0.38 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
    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
    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ı
    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.]

    ---

31. Sorgu Süresi: 0.21 ms Son sorgudan sonra: 0.71 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.509 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.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 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
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.]

    ---

32. Sorgu Süresi: 0.22 ms Son sorgudan sonra: 1.27 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.537 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.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.01 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.]

    ---

33. Sorgu Süresi: 0.26 ms Son sorgudan sonra: 1.16 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 11.565 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.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.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
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.01 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.]

    ---

34. Sorgu Süresi: 0.34 ms Son sorgudan sonra: 1.33 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.610 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.04 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.02 ms
    Statistics	0.05 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
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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.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.01 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: 0.96 ms Son sorgudan sonra: 19.06 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 12.600 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 <= '2022-11-28 01:09:11') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-11-28 01:09:11') 
      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.01 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.08 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.06 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.39 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 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.03 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.01 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.]

    ---

36. Sorgu Süresi: 1.09 ms Son sorgudan sonra: 11.17 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 13.197 MB Dönen satır: 0

    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.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 = 1 
      AND a.catid IN (0,9,10,11,12,13) 
      AND a.created >= DATE_SUB('2022-11-28 01:09:11', INTERVAL 1200 DAY)
    
      ORDER BY a.created DESC 
      LIMIT 16

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	range	idx_access,idx_catid	idx_catid	4	NULL	25	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.22 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.10 ms
    Optimizing	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    Preparing	0.06 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.12 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	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
    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.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/modules/mod_minifrontpage/helper.php:118
    14	modMiniFrontPageHelper::getList()	JROOT/modules/mod_minifrontpage/mod_minifrontpage.php:94
    13	include JROOT/modules/mod_minifrontpage/mod_minifrontpage.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:592
    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.]

    ---

37. Sorgu Süresi: 0.51 ms Son sorgudan sonra: 19.11 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 13.639 MB Dönen satır: 1

    SELECT SUM(visits) AS visits 
      FROM k0o5r_vvisit_counter 
      WHERE '1=1' 
      AND time > 1669593600

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_vvisit_counter	range	PRIMARY,time	PRIMARY	4	NULL	61	Using index condition

    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.05 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.01 ms
    init	0.02 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Storing result in query cache	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	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ı
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:110
    14	plgVVisitCounterHelper::getVisitsByType()	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:129
    13	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.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:592
    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.]

    ---

38. Sorgu Süresi: 0.52 ms Son sorgudan sonra: 0.37 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 13.679 MB Dönen satır: 1

    SELECT SUM(visits) AS visits 
      FROM k0o5r_vvisit_counter 
      WHERE '1=1' 
      AND time > 1669507200  
      AND time <= 1669593600

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_vvisit_counter	range	PRIMARY,time	PRIMARY	4	NULL	63	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.06 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.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    Storing result in query cache	0.01 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.20 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	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ı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:110
    17	plgVVisitCounterHelper::getVisitsByType()	Aşağıdaki satırda bulunan çağrı gibi.
    16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    14	JCacheControllerCallback->call()	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:135
    13	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.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:592
    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.]

    ---

39. Sorgu Süresi: 48.76 ms Son sorgudan sonra: 0.62 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 13.703 MB Dönen satır: 1

    SELECT SUM(visits) AS visits 
      FROM k0o5r_vvisit_counter 
      WHERE '1=1' 
      AND time <= 1668902400

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_vvisit_counter	ALL	PRIMARY,time	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	386791	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.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    Storing result in query cache	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	48.46 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.03 ms
    Starting cleanup	0.00 ms
    Freeing items	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ı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:110
    17	plgVVisitCounterHelper::getVisitsByType()	Aşağıdaki satırda bulunan çağrı gibi.
    16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    14	JCacheControllerCallback->call()	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:155
    13	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.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:592
    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.]

    ---

40. Sorgu Süresi: 2.35 ms Son sorgudan sonra: 0.89 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 13.725 MB Dönen satır: 1

    SELECT SUM(visits) AS visits 
      FROM k0o5r_vvisit_counter 
      WHERE '1=1' 
      AND time > 1667260800  
      AND time <= 1669593600

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_vvisit_counter	range	PRIMARY,time	PRIMARY	4	NULL	1111	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.06 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
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    Storing result in query cache	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	1.98 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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ı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:110
    17	plgVVisitCounterHelper::getVisitsByType()	Aşağıdaki satırda bulunan çağrı gibi.
    16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    14	JCacheControllerCallback->call()	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:165
    13	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.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:592
    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.]

    ---

41. Sorgu Süresi: 2.28 ms Son sorgudan sonra: 0.70 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 13.748 MB Dönen satır: 1

    SELECT SUM(visits) AS visits 
      FROM k0o5r_vvisit_counter 
      WHERE '1=1' 
      AND time > 1664582400  
      AND time <= 1667260800

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_vvisit_counter	range	PRIMARY,time	PRIMARY	4	NULL	1141	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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 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
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    Storing result in query cache	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	1.93 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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ı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/plugins/system/vvisit_counter/helper/vvisit_counter.php:110
    17	plgVVisitCounterHelper::getVisitsByType()	Aşağıdaki satırda bulunan çağrı gibi.
    16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    14	JCacheControllerCallback->call()	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:175
    13	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.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:592
    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.]

    ---

42. Sorgu Süresi: 36.26 ms Son sorgudan sonra: 1.82 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 13.771 MB Dönen satır: 1

    SELECT SUM(visits) AS visits 
      FROM k0o5r_vvisit_counter 
      WHERE '1=1' 
      AND time <= 1669593600

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	k0o5r_vvisit_counter	ALL	PRIMARY,time	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	386791	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.02 ms
    init	0.01 ms
    Waiting for query cache lock	0.00 ms
    init	0.00 ms
    Storing result in query cache	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	35.94 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	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/plugins/system/vvisit_counter/helper/vvisit_counter.php:110
    17	plgVVisitCounterHelper::getVisitsByType()	Aşağıdaki satırda bulunan çağrı gibi.
    16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    14	JCacheControllerCallback->call()	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:185
    13	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.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:592
    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.]

    ---

43. Sorgu Süresi: 1.10 ms Son sorgudan sonra: 5.22 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 13.828 MB Dönen satır: 0

    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.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 = 1 
      AND a.catid IN (10) 
      AND a.created >= DATE_SUB('2022-11-28 01:09:11', INTERVAL 1200 DAY)
    
      ORDER BY a.created DESC 
      LIMIT 3

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	10	Using where; Dosya sıralama kullanılıyor
    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	const	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	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.01 ms
    starting	0.00 ms
    Checking query cache for query	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.13 ms
    Optimizing	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.11 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.07 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	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
    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.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/modules/mod_minifrontpage/helper.php:118
    14	modMiniFrontPageHelper::getList()	JROOT/modules/mod_minifrontpage/mod_minifrontpage.php:94
    13	include JROOT/modules/mod_minifrontpage/mod_minifrontpage.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:592
    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.]

    ---

44. Sorgu Süresi: 1.00 ms Son sorgudan sonra: 2.79 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 13.856 MB Dönen satır: 0

    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.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 = 1 
      AND a.catid IN (11) 
      AND a.created >= DATE_SUB('2022-11-28 01:09:11', INTERVAL 1200 DAY)
    
      ORDER BY a.created DESC 
      LIMIT 3

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	5	Using where; Dosya sıralama kullanılıyor
    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	const	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	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.21 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.09 ms
    Optimizing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Statistics	0.13 ms
    Preparing	0.03 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	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
    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.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/modules/mod_minifrontpage/helper.php:118
    14	modMiniFrontPageHelper::getList()	JROOT/modules/mod_minifrontpage/mod_minifrontpage.php:94
    13	include JROOT/modules/mod_minifrontpage/mod_minifrontpage.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:592
    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.]

    ---

45. Sorgu Süresi: 0.97 ms Son sorgudan sonra: 2.76 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 13.885 MB Dönen satır: 0

    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.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 = 1 
      AND a.catid IN (12) 
      AND a.created >= DATE_SUB('2022-11-28 01:09:11', INTERVAL 1200 DAY)
    
      ORDER BY a.created DESC 
      LIMIT 3

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	4	Using where; Dosya sıralama kullanılıyor
    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	const	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	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.18 ms
    checking permissions	0.01 ms
    Opening tables	0.04 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.13 ms
    Optimizing	0.05 ms
    Optimizing	0.01 ms
    Statistics	0.06 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.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	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
    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.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/modules/mod_minifrontpage/helper.php:118
    14	modMiniFrontPageHelper::getList()	JROOT/modules/mod_minifrontpage/mod_minifrontpage.php:94
    13	include JROOT/modules/mod_minifrontpage/mod_minifrontpage.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:592
    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.]

    ---

46. Sorgu Süresi: 0.42 ms Son sorgudan sonra: 2.83 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 13.885 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.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.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.08 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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.05 ms
    Reset for next command	0.01 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.]

    ---

47. Sorgu Süresi: 0.44 ms Son sorgudan sonra: 0.15 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 13.915 MB Dönen satır: 1
    Sorguları çoğalt: #48  #51  #54

    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.02 ms
    Waiting for query cache lock	0.01 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.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.05 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	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ı
    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.]

    ---

48. Sorgu Süresi: 0.13 ms Son sorgudan sonra: 0.89 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 13.957 MB Dönen satır: 1
    Sorguları çoğalt: #47  #51  #54

    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.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ı
    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.44 ms Son sorgudan sonra: 0.16 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.976 MB Dönen satır: 9
    Sorguları çoğalt: #50  #52  #53  #55  #56

    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.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.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 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.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.01 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.16 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.996 MB Dönen satır: 9
    Sorguları çoğalt: #49  #52  #53  #55  #56

    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.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.00 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.00 ms
    Reset for next command	0.01 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.14 ms Son sorgudan sonra: 0.32 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 14.017 MB Dönen satır: 1
    Sorguları çoğalt: #47  #48  #54

    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.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ı
    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.17 ms Son sorgudan sonra: 0.16 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 14.036 MB Dönen satır: 9
    Sorguları çoğalt: #49  #50  #53  #55  #56

    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.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.03 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.15 ms Son sorgudan sonra: 0.09 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 14.056 MB Dönen satır: 9
    Sorguları çoğalt: #49  #50  #52  #55  #56

    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.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ı
    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.13 ms Son sorgudan sonra: 0.28 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 14.076 MB Dönen satır: 1