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

Süre

Bellek

65 Sorgu Kaydedildi 207.82 ms

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

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

   Açıkla

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

   Profil

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

   Yığın Çağır

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

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

   ---

2. Sorgu Süresi: 0.62 ms Son sorgudan sonra: 2.20 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 3.172 MB

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

   Açıkla

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

   Profil

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

   Yığın Çağır

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

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

   ---

3. Sorgu Süresi: 0.53 ms Son sorgudan sonra: 0.15 ms Sorgu belleği: 0.012 MB belleği şu sorgudan önce: 3.184 MB Dönen satır: 0

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

   Açıkla

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

   Profil

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

   Yığın Çağır

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

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

   ---

4. Sorgu Süresi: 0.30 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 3.199 MB

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

   Açıkla

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

   Profil

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

   Yığın Çağır

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

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

   ---

5. Sorgu Süresi: 1.28 ms Son sorgudan sonra: 5.60 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 3.642 MB Dönen satır: 37

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

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.06 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.60 ms
   Waiting for query cache lock	0.01 ms
   Sending data	0.17 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.08 ms
   Reset for next command	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()	Aşağıdaki satırda bulunan çağrı gibi.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:45

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

   ---

6. Sorgu Süresi: 1.04 ms Son sorgudan sonra: 4.93 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 3.868 MB Dönen satır: 5

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

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.28 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.03 ms
   Optimizing	0.16 ms
   Statistics	0.10 ms
   Preparing	0.01 ms
   Unlocking tables	0.00 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.06 ms
   End of update loop	0.03 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.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
   Reset for next command	0.01 ms

   Yığın Çağır

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

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

   ---

7. Sorgu Süresi: 0.45 ms Son sorgudan sonra: 0.92 ms Sorgu belleği: 0.015 MB belleği şu sorgudan önce: 3.945 MB Dönen satır: 13
   Sorguları çoğalt: #13

   SELECT id, rules
   
     FROM `k0o5r_viewlevels`

   Açıkla

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

   Profil

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

   Yığın Çağır

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

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

   ---

8. Sorgu Süresi: 1.02 ms Son sorgudan sonra: 0.70 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 3.969 MB Dönen satır: 50

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

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   starting	0.00 ms
   Checking query cache for query	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.05 ms
   Preparing	0.03 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.45 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.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
   Reset for next command	0.01 ms

   Yığın Çağır

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

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

   ---

9. Sorgu Süresi: 0.44 ms Son sorgudan sonra: 14.21 ms Sorgu belleği: 0.016 MB belleği şu sorgudan önce: 5.110 MB Dönen satır: 1

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

   Açıkla

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

   Profil

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

   Yığın Çağır

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

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

   ---

10. Sorgu Süresi: 0.51 ms Son sorgudan sonra: 0.22 ms Sorgu belleği: 0.014 MB belleği şu sorgudan önce: 5.126 MB

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

11. Sorgu Süresi: 0.46 ms Son sorgudan sonra: 0.87 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 5.197 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

12. Sorgu Süresi: 1.30 ms Son sorgudan sonra: 2.18 ms Sorgu belleği: 0.034 MB belleği şu sorgudan önce: 5.421 MB Dönen satır: 18

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM k0o5r_menu AS m
    
      LEFT JOIN k0o5r_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language,published,parent_id	idx_client_id_parent_id_alias_language	1	const	21	Using index condition; Using where; Dosya sıralama kullanılıyor
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d0194bbb.m.component_id	1	Using where

    Profil

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

    Yığın Çağır

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

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

    ---

13. Sorgu Süresi: 0.29 ms Son sorgudan sonra: 7.48 ms Sorgu belleği: 0.016 MB belleği şu sorgudan önce: 6.067 MB Dönen satır: 13
    Sorguları çoğalt: #7

    SELECT id, rules
    
      FROM `k0o5r_viewlevels`

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

14. Sorgu Süresi: 0.37 ms Son sorgudan sonra: 0.24 ms Sorgu belleği: 0.017 MB belleği şu sorgudan önce: 6.082 MB Dönen satır: 0

    Select * 
      From k0o5r_virtualdomain_params 
      Where 1

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

15. Sorgu Süresi: 0.60 ms Son sorgudan sonra: 3.13 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 6.292 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

16. Sorgu Süresi: 0.76 ms Son sorgudan sonra: 0.73 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 6.299 MB

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

17. Sorgu Süresi: 0.62 ms Son sorgudan sonra: 4.09 ms Sorgu belleği: 0.026 MB belleği şu sorgudan önce: 6.653 MB Dönen satır: 97

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

18. Sorgu Süresi: 0.82 ms Son sorgudan sonra: 1.66 ms Sorgu belleği: 0.018 MB belleği şu sorgudan önce: 6.680 MB Dönen satır: 12

    SELECT id, home, template, s.params
    
      FROM k0o5r_template_styles as s
    
      LEFT JOIN k0o5r_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	14	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	d0194bbb.s.template,const	1	Using index condition; Using where

    Profil

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

    Yığın Çağır

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

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

    ---

19. Sorgu Süresi: 0.56 ms Son sorgudan sonra: 2.47 ms Sorgu belleği: 0.013 MB belleği şu sorgudan önce: 6.758 MB Dönen satır: 1

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.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.03 ms
    Reset for next command	0.01 ms

    Yığın Çağır

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

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

    ---

20. Sorgu Süresi: 1.12 ms Son sorgudan sonra: 12.28 ms Sorgu belleği: 0.034 MB belleği şu sorgudan önce: 8.053 MB Dönen satır: 8

    SHOW FULL COLUMNS 
      FROM `k0o5r_assets`

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

21. Sorgu Süresi: 0.49 ms Son sorgudan sonra: 0.87 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.130 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

