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

Time

Memory

43 Queries Logged 225.69 ms

1. Query Time: 0.31 ms Query memory: 0.019 MB Memory before query: 2.979 MB Rows returned: 0

   SELECT `data`
   
     FROM `n7kfz_session`
   
     WHERE `session_id` = '30c79cfb8f988d6f371b356d76ab475a'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	n7kfz_session	const	PRIMARY	PRIMARY	766	const	1

   Profile

   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	0.02 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   14	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   13	JSessionStorageDatabase->read()	Same as call in the line below.
   12	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   11	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   10	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   9	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   8	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   7	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   6	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   5	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   4	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   3	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   2	JFactory::getApplication()	JROOT/home.php:46
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.29 ms After last query: 2.07 ms Query memory: 0.009 MB Memory before query: 3.187 MB

   DELETE 
   
     FROM `n7kfz_session`
   
     WHERE `time` < '1756724119'

   Explain

   EXPLAIN not possible on query: DELETE FROM `n7kfz_session` WHERE `time` < '1756724119'

   Profile

   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	0.05 ms
   updating	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   6	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   5	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   4	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   3	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   2	JFactory::getApplication()	JROOT/home.php:46
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.26 ms After last query: 0.14 ms Query memory: 0.013 MB Memory before query: 3.200 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `n7kfz_session`
   
     WHERE `session_id` = '30c79cfb8f988d6f371b356d76ab475a' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	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
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   8	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   7	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   6	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   5	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   4	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   3	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   2	JFactory::getApplication()	JROOT/home.php:46
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 1.05 ms After last query: 0.15 ms Query memory: 0.010 MB Memory before query: 3.217 MB

   INSERT INTO `n7kfz_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('30c79cfb8f988d6f371b356d76ab475a', 0, 1, '1756725019', 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `n7kfz_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('30c79cfb8f988d6f371b356d76ab475a', 0, 1, '1756725019', 0, '')

   Profile

   Status	Duration
   starting	0.05 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
   init	0.01 ms
   update	0.05 ms
   end	0.01 ms
   query end	0.70 ms
   closing tables	0.05 ms
   Unlocking tables	0.04 ms
   freeing items	0.03 ms
   updating status	0.04 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   7	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   6	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   5	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   4	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   3	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   2	JFactory::getApplication()	JROOT/home.php:46
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 1.34 ms After last query: 2.36 ms Query memory: 0.023 MB Memory before query: 3.472 MB Rows returned: 52

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	n7kfz_extensions	ref	extension	extension	82	const	52	Using index condition

   Profile

   Status	Duration
   starting	0.10 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   After opening tables	0.03 ms
   System lock	0.04 ms
   Table lock	0.03 ms
   init	0.05 ms
   optimizing	0.04 ms
   statistics	0.10 ms
   preparing	0.05 ms
   executing	0.02 ms
   Sending data	0.51 ms
   end	0.03 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.04 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   10	JDatabaseDriver->loadObjectList()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   8	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   7	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   6	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   5	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   2	JApplicationCms->execute()	JROOT/home.php:49
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.96 ms After last query: 1.79 ms Query memory: 0.016 MB Memory before query: 3.701 MB Rows returned: 2

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

   Explain

   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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

   Profile

   Status	Duration
   starting	0.14 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   After opening tables	0.03 ms
   System lock	0.03 ms
   Table lock	0.03 ms
   init	0.05 ms
   optimizing	0.05 ms
   statistics	0.12 ms
   preparing	0.02 ms
   Unlocking tables	0.06 ms
   executing	0.02 ms
   Sending data	0.07 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.03 ms
   updating status	0.04 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   10	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   9	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   8	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   7	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   6	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   5	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   2	JApplicationCms->execute()	JROOT/home.php:49
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 0.61 ms After last query: 0.70 ms Query memory: 0.016 MB Memory before query: 3.779 MB Rows returned: 5

   SELECT id, rules
   
     FROM `n7kfz_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	n7kfz_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.05 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.03 ms
   executing	0.02 ms
   Sending data	0.07 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.04 ms
   freeing items	0.02 ms
   updating status	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   10	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   9	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   8	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   7	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   6	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   5	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   2	JApplicationCms->execute()	JROOT/home.php:49
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 2.32 ms After last query: 0.14 ms Query memory: 0.017 MB Memory before query: 3.798 MB Rows returned: 104

   SELECT folder AS type, element AS name, params
   
     FROM n7kfz_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

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

   Profile

   Status	Duration
   starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.05 ms
   optimizing	0.05 ms
   statistics	0.09 ms
   preparing	0.06 ms
   Sorting result	0.03 ms
   executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	1.57 ms
   end	0.03 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.03 ms
   updating status	0.04 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   7	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   6	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   5	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   2	JApplicationCms->execute()	JROOT/home.php:49
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.90 ms After last query: 19.27 ms Query memory: 0.014 MB Memory before query: 5.654 MB Rows returned: 1

   SELECT `enabled`
   
     FROM `n7kfz_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explain

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

   Profile

   Status	Duration
   starting	0.10 ms
   checking permissions	0.05 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   init	0.05 ms
   optimizing	0.04 ms
   statistics	0.16 ms
   preparing	0.06 ms
   executing	0.02 ms
   Sending data	0.09 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
   8	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
   7	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   6	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   2	JApplicationCms->execute()	JROOT/home.php:49
   1	include JROOT/home.php	JROOT/index.php:27

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 0.82 ms After last query: 20.01 ms Query memory: 0.018 MB Memory before query: 7.701 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.09 ms
    optimizing	0.04 ms
    statistics	0.04 ms
    preparing	0.04 ms
    Sorting result	0.03 ms
    executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.11 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    9	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:97
    8	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    7	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    6	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.81 ms After last query: 0.43 ms Query memory: 0.015 MB Memory before query: 7.738 MB Rows returned: 6

    SELECT element
    
      FROM n7kfz_extensions
    
      WHERE type = 'language' 
      AND client_id = 0 
      AND enabled = 1

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.10 ms
    preparing	0.06 ms
    executing	0.02 ms
    Sending data	0.14 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
    9	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
    8	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    7	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    6	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 0.80 ms After last query: 9.09 ms Query memory: 0.017 MB Memory before query: 8.721 MB Rows returned: 1

    SELECT params
    
      FROM n7kfz_extensions
    
      WHERE type = "plugin" 
      AND folder = "system" 
      AND element = 'jsnextfw'

    Explain

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

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.14 ms
    preparing	0.06 ms
    executing	0.02 ms
    Sending data	0.08 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnextfw/includes/helper.php:163
    11	JsnExtFwHelper::getSettings()	JROOT/plugins/system/jsnextfw/jsnextfw.php:141
    10	PlgSystemJsnExtFw->onAfterInitialise()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.83 ms After last query: 3.69 ms Query memory: 0.028 MB Memory before query: 9.167 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.05 ms
    executing	0.02 ms
    Sending data	0.09 ms
    end	0.07 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    21	JDatabaseDriver->loadObject()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    19	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    18	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    17	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    16	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    15	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    14	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    13	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
    12	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
    11	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
    10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 1.26 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 9.178 MB

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

    Explain

    EXPLAIN not possible on query: UPDATE `n7kfz_extensions` SET `params` = '{\"mediaversion\":\"d556f97935d3d58b37df88c839c4e319\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.13 ms
    updating	0.12 ms
    end	0.03 ms
    query end	0.62 ms
    closing tables	0.05 ms
    Unlocking tables	0.04 ms
    freeing items	0.03 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    17	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    16	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    15	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    14	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    13	JFactory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
    12	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
    11	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
    10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 3.58 ms After last query: 2.44 ms Query memory: 0.048 MB Memory before query: 9.488 MB Rows returned: 93

    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 n7kfz_menu AS m
    
      LEFT JOIN n7kfz_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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	109	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.m.component_id	1	Using where

    Profile

    Status	Duration
    starting	0.21 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    Table lock	0.03 ms
    init	0.09 ms
    optimizing	0.07 ms
    statistics	0.13 ms
    preparing	0.13 ms
    Sorting result	0.05 ms
    executing	0.03 ms
    Sending data	0.06 ms
    Creating sort index	2.34 ms
    end	0.04 ms
    query end	0.04 ms
    closing tables	0.03 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    22	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    21	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    20	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    19	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    18	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    17	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
    16	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    15	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    14	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    13	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    12	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    11	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 1.15 ms After last query: 3.81 ms Query memory: 0.030 MB Memory before query: 10.733 MB Rows returned: 6

    SELECT id, home, template, s.params
    
      FROM n7kfz_template_styles as s
    
      LEFT JOIN n7kfz_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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	islamctr_db1.s.template,const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.06 ms
    optimizing	0.06 ms
    statistics	0.14 ms
    preparing	0.07 ms
    executing	0.02 ms
    Sending data	0.29 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    16	JApplicationSite->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    15	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    14	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    13	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    12	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    11	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    10	plgSystemHelix->onAfterInitialise()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 0.84 ms After last query: 9.73 ms Query memory: 0.017 MB Memory before query: 11.587 MB Rows returned: 1

    SELECT timestamp
    
      FROM n7kfz_zt_visitor_counter
    
      WHERE ipaddress = '10.0.5.224' 
      AND useragent LIKE "%other%"
    
      ORDER BY timestamp DESC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	index	NULL	timestamp	4	NULL	1	Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.03 ms
    init	0.06 ms
    optimizing	0.04 ms
    statistics	0.04 ms
    preparing	0.04 ms
    Sorting result	0.03 ms
    executing	0.02 ms
    Sending data	0.12 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/plugins/system/zt_visitor_counter/helper.php:65
    11	plgZTVisitorCounterHelper::getLastVisit()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:42
    10	plgSystemZT_Visitor_Counter->onAfterInitialise()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 18.14 ms After last query: 0.12 ms Query memory: 0.015 MB Memory before query: 11.600 MB

    UPDATE n7kfz_zt_visitor_counter 
      SET visits=visits + 1, guests=guests + 1, useragent = 'other' 
      WHERE timestamp = 1756725525 
      AND `ipaddress` = '10.0.5.224';

    Explain

    EXPLAIN not possible on query: UPDATE n7kfz_zt_visitor_counter SET visits=visits + 1, guests=guests + 1, useragent = 'other' WHERE timestamp = 1756725525 AND `ipaddress` = '10.0.5.224';

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.08 ms
    updating	0.11 ms
    end	0.03 ms
    query end	17.50 ms
    closing tables	0.05 ms
    Unlocking tables	0.04 ms
    freeing items	0.03 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/plugins/system/zt_visitor_counter/helper.php:43
    11	plgZTVisitorCounterHelper::updateVisits()	JROOT/plugins/system/zt_visitor_counter/zt_visitor_counter.php:52
    10	plgSystemZT_Visitor_Counter->onAfterInitialise()	Same as call in the line below.
    9	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    8	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    7	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    6	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    5	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    4	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 4.62 ms After last query: 17.89 ms Query memory: 0.025 MB Memory before query: 13.074 MB Rows returned: 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 n7kfz_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM n7kfz_categories AS cat JOIN n7kfz_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 n7kfz_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=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

    Explain

    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; Using filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.40 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.05 ms
    Opening tables	0.09 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    Table lock	0.03 ms
    init	0.27 ms
    optimizing	0.11 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.06 ms
    Creating tmp table	0.04 ms
    Sorting result	0.05 ms
    statistics	0.34 ms
    preparing	0.03 ms
    Unlocking tables	0.10 ms
    Creating tmp table	0.11 ms
    Sorting result	0.04 ms
    executing	0.02 ms
    Sending data	0.12 ms
    executing	0.02 ms
    Sending data	0.15 ms
    Creating sort index	0.05 ms
    removing tmp table	0.03 ms
    Creating sort index	1.14 ms
    Creating sort index	0.18 ms
    removing tmp table	0.48 ms
    Creating sort index	0.05 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.02 ms
    removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.05 ms
    updating status	0.04 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    12	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    11	JCategories->get()	JROOT/components/com_content/router.php:341
    10	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
    9	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    8	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    7	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    6	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    5	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    4	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 2.21 ms After last query: 11.43 ms Query memory: 0.034 MB Memory before query: 14.432 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `n7kfz_assets`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `n7kfz_assets`

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.03 ms
    closing tables	0.02 ms
    Opening tables	0.71 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.04 ms
    executing	0.02 ms
    Filling schema table	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    checking permissions	0.08 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    closing tables	0.03 ms
    executing	0.02 ms
    Sending data	0.10 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    removing tmp table	0.43 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    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/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 0.65 ms After last query: 0.86 ms Query memory: 0.029 MB Memory before query: 14.507 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Unlocking tables	0.04 ms
    executing	0.02 ms
    Sending data	0.04 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    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/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 0.70 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 14.530 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	0.16 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    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/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 1.71 ms After last query: 0.80 ms Query memory: 0.031 MB Memory before query: 14.591 MB Rows returned: 157

    SELECT a.id, a.parent_id
    
      FROM n7kfz_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	349	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.04 ms
    optimizing	0.04 ms
    statistics	0.11 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	1.04 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
    19	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
    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/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 1.76 ms After last query: 0.85 ms Query memory: 0.032 MB Memory before query: 14.753 MB Rows returned: 157

    SELECT a.id, a.name, a.rules
    
      FROM n7kfz_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	349	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.05 ms
    executing	0.03 ms
    Sending data	1.07 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
    20	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
    19	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
    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/category.php:142
    15	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    14	JModelLegacy->getState()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 5.68 ms After last query: 1.01 ms Query memory: 0.030 MB Memory before query: 14.960 MB Rows returned: 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,COUNT(i.`id`) AS numitems
    
      FROM n7kfz_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM n7kfz_categories AS cat JOIN n7kfz_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 n7kfz_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('en-GB','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      LEFT JOIN `n7kfz_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1 
      AND (i.language = '*' OR i.language = 'en-GB')
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=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

    Explain

    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; Using filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	Using where
    1	PRIMARY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	islamctr_db1.c.id	7	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.39 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.03 ms
    init	0.29 ms
    optimizing	0.12 ms
    optimizing	0.04 ms
    statistics	0.13 ms
    preparing	0.06 ms
    Creating tmp table	0.04 ms
    Sorting result	0.04 ms
    statistics	0.38 ms
    preparing	0.03 ms
    Unlocking tables	0.14 ms
    Creating tmp table	0.12 ms
    Sorting result	0.04 ms
    executing	0.02 ms
    Sending data	0.12 ms
    executing	0.02 ms
    Sending data	0.15 ms
    Creating sort index	0.05 ms
    removing tmp table	0.03 ms
    Creating sort index	2.63 ms
    Creating sort index	0.06 ms
    removing tmp table	0.29 ms
    Creating sort index	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.03 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    15	JCategories->get()	JROOT/components/com_content/models/category.php:354
    14	ContentModelCategory->getCategory()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 0.72 ms After last query: 2.93 ms Query memory: 0.031 MB Memory before query: 15.256 MB Rows returned: 51

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

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.27 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    23	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    22	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    21	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    20	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    19	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    18	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 1.88 ms After last query: 0.25 ms Query memory: 0.032 MB Memory before query: 15.297 MB Rows returned: 51

    SELECT a.name, a.rules
    
      FROM n7kfz_assets AS a
    
      WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_akeeba','com_allvideoshare','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_countdowntimer','com_cpanel','com_finder','com_hdwmusic','com_installer','com_jaextmanager','com_jalang','com_jce','com_jevents','com_jforms','com_jimigrator','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_pagebuilder3','com_phocagallery','com_phocamaps','com_plugins','com_portfoliogallery','com_postinstall','com_redirect','com_search','com_seftranslate','com_tags','com_templates','com_uniform','com_users','com_weblinks','com_wrapper','com_youtubegallery') OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	349	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.10 ms
    optimizing	0.03 ms
    statistics	0.24 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	1.17 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    23	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    22	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    21	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    20	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    19	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    18	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
    16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 3.93 ms After last query: 2.49 ms Query memory: 0.037 MB Memory before query: 15.663 MB Rows returned: 9

    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 n7kfz_content AS a
    
      LEFT JOIN n7kfz_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN n7kfz_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN n7kfz_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN n7kfz_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN n7kfz_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM n7kfz_categories AS cat JOIN n7kfz_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,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.catid = 2 OR a.catid IN (
    SELECT sub.id
    
      FROM n7kfz_categories as sub
    
      INNER JOIN n7kfz_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 2)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-09-01 11:10:19') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-09-01 11:10:19') 
      AND a.language in ('en-GB','*')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 20, 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where; Using temporary; Using filesort
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	islamctr_db1.c.id	7	Using index condition; Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.created_by	1	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.modified_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.c.parent_id	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	Using where
    3	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    3	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	21	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.26 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.12 ms
    optimizing	0.06 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    statistics	0.10 ms
    preparing	0.05 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.10 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	0.02 ms
    removing tmp table	0.01 ms
    Creating sort index	1.16 ms
    executing	0.02 ms
    Sending data	0.53 ms
    Creating sort index	0.25 ms
    removing tmp table	0.42 ms
    Creating sort index	0.02 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    removing tmp table	0.01 ms
    freeing items	0.03 ms
    removing tmp table	0.01 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    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/components/com_content/models/category.php:253
    14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 2.23 ms After last query: 3.66 ms Query memory: 0.025 MB Memory before query: 16.108 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM n7kfz_content AS a
    
      LEFT JOIN n7kfz_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN n7kfz_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN n7kfz_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN n7kfz_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN n7kfz_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM n7kfz_categories AS cat JOIN n7kfz_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,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.catid = 2 OR a.catid IN (
    SELECT sub.id
    
      FROM n7kfz_categories as sub
    
      INNER JOIN n7kfz_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 2)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-09-01 11:10:19') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-09-01 11:10:19') 
      AND a.language in ('en-GB','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	islamctr_db1.c.id	7	Using index condition; Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	islamctr_db1.c.id	4	Using where
    3	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    3	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	21	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.08 ms
    optimizing	0.07 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    statistics	0.12 ms
    preparing	0.01 ms
    Unlocking tables	0.05 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.09 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	0.02 ms
    removing tmp table	0.01 ms
    Creating sort index	0.26 ms
    executing	0.01 ms
    Sending data	0.55 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    removing tmp table	0.01 ms
    freeing items	0.02 ms
    removing tmp table	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    18	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
    17	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
    16	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
    15	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
    14	ContentModelCategory->getItems()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 0.59 ms After last query: 2.11 ms Query memory: 0.027 MB Memory before query: 16.296 MB Rows returned: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `n7kfz_contentitem_tag_map` AS m 
    
      INNER JOIN `n7kfz_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 2 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	islamctr_db1.m.tag_id	1	Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.06 ms
    optimizing	0.04 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    13	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
    12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

31. Query Time: 2.71 ms After last query: 14.56 ms Query memory: 0.030 MB Memory before query: 17.596 MB Rows returned: 30

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM n7kfz_modules AS m
    
      LEFT JOIN n7kfz_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN n7kfz_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-09-01 11:10:19') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-09-01 11:10:19') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 150 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	49	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	islamctr_db1.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	islamctr_db1.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.09 ms
    optimizing	0.09 ms
    statistics	0.17 ms
    preparing	0.11 ms
    Sorting result	0.03 ms
    executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	1.64 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:413
    19	JModuleHelper::getModuleList()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:356
    18	JModuleHelper::load()	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:84
    17	JModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:137
    16	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
    15	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
    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/category/view.html.php:106
    11	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    9	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    7	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    6	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    5	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

32. Query Time: 0.58 ms After last query: 23.33 ms Query memory: 0.016 MB Memory before query: 18.963 MB Rows returned: 1

    SELECT language,id
    
      FROM `n7kfz_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	110	Using where

    Profile

    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	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.22 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    10	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
    9	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
    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/site.php:196
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

33. Query Time: 0.40 ms After last query: 1.54 ms Query memory: 0.020 MB Memory before query: 19.049 MB Rows returned: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `n7kfz_categories` AS `c`
    
      INNER JOIN `n7kfz_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_categories.item'
    
      INNER JOIN `n7kfz_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `n7kfz_categories` AS `c2` 
      ON a2.id = c2.`id` 
      AND c2.extension = 'com_content'
    
      WHERE c.id = 2 
      AND c.extension = 'com_content'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    14	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_categories/helpers/categories.php:102
    13	CategoriesHelper::getAssociations()	JROOT/administrator/components/com_categories/helpers/association.php:43
    12	CategoryHelperAssociation::getCategoryAssociations()	JROOT/components/com_content/helpers/association.php:58
    11	ContentHelperAssociation::getAssociations()	Same as call in the line below.
    10	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:729
    9	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
    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/site.php:196
    4	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    3	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

34. Query Time: 0.81 ms After last query: 10.93 ms Query memory: 0.019 MB Memory before query: 19.459 MB Rows returned: 1

    SELECT SUM(visits)
    
      FROM n7kfz_zt_visitor_counter
    
      WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
      AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	111	Using index condition

    Profile

    Status	Duration
    starting	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
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.07 ms
    executing	0.01 ms
    Sending data	0.26 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.04 ms
    Unlocking tables	0.04 ms
    freeing items	0.02 ms
    updating status	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:32
    12	modZTCounterHelper->getTodayVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:57
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

35. Query Time: 0.64 ms After last query: 0.10 ms Query memory: 0.019 MB Memory before query: 19.478 MB Rows returned: 1

    SELECT SUM(visits)
    
      FROM n7kfz_zt_visitor_counter
    
      WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) 
      AND UNIX_TIMESTAMP(DATE(NOW()))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	132	Using index condition

    Profile

    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	0.02 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.29 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:48
    12	modZTCounterHelper->getYesterdayVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:65
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

