Dogunun Incisi: Erzincan

Erzincan ili Dogu Anadolu Bölgesi'nde dokuz ilçeden olusan bir ildir. Bunlar Refahiye, Kemah, Kemaliye, Tercan, Çayirli, Iliç, Otlukbeli ve Üzümlü'dür. Tarihi ipek yolunun üzerinde yer alir.

Yüzölçümü 600 km kare, yüksekligi 1.150-1.300 m'dir. Ovanin çevresini yüksek daglar kusatir. Bunlarin en yüksekleri kuzeydogudaki Kesis (3.547 m) ve güneydeki Mercan Daglari'dir. Mercan Daglari halk arasinda Munzur Daglari olarak bilinir.

Erzincan Ovasi'na güneydoguda Sansa Bogazi'ndan giren Karasu, ovanin tektonik dogrultusunu (güney, güneydogu-bati, kuzeybati) takip ederek Erzincan önlerine gelir ve bu dogrultuyu (bati, güneydogu) dönerek Kemah Bogazi'na girer. Demiryolu da bu bogazlari boylar. Ova, kuzeybatida Sipiköz ve Karadaglari arasina sokulur.

Devamını oku... Yorum Ekle

Vefat: Ibrahim Çetiner´i kaybettik

Ibrahim Çetiner´i kaybettik.

Köyümüz sakinlerinden Ibrahim Çetiner vefat etmistir.

Kendisine tanridan rahmet, ailesi ve yakinlarina bas sagligi diliyoruz.

Yorum Ekle

Videolar

Videolar bölümü eklendi.

Yayinlanmasini arzu ettiginiz videolari gönderebilirsiniz.

Yorum Ekle

Iletisim

Bu bölümde yaptiginiz ya da yapacaginiz etkinlikler (nisan, dügün, dinleti vs..) hakkinda yurtdisindaki Konukseverlileri haberdar edebilirsiniz.

Yorum Ekle

Bir Portre: Özcan Dursun

Bugun size komsu köyümüz Timigi´dan Özcan Dursun'u tanitmak istiyorum.

Bir dönemin Abidin Bey'in bahcesini bilenler Özcan'i hatirlayacaklardir.

Ben, yeni nesillerin de bu yetenekli insani tanimasi gerektigini düsünüyorum.

Özcan Dursun, Istanbul Belediyesi ve Arif Sag Müzik (ASM) evinde 5 yil müzik egitimi aldiktan sonra Paris'e yerlesti ve orada Avrupa dalinda birçok müzik ve sanat aktivitesine katildi ve kendine ait okullarda dersler verdi.

Simdi müzik konusundaki yüksek deneyimini Londra'da ÖDM ögrencilerine aktariyor. Sanatçinin kendine ait 1 albümü bulunmasinin yaninda birçok sanatçinin albümüne katkida bulunmustur ve eslik etmistir.

Erzincan Kemah´li Özcan Dursun su anda ikinci albüm çalismasini yapmaktadir.

Özcan Dursun ÖDM'de Baglama, Perküsyon ve San dersleri vermektedir.

Devamını oku... 7 yorum

Etkinlikler

Bu bölümde yaptiginiz ya da yapacaginiz etkinlikler (nisan, dügün, dinleti vs..) hakkinda yurtdisindaki Konukseverlileri haberdar edebilirsiniz.

Yorum Ekle

Sayfa 3 / 4

954971

Bugün

Dün

Bu Hafta

Gecen Hafta

Bu Ay

Gecen Ay

Tümü

206

454716

1648

2206

954971

Güncel

Joomla Hata Ayıklama Konsolu

Oturum

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

Profil Bilgisi

Bellek Kullanımı

Veritabanı Sorguları

46 Sorgu Kaydedildi 21.33 ms

12 çoğaltma bulundu!

2 çoğaltma: #5 #10

4 çoğaltma: #37 #38 #41 #44

6 çoğaltma: #39 #40 #42 #43 #45 #46

