**Joomla! Debug Console**

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1718034400,
                "last": 1718034400,
                "now": 1718034401
            }
        },
        "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**

**73 Queries Logged** 349.00 ms

1. **Query Time: 0.74 ms** **Query memory: 0.019 MB Memory before query: 0.913 MB** **Rows returned: 1**

   SELECT `data`
   
     FROM `yk9mw_session`
   
     WHERE `session_id` = 'r5i7gat8c24aomrh6fff8mjet7'

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	yk9mw_session	const	PRIMARY	PRIMARY	575	const	1

   **Profile**

   Status	Duration
   Starting	0.20 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.11 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.01 ms
   Updating status	0.01 ms
   Storing result in query cache	0.11 ms
   Reset for next command	0.01 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:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. **Query Time: 0.50 ms** **After last query: 0.37 ms** **Query memory: 0.008 MB Memory before query: 0.966 MB**

   DELETE 
   
     FROM `yk9mw_session`
   
     WHERE `time` < '1718032601'

   **Explain**

   **EXPLAIN not possible on query: DELETE FROM `yk9mw_session` WHERE `time` < '1718032601'**

   **Profile**

   Status	Duration
   Starting	0.16 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.05 ms
   Updating	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.11 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   **Call Stack**

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

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

   ---

3. **Query Time: 0.30 ms** **After last query: 0.50 ms** **Query memory: 0.028 MB Memory before query: 1.025 MB** **Rows returned: 51**

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

   **Explain**

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

   **Profile**

   Status	Duration
   Starting	0.12 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.15 ms
   Updating status	0.01 ms
   Reset for next command	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:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

4. **Query Time: 0.23 ms** **After last query: 0.63 ms** **Query memory: 0.015 MB Memory before query: 1.145 MB** **Rows returned: 2**

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

   **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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	5	Using where; Using index

   **Profile**

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

   **Call Stack**

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

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

   ---

5. **Query Time: 0.21 ms** **After last query: 0.14 ms** **Query memory: 0.014 MB Memory before query: 1.165 MB** **Rows returned: 6**

   SELECT id, rules
   
     FROM `yk9mw_viewlevels`

   **Explain**

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

   **Profile**

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

   **Call Stack**

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

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

   ---

6. **Query Time: 0.28 ms** **After last query: 0.12 ms** **Query memory: 0.016 MB Memory before query: 1.184 MB** **Rows returned: 132**

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

   **Profile**

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

   **Call Stack**

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

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

   ---