36. Query Time: 0.70 ms After last query: 0.15 ms Query memory: 0.019 MB Memory before query: 19.497 MB Rows returned: 1

    SELECT SUM(visits)
    
      FROM n7kfz_zt_visitor_counter
    
      WHERE timestamp BETWEEN 1756594800 
      AND 1757199600

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	210	Using index condition

    Profile

    Status	Duration
    starting	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
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.39 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:103
    12	modZTCounterHelper->getWeekVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:74
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

37. Query Time: 1.26 ms After last query: 0.14 ms Query memory: 0.019 MB Memory before query: 19.515 MB Rows returned: 1

    SELECT SUM(visits)
    
      FROM n7kfz_zt_visitor_counter
    
      WHERE timestamp BETWEEN 1755990000 
      AND 1756594800

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	518	Using index condition

    Profile

    Status	Duration
    starting	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
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.96 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:130
    12	modZTCounterHelper->getLastWeekVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:84
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

38. Query Time: 0.90 ms After last query: 0.08 ms Query memory: 0.019 MB Memory before query: 19.533 MB Rows returned: 1

    SELECT SUM(visits)
    
      FROM n7kfz_zt_visitor_counter
    
      WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), '%Y-%m-01')) 
      AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-%m-01') + INTERVAL 1 MONTH)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	111	Using index condition

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.03 ms
    Table lock	0.02 ms
    init	0.06 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.03 ms
    Sending data	0.32 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:150
    12	modZTCounterHelper->getMonthVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:94
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