Sorgu Süresi: 0.51 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` = 'f091aa3f225f966cf3ef856ffc53340f'

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.01 ms
starting	0.01 ms
Checking query cache for query	0.05 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.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.03 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.02 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.04 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ı
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.]

Sorgu Süresi: 0.43 ms Son sorgudan sonra: 1.81 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` = 'f091aa3f225f966cf3ef856ffc53340f' 
  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.01 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.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.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.02 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.01 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ı
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.]

Sorgu Süresi: 0.49 ms Son sorgudan sonra: 0.14 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 
('f091aa3f225f966cf3ef856ffc53340f', 0, 1, '1679434268', 0, '')

Açıkla

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

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.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.09 ms
Waiting for query cache lock	0.01 ms
Update	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.10 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 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ı
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.]

Sorgu Süresi: 0.19 ms Son sorgudan sonra: 4.37 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.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.20 ms Son sorgudan sonra: 0.55 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.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.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.]

Sorgu Süresi: 0.45 ms Son sorgudan sonra: 7.78 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.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
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 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
Waiting for query cache lock	0.00 ms
Updating status	0.04 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ı
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.]

Sorgu Süresi: 0.44 ms Son sorgudan sonra: 0.16 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 5.082 MB

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

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.02 ms
Update	0.07 ms
Waiting for query cache lock	0.01 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.03 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.03 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.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.]

Sorgu Süresi: 0.22 ms Son sorgudan sonra: 0.59 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 5.153 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.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.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.]

Sorgu Süresi: 1.06 ms Son sorgudan sonra: 1.41 ms Sorgu belleği: 0.036 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	idx_client_id_parent_id_alias_language,published,parent_id	idx_client_id_parent_id_alias_language	1	const	21	Using index condition; Using where; Dosya sıralama kullanılıyor
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.09 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.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.38 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.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.00 ms
Reset for next command	0.01 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.]

Sorgu Süresi: 0.19 ms Son sorgudan sonra: 4.67 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.01 ms
Waiting for query cache lock	0.00 ms
starting	0.01 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.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.]

Sorgu Süresi: 0.19 ms Son sorgudan sonra: 0.19 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.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.62 ms Son sorgudan sonra: 1.96 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 6.236 MB

UPDATE `k0o5r_extensions`

  SET `params` = '{\"mediaversion\":\"7dc0fb68574db4f0a7a30911b9995322\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Açıkla

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

Profil

Status	Duration
Starting	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
init for update	0.10 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.11 ms
Query end	0.01 ms
Commit	0.08 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
closing tables	0.01 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.]

Sorgu Süresi: 1.02 ms Son sorgudan sonra: 11.35 ms Sorgu belleği: 0.034 MB belleği şu sorgudan önce: 7.935 MB Dönen satır: 8

SHOW FULL COLUMNS 
  FROM `k0o5r_assets`

Açıkla

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.35 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.09 ms
closing tables	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
Removing tmp table	0.14 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.]

Sorgu Süresi: 0.18 ms Son sorgudan sonra: 0.63 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.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.16 ms Son sorgudan sonra: 0.18 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.01 ms
starting	0.01 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.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: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.]

Sorgu Süresi: 0.65 ms Son sorgudan sonra: 0.59 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.01 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.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.18 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.01 ms
Updating status	0.01 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.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.]

Sorgu Süresi: 0.13 ms Son sorgudan sonra: 0.22 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.00 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 1.97 ms Son sorgudan sonra: 2.31 ms Sorgu belleği: 0.040 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 12, 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.23 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.16 ms
Optimizing	0.05 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Statistics	0.16 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.08 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.23 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.40 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.08 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.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.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.03 ms
Reset for next command	0.00 ms

Yığın Çağır

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

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

Sorgu Süresi: 0.63 ms Son sorgudan sonra: 1.54 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.805 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` = 10 
  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.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.06 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.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 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.02 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.04 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.]

Sorgu Süresi: 0.58 ms Son sorgudan sonra: 0.38 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.844 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` = 19 
  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.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 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
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.07 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.]

Sorgu Süresi: 0.62 ms Son sorgudan sonra: 0.33 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.884 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` = 22 
  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.01 ms
starting	0.00 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 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.02 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.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.]

Sorgu Süresi: 0.63 ms Son sorgudan sonra: 0.34 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.923 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` = 15 
  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.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 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.02 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ı
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.]