7. **Query Time: 0.59 ms** **After last query: 40.68 ms** **Query memory: 0.015 MB Memory before query: 1.763 MB** **Rows returned: 1**

   SELECT lft,rgt 
     FROM yk9mw_categories 
     WHERE id=1

   **Explain**

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

   **Profile**

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

   **Call Stack**

   #	**Caller**	**File and line number**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/defineconstants.php:115
   8	require_once JROOT/administrator/components/com_flexicontent/defineconstants.php	JROOT/plugins/system/flexisystem/flexisystem.php:25
   7	require_once JROOT/plugins/system/flexisystem/flexisystem.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. **Query Time: 9.15 ms** **After last query: 14.63 ms** **Query memory: 0.019 MB Memory before query: 2.247 MB** **Rows returned: 1**
   **Duplicate queries**: #9

   SELECT template
   
     FROM yk9mw_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	s	ALL	idx_home	**NO INDEX KEY COULD BE USED**	NULL	NULL	8	Using where

   **Profile**

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

   **Call Stack**

   #	**Caller**	**File and line number**
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. **Query Time: 0.24 ms** **After last query: 0.20 ms** **Query memory: 0.020 MB Memory before query: 2.266 MB** **Rows returned: 1**
   **Duplicate queries**: #8

   SELECT template
   
     FROM yk9mw_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	s	ALL	idx_home	**NO INDEX KEY COULD BE USED**	NULL	NULL	8	Using where

   **Profile**

   Status	Duration
   Starting	0.15 ms
   Waiting for query cache lock	0.01 ms
   starting	0.01 ms
   Checking query cache for query	0.01 ms
   checking privileges on cached	0.01 ms
   checking permissions	0.01 ms
   Sending cached result to clien	0.12 ms
   Updating status	0.01 ms
   Reset for next command	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/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. **Query Time: 0.88 ms** **After last query: 2.59 ms** **Query memory: 0.015 MB Memory before query: 2.477 MB** **Rows returned: 2**

    SELECT extension, file, type
    
      FROM yk9mw_rokcommon_configs
    
      ORDER BY priority

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. **Query Time: 5.07 ms** **After last query: 78.64 ms** **Query memory: 0.016 MB Memory before query: 3.398 MB** **Rows returned: 0**

    SELECT DISTINCT userid 
      FROM yk9mw_session 
      WHERE guest=0

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	yk9mw_session	index	NULL	userid	5	NULL	858	Using where

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/flexisystem/flexisystem.php:965
    10	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:119
    9	plgSystemFlexisystem->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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. **Query Time: 0.31 ms** **After last query: 0.12 ms** **Query memory: 0.016 MB Memory before query: 3.414 MB** **Rows returned: 0**

    SELECT id, checked_out, checked_out_time 
      FROM yk9mw_content 
      WHERE checked_out > 0

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	yk9mw_content	range	idx_checkout	idx_checkout	4	NULL	1	Using index condition

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:977
    10	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:119
    9	plgSystemFlexisystem->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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. **Query Time: 0.36 ms** **After last query: 0.05 ms** **Query memory: 0.016 MB Memory before query: 3.429 MB** **Rows returned: 0**

    SELECT id, checked_out, checked_out_time 
      FROM yk9mw_categories 
      WHERE checked_out > 0

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	yk9mw_categories	range	idx_checkout	idx_checkout	4	NULL	1	Using index condition

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:977
    10	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:119
    9	plgSystemFlexisystem->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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. **Query Time: 0.25 ms** **After last query: 0.06 ms** **Query memory: 0.016 MB Memory before query: 3.444 MB** **Rows returned: 0**

    SELECT id, checked_out, checked_out_time 
      FROM yk9mw_modules 
      WHERE checked_out > 0

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:977
    10	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:119
    9	plgSystemFlexisystem->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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. **Query Time: 0.26 ms** **After last query: 0.04 ms** **Query memory: 0.016 MB Memory before query: 3.459 MB** **Rows returned: 0**

    SELECT id, checked_out, checked_out_time 
      FROM yk9mw_menu 
      WHERE checked_out > 0

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/flexisystem/flexisystem.php:977
    10	plgSystemFlexisystem->checkinRecords()	JROOT/plugins/system/flexisystem/flexisystem.php:119
    9	plgSystemFlexisystem->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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. **Query Time: 2.38 ms** **After last query: 5.53 ms** **Query memory: 0.027 MB Memory before query: 3.625 MB** **Rows returned: 17**

    SHOW FULL COLUMNS 
      FROM `yk9mw_extensions`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yk9mw_extensions`**

    **Profile**

    Status	Duration
    Starting	0.34 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.85 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    checking permissions	0.11 ms
    closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.26 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.16 ms
    Updating status	0.02 ms
    Reset for next command	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/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    15	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
    14	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
    13	JTable::getInstance()	JROOT/administrator/components/com_simplerenew/library/joomla/addon.php:55
    12	SimplerenewAddon::load()	JROOT/administrator/components/com_simplerenew/include.php:31
    11	require_once JROOT/administrator/components/com_simplerenew/include.php	JROOT/plugins/system/simplerenew/simplerenew.php:112
    10	plgSystemSimplerenew->isInstalled()	JROOT/plugins/system/simplerenew/simplerenew.php:44
    9	plgSystemSimplerenew->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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. **Query Time: 1.13 ms** **After last query: 3.72 ms** **Query memory: 0.021 MB Memory before query: 3.773 MB** **Rows returned: 17**

    SELECT *
    
      FROM yk9mw_axisubs_configurations

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_axisubs/Helper/Config.php:31
    13	Flycart\Axisubs\Admin\Helper\Config->__construct()	JROOT/administrator/components/com_axisubs/Helper/Config.php:39
    12	Flycart\Axisubs\Admin\Helper\Config::getInstance()	JROOT/administrator/components/com_axisubs/Helper/Axisubs.php:30
    11	Flycart\Axisubs\Admin\Helper\Axisubs::config()	JROOT/plugins/system/axisexpirycontrol/axisexpirycontrol.php:270
    10	plgSystemAxisexpirycontrol->doIHaveToRun()	JROOT/plugins/system/axisexpirycontrol/axisexpirycontrol.php:137
    9	plgSystemAxisexpirycontrol->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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. **Query Time: 0.47 ms** **After last query: 0.19 ms** **Query memory: 0.016 MB Memory before query: 3.814 MB** **Rows returned: 1**

    SELECT `extension_id`
    
      FROM `yk9mw_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:50
    9	plgSystemRokSprocket->onAfterInitialise()	**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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. **Query Time: 0.27 ms** **After last query: 0.12 ms** **Query memory: 0.020 MB Memory before query: 3.831 MB** **Rows returned: 1**
    **Duplicate queries**: #21

    SELECT *
    
      FROM yk9mw_extensions
    
      WHERE `extension_id` = '10099'

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:55
    9	plgSystemRokSprocket->onAfterInitialise()	**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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. **Query Time: 0.20 ms** **After last query: 0.11 ms** **Query memory: 0.016 MB Memory before query: 3.845 MB** **Rows returned: 1**

    SELECT `extension_id`
    
      FROM `yk9mw_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:73
    9	plgSystemRokSprocket->onAfterInitialise()	**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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. **Query Time: 0.20 ms** **After last query: 0.09 ms** **Query memory: 0.020 MB Memory before query: 3.861 MB** **Rows returned: 1**
    **Duplicate queries**: #19

    SELECT *
    
      FROM yk9mw_extensions
    
      WHERE `extension_id` = '10099'

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:77
    9	plgSystemRokSprocket->onAfterInitialise()	**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:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. **Query Time: 47.81 ms** **After last query: 94.43 ms** **Query memory: 0.207 MB Memory before query: 4.146 MB** **Rows returned: 1194**

    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 yk9mw_menu AS m
    
      LEFT JOIN yk9mw_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	199	Using index condition; Using where; Using temporary; **Using filesort**
    1	SIMPLE	e	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	386	Using where; Using join buffer (flat, BNL join)

    **Profile**

    Status	Duration
    Starting	0.23 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Creating tmp table	0.07 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	26.42 ms
    Creating sort index	1.71 ms
    Waiting for query cache lock	0.15 ms
    Creating sort index	0.36 ms
    Waiting for query cache lock	0.02 ms
    Creating sort index	0.61 ms
    Waiting for query cache lock	0.06 ms
    Creating sort index	0.35 ms
    Waiting for query cache lock	0.02 ms
    Creating sort index	0.35 ms
    Waiting for query cache lock	0.72 ms
    Creating sort index	0.46 ms
    Waiting for query cache lock	0.05 ms
    Creating sort index	0.30 ms
    Waiting for query cache lock	0.04 ms
    Creating sort index	0.32 ms
    Waiting for query cache lock	0.05 ms
    Creating sort index	0.23 ms
    Waiting for query cache lock	0.04 ms
    Creating sort index	0.17 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.17 ms
    Waiting for query cache lock	0.02 ms
    Creating sort index	1.67 ms
    Waiting for query cache lock	0.19 ms
    Creating sort index	0.31 ms
    Waiting for query cache lock	0.37 ms
    Creating sort index	0.25 ms
    Waiting for query cache lock	0.05 ms
    Creating sort index	0.21 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.92 ms
    Waiting for query cache lock	0.08 ms
    Creating sort index	1.16 ms
    Waiting for query cache lock	0.22 ms
    Creating sort index	6.18 ms
    Removing tmp table	2.07 ms
    Creating sort index	0.10 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.19 ms
    Updating status	0.03 ms
    Reset for next command	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/menu/site.php:86
    14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. **Query Time: 1.25 ms** **After last query: 44.14 ms** **Query memory: 0.024 MB Memory before query: 6.451 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	**Same as call in the line below.**
    17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/flexisystem/flexisystem.php:156
    9	plgSystemFlexisystem->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:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. **Query Time: 2.37 ms** **After last query: 0.20 ms** **Query memory: 0.017 MB Memory before query: 6.458 MB**

    UPDATE `yk9mw_extensions`
    
      SET `params` = '{\"mediaversion\":\"83e608e111a970d10f39393c5e24b333\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **Explain**

    **EXPLAIN not possible on query: UPDATE `yk9mw_extensions` SET `params` = '{\"mediaversion\":\"83e608e111a970d10f39393c5e24b333\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

    **Profile**

    Status	Duration
    Starting	0.17 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 for update	0.03 ms
    Updating	0.60 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.01 ms
    End of update loop	0.36 ms
    Query end	0.01 ms
    Commit	0.85 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.13 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/flexisystem/flexisystem.php:156
    9	plgSystemFlexisystem->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:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. **Query Time: 1.50 ms** **After last query: 0.94 ms** **Query memory: 0.016 MB Memory before query: 6.555 MB** **Rows returned: 1**

    SELECT	attribs 
      FROM yk9mw_flexicontent_types AS ty  JOIN yk9mw_flexicontent_items_ext AS ie 
      ON ie.type_id = ty.id  
      WHERE ie.item_id = 429

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ie	const	PRIMARY,type_id	PRIMARY	4	const	1
    1	SIMPLE	ty	const	PRIMARY	PRIMARY	4	const	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/flexisystem/flexisystem.php:380
    10	plgSystemFlexisystem->redirectSiteComContent()	JROOT/plugins/system/flexisystem/flexisystem.php:216
    9	plgSystemFlexisystem->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:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. **Query Time: 0.35 ms** **After last query: 7.49 ms** **Query memory: 0.013 MB Memory before query: 6.834 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

    Status	Duration
    Starting	0.20 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.10 ms
    Updating status	0.01 ms
    Reset for next command	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/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. **Query Time: 0.94 ms** **After last query: 0.30 ms** **Query memory: 0.010 MB Memory before query: 6.854 MB** **Rows returned: 5**

    SELECT id, home, template, s.params
    
      FROM yk9mw_template_styles as s
    
      LEFT JOIN yk9mw_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	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	386	Using where; Using join buffer (flat, BNL join)

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. **Query Time: 1.85 ms** **After last query: 74.66 ms** **Query memory: 0.024 MB Memory before query: 7.535 MB** **Rows returned: 1**

    SELECT ie.type_id as id,t.name 
      FROM yk9mw_flexicontent_items_ext as ie JOIN yk9mw_flexicontent_types as t 
      ON ie.type_id=t.id 
      WHERE ie.item_id = 429

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ie	const	PRIMARY,type_id	PRIMARY	4	const	1
    1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3357
    16	ParentClassItem->getTypesselected()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:170
    15	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:129
    14	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
    13	FlexicontentModelItem->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    12	JModelLegacy::getInstance()	JROOT/libraries/legacy/controller/legacy.php:547
    11	JControllerLegacy->createModel()	JROOT/libraries/legacy/controller/legacy.php:728
    10	JControllerLegacy->getModel()	JROOT/libraries/legacy/controller/legacy.php:622
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. **Query Time: 0.94 ms** **After last query: 1.26 ms** **Query memory: 0.025 MB Memory before query: 7.603 MB** **Rows returned: 1**

    SELECT t.id, t.attribs 
      FROM yk9mw_flexicontent_types AS t JOIN yk9mw_flexicontent_items_ext AS ie 
      ON ie.type_id = t.id 
      WHERE ie.item_id = 429

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ie	const	PRIMARY,type_id	PRIMARY	4	const	1
    1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3441
    17	ParentClassItem->getTypeparams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:198
    16	ParentClassItem->getComponentTypeParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:174
    15	ParentClassItem->setId()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:129
    14	ParentClassItem->__construct()	JROOT/components/com_flexicontent/models/item.php:41
    13	FlexicontentModelItem->__construct()	JROOT/libraries/legacy/model/legacy.php:204
    12	JModelLegacy::getInstance()	JROOT/libraries/legacy/controller/legacy.php:547
    11	JControllerLegacy->createModel()	JROOT/libraries/legacy/controller/legacy.php:728
    10	JControllerLegacy->getModel()	JROOT/libraries/legacy/controller/legacy.php:622
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. **Query Time: 0.78 ms** **After last query: 1.81 ms** **Query memory: 0.020 MB Memory before query: 7.653 MB** **Rows returned: 1**

    SELECT i.id, i.version 
      FROM yk9mw_content as i JOIN yk9mw_categories AS c 
      ON i.catid=c.id 
      WHERE c.extension='com_content' 
      AND i.id=429

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	const	PRIMARY,idx_catid	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    14	JDatabaseDriver->loadAssocList()	JROOT/components/com_flexicontent/classes/flexicontent.helper.php:5312
    13	FLEXIUtilities::getCurrentVersions()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:399
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. **Query Time: 0.63 ms** **After last query: 0.10 ms** **Query memory: 0.020 MB Memory before query: 7.673 MB** **Rows returned: 1**

    SELECT item_id as id, max(version_id) as version 
      FROM yk9mw_flexicontent_versions 
      WHERE 1 
      AND item_id=429 
      GROUP BY item_id

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	yk9mw_flexicontent_versions	ref	version2item	version2item	4	const	1	Using index

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    14	JDatabaseDriver->loadAssocList()	JROOT/components/com_flexicontent/classes/flexicontent.helper.php:5271
    13	FLEXIUtilities::getLastVersions()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:400
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. **Query Time: 0.44 ms** **After last query: 0.14 ms** **Query memory: 0.026 MB Memory before query: 7.694 MB** **Rows returned: 1**

    SELECT * 
      FROM yk9mw_flexicontent_fields 
      WHERE field_type="voting"

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3274
    13	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:497
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. **Query Time: 10.64 ms** **After last query: 42.40 ms** **Query memory: 0.027 MB Memory before query: 7.802 MB** **Rows returned: 18**

    SHOW FULL COLUMNS 
      FROM `yk9mw_flexicontent_items_tmp`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yk9mw_flexicontent_items_tmp`**

    **Profile**

    Status	Duration
    Starting	0.24 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.61 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.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    checking permissions	0.10 ms
    closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.17 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.12 ms
    Updating status	0.02 ms
    Reset for next command	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/joomla/database/driver/mysqli.php:440
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:237
    15	flexicontent_items->flexicontent_items()	JROOT/libraries/joomla/table/table.php:308
    14	JTable::getInstance()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3275
    13	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:497
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. **Query Time: 1.66 ms** **After last query: 0.45 ms** **Query memory: 0.030 MB Memory before query: 7.833 MB** **Rows returned: 30**

    SHOW FULL COLUMNS 
      FROM `yk9mw_content`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yk9mw_content`**

    **Profile**

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.59 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
    Filling schema table	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    checking permissions	0.09 ms
    closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.20 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    16	JTable->__construct()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:241
    15	flexicontent_items->flexicontent_items()	JROOT/libraries/joomla/table/table.php:308
    14	JTable::getInstance()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3275
    13	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:497
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. **Query Time: 5.24 ms** **After last query: 0.37 ms** **Query memory: 0.031 MB Memory before query: 7.920 MB** **Rows returned: 1**

    SELECT * 
      FROM yk9mw_content 
      LEFT JOIN yk9mw_flexicontent_items_ext 
      ON id = item_id 
      WHERE id = '429'

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_flexicontent/tables/flexicontent_items.php:316
    14	flexicontent_items->load()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3276
    13	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:497
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. **Query Time: 0.26 ms** **After last query: 0.33 ms** **Query memory: 0.023 MB Memory before query: 7.953 MB** **Rows returned: 14**

    SELECT field_type 
      FROM yk9mw_flexicontent_fields 
      WHERE iscore=1

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1346
    15	FlexicontentFields::_getTypeToCoreFieldParams()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1264
    14	FlexicontentFields::loadFieldConfig()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3277
    13	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:497
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. **Query Time: 0.37 ms** **After last query: 0.11 ms** **Query memory: 0.023 MB Memory before query: 7.977 MB** **Rows returned: 1**

    SELECT t.attribs, t.name, t.alias 
      FROM yk9mw_flexicontent_types AS t 
      WHERE t.id = 27

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1356
    15	FlexicontentFields::_getTypeToCoreFieldParams()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1264
    14	FlexicontentFields::loadFieldConfig()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3277
    13	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:497
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. **Query Time: 0.39 ms** **After last query: 0.59 ms** **Query memory: 0.022 MB Memory before query: 8.036 MB** **Rows returned: 0**

    SELECT attribs, published 
      FROM yk9mw_flexicontent_fields 
      WHERE name='voting_accessibility-features'

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    15	JDatabaseDriver->loadObject()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1313
    14	FlexicontentFields::loadFieldConfig()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3277
    13	ParentClassItem->getVotingResolution()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:497
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. **Query Time: 1.65 ms** **After last query: 0.29 ms** **Query memory: 0.033 MB Memory before query: 8.049 MB** **Rows returned: 1**

    SELECT i.*, ie.*,mc.access as category_access, ty.access as type_access, 
      CASE WHEN ty.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_type_access, 
      CASE WHEN mc.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_mcat_access, 
      CASE WHEN  i.access IN (0,1,1,5) THEN 1 ELSE 0 END AS has_item_access,c.id AS catid, i.catid as maincatid,c.title AS category_title, c.alias AS category_alias, c.lft,c.rgt, mc.title AS maincat_title, mc.alias AS maincat_alias,ty.name AS typename, ty.alias as typealias,u.name AS author,v.rating_count as rating_count, ROUND( v.rating_sum / v.rating_count ) AS rating, ((v.rating_sum / v.rating_count)*20) as score,
      CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug,
      CASE WHEN i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-06-10 15:46:41' THEN 0 ELSE 1 END as publication_scheduled,
      CASE WHEN i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-06-10 15:46:41' THEN 0 ELSE 1 END as publication_expired
    
      FROM yk9mw_content AS i
    
      LEFT JOIN yk9mw_flexicontent_items_ext AS ie 
      ON ie.item_id = i.id
    
      LEFT JOIN yk9mw_flexicontent_types AS ty 
      ON ie.type_id = ty.id
    
      LEFT JOIN yk9mw_users AS u 
      on u.id = i.created_by
    
      LEFT JOIN yk9mw_content_rating AS v 
      ON i.id = v.content_id
    
      LEFT JOIN yk9mw_flexicontent_cats_item_relations AS rel 
      ON rel.itemid = i.id 
      AND rel.catid = i.catid
    
      LEFT JOIN yk9mw_categories AS c 
      on c.id = rel.catid
    
      LEFT JOIN yk9mw_categories AS mc 
      on mc.id = i.catid
    
      WHERE i.id = 429

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ie	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ty	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	45	Using where
    1	SIMPLE	rel	eq_ref	PRIMARY,catid,itemid	PRIMARY	8	const,const	1	Using where; Using index
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	admin_narayani.rel.catid	1	Using where
    1	SIMPLE	mc	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:576
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. **Query Time: 0.47 ms** **After last query: 0.48 ms** **Query memory: 0.019 MB Memory before query: 8.089 MB** **Rows returned: 0**

    SELECT DISTINCT tid 
      FROM yk9mw_flexicontent_tags_item_relations 
      WHERE itemid = 429

    **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.13 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	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.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.00 ms
    Storing result in query cache	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:776
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. **Query Time: 6.13 ms** **After last query: 0.06 ms** **Query memory: 0.019 MB Memory before query: 8.107 MB** **Rows returned: 1**

    SELECT DISTINCT catid 
      FROM yk9mw_flexicontent_cats_item_relations 
      WHERE itemid = 429

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	yk9mw_flexicontent_cats_item_relations	ref	itemid	itemid	4	const	1	Using where; Using temporary

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:788
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

42. **Query Time: 18.88 ms** **After last query: 0.13 ms** **Query memory: 0.019 MB Memory before query: 8.126 MB** **Rows returned: 1**

    SELECT title 
      FROM yk9mw_viewlevels 
      WHERE id = 1

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:824
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. **Query Time: 0.80 ms** **After last query: 0.15 ms** **Query memory: 0.019 MB Memory before query: 8.145 MB** **Rows returned: 1**

    SELECT access 
      FROM yk9mw_categories 
      WHERE id = 9

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:830
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

44. **Query Time: 0.93 ms** **After last query: 0.08 ms** **Query memory: 0.019 MB Memory before query: 8.163 MB** **Rows returned: 0**

    SELECT  v.rating_count as rating_count, ROUND( v.rating_sum / v.rating_count ) AS rating, ((v.rating_sum / v.rating_count)*20) as score 
      FROM yk9mw_content_rating AS v 
      WHERE v.content_id = 429

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:847
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

45. **Query Time: 2.00 ms** **After last query: 0.15 ms** **Query memory: 0.019 MB Memory before query: 8.181 MB** **Rows returned: 1**

    SELECT name, email 
      FROM yk9mw_users 
      WHERE id = 513

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:858
    12	ParentClassItem->_loadItem()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:256
    11	ParentClassItem->get()	JROOT/components/com_flexicontent/views/item/view.html.php:133
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

46. **Query Time: 0.35 ms** **After last query: 5.09 ms** **Query memory: 0.023 MB Memory before query: 8.611 MB** **Rows returned: 28**

    SELECT attribs, layout, template 
      FROM yk9mw_flexicontent_layouts_conf

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.helper.php:4847
    14	flexicontent_tmpl::getLayoutparams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:3462
    13	ParentClassItem->getLayoutparams()	JROOT/components/com_flexicontent/models/item.php:435
    12	FlexicontentModelItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:316
    11	ParentClassItem->getItem()	JROOT/components/com_flexicontent/views/item/view.html.php:150
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

47. **Query Time: 1.66 ms** **After last query: 1.13 ms** **Query memory: 0.032 MB Memory before query: 8.757 MB** **Rows returned: 8**

    SHOW FULL COLUMNS 
      FROM `yk9mw_assets`

    **Explain**

    **EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yk9mw_assets`**

    **Profile**

    Status	Duration
    Starting	0.19 ms
    checking permissions	0.03 ms
    closing tables	0.01 ms
    Opening tables	0.65 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    checking permissions	0.08 ms
    closing tables	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.22 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.13 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    19	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    18	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    17	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    14	JUser->authorise()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1249
    13	ParentClassItem->getItemAccess()	JROOT/components/com_flexicontent/models/item.php:463
    12	FlexicontentModelItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:316
    11	ParentClassItem->getItem()	JROOT/components/com_flexicontent/views/item/view.html.php:150
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. **Query Time: 1.82 ms** **After last query: 0.26 ms** **Query memory: 0.027 MB Memory before query: 8.808 MB** **Rows returned: 1**

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

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    17	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    14	JUser->authorise()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1249
    13	ParentClassItem->getItemAccess()	JROOT/components/com_flexicontent/models/item.php:463
    12	FlexicontentModelItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:316
    11	ParentClassItem->getItem()	JROOT/components/com_flexicontent/views/item/view.html.php:150
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. **Query Time: 0.26 ms** **After last query: 0.17 ms** **Query memory: 0.023 MB Memory before query: 8.829 MB** **Rows returned: 1**

    SELECT a.rules
    
      FROM yk9mw_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	10080	Using where

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    14	JUser->authorise()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1249
    13	ParentClassItem->getItemAccess()	JROOT/components/com_flexicontent/models/item.php:463
    12	FlexicontentModelItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:316
    11	ParentClassItem->getItem()	JROOT/components/com_flexicontent/views/item/view.html.php:150
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

