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

24 Queries Logged 36.40 ms

1. Query Time: 0.51 ms Query memory: 0.018 MB Memory before query: 1.176 MB Rows returned: 0

   SELECT `data`
   
     FROM `site_session`
   
     WHERE `session_id` = '7op0mjg9dmv2kl55fu5bpaiad7'

   Explain

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

   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.00 ms
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.17 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

2. Query Time: 0.30 ms After last query: 2.06 ms Query memory: 0.012 MB Memory before query: 1.251 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `site_session`
   
     WHERE `session_id` = '7op0mjg9dmv2kl55fu5bpaiad7' 
     LIMIT 1

   Explain

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

   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.00 ms
   Table lock	0.00 ms
   After table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.11 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.00 ms

   Call Stack

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

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

   ---

3. Query Time: 19.18 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 1.263 MB

   INSERT INTO `site_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('7op0mjg9dmv2kl55fu5bpaiad7', 0, '1779251938')

   Explain

   EXPLAIN not possible on query: INSERT INTO `site_session` (`session_id`, `client_id`, `time`) VALUES ('7op0mjg9dmv2kl55fu5bpaiad7', 0, '1779251938')

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   After table lock	0.00 ms
   init	0.01 ms
   update	18.72 ms
   end	0.02 ms
   query end	0.22 ms
   closing tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:37

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

   ---

4. Query Time: 0.78 ms After last query: 3.60 ms Query memory: 0.025 MB Memory before query: 1.365 MB Rows returned: 36

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

   Explain

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

   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
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.34 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.01 ms

   Call Stack

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

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

   ---

5. Query Time: 0.42 ms After last query: 1.78 ms Query memory: 0.014 MB Memory before query: 1.455 MB Rows returned: 2

   SELECT b.id
   
     FROM site_usergroups AS a
   
     LEFT JOIN site_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	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
   1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where; Using join buffer (flat, BNL join)

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:852
   8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:921
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:40

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

   ---

6. Query Time: 0.42 ms After last query: 0.51 ms Query memory: 0.013 MB Memory before query: 1.478 MB Rows returned: 5

   SELECT id, rules
   
     FROM `site_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.02 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.02 ms
   After table lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing 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
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:938
   7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:40

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

   ---

7. Query Time: 0.90 ms After last query: 0.37 ms Query memory: 0.013 MB Memory before query: 1.498 MB Rows returned: 77

   SELECT folder AS type, element AS name, params
   
     FROM site_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	site_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	214	Using where; Using filesort

   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
   After 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
   Sorting result	0.28 ms
   Sending data	0.27 ms
   end	0.01 ms
   query end	0.01 ms
   closing 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
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:40

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

   ---

8. Query Time: 0.52 ms After last query: 2.97 ms Query memory: 0.016 MB Memory before query: 1.622 MB Rows returned: 2

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

   Explain

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

   Profile

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

   Call Stack

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

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

   ---

9. Query Time: 0.50 ms After last query: 0.55 ms Query memory: 0.013 MB Memory before query: 1.645 MB Rows returned: 2

   SELECT element
   
     FROM site_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	site_extensions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	214	Using where

   Profile

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

   Call Stack

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

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

   ---

10. Query Time: 0.49 ms After last query: 7.65 ms Query memory: 0.022 MB Memory before query: 1.933 MB Rows returned: 1

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

    Explain

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

    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.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	Same as call in the line below.
    15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    13	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    8	JFactory::getDocument()	JROOT/plugins/system/ytshortcodes/ytshortcodes.php:32
    7	plgSystemYtshortcodes->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

11. Query Time: 0.62 ms After last query: 0.29 ms Query memory: 0.016 MB Memory before query: 1.939 MB

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

    Explain

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

    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.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.02 ms
    Updating	0.27 ms
    end	0.01 ms
    query end	0.19 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    8	JFactory::getDocument()	JROOT/plugins/system/ytshortcodes/ytshortcodes.php:32
    7	plgSystemYtshortcodes->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

12. Query Time: 4.36 ms After last query: 6.06 ms Query memory: 0.037 MB Memory before query: 2.298 MB Rows returned: 47

    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 site_menu AS m
    
      LEFT JOIN site_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	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	87	Using where; Using temporary; Using filesort
    1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	214	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.01 ms
    Creating tmp table	0.71 ms
    Copying to tmp table	2.97 ms
    Sorting result	0.05 ms
    Sending data	0.13 ms
    end	0.01 ms
    removing tmp table	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
    16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
    15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
    12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
    11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
    9	PlgSystemLanguageFilter->onAfterInitialise()	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/cms.php:663
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