39. Query Time: 9.59 ms After last query: 0.07 ms Query memory: 0.019 MB Memory before query: 19.552 MB Rows returned: 1

    SELECT SUM(visits)
    
      FROM n7kfz_zt_visitor_counter
    
      WHERE timestamp BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), '%Y-%m-01') - INTERVAL 1 MONTH) 
      AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(),'%Y-%m-01'))

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	range	timestamp	timestamp	4	NULL	3943	Using index condition

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	9.11 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:169
    12	modZTCounterHelper->getLastMonthVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:103
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

40. Query Time: 142.11 ms After last query: 0.17 ms Query memory: 0.019 MB Memory before query: 19.569 MB Rows returned: 1

    SELECT SUM(visits)
    
      FROM n7kfz_zt_visitor_counter

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_zt_visitor_counter	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	320273

    Profile

    Status	Duration
    starting	0.02 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
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	141.79 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/modules/mod_zt_visitor_counter/helper.php:187
    12	modZTCounterHelper->getTotalVisitors()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:112
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

41. Query Time: 0.44 ms After last query: 0.51 ms Query memory: 0.020 MB Memory before query: 19.590 MB Rows returned: 47

    SELECT guest, client_id
    
      FROM n7kfz_session
    
      WHERE client_id = 0 
      AND `time` BETWEEN 1756724120 
      AND 1756725020

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_session	ALL	time	NO INDEX KEY COULD BE USED	NULL	NULL	47	Using where

    Profile

    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	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_zt_visitor_counter/helper.php:309
    12	modZTCounterHelper->getOnline()	JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php:139
    11	include JROOT/modules/mod_zt_visitor_counter/mod_zt_visitor_counter.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

42. Query Time: 1.93 ms After last query: 17.48 ms Query memory: 0.055 MB Memory before query: 20.131 MB Rows returned: 12

    SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 n7kfz_content AS a
    
      LEFT JOIN n7kfz_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN n7kfz_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN n7kfz_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN n7kfz_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN n7kfz_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM n7kfz_categories AS cat JOIN n7kfz_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,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-09-01 11:10:19') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-09-01 11:10:19') 
      AND a.language in ('en-GB','*')
    
      ORDER BY a.created desc 
      LIMIT 12

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	51	Using where; Using filesort
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.created_by	1	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	islamctr_db1.a.id	1	Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	const	4	Using where
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Using filesort
    2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	23	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.28 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.14 ms
    optimizing	0.06 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    statistics	0.13 ms
    preparing	0.01 ms
    Unlocking tables	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	0.25 ms
    executing	0.01 ms
    Sending data	0.07 ms
    Creating sort index	0.02 ms
    removing tmp table	0.01 ms
    Creating sort index	0.21 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.03 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    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/modules/mod_bt_contentslider/classes/content.php:159
    13	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    12	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    11	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

43. Query Time: 0.68 ms After last query: 17.07 ms Query memory: 0.020 MB Memory before query: 20.598 MB Rows returned: 1

    SELECT module, title
    
      FROM n7kfz_modules
    
      WHERE published=1 
      AND client_id=0 
      AND id='126'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	n7kfz_modules	const	PRIMARY,published	PRIMARY	4	const	1

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    init	0.04 ms
    optimizing	0.04 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Unlocking tables	0.03 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    14	JDatabaseDriver->loadObject()	JROOT/modules/mod_popup_jt/helper.php:136
    13	modPopupJTHelper::getModuleById()	JROOT/modules/mod_popup_jt/helper.php:121
    12	modPopupJTHelper::getModulesEnable()	JROOT/modules/mod_popup_jt/mod_popup_jt.php:46
    11	include JROOT/modules/mod_popup_jt/mod_popup_jt.php	JROOT/plugins/system/helix/core/classes/joomla30/helper.php:190
    10	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    9	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    8	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    7	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    6	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    5	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    4	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    3	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    2	JApplicationCms->execute()	JROOT/home.php:49
    1	include JROOT/home.php	JROOT/index.php:27

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---