50. **Query Time: 2.18 ms** **After last query: 0.42 ms** **Query memory: 0.246 MB Memory before query: 8.864 MB** **Rows returned: 9665**

    SELECT a.id, a.parent_id
    
      FROM yk9mw_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	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	10080	Using where

    **Profile**

    Status	Duration
    Starting	0.15 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.01 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.01 ms
    Sending cached result to clien	0.16 ms
    Updating status	0.01 ms
    Reset for next command	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/joomla/access/access.php:332
    17	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
    16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    14	JUser->authorise()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1249
    13	ParentClassItem->getItemAccess()	JROOT/components/com_flexicontent/models/item.php:463
    12	FlexicontentModelItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:316
    11	ParentClassItem->getItem()	JROOT/components/com_flexicontent/views/item/view.html.php:150
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

51. **Query Time: 119.56 ms** **After last query: 12.51 ms** **Query memory: 0.320 MB Memory before query: 9.177 MB** **Rows returned: 9665**

    SELECT a.id, a.name, a.rules
    
      FROM yk9mw_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	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	10080	Using where

    **Profile**

    Status	Duration
    Starting	0.18 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.32 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.71 ms
    Waiting for query cache lock	0.02 ms
    Sending data	0.18 ms
    Waiting for query cache lock	0.34 ms
    Sending data	0.16 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.14 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.13 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.09 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.15 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.09 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.25 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.07 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.56 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.13 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.18 ms
    Waiting for query cache lock	0.08 ms
    Sending data	0.45 ms
    Waiting for query cache lock	0.01 ms
    Sending data	68.67 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.17 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
    18	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
    17	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
    16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    14	JUser->authorise()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:1249
    13	ParentClassItem->getItemAccess()	JROOT/components/com_flexicontent/models/item.php:463
    12	FlexicontentModelItem->_loadItemParams()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:316
    11	ParentClassItem->getItem()	JROOT/components/com_flexicontent/views/item/view.html.php:150
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