Sorgu Süresi: 0.62 ms Son sorgudan sonra: 0.36 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.963 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` = 9 
  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.01 ms
starting	0.00 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 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.02 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ı
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.]

Sorgu Süresi: 0.46 ms Son sorgudan sonra: 0.36 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.002 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` = 12 
  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.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.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 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.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ı
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.]

Sorgu Süresi: 0.15 ms Son sorgudan sonra: 1.09 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 9.132 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.02 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.22 ms Son sorgudan sonra: 14.68 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.097 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.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.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ı
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.]

Sorgu Süresi: 0.53 ms Son sorgudan sonra: 2.00 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.348 MB Dönen satır: 1

SELECT count(*)

  FROM k0o5r_jcomments AS c

  WHERE c.object_id = 10 
  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.01 ms
starting	0.00 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 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.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.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.]

Sorgu Süresi: 0.35 ms Son sorgudan sonra: 0.97 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.378 MB Dönen satır: 1

SELECT count(*)

  FROM k0o5r_jcomments AS c

  WHERE c.object_id = 19 
  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.01 ms
starting	0.00 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 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.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.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.]

Sorgu Süresi: 2.06 ms Son sorgudan sonra: 0.72 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.409 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=13

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Açıkla

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

Profil

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.23 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.14 ms
Optimizing	0.05 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Statistics	0.21 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.50 ms
Creating sort index	0.08 ms
Removing tmp table	0.13 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.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ı
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.]

Sorgu Süresi: 0.44 ms Son sorgudan sonra: 0.46 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.440 MB Dönen satır: 1

SELECT count(*)

  FROM k0o5r_jcomments AS c

  WHERE c.object_id = 22 
  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.01 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 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.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.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.]

Sorgu Süresi: 0.46 ms Son sorgudan sonra: 1.03 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.467 MB Dönen satır: 1

SELECT count(*)

  FROM k0o5r_jcomments AS c

  WHERE c.object_id = 15 
  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.01 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.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 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.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.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.]

Sorgu Süresi: 0.18 ms Son sorgudan sonra: 0.84 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.501 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.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.44 ms Son sorgudan sonra: 0.49 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 11.534 MB Dönen satır: 1

SELECT count(*)

  FROM k0o5r_jcomments AS c

  WHERE c.object_id = 9 
  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	7	Using where; Using index

Profil

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.03 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.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.]

Sorgu Süresi: 1.88 ms Son sorgudan sonra: 0.85 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.564 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.01 ms
starting	0.00 ms
Checking query cache for query	0.18 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.03 ms
init	0.13 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Statistics	0.19 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.05 ms
Creating tmp table	0.05 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.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.45 ms
Creating sort index	0.07 ms
Removing tmp table	0.12 ms
Creating sort index	0.02 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.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.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.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.]

Sorgu Süresi: 0.44 ms Son sorgudan sonra: 0.50 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.596 MB Dönen satır: 1

SELECT count(*)

  FROM k0o5r_jcomments AS c

  WHERE c.object_id = 12 
  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.01 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.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 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.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.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.]

Sorgu Süresi: 0.20 ms Son sorgudan sonra: 26.00 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 13.184 MB Dönen satır: 3

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

Açıkla

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

Profil

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.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ı
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.]

Sorgu Süresi: 0.15 ms Son sorgudan sonra: 0.12 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 13.213 MB Dönen satır: 1

Sorguları çoğalt: #38 #41 #44

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.01 ms
starting	0.00 ms
Checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.17 ms Son sorgudan sonra: 0.45 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 13.256 MB Dönen satır: 1

Sorguları çoğalt: #37 #41 #44

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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 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/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.]

Sorgu Süresi: 0.18 ms Son sorgudan sonra: 0.14 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.276 MB Dönen satır: 9

Sorguları çoğalt: #40 #42 #43 #45 #46

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.01 ms
starting	0.00 ms
Checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/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.]