22. Sorgu Süresi: 0.58 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 8.153 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

23. Sorgu Süresi: 0.66 ms Son sorgudan sonra: 0.80 ms Sorgu belleği: 0.028 MB belleği şu sorgudan önce: 8.213 MB Dönen satır: 37

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

24. Sorgu Süresi: 0.78 ms Son sorgudan sonra: 0.26 ms Sorgu belleği: 0.028 MB belleği şu sorgudan önce: 8.248 MB Dönen satır: 37

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	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
    Waiting for query cache lock	0.02 ms
    init	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.16 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.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
    Reset for next command	0.01 ms

    Yığın Çağır

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

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

    ---

25. Sorgu Süresi: 2.49 ms Son sorgudan sonra: 3.15 ms Sorgu belleği: 0.035 MB belleği şu sorgudan önce: 8.597 MB Dönen satır: 6

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.28 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.03 ms
    Waiting for query cache lock	0.05 ms
    init	0.19 ms
    Optimizing	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Statistics	0.25 ms
    Preparing	0.04 ms
    Creating tmp table	0.03 ms
    Sorting result	0.02 ms
    Preparing	0.12 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    Creating sort index	0.53 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.20 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 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.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    Yığın Çağır

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

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

    ---

26. Sorgu Süresi: 0.70 ms Son sorgudan sonra: 2.14 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.914 MB Dönen satır: 0

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

27. Sorgu Süresi: 0.67 ms Son sorgudan sonra: 0.48 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.954 MB Dönen satır: 0

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.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
    Reset for next command	0.01 ms

    Yığın Çağır

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

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

    ---

28. Sorgu Süresi: 0.68 ms Son sorgudan sonra: 0.46 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 8.993 MB Dönen satır: 0

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.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
    Reset for next command	0.01 ms

    Yığın Çağır

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

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

    ---

29. Sorgu Süresi: 0.69 ms Son sorgudan sonra: 0.46 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.033 MB Dönen satır: 0

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

30. Sorgu Süresi: 0.69 ms Son sorgudan sonra: 0.46 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.072 MB Dönen satır: 0

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.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
    Reset for next command	0.01 ms

    Yığın Çağır

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

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

    ---

31. Sorgu Süresi: 0.70 ms Son sorgudan sonra: 0.45 ms Sorgu belleği: 0.029 MB belleği şu sorgudan önce: 9.111 MB Dönen satır: 0

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.01 ms
    Checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.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
    Reset for next command	0.01 ms

    Yığın Çağır

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

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

    ---

32. Sorgu Süresi: 1.42 ms Son sorgudan sonra: 1.30 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 9.241 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

33. Sorgu Süresi: 4.88 ms Son sorgudan sonra: 15.56 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 11.205 MB Dönen satır: 2

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

34. Sorgu Süresi: 0.31 ms Son sorgudan sonra: 2.60 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 11.456 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

35. Sorgu Süresi: 2.17 ms Son sorgudan sonra: 6.18 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 12.557 MB Dönen satır: 3

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

36. Sorgu Süresi: 0.28 ms Son sorgudan sonra: 0.68 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 12.596 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

37. Sorgu Süresi: 0.28 ms Son sorgudan sonra: 1.33 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 12.625 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

38. Sorgu Süresi: 0.28 ms Son sorgudan sonra: 1.19 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 12.653 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

39. Sorgu Süresi: 1.74 ms Son sorgudan sonra: 0.97 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 12.683 MB Dönen satır: 2

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

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

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

41. Sorgu Süresi: 0.33 ms Son sorgudan sonra: 1.20 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 12.743 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

42. Sorgu Süresi: 0.81 ms Son sorgudan sonra: 16.76 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 13.594 MB Dönen satır: 19

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

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

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    starting	0.00 ms
    Checking query cache for query	0.29 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.04 ms
    init	0.19 ms
    Optimizing	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.11 ms
    Statistics	0.19 ms
    Preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    Preparing	0.10 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.21 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.03 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.03 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/modules/mod_minifrontpage/helper.php:118
    14	modMiniFrontPageHelper::getList()	JROOT/modules/mod_minifrontpage/mod_minifrontpage.php:94
    13	include JROOT/modules/mod_minifrontpage/mod_minifrontpage.php	JROOT/libraries/cms/module/helper.php:199
    12	JModuleHelper::renderModule()	Aşağıdaki satırda bulunan çağrı gibi.
    11	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:592
    9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:399
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:45

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

    ---

44. Sorgu Süresi: 0.63 ms Son sorgudan sonra: 16.19 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 15.007 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

45. Sorgu Süresi: 1.21 ms Son sorgudan sonra: 0.36 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 15.048 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

46. Sorgu Süresi: 2.23 ms Son sorgudan sonra: 0.56 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 15.072 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

47. Sorgu Süresi: 85.96 ms Son sorgudan sonra: 0.54 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 15.096 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

48. Sorgu Süresi: 6.01 ms Son sorgudan sonra: 0.80 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 15.119 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

49. Sorgu Süresi: 8.19 ms Son sorgudan sonra: 0.60 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 15.142 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

50. Sorgu Süresi: 57.58 ms Son sorgudan sonra: 0.59 ms Sorgu belleği: 0.024 MB belleği şu sorgudan önce: 15.165 MB Dönen satır: 1

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

    Açıkla

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

    Profil

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

    Yığın Çağır

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

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

    ---

51. Sorgu Süresi: 3.53 ms Son sorgudan sonra: 12.01 ms Sorgu belleği: 0.033 MB belleği şu sorgudan önce: 15.225 MB Dönen satır: 0

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

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	PRIMARY	a	ref	idx_access,idx_c