52. **Query Time: 0.57 ms** **After last query: 64.02 ms** **Query memory: 0.023 MB Memory before query: 11.059 MB** **Rows returned: 1**
    **Duplicate queries**: #72

    SELECT id, title, published, access, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
      FROM yk9mw_categories 
      WHERE id IN (9) 
      AND extension="com_content"

    **Explain**

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

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.categories.php:78
    14	flexicontent_cats->getParentCats()	JROOT/components/com_flexicontent/classes/flexicontent.categories.php:124
    13	flexicontent_cats->getParentlist()	JROOT/components/com_flexicontent/models/item.php:109
    12	FlexicontentModelItem->_check_viewing_access()	JROOT/administrator/components/com_flexicontent/models/parentclassitem.php:318
    11	ParentClassItem->getItem()	JROOT/components/com_flexicontent/views/item/view.html.php:150
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

53. **Query Time: 1.46 ms** **After last query: 1.18 ms** **Query memory: 0.022 MB Memory before query: 11.140 MB** **Rows returned: 0**

    SELECT DISTINCT t.id, t.name, i.itemid, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM yk9mw_flexicontent_tags AS t JOIN yk9mw_flexicontent_tags_item_relations AS i 
      ON i.tid = t.id 
      WHERE i.itemid IN ('429') 
      AND t.published = 1 
      ORDER BY t.name

    **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.12 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.12 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.15 ms
    Reset for next command	0.02 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1019
    13	FlexicontentFields::_getTags()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:305
    12	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146
    11	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/item/view.html.php:191
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

54. **Query Time: 0.94 ms** **After last query: 0.08 ms** **Query memory: 0.022 MB Memory before query: 11.161 MB** **Rows returned: 1**

    SELECT DISTINCT c.id, c.title, rel.itemid, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
      FROM yk9mw_categories AS c JOIN yk9mw_flexicontent_cats_item_relations AS rel 
      ON rel.catid = c.id 
      WHERE rel.itemid IN ('429')

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rel	ref	PRIMARY,catid,itemid	itemid	4	const	1	Using temporary
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	admin_narayani.rel.catid	1

    **Profile**

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

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1061
    13	FlexicontentFields::_getCategories()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:306
    12	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146
    11	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/item/view.html.php:191
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

55. **Query Time: 0.51 ms** **After last query: 0.08 ms** **Query memory: 0.021 MB Memory before query: 11.183 MB** **Rows returned: 0**

    SELECT itemid, COUNT(id) AS favs 
      FROM yk9mw_flexicontent_favourites 
      WHERE itemid IN ('429') 
      GROUP BY itemid

    **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.14 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.12 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.02 ms
    Updating status	0.01 ms
    Storing result in query cache	0.03 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1089
    13	FlexicontentFields::_getFavourites()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:307
    12	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146
    11	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/item/view.html.php:191
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