Sorgu Süresi: 0.15 ms Son sorgudan sonra: 0.09 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.295 MB Dönen satır: 9

Sorguları çoğalt: #39 #42 #43 #45 #46

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.01 ms
starting	0.00 ms
Checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

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

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

Sorgu Süresi: 0.14 ms Son sorgudan sonra: 0.24 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 13.316 MB Dönen satır: 1

Sorguları çoğalt: #37 #38 #44

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.01 ms
starting	0.00 ms
Checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.11 ms Son sorgudan sonra: 0.14 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.336 MB Dönen satır: 9

Sorguları çoğalt: #39 #40 #43 #45 #46

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.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/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.]

Sorgu Süresi: 0.11 ms Son sorgudan sonra: 0.07 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.355 MB Dönen satır: 9

Sorguları çoğalt: #39 #40 #42 #45 #46

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.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

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

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

Sorgu Süresi: 0.09 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 13.376 MB Dönen satır: 1

Sorguları çoğalt: #37 #38 #41

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.00 ms
starting	0.00 ms
Checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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.]

Sorgu Süresi: 0.11 ms Son sorgudan sonra: 0.11 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.395 MB Dönen satır: 9

Sorguları çoğalt: #39 #40 #42 #43 #46

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.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/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.]

Sorgu Süresi: 0.11 ms Son sorgudan sonra: 0.07 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 13.414 MB Dönen satır: 9

Sorguları çoğalt: #39 #40 #42 #43 #45

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.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Yığın Çağır

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

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

23 sorgu türü kayıt altına alındı, yinelemeye göre tersten sıralandı.

Seçili Tablolar:

```
7 × SELECT * 
  FROM `k0o5r_easybook`
```

6 × SELECT `m`.`tag_id`,`t`.* 
  FROM `k0o5r_contentitem_tag_map` AS m  
  INNER JOIN `k0o5r_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

6 × SELECT count(*) 
  FROM k0o5r_jcomments AS c

```
4 × SELECT `id` 
  FROM `k0o5r_menu`
```

4 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM 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

2 × SELECT id, rules 
  FROM `k0o5r_viewlevels

1 × SELECT a.name, a.rules 
  FROM k0o5r_assets AS a

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN 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

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

1 × SELECT element 
  FROM k0o5r_extensions

1 × SELECT a.rules 
  FROM k0o5r_assets AS a

1 × SELECT time 
  FROM k0o5r_vvisit_counter USE INDEX(time)

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

1 × SELECT `session_id` 
  FROM `k0o5r_session`

1 × SELECT * 
  FROM k0o5r_virtualdomain

1 × 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

```
1 × SELECT * 
  FROM k0o5r_assets
```

1 × Select * 
  From k0o5r_virtualdomain_params

1 × SELECT `data` 
  FROM `k0o5r_session`

Diğer Tablolar:

1 × SHOW FULL COLUMNS 
  FROM `k0o5r_assets

1 × UPDATE `k0o5r_extensions` 
  SET `params` = '{\"mediaversion\":\"7dc0fb68574db4f0a7a30911b9995322\"}'

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

1 × INSERT INTO `k0o5r_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('f091aa3f225f966cf3ef856ffc53340f', 0, 1, '1679434268', 0, ''

Dogunun Incisi: Erzincan

Vefat: Ibrahim Çetiner´i kaybettik

Videolar

Iletisim

Bir Portre: Özcan Dursun

Etkinlikler

Genel

Edebiyat & Sanat

Etkinlikler

Ziyaretci Defterinden

Son Yorumlar

Vefat: Mustafa Özkul´u kaybettik

Vefat: Mustafa Özkul´u kaybettik

Bir Portre: Özcan Dursun

Güncel

Joomla Hata Ayıklama Konsolu

Oturum

Profil Bilgisi

Süre

Bellek

Bellek Kullanımı

Veritabanı Sorguları

46 Sorgu Kaydedildi 21.33 ms

12 çoğaltma bulundu!

23 sorgu türü kayıt altına alındı, yinelemeye göre tersten sıralandı.

Seçili Tablolar:

Diğer Tablolar: