Joomla Hata Ayıklama Konsolu

Oturum

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

48 Sorgu Kaydedildi 135.07 ms

8 çoğaltma bulundu!

2 çoğaltma: #5 #6

2 çoğaltma: #11 #13

4 çoğaltma: #44 #45 #46 #47

Sorgu Süresi: 0.95 ms Sorgu belleği: 0.010 MB belleği şu sorgudan önce: 0.997 MB Dönen satır: 0

SELECT `session_id`

  FROM `kd98ar_session`

  WHERE `session_id` = 'i64ct6gberah06qbfhgpb75rf2' 
  LIMIT 1

Açıkla

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

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.13 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.06 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.06 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.02 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:46

[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.62 ms Son sorgudan sonra: 0.41 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 1.012 MB

INSERT INTO `kd98ar_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('i64ct6gberah06qbfhgpb75rf2', 0, 1, '1747113832', 0, '')

Açıkla

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.02 ms
update	0.13 ms
Waiting for query cache lock	0.01 ms
update	0.04 ms
end	0.01 ms
query end	1.05 ms
closing tables	0.04 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 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:46

[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.31 ms Son sorgudan sonra: 6.67 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 1.208 MB Dönen satır: 2

SELECT b.id

  FROM kd98ar_usergroups AS a

  LEFT JOIN kd98ar_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

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	4	Using where; Using index

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	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:49

[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.27 ms Son sorgudan sonra: 0.74 ms Sorgu belleği: 0.012 MB belleği şu sorgudan önce: 1.228 MB Dönen satır: 5

SELECT id, rules

  FROM `kd98ar_viewlevels`

Açıkla

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.02 ms
init	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
cleaning up	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:49

[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.27 ms Son sorgudan sonra: 22.84 ms Sorgu belleği: 0.017 MB belleği şu sorgudan önce: 1.963 MB Dönen satır: 1

Sorguları çoğalt: #6

SELECT template

  FROM kd98ar_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Açıkla

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

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.01 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/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
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:49

[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.14 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 1.982 MB Dönen satır: 1

Sorguları çoğalt: #5

SELECT template

  FROM kd98ar_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Açıkla

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

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	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
cleaning up	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/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
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:49

[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.93 ms Son sorgudan sonra: 3.68 ms Sorgu belleği: 0.013 MB belleği şu sorgudan önce: 2.052 MB Dönen satır: 2

SELECT extension, file, type

  FROM kd98ar_rokcommon_configs

  ORDER BY priority

Açıkla

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 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.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
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:49

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

Sorgu Süresi: 3.02 ms Son sorgudan sonra: 15.53 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 2.602 MB Dönen satır: 48

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 kd98ar_menu AS m

  LEFT JOIN kd98ar_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	idx_client_id_parent_id_alias_language	1	const	54	Using index condition; Using where; Dosya sıralama kullanılıyor
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c7stendustridergi.m.component_id	1	Using where

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.05 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.61 ms
Sending data	0.22 ms
Waiting for query cache lock	0.00 ms
Sending data	0.36 ms
Waiting for query cache lock	0.01 ms
Sending data	0.30 ms
Waiting for query cache lock	0.01 ms
Sending data	0.23 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.11 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	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/cms/menu/site.php:86
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
10	JApplicationSite::getRouter()	JROOT/plugins/system/hippofixitemid/hippofixitemid.php:22
9	plgSystemHippoFixItemID->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:49

[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.71 ms Son sorgudan sonra: 11.82 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 3.310 MB Dönen satır: 18

SHOW FULL COLUMNS 
  FROM `kd98ar_extensions`

Açıkla

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.22 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:46
9	plgSystemRokSprocket->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:49

[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.78 ms Son sorgudan sonra: 2.10 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 3.380 MB Dönen satır: 1

SELECT `extension_id`

  FROM `kd98ar_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kd98ar_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.09 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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.05 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.01 ms
cleaning up	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/libraries/joomla/table/extension.php:109
10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:50
9	plgSystemRokSprocket->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:49

[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.46 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 3.398 MB Dönen satır: 1

Sorguları çoğalt: #13

SELECT *

  FROM kd98ar_extensions

  WHERE `extension_id` = '10112'

Açıkla

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	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
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.03 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	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:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:55
9	plgSystemRokSprocket->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:49

[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.87 ms Son sorgudan sonra: 0.33 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 3.411 MB Dönen satır: 1

SELECT `extension_id`

  FROM `kd98ar_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kd98ar_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.28 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	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/libraries/joomla/table/extension.php:109
10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:73
9	plgSystemRokSprocket->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:49

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

Sorguları çoğalt: #11

SELECT *

  FROM kd98ar_extensions

  WHERE `extension_id` = '10112'

Açıkla

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	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
cleaning up	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:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:77
9	plgSystemRokSprocket->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:49

[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.84 ms Son sorgudan sonra: 61.51 ms Sorgu belleği: 0.017 MB belleği şu sorgudan önce: 3.902 MB

UPDATE `kd98ar_extensions`

  SET `params` = '{\"mediaversion\":\"04defdf6393ff717bb48e88f384e0fdf\"}'

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

Açıkla

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

Profil

Status	Duration
starting	0.11 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
After opening tables	0.00 ms
init	0.15 ms
updating	0.12 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.09 ms
query end	1.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 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/yt/yt.php:89
9	plgSystemYt->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:49

[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.15 ms Son sorgudan sonra: 28.59 ms Sorgu belleği: 0.030 MB belleği şu sorgudan önce: 4.427 MB Dönen satır: 8

SHOW FULL COLUMNS 
  FROM `kd98ar_assets`

Açıkla

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.37 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	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:49

[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.30 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 4.480 MB Dönen satır: 1

SELECT *

  FROM kd98ar_assets

  WHERE `id` = '1'

Açıkla

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 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.00 ms
cleaning up	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:49

[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.20 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 4.504 MB Dönen satır: 1

SELECT a.rules

  FROM kd98ar_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,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	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
cleaning up	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:49

[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.01 ms Son sorgudan sonra: 0.91 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 4.541 MB Dönen satır: 40

SELECT element

  FROM kd98ar_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kd98ar_extensions	ref	extension	extension	82	const	44	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.35 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.01 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.02 ms
cleaning up	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: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:49

[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.23 ms Son sorgudan sonra: 0.53 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 4.576 MB Dönen satır: 40

SELECT a.name, a.rules

  FROM kd98ar_assets AS a

  WHERE (a.name IN ('com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_jsn','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_miniorangesociallogin','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_virtuemart','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	range	idx_asset_name	idx_asset_name	202	NULL	41	Using index condition; Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.04 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.00 ms
cleaning up	0.01 ms

Yığın Çağır

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

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

Sorgu Süresi: 8.25 ms Son sorgudan sonra: 8.57 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 4.983 MB Dönen satır: 19

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 kd98ar_content AS a

  LEFT JOIN kd98ar_categories AS c 
  ON c.id = a.catid

  LEFT JOIN kd98ar_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN kd98ar_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN kd98ar_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN kd98ar_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-13 05:23:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-13 05:23:52') 
  AND a.catid IN (117,127,114,115,118,119,113,125,116,141,123,120,136,124,131,129,134,133,126,132,128,135,137,139,130)

  ORDER BY c.lft, a.ordering, a.created DESC  
  LIMIT 24

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	range	idx_catid,idx_featured_catid	idx_featured_catid	5	NULL	26	Using index condition; Using where; Using temporary; Dosya sıralama kullanılıyor
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	c7stendustridergi.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	c7stendustridergi.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	c7stendustridergi.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	c7stendustridergi.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	c7stendustridergi.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	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
init	0.00 ms
checking query cache for query	0.27 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	2.09 ms
After opening tables	0.05 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.16 ms
optimizing	0.00 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.10 ms
statistics	1.67 ms
preparing	0.08 ms
executing	0.00 ms
Copying to tmp table	0.57 ms
Copying to tmp table	0.16 ms
executing	0.00 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.23 ms
Sorting result	0.03 ms
Sending data	0.03 ms
removing tmp table	0.03 ms
Sending data	0.72 ms
Sorting result	0.06 ms
Sending data	0.10 ms
Waiting for query cache lock	0.00 ms
Sending data	0.11 ms
Waiting for query cache lock	0.00 ms
Sending data	0.03 ms
end	0.00 ms
removing tmp table	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.02 ms
freeing items	0.04 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.01 ms
cleaning up	0.01 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:49

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

Sorgu Süresi: 5.08 ms Son sorgudan sonra: 25.64 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 5.644 MB Dönen satır: 1

SELECT COUNT(*)

  FROM kd98ar_content AS a

  LEFT JOIN kd98ar_categories AS c 
  ON c.id = a.catid

  LEFT JOIN kd98ar_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN kd98ar_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN kd98ar_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN kd98ar_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-13 05:23:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-13 05:23:52') 
  AND a.catid IN (117,127,114,115,118,119,113,125,116,141,123,120,136,124,131,129,134,133,126,132,128,135,137,139,130)

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	range	idx_catid,idx_featured_catid	idx_featured_catid	5	NULL	26	Using index condition; Using where
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	c7stendustridergi.a.catid	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.17 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.14 ms
statistics	0.67 ms
preparing	0.11 ms
executing	0.02 ms
Sending data	0.19 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	2.11 ms
Sorting result	0.04 ms
Sending data	0.07 ms
removing tmp table	0.01 ms
Sending data	0.48 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.05 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.14 ms
cleaning up	0.01 ms

Yığın Çağır

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

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

Sorgu Süresi: 5.21 ms Son sorgudan sonra: 178.29 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 5.928 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=117

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	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
init	0.01 ms
checking query cache for query	0.33 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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
After opening tables	0.02 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.21 ms
optimizing	0.00 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.11 ms
statistics	0.28 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.65 ms
Copying to tmp table	0.12 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	1.73 ms
Sorting result	0.03 ms
Sending data	0.04 ms
removing tmp table	0.05 ms
Sending data	0.52 ms
Sorting result	0.04 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.06 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 3.34 ms Son sorgudan sonra: 143.01 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 5.980 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=127

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.04 ms
init	0.14 ms
optimizing	0.00 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.10 ms
statistics	0.16 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.46 ms
Copying to tmp table	0.06 ms
executing	0.00 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.94 ms
Sorting result	0.02 ms
Sending data	0.07 ms
removing tmp table	0.01 ms
Sending data	0.31 ms
Sorting result	0.02 ms
Sending data	0.06 ms
end	0.02 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.02 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
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.05 ms Son sorgudan sonra: 156.13 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.017 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=114

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.37 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.03 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.20 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.12 ms
statistics	0.23 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.56 ms
Copying to tmp table	0.07 ms
executing	0.00 ms
Copying to tmp table	0.02 ms
Copying to tmp table	1.65 ms
Sorting result	0.04 ms
Sending data	0.06 ms
removing tmp table	0.01 ms
Sending data	0.50 ms
Sorting result	0.03 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.19 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.03 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.07 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.07 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

[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.54 ms Son sorgudan sonra: 122.23 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.054 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=115

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	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
init	0.00 ms
checking query cache for query	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.13 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.07 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.01 ms
Copying to tmp table	0.30 ms
Copying to tmp table	0.05 ms
executing	0.00 ms
Copying to tmp table	0.01 ms
Copying to tmp table	0.65 ms
Sorting result	0.02 ms
Sending data	0.03 ms
removing tmp table	0.01 ms
Sending data	0.22 ms
Sorting result	0.02 ms
Sending data	0.04 ms
end	0.00 ms
removing tmp table	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.12 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.04 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.00 ms Son sorgudan sonra: 105.00 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.090 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=118

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.37 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.29 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.13 ms
statistics	0.24 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.60 ms
Copying to tmp table	0.07 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.48 ms
Sorting result	0.03 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.52 ms
Sorting result	0.04 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.02 ms
freeing items	0.03 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.03 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.07 ms Son sorgudan sonra: 113.37 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.127 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=119

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.32 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.07 ms
init	0.26 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.12 ms
statistics	0.25 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.61 ms
Copying to tmp table	0.10 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.69 ms
Sorting result	0.04 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.50 ms
Sorting result	0.03 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.05 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.03 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.22 ms Son sorgudan sonra: 146.47 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.164 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=113

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.30 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.21 ms
optimizing	0.01 ms
optimizing	0.07 ms
statistics	0.15 ms
preparing	0.12 ms
statistics	0.23 ms
preparing	0.10 ms
executing	0.01 ms
Copying to tmp table	0.64 ms
Copying to tmp table	0.09 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.72 ms
Sorting result	0.04 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.48 ms
Sorting result	0.03 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.07 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.11 ms Son sorgudan sonra: 116.35 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.201 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=125

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.32 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.06 ms
init	0.25 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.12 ms
statistics	0.25 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.49 ms
Copying to tmp table	0.06 ms
executing	0.00 ms
Copying to tmp table	0.02 ms
Copying to tmp table	1.77 ms
Sorting result	0.04 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.53 ms
Sorting result	0.03 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.07 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.03 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 3.18 ms Son sorgudan sonra: 1000.45 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.238 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=116

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.04 ms
init	0.16 ms
optimizing	0.00 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.08 ms
statistics	0.15 ms
preparing	0.05 ms
executing	0.00 ms
Copying to tmp table	0.36 ms
Copying to tmp table	0.04 ms
executing	0.00 ms
Copying to tmp table	0.01 ms
Copying to tmp table	0.94 ms
Sorting result	0.03 ms
Sending data	0.04 ms
removing tmp table	0.01 ms
Sending data	0.33 ms
Sorting result	0.02 ms
Sending data	0.06 ms
end	0.00 ms
removing tmp table	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 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.04 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 4.01 ms Son sorgudan sonra: 45.54 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.275 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=141

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.28 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.05 ms
init	0.20 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.13 ms
statistics	0.23 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.44 ms
Copying to tmp table	0.07 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.30 ms
Sorting result	0.03 ms
Sending data	0.03 ms
removing tmp table	0.01 ms
Sending data	0.32 ms
Sorting result	0.02 ms
Sending data	0.07 ms
end	0.00 ms
removing tmp table	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.05 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 4.04 ms Son sorgudan sonra: 5.12 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.312 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=136

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	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
init	0.00 ms
checking query cache for query	0.23 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.05 ms
init	0.22 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.13 ms
statistics	0.19 ms
preparing	0.06 ms
executing	0.00 ms
Copying to tmp table	0.41 ms
Copying to tmp table	0.06 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	1.29 ms
Sorting result	0.03 ms
Sending data	0.03 ms
removing tmp table	0.01 ms
Sending data	0.38 ms
Sorting result	0.03 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.20 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.05 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.60 ms Son sorgudan sonra: 10.48 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.350 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=124

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.36 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.25 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.14 ms
statistics	0.27 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.57 ms
Copying to tmp table	0.07 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.94 ms
Sorting result	0.04 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.52 ms
Sorting result	0.04 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.26 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.55 ms Son sorgudan sonra: 7.15 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.387 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=131

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.26 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.21 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.10 ms
statistics	0.21 ms
preparing	0.07 ms
executing	0.01 ms
Copying to tmp table	0.53 ms
Copying to tmp table	0.09 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	2.17 ms
Sorting result	0.06 ms
Sending data	0.07 ms
removing tmp table	0.02 ms
Sending data	0.75 ms
Sorting result	0.05 ms
Sending data	0.11 ms
end	0.01 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.05 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 4.78 ms Son sorgudan sonra: 6.21 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.424 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=129

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	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
init	0.01 ms
checking query cache for query	0.28 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.20 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.12 ms
statistics	0.22 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.48 ms
Copying to tmp table	0.08 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	1.54 ms
Sorting result	0.04 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.49 ms
Sorting result	0.03 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.12 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.28 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 4.82 ms Son sorgudan sonra: 5.89 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.461 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=134

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.32 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.05 ms
init	0.20 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.11 ms
statistics	0.24 ms
preparing	0.09 ms
executing	0.01 ms
Copying to tmp table	0.52 ms
Copying to tmp table	0.08 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.52 ms
Sorting result	0.03 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.52 ms
Sorting result	0.04 ms
Sending data	0.10 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.11 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.35 ms Son sorgudan sonra: 13.53 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.498 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=133

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.30 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.26 ms
optimizing	0.01 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.12 ms
statistics	0.25 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.66 ms
Copying to tmp table	0.09 ms
executing	0.01 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.76 ms
Sorting result	0.05 ms
Sending data	0.06 ms
removing tmp table	0.01 ms
Sending data	0.49 ms
Sorting result	0.03 ms
Sending data	0.12 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.18 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.14 ms Son sorgudan sonra: 5.86 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.550 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=126

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	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
init	0.01 ms
checking query cache for query	0.29 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.13 ms
init	0.19 ms
optimizing	0.00 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.14 ms
statistics	0.24 ms
preparing	0.08 ms
executing	0.01 ms
Copying to tmp table	0.49 ms
Copying to tmp table	0.07 ms
executing	0.00 ms
Copying to tmp table	0.02 ms
Copying to tmp table	1.80 ms
Sorting result	0.03 ms
Sending data	0.05 ms
removing tmp table	0.02 ms
Sending data	0.47 ms
Sorting result	0.03 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.12 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.03 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 4.93 ms Son sorgudan sonra: 13.50 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.588 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=135

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	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
init	0.00 ms
checking query cache for query	0.26 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.09 ms
init	0.18 ms
optimizing	0.01 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.13 ms
statistics	0.28 ms
preparing	0.11 ms
executing	0.01 ms
Copying to tmp table	0.47 ms
Copying to tmp table	0.06 ms
executing	0.04 ms
Copying to tmp table	0.03 ms
Copying to tmp table	1.67 ms
Sorting result	0.04 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.57 ms
Sorting result	0.04 ms
Sending data	0.09 ms
end	0.01 ms
removing tmp table	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.07 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.06 ms
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

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

Sorgu Süresi: 5.03 ms Son sorgudan sonra: 882.50 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.625 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 kd98ar_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_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 kd98ar_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,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=130

  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	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	100	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	c7stendustridergi.c.id	35	Using where
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	35	Using index condition; Using temporary; Dosya sıralama kullanılıyor
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	100	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.33 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.06 ms
init	0.21 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.12 ms
statistics	0.27 ms
preparing	0.12 ms
executing	0.01 ms
Copying to tmp table	0.51 ms
Copying to tmp table	0.06 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	1.67 ms
Sorting result	0.04 ms
Sending data	0.05 ms
removing tmp table	0.01 ms
Sending data	0.53 ms
Sorting result	0.06 ms
Sending data	0.11 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.02 ms
freeing items	0.03 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
cleaning up	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/templates/sj_g2shop/html/com_content/featured/default_item.php:136
16	include JROOT/templates/sj_g2shop/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/sj_g2shop/html/com_content/featured/default.php:73
14	include JROOT/templates/sj_g2shop/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
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:49

[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: 129.65 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 7.276 MB Dönen satır: 1

SELECT template_style_id 
  FROM kd98ar_menu 
  WHERE id = 875

Açıkla

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

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	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/yt/includes/site/lib/yt_template.php:129
10	YtFrameworkTemplate->isOverrideTemplate()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
9	YtFrameworkTemplate->YtFrameworkTemplate()	JROOT/templates/sj_g2shop/includes/frame_inc.php:29
8	include_once JROOT/templates/sj_g2shop/includes/frame_inc.php	JROOT/templates/sj_g2shop/index.php:29
7	require JROOT/templates/sj_g2shop/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[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.50 ms Son sorgudan sonra: 0.12 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 7.292 MB Dönen satır: 1

SELECT id 
  FROM kd98ar_template_styles 
  WHERE home = 1 
  AND client_id = 0

Açıkla

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.04 ms
init	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.06 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	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/yt/includes/site/lib/yt_template.php:133
10	YtFrameworkTemplate->isOverrideTemplate()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
9	YtFrameworkTemplate->YtFrameworkTemplate()	JROOT/templates/sj_g2shop/includes/frame_inc.php:29
8	include_once JROOT/templates/sj_g2shop/includes/frame_inc.php	JROOT/templates/sj_g2shop/index.php:29
7	require JROOT/templates/sj_g2shop/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Sorgu Süresi: 13.86 ms Son sorgudan sonra: 7.14 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 7.365 MB Dönen satır: 5

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM kd98ar_modules AS m

  LEFT JOIN kd98ar_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN kd98ar_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-05-13 05:23:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-13 05:23:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 875 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Açıkla

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

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.19 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.65 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.05 ms
init	0.08 ms
optimizing	0.07 ms
statistics	1.39 ms
preparing	0.11 ms
executing	0.01 ms
Sorting result	4.46 ms
Sending data	3.31 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	2.14 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	Aşağıdaki satırda bulunan çağrı gibi.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
12	JDocumentHtml->countModules()	JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:190
11	YtFrameworkRenderXML->getBlocks()	JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:115
10	YtFrameworkRenderXML->getTagBody()	JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49
9	YtFrameworkRenderXML->YtFrameworkRenderXML()	JROOT/templates/sj_g2shop/includes/frame_inc.php:96
8	include_once JROOT/templates/sj_g2shop/includes/frame_inc.php	JROOT/templates/sj_g2shop/index.php:29
7	require JROOT/templates/sj_g2shop/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Sorguları çoğalt: #45 #46 #47

SELECT home 
  FROM kd98ar_menu 
  WHERE id=875

Açıkla

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

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117
8	YtFrameworkTemplate->isHomePage()	JROOT/templates/sj_g2shop/index.php:71
7	require JROOT/templates/sj_g2shop/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[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.13 ms Sorgu belleği: 0.013 MB belleği şu sorgudan önce: 7.523 MB Dönen satır: 1

Sorguları çoğalt: #44 #46 #47

SELECT home 
  FROM kd98ar_menu 
  WHERE id=875

Açıkla

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	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
cleaning up	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118
8	YtFrameworkTemplate->isHomePage()	JROOT/templates/sj_g2shop/index.php:71
7	require JROOT/templates/sj_g2shop/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[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.12 ms Son sorgudan sonra: 35.98 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 7.607 MB Dönen satır: 1

Sorguları çoğalt: #44 #45 #47

SELECT home 
  FROM kd98ar_menu 
  WHERE id=875

Açıkla

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	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
cleaning up	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117
10	YtFrameworkTemplate->isHomePage()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:273
9	YtFrameworkTemplate->renPositionsGroup()	JROOT/templates/sj_g2shop/includes/block-content.php:102
8	include JROOT/templates/sj_g2shop/includes/block-content.php	JROOT/templates/sj_g2shop/index.php:116
7	require JROOT/templates/sj_g2shop/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

[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.07 ms Son sorgudan sonra: 0.07 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 7.623 MB Dönen satır: 1

Sorguları çoğalt: #44 #45 #46

SELECT home 
  FROM kd98ar_menu 
  WHERE id=875

Açıkla

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

Profil

Status	Duration
starting	0.00 ms
Waiting for query cache lock	0.01 ms
init	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
cleaning up	0.00 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118
10	YtFrameworkTemplate->isHomePage()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:273
9	YtFrameworkTemplate->renPositionsGroup()	JROOT/templates/sj_g2shop/includes/block-content.php:102
8	include JROOT/templates/sj_g2shop/includes/block-content.php	JROOT/templates/sj_g2shop/index.php:116
7	require JROOT/templates/sj_g2shop/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

SELECT template

  FROM kd98ar_template_styles

  WHERE home = 1 
  AND client_id = 0

Açıkla

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

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.04 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.05 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.07 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/yt.php:263
9	plgSystemYt->nameOfSJTemplate()	JROOT/plugins/system/yt/yt.php:166
8	plgSystemYt->onBeforeRender()	Aşağıdaki satırda bulunan çağrı gibi.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1076
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:49

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

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

Seçili Tablolar:

19 × 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 kd98ar_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
4 × SELECT home 
  FROM kd98ar_menu
```

2 × SELECT `extension_id` 
  FROM `kd98ar_extensions`

2 × SELECT template 
  FROM kd98ar_template_styles as s

2 × SELECT * 
  FROM kd98ar_extensions

1 × SELECT COUNT(*) 
  FROM kd98ar_content AS a 
  LEFT JOIN kd98ar_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN kd98ar_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN kd98ar_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN kd98ar_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN kd98ar_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT template_style_id 
  FROM kd98ar_menu

1 × SELECT id 
  FROM kd98ar_template_styles

1 × SELECT template 
  FROM kd98ar_template_styles

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM kd98ar_modules AS m 
  LEFT JOIN kd98ar_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN kd98ar_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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 kd98ar_content AS a 
  LEFT JOIN kd98ar_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN kd98ar_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN kd98ar_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN kd98ar_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN kd98ar_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM kd98ar_categories AS cat JOIN kd98ar_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.rules 
  FROM kd98ar_assets AS a

1 × SELECT extension, file, type 
  FROM kd98ar_rokcommon_configs

1 × SELECT id, rules 
  FROM `kd98ar_viewlevels

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

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 kd98ar_menu AS m 
  LEFT JOIN kd98ar_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM kd98ar_assets
```

1 × SELECT element 
  FROM kd98ar_extensions

1 × SELECT `session_id` 
  FROM `kd98ar_session`

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

Diğer Tablolar:

1 × SHOW FULL COLUMNS 
  FROM `kd98ar_assets

1 × UPDATE `kd98ar_extensions` 
  SET `params` = '{\"mediaversion\":\"04defdf6393ff717bb48e88f384e0fdf\"}'

1 × SHOW FULL COLUMNS 
  FROM `kd98ar_extensions

1 × INSERT INTO `kd98ar_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('i64ct6gberah06qbfhgpb75rf2', 0, 1, '1747113832', 0, ''