13. Query Time: 0.66 ms After last query: 16.89 ms Query memory: 0.027 MB Memory before query: 3.780 MB Rows returned: 3

    SELECT id, home, template, s.params
    
      FROM site_template_styles as s
    
      LEFT JOIN site_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	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
    1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	214	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 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.00 ms
    After table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.17 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:334
    19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:679
    18	JHtml::script()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    16	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:61
    14	JHtmlBehavior::framework()	Same as call in the line below.
    13	call_user_func_array()	JROOT/libraries/cms/html/html.php:236
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:138
    11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:76
    10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
    9	plgSystemK2->onAfterRoute()	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/cms.php:1107
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

14. Query Time: 0.80 ms After last query: 14.42 ms Query memory: 0.033 MB Memory before query: 4.358 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `site_assets`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:304
    18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:714
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:111
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:46
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

15. Query Time: 0.31 ms After last query: 0.88 ms Query memory: 0.028 MB Memory before query: 4.422 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
    18	JTable->load()	JROOT/libraries/joomla/access/access.php:715
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:111
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:46
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

16. Query Time: 0.29 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 4.444 MB Rows returned: 1

    SELECT a.rules
    
      FROM site_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	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	97	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:111
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:46
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

17. Query Time: 0.36 ms After last query: 0.65 ms Query memory: 0.027 MB Memory before query: 4.482 MB Rows returned: 36

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:412
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:111
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:46
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

18. Query Time: 0.44 ms After last query: 0.25 ms Query memory: 0.027 MB Memory before query: 4.515 MB Rows returned: 36

    SELECT a.name, a.rules
    
      FROM site_assets AS a
    
      WHERE (a.name IN ('com_mailto','com_wrapper','com_admin','com_banners','com_cache','com_categories','com_checkin','com_contact','com_cpanel','com_installer','com_languages','com_login','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_search','com_templates','com_weblinks','com_content','com_config','com_redirect','com_users','com_finder','com_joomlaupdate','com_tags','com_contenthistory','com_ajax','com_postinstall','com_k2','com_uniterevolution2','com_sigpro','com_acymailing','com_chronoforms') OR a.name = 'root.1')

    Explain

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

    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.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:439
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:111
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:439
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:46
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

19. Query Time: 1.26 ms After last query: 2.18 ms Query memory: 0.032 MB Memory before query: 4.819 MB Rows returned: 0

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM site_content AS a
    
      INNER JOIN site_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN site_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN site_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN site_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN site_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN site_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM site_categories AS cat JOIN site_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-20 04:38:58') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-20 04:38:58') 
      AND a.language in ('en-GB','*')
    
      ORDER BY c.lft,  a.featured DESC, fp.ordering,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created DESC   
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
    1	PRIMARY	fp	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	PRIMARY	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	ua	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	21	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	uam	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	21	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	v	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	<derived2>	ref	key0	key0	5	serigy_site.c.id	10	Using where
    2	DERIVED	cat	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using temporary; Using filesort
    2	DERIVED	parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.09 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.05 ms
    statistics	0.05 ms
    preparing	0.09 ms
    executing	0.01 ms
    Creating tmp table	0.35 ms
    Copying to tmp table	0.05 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.01 ms
    removing tmp table	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    15	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    14	JModelList->getItems()	JROOT/components/com_content/models/articles.php:566
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:90
    12	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:47
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

20. Query Time: 0.48 ms After last query: 0.77 ms Query memory: 0.021 MB Memory before query: 4.865 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM site_content AS a
    
      INNER JOIN site_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN site_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN site_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN site_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN site_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN site_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM site_categories AS cat JOIN site_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-20 04:38:58') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-20 04:38:58') 
      AND a.language in ('en-GB','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	PRIMARY	fp	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	PRIMARY	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	ua	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	21	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	uam	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	21	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	v	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (incremental, BNL join)
    1	PRIMARY	<derived2>	ref	key0	key0	5	serigy_site.c.id	10	Using where
    2	DERIVED	cat	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using temporary; Using filesort
    2	DERIVED	parent	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	14	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.04 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing 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:1728
    15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
    14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
    13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:235
    12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:48
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

21. Query Time: 0.30 ms After last query: 3.78 ms Query memory: 0.015 MB Memory before query: 4.894 MB Rows returned: 3

    SELECT language,id
    
      FROM `site_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	site_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	87	Using where

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 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:121
    9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:647
    8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

22. Query Time: 0.27 ms After last query: 0.69 ms Query memory: 0.016 MB Memory before query: 4.925 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `site_menu` AS `c`
    
      INNER JOIN `site_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `site_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `site_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 241

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	a2	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	87	Using where; Using join buffer (incremental, BNL join)
    1	SIMPLE	c2	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	87	Using where; Using join buffer (incremental, BNL join)

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After 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.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing 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/associations.php:101
    10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:285
    9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:663
    8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

23. Query Time: 1.99 ms After last query: 12.39 ms Query memory: 0.020 MB Memory before query: 5.090 MB Rows returned: 12

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM site_modules AS m
    
      LEFT JOIN site_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN site_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 <= '2026-05-20 04:38:58') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-20 04:38:58') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 241 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	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	70	Using where; Using temporary; Using filesort
    1	SIMPLE	mm	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	90	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	214	Using where; Using join buffer (incremental, BNL join)

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.01 ms
    Creating tmp table	0.27 ms
    Copying to tmp table	1.09 ms
    Sorting result	0.04 ms
    Sending data	0.04 ms
    end	0.01 ms
    removing tmp table	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/protostar/index.php:94
    7	require JROOT/templates/protostar/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

24. Query Time: 0.22 ms After last query: 1.30 ms Query memory: 0.015 MB Memory before query: 5.145 MB Rows returned: 1

    SELECT template
    
      FROM site_template_styles
    
      WHERE home = 1 
      AND client_id = 0

    Explain

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

    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.00 ms
    Table lock	0.00 ms
    After table lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/yt.php:237
    9	plgSystemYt->nameOfSJTemplate()	JROOT/plugins/system/yt/yt.php:141
    8	plgSystemYt->onBeforeRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1058
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:40

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

    ---

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT element 
     FROM site_extensions

2. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM site_extensions

3. 1 × SELECT a.name, a.rules 
     FROM site_assets AS a

4. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
     CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
     CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
     FROM site_content AS a 
     INNER JOIN site_content_frontpage AS fp 
     ON fp.content_id = a.id 
     LEFT JOIN site_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN site_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN site_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN site_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN site_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN (SELECT cat.id as id 
     FROM site_categories AS cat JOIN site_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

5. 1 × SELECT COUNT(*) 
     FROM site_content AS a 
     INNER JOIN site_content_frontpage AS fp 
     ON fp.content_id = a.id 
     LEFT JOIN site_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN site_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN site_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN site_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN site_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN (SELECT cat.id as id 
     FROM site_categories AS cat JOIN site_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

6. 1 × SELECT `c2`.`language`,`c2`.`id` 
     FROM `site_menu` AS `c` 
     INNER JOIN `site_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_menus.item' 
     INNER JOIN `site_associations` AS `a2` 
     ON a.key = a2.key 
     INNER JOIN `site_menu` AS `c2` 
     ON a2.id = c2.`id`

7. 1 × SELECT template 
     FROM site_template_styles

8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM site_modules AS m 
     LEFT JOIN site_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN site_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

9. 1 × SELECT a.rules 
     FROM site_assets AS a

10. 1 × SELECT language,id 
      FROM `site_menu`

11. 1 × SELECT id, home, template, s.params 
      FROM site_template_styles as s 
      LEFT JOIN site_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

12. 1 × SELECT id, rules 
      FROM `site_viewlevels

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

14. 1 × SELECT `session_id` 
      FROM `site_session`

15. 1 × SELECT folder AS type, element AS name, params 
      FROM site_extensions

16. 1 × SELECT * 
      FROM site_languages

17. 1 × SELECT `data` 
      FROM `site_session`

18. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM site_menu AS m 
      LEFT JOIN site_extensions AS e 
      ON m.component_id = e.extension_id

19. 1 × SELECT * 
      FROM site_assets

OTHER Tables:

1. 1 × SHOW FULL COLUMNS 
     FROM `site_assets

2. 1 × UPDATE `site_extensions` 
     SET `params` = '{\"mediaversion\":\"a9732442649f2d6fc43221f7d10c48d7\"}'

3. 1 × INSERT INTO `site_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('7op0mjg9dmv2kl55fu5bpaiad7', 0, '1779251938'