56. **Query Time: 1.10 ms** **After last query: 0.07 ms** **Query memory: 0.021 MB Memory before query: 11.203 MB** **Rows returned: 0**

    SELECT itemid, COUNT(id) AS fav 
      FROM yk9mw_flexicontent_favourites 
      WHERE itemid IN ('429') 
      AND userid = '0' 
      GROUP BY itemid

    **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.11 ms
    Waiting for query cache lock	0.01 ms
    starting	0.01 ms
    Checking query cache for query	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
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.16 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.57 ms
    Updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    Updating status	0.01 ms
    Storing result in query cache	0.61 ms
    Reset for next command	0.01 ms

    **Call Stack**

    #	**Caller**	**File and line number**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:1115
    13	FlexicontentFields::_getFavoured()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:308
    12	FlexicontentFields::getItemFields()	JROOT/components/com_flexicontent/classes/flexicontent.fields.php:146
    11	FlexicontentFields::getFields()	JROOT/components/com_flexicontent/views/item/view.html.php:191
    10	FlexicontentViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_flexicontent/controller.php:1036
    8	FlexicontentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_flexicontent/flexicontent.php:199
    6	require_once JROOT/components/com_flexicontent/flexicontent.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

57. **Query Time: 1.13 ms** **After last query: 0.10 ms** **Query memory: 0.021 MB Memory before query: 11.223 MB** **Rows returned: 1**