Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1728150399,
                "last": 1728150399,
                "now": 1728150400
            },
            "client": {
                "forwarded": "18.191.93.12"
            },
            "token": "KF7dKNJBXUqmm8Er2zJcgmipLwH0V1AG"
        },
        "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
        },
        "jomsocial_userip": "18.191.93.12"
    }
}

Time

Memory

66 Queries Logged 64.84 ms

1. Query Time: 1.00 ms Query memory: 0.046 MB Memory before query: 4.355 MB Rows returned: 80

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

   Explain

   EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions` WHERE `type` = 'component'

   Profile

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.28 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
   9	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/cms/component/helper.php:447
   8	JComponentHelper::{closure}()	CopyJROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	CopyJROOT/libraries/cms/component/helper.php:455
   6	JComponentHelper::load()	CopyJROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	CopyJROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	CopyJROOT/libraries/cms/application/site.php:598
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

2. Query Time: 0.58 ms After last query: 1.26 ms Query memory: 0.021 MB Memory before query: 4.565 MB Rows returned: 7

   SELECT id, rules
   
     FROM `joom_viewlevels`

   Explain

   EXPLAIN not possible on query: SELECT id, rules FROM `joom_viewlevels`

   Profile

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.06 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1526
   9	JDatabaseDriver->loadAssocList()	CopyJROOT/libraries/joomla/access/access.php:1062
   8	JAccess::getAuthorisedViewLevels()	CopyJROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	CopyJROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	CopyJROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	CopyJROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	CopyJROOT/libraries/cms/application/site.php:608
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

3. Query Time: 0.60 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 4.578 MB Rows returned: 1

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

   Explain

   EXPLAIN not possible on query: SELECT b.id FROM joom_usergroups AS a LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1

   Profile

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1570
   10	JDatabaseDriver->loadColumn()	CopyJROOT/libraries/joomla/access/access.php:979
   9	JAccess::getGroupsByUser()	CopyJROOT/libraries/joomla/access/access.php:1094
   8	JAccess::getAuthorisedViewLevels()	CopyJROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	CopyJROOT/libraries/cms/plugin/helper.php:293
   6	JPluginHelper::load()	CopyJROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	CopyJROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	CopyJROOT/libraries/cms/application/site.php:608
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

4. Query Time: 1.85 ms After last query: 0.49 ms Query memory: 0.046 MB Memory before query: 4.640 MB Rows returned: 143

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

   Explain

   EXPLAIN not possible on query: SELECT `folder` AS `type`,`element` AS `name`,`params` FROM joom_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering

   Profile

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.03 ms
   executing	1.19 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
   9	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/cms/plugin/helper.php:311
   8	JPluginHelper::{closure}()	CopyJROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	CopyJROOT/libraries/cms/plugin/helper.php:316
   6	JPluginHelper::load()	CopyJROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	CopyJROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	CopyJROOT/libraries/cms/application/site.php:608
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

5. Query Time: 0.84 ms After last query: 19.59 ms Query memory: 0.024 MB Memory before query: 7.101 MB Rows returned: 1

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

   Explain

   EXPLAIN not possible on query: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions` WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

   Status	Duration
   starting	0.09 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.10 ms
   preparing	0.02 ms
   executing	0.05 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   17	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
   16	JDatabaseDriver->loadObject()	CopyJROOT/libraries/cms/library/helper.php:166
   15	JLibraryHelper::{closure}()	CopyJROOT/libraries/joomla/cache/controller/callback.php:169
   14	JCacheControllerCallback->get()	CopyJROOT/libraries/cms/library/helper.php:174
   13	JLibraryHelper::loadLibrary()	CopyJROOT/libraries/cms/library/helper.php:42
   12	JLibraryHelper::getLibrary()	CopyJROOT/libraries/cms/library/helper.php:89
   11	JLibraryHelper::getParams()	CopyJROOT/libraries/cms/version/version.php:270
   10	JVersion->getMediaVersion()	CopyJROOT/libraries/joomla/factory.php:777
   9	JFactory::createDocument()	CopyJROOT/libraries/joomla/factory.php:216
   8	JFactory::getDocument()	CopyJROOT/plugins/system/mootable/mootable.php:100
   7	PlgSystemMootable->__construct()	CopyJROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	CopyJROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	CopyJROOT/libraries/cms/application/cms.php:739
   4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

6. Query Time: 9.27 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 7.093 MB

   UPDATE `joom_extensions`
   
     SET `params` = '{\"mediaversion\":\"11c20fdebc8c1a25fabcda5862fb48c8\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profile

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.07 ms
   updating	0.09 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.04 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   async commit	2.16 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/cms/library/helper.php:116
   12	JLibraryHelper::saveParams()	CopyJROOT/libraries/cms/version/version.php:321
   11	JVersion->setMediaVersion()	CopyJROOT/libraries/cms/version/version.php:280
   10	JVersion->getMediaVersion()	CopyJROOT/libraries/joomla/factory.php:777
   9	JFactory::createDocument()	CopyJROOT/libraries/joomla/factory.php:216
   8	JFactory::getDocument()	CopyJROOT/plugins/system/mootable/mootable.php:100
   7	PlgSystemMootable->__construct()	CopyJROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	CopyJROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	CopyJROOT/libraries/cms/application/cms.php:739
   4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

7. Query Time: 0.80 ms After last query: 4.43 ms Query memory: 0.029 MB Memory before query: 8.033 MB Rows returned: 19

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

   Explain

   EXPLAIN not possible on query: SELECT * FROM joom_languages WHERE published=1 ORDER BY ordering ASC

   Profile

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.03 ms
   executing	0.15 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
   9	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/joomla/language/helper.php:148
   8	JLanguageHelper::getLanguages()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:99
   7	PlgSystemLanguageFilter->__construct()	CopyJROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	CopyJROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	CopyJROOT/libraries/cms/application/cms.php:739
   4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

8. Query Time: 0.60 ms After last query: 0.45 ms Query memory: 0.021 MB Memory before query: 8.103 MB Rows returned: 1

   SELECT * 
     FROM axs_domains 
     WHERE domain = 'k8s.intg.tovuti.io'

   Explain

   EXPLAIN not possible on query: SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'

   Profile

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.04 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
   9	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/language.php:183
   8	AxsLanguage::getSubdomainDefault()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:103
   7	PlgSystemLanguageFilter->__construct()	CopyJROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	CopyJROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	CopyJROOT/libraries/cms/application/cms.php:739
   4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

9. Query Time: 0.94 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 8.112 MB Rows returned: 94

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `joom_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   EXPLAIN not possible on query: SELECT `element`,`name`,`client_id`,`extension_id` FROM `joom_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1

   Profile

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.36 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
   9	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/joomla/language/helper.php:207
   8	JLanguageHelper::getInstalledLanguages()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:113
   7	PlgSystemLanguageFilter->__construct()	CopyJROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	CopyJROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	CopyJROOT/libraries/cms/application/cms.php:739
   4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
   3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

   ---

10. Query Time: 0.67 ms After last query: 1.20 ms Query memory: 0.022 MB Memory before query: 8.244 MB Rows returned: 1

    SELECT * 
      FROM `axs_brands` 
      WHERE language = 'en-GB' 
      AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM `axs_brands` WHERE language = 'en-GB' AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) LIMIT 1

    Profile

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    12	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/axslibs/brands.php:290
    11	AxsBrands::getData()	CopyJROOT/libraries/axslibs/brands.php:355
    10	AxsBrands::getBrandObject()	CopyJROOT/libraries/axslibs/brands.php:55
    9	AxsBrands::getBrand()	CopyJROOT/plugins/system/axslibs/axslibs.php:35
    8	plgSystemAxslibs->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

11. Query Time: 0.65 ms After last query: 0.05 ms Query memory: 0.030 MB Memory before query: 8.266 MB Rows returned: 19

    SELECT * 
      FROM joom_languages 
      WHERE published = 1 
      ORDER BY `title`

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_languages WHERE published = 1 ORDER BY `title`

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.15 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    13	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/axslibs/language.php:342
    12	AxsLanguage::getPublishedLanguages()	CopyJROOT/libraries/axslibs/language.php:251
    11	AxsLanguage::getCurrentLanguage()	CopyJROOT/libraries/axslibs/brands.php:371
    10	AxsBrands::getBrandObject()	CopyJROOT/libraries/axslibs/brands.php:55
    9	AxsBrands::getBrand()	CopyJROOT/plugins/system/axslibs/axslibs.php:35
    8	plgSystemAxslibs->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

12. Query Time: 0.51 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 8.291 MB Rows returned: 1

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

    Explain

    EXPLAIN not possible on query: SELECT * FROM `axs_homepage_templates` WHERE id='1'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    11	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/axslibs/brands.php:388
    10	AxsBrands::getBrandObject()	CopyJROOT/libraries/axslibs/brands.php:55
    9	AxsBrands::getBrand()	CopyJROOT/plugins/system/axslibs/axslibs.php:35
    8	plgSystemAxslibs->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

13. Query Time: 0.47 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 8.332 MB Rows returned: 1

    SELECT * 
      FROM `axs_dashboard_templates` 
      WHERE id='2'

    Explain

    EXPLAIN not possible on query: SELECT * FROM `axs_dashboard_templates` WHERE id='2'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    11	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/axslibs/brands.php:406
    10	AxsBrands::getBrandObject()	CopyJROOT/libraries/axslibs/brands.php:55
    9	AxsBrands::getBrand()	CopyJROOT/plugins/system/axslibs/axslibs.php:35
    8	plgSystemAxslibs->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

14. Query Time: 0.44 ms After last query: 0.07 ms Query memory: 0.022 MB Memory before query: 8.351 MB Rows returned: 1

    SELECT *
    
      FROM axs_email_settings
    
      WHERE id = '1'

    Explain

    EXPLAIN not possible on query: SELECT * FROM axs_email_settings WHERE id = '1'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    12	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/brands.php:632
    11	AxsBrands::getEmailSettingsById()	CopyJROOT/libraries/axslibs/brands.php:409
    10	AxsBrands::getBrandObject()	CopyJROOT/libraries/axslibs/brands.php:55
    9	AxsBrands::getBrand()	CopyJROOT/plugins/system/axslibs/axslibs.php:35
    8	plgSystemAxslibs->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

15. Query Time: 0.44 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 8.359 MB Rows returned: 1

    SELECT *
    
      FROM axs_payment_gateways
    
      WHERE id = '1'

    Explain

    EXPLAIN not possible on query: SELECT * FROM axs_payment_gateways WHERE id = '1'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    12	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/brands.php:582
    11	AxsBrands::getPaymentGatewayById()	CopyJROOT/libraries/axslibs/brands.php:412
    10	AxsBrands::getBrandObject()	CopyJROOT/libraries/axslibs/brands.php:55
    9	AxsBrands::getBrand()	CopyJROOT/plugins/system/axslibs/axslibs.php:35
    8	plgSystemAxslibs->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

16. Query Time: 0.43 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 8.370 MB Rows returned: 1

    SELECT *
    
      FROM axs_integrations
    
      WHERE id = '1'

    Explain

    EXPLAIN not possible on query: SELECT * FROM axs_integrations WHERE id = '1'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    12	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/brands.php:659
    11	AxsBrands::getIntegrationById()	CopyJROOT/libraries/axslibs/brands.php:418
    10	AxsBrands::getBrandObject()	CopyJROOT/libraries/axslibs/brands.php:55
    9	AxsBrands::getBrand()	CopyJROOT/plugins/system/axslibs/axslibs.php:35
    8	plgSystemAxslibs->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

17. Query Time: 1.70 ms After last query: 11.06 ms Query memory: 0.102 MB Memory before query: 10.083 MB Rows returned: 88

    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 joom_menu AS m
    
      LEFT JOIN joom_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

    EXPLAIN not possible on query: 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 joom_menu AS m LEFT JOIN joom_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

    Profile

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.04 ms
    executing	0.95 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    21	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/cms/menu/site.php:88
    20	JMenuSite->{closure}()	CopyJROOT/libraries/joomla/cache/controller/callback.php:169
    19	JCacheControllerCallback->get()	CopyJROOT/libraries/cms/menu/site.php:96
    18	JMenuSite->load()	CopyJROOT/libraries/cms/menu/menu.php:74
    17	JMenu->__construct()	CopyJROOT/libraries/cms/menu/site.php:57
    16	JMenuSite->__construct()	CopyJROOT/libraries/cms/menu/menu.php:129
    15	JMenu::getInstance()	CopyJROOT/libraries/cms/application/cms.php:500
    14	JApplicationCms->getMenu()	CopyJROOT/libraries/cms/application/site.php:277
    13	JApplicationSite->getMenu()	CopyJROOT/libraries/cms/router/site.php:59
    12	JRouterSite->__construct()	CopyJROOT/libraries/cms/router/router.php:198
    11	JRouter::getInstance()	CopyJROOT/libraries/cms/application/cms.php:605
    10	JApplicationCms::getRouter()	CopyJROOT/libraries/cms/application/site.php:407
    9	JApplicationSite::getRouter()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:134
    8	PlgSystemLanguageFilter->onAfterInitialise()	CopyJROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/cms.php:740
    4	JApplicationCms->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:690
    3	JApplicationSite->initialiseApp()	CopyJROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

18. Query Time: 2.00 ms After last query: 13.44 ms Query memory: 0.028 MB Memory before query: 11.606 MB Rows returned: 17

    SHOW FULL COLUMNS 
      FROM `joom_users`

    Explain

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

    Profile

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.54 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.04 ms
    Creating tmp table	0.05 ms
    executing	0.10 ms
    checking permissions	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    19	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/joomla/database/driver/mysqli.php:421
    18	JDatabaseDriverMysqli->getTableColumns()	CopyJROOT/libraries/joomla/table/table.php:244
    17	JTable->getFields()	CopyJROOT/libraries/joomla/table/table.php:163
    16	JTable->__construct()	CopyJROOT/libraries/joomla/table/user.php:39
    15	JTableUser->__construct()	CopyJROOT/libraries/joomla/table/table.php:311
    14	JTable::getInstance()	CopyJROOT/libraries/joomla/user/user.php:598
    13	JUser::getTable()	CopyJROOT/libraries/joomla/user/user.php:782
    12	JUser->save()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:848
    11	PlgSystemLanguageFilter->setPreferredLanguage()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:512
    10	PlgSystemLanguageFilter->parseRule()	CopyJROOT/libraries/cms/router/router.php:597
    9	JRouter->processParseRules()	CopyJROOT/libraries/cms/router/site.php:584
    8	JRouterSite->processParseRules()	CopyJROOT/libraries/cms/router/router.php:571
    7	JRouter->_processParseRules()	CopyJROOT/libraries/cms/router/router.php:225
    6	JRouter->parse()	CopyJROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	CopyJROOT/libraries/cms/application/cms.php:1220
    4	JApplicationCms->route()	CopyJROOT/libraries/cms/application/site.php:800
    3	JApplicationSite->route()	CopyJROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

19. Query Time: 0.52 ms After last query: 0.40 ms Query memory: 0.022 MB Memory before query: 11.650 MB Rows returned: 1

    SELECT `id`,`title`
    
      FROM `joom_usergroups`
    
      WHERE `id` = 1

    Explain

    EXPLAIN not possible on query: SELECT `id`,`title` FROM `joom_usergroups` WHERE `id` = 1

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1526
    14	JDatabaseDriver->loadAssocList()	CopyJROOT/libraries/joomla/table/user.php:152
    13	JTableUser->bind()	CopyJROOT/libraries/joomla/user/user.php:784
    12	JUser->save()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:848
    11	PlgSystemLanguageFilter->setPreferredLanguage()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:512
    10	PlgSystemLanguageFilter->parseRule()	CopyJROOT/libraries/cms/router/router.php:597
    9	JRouter->processParseRules()	CopyJROOT/libraries/cms/router/site.php:584
    8	JRouterSite->processParseRules()	CopyJROOT/libraries/cms/router/router.php:571
    7	JRouter->_processParseRules()	CopyJROOT/libraries/cms/router/router.php:225
    6	JRouter->parse()	CopyJROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	CopyJROOT/libraries/cms/application/cms.php:1220
    4	JApplicationCms->route()	CopyJROOT/libraries/cms/application/site.php:800
    3	JApplicationSite->route()	CopyJROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

20. Query Time: 0.63 ms After last query: 9.19 ms Query memory: 0.019 MB Memory before query: 12.256 MB Rows returned: 0

    SELECT params
    
      FROM axs_user_settings
    
      WHERE id = 1

    Explain

    EXPLAIN not possible on query: SELECT params FROM axs_user_settings WHERE id = 1

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    6	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/user.php:673
    5	AxsUser::getGlobalUserSettings()	CopyJROOT/libraries/axslibs/security.php:35
    4	AxsSecurity::getSettings()	CopyJROOT/libraries/cms/application/cms.php:377
    3	JApplicationCms->checkUserRequireTwoFactor()	CopyJROOT/libraries/cms/application/site.php:231
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

21. Query Time: 0.68 ms After last query: 2.94 ms Query memory: 0.019 MB Memory before query: 12.646 MB Rows returned: 0

    SELECT *
    
      FROM `joom_users`
    
      WHERE `id` = 5

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_users` WHERE `id` = 5

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    5	JDatabaseDriver->loadObject()	CopyJROOT/administrator/components/com_users/models/user.php:992
    4	UsersModelUser->getOtpConfig()	CopyJROOT/libraries/cms/application/cms.php:381
    3	JApplicationCms->checkUserRequireTwoFactor()	CopyJROOT/libraries/cms/application/site.php:231
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

22. Query Time: 0.87 ms After last query: 0.17 ms Query memory: 0.019 MB Memory before query: 12.657 MB Rows returned: 6

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

    EXPLAIN not possible on query: SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_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

    Profile

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.04 ms
    executing	0.14 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    5	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/cms/application/site.php:490
    4	JApplicationSite->getTemplate()	CopyJROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

23. Query Time: 9.23 ms After last query: 21.04 ms Query memory: 0.064 MB Memory before query: 15.540 MB Rows returned: 713

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.40 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.22 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 ms
    freeing items	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1570
    18	JDatabaseDriver->loadColumn()	CopyJROOT/libraries/joomla/database/driver/mysqli.php:477
    17	JDatabaseDriverMysqli->getTableList()	CopyJROOT/libraries/fof/database/driver/joomla.php:251
    16	FOFDatabaseDriverJoomla->getTableList()	CopyJROOT/libraries/fof/table/table.php:2087
    15	FOFTable->getTableFields()	CopyJROOT/libraries/fof/table/table.php:536
    14	FOFTable->__construct()	CopyJROOT/libraries/fof/table/table.php:433
    13	FOFTable::getAnInstance()	CopyJROOT/libraries/fof/model/model.php:2098
    12	FOFModel->_createTable()	CopyJROOT/libraries/fof/model/model.php:2055
    11	FOFModel->getTable()	CopyJROOT/libraries/fof/model/model.php:1173
    10	FOFModel->getItem()	CopyJROOT/libraries/fof/controller/controller.php:1198
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

24. Query Time: 2.02 ms After last query: 0.29 ms Query memory: 0.029 MB Memory before query: 15.620 MB Rows returned: 27

    SHOW FULL COLUMNS 
      FROM `joom_splms_lessons`

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.47 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    executing	0.08 ms
    checking permissions	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    18	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/joomla/database/driver/mysqli.php:421
    17	JDatabaseDriverMysqli->getTableColumns()	CopyJROOT/libraries/fof/database/driver/joomla.php:229
    16	FOFDatabaseDriverJoomla->getTableColumns()	CopyJROOT/libraries/fof/table/table.php:2172
    15	FOFTable->getTableFields()	CopyJROOT/libraries/fof/table/table.php:536
    14	FOFTable->__construct()	CopyJROOT/libraries/fof/table/table.php:433
    13	FOFTable::getAnInstance()	CopyJROOT/libraries/fof/model/model.php:2098
    12	FOFModel->_createTable()	CopyJROOT/libraries/fof/model/model.php:2055
    11	FOFModel->getTable()	CopyJROOT/libraries/fof/model/model.php:1173
    10	FOFModel->getItem()	CopyJROOT/libraries/fof/controller/controller.php:1198
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

25. Query Time: 0.68 ms After last query: 1.36 ms Query memory: 0.023 MB Memory before query: 16.331 MB Rows returned: 1

    SELECT joom_splms_lessons.*
    
      FROM joom_splms_lessons
    
      WHERE `joom_splms_lessons`.`splms_lesson_id` = '5'

    Explain

    EXPLAIN not possible on query: SELECT joom_splms_lessons.* FROM joom_splms_lessons WHERE `joom_splms_lessons`.`splms_lesson_id` = '5'

    Profile

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1485
    13	JDatabaseDriver->loadAssoc()	CopyJROOT/libraries/fof/database/driver/joomla.php:291
    12	FOFDatabaseDriverJoomla->loadAssoc()	CopyJROOT/libraries/fof/table/table.php:949
    11	FOFTable->load()	CopyJROOT/libraries/fof/model/model.php:1174
    10	FOFModel->getItem()	CopyJROOT/libraries/fof/controller/controller.php:1198
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

26. Query Time: 1.37 ms After last query: 3.55 ms Query memory: 0.032 MB Memory before query: 16.509 MB Rows returned: 63

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `joom_assets`
    
      WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

    Explain

    EXPLAIN not possible on query: SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets` WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

    Profile

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.23 ms
    preparing	0.03 ms
    executing	0.46 ms
    end	0.02 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    22	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/joomla/access/access.php:427
    21	JAccess::preloadComponents()	CopyJROOT/libraries/joomla/access/access.php:211
    20	JAccess::preload()	CopyJROOT/libraries/joomla/access/access.php:530
    19	JAccess::getAssetRules()	CopyJROOT/libraries/joomla/access/access.php:181
    18	JAccess::check()	CopyJROOT/libraries/joomla/user/user.php:393
    17	JUser->authorise()	CopyJROOT/libraries/fof/integration/joomla/platform.php:584
    16	FOFIntegrationJoomlaPlatform->authorise()	CopyJROOT/libraries/fof/view/raw.php:80
    15	FOFViewRaw->__construct()	CopyJROOT/libraries/fof/view/html.php:53
    14	FOFViewHtml->__construct()	CopyJROOT/libraries/fof/controller/controller.php:2811
    13	FOFController->createView()	CopyJROOT/libraries/fof/controller/controller.php:2506
    12	FOFController->getView()	CopyJROOT/libraries/fof/controller/controller.php:2408
    11	FOFController->getThisView()	CopyJROOT/libraries/fof/controller/controller.php:1028
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

27. Query Time: 0.65 ms After last query: 8.82 ms Query memory: 0.024 MB Memory before query: 17.536 MB Rows returned: 1

    SELECT *
    
      FROM axs_lms_settings
    
      WHERE id=1 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM axs_lms_settings WHERE id=1 LIMIT 1

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    16	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/lms.php:1789
    15	AxsLMS::getSettings()	CopyJROOT/components/com_splms/models/courses.php:35
    14	SplmsModelCourses->__construct()	CopyJROOT/libraries/fof/model/model.php:347
    13	FOFModel::getAnInstance()	CopyJROOT/libraries/fof/model/model.php:457
    12	FOFModel::getTmpInstance()	CopyJROOT/components/com_splms/views/lesson/view.html.php:20
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

28. Query Time: 0.58 ms After last query: 1.04 ms Query memory: 0.023 MB Memory before query: 17.657 MB Rows returned: 0

    SELECT *
    
      FROM `joom_splms_teachers`
    
      WHERE `enabled`='1' 
      AND `splms_teacher_id`='0'
    
      ORDER BY ordering DESC

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_teachers` WHERE `enabled`='1' AND `splms_teacher_id`='0' ORDER BY ordering DESC

    Profile

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    13	JDatabaseDriver->loadObject()	CopyJROOT/components/com_splms/models/teachers.php:42
    12	SplmsModelTeachers::getTeacher()	CopyJROOT/components/com_splms/views/lesson/view.html.php:32
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

29. Query Time: 0.63 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 17.691 MB Rows returned: 1

    SELECT *
    
      FROM `joom_splms_courses`
    
      WHERE `enabled`='1' 
      AND `splms_course_id`='8' 
      AND (  ( access_type = 'access' 
      AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
      AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
      AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' OR access_type IS NULL ) )
    
      ORDER BY ordering ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_courses` WHERE `enabled`='1' AND `splms_course_id`='8' AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) ORDER BY ordering ASC

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    13	JDatabaseDriver->loadObject()	CopyJROOT/components/com_splms/models/courses.php:710
    12	SplmsModelCourses::getCourse()	CopyJROOT/components/com_splms/views/lesson/view.html.php:33
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

30. Query Time: 0.82 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 17.717 MB Rows returned: 2

    SELECT `id`
    
      FROM `joom_menu`
    
      WHERE `link` LIKE '%option=com_splms&view=courses%' 
      AND `published` = '1'

    Explain

    EXPLAIN not possible on query: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_splms&view=courses%' AND `published` = '1'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.35 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1760
    14	JDatabaseDriver->loadResult()	CopyJROOT/components/com_splms/helpers/helper.php:26
    13	SplmsHelper::getItemid()	CopyJROOT/components/com_splms/models/courses.php:712
    12	SplmsModelCourses::getCourse()	CopyJROOT/components/com_splms/views/lesson/view.html.php:33
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

31. Query Time: 0.45 ms After last query: 0.12 ms Query memory: 0.023 MB Memory before query: 17.722 MB Rows returned: 1

    SELECT sef 
      FROM joom_languages 
      WHERE lang_code = 'en-GB' 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT sef FROM joom_languages WHERE lang_code = 'en-GB' LIMIT 1

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    14	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/language.php:285
    13	AxsLanguage::getSefByLangCode()	CopyJROOT/components/com_splms/models/courses.php:1345
    12	SplmsModelCourses::setOverrides()	CopyJROOT/components/com_splms/views/lesson/view.html.php:34
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

32. Query Time: 0.47 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 17.731 MB Rows returned: 0

    SELECT *
    
      FROM `joom_splms_accuratethoughts`
    
      WHERE `course_id`='8' 
      AND `user_id`='0'

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_accuratethoughts` WHERE `course_id`='8' AND `user_id`='0'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    13	JDatabaseDriver->loadObjectList()	CopyJROOT/components/com_splms/models/accuratethoughts.php:29
    12	SplmsModelAccuratethoughts::getAccurateThoughts()	CopyJROOT/components/com_splms/views/lesson/view.html.php:38
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

33. Query Time: 0.51 ms After last query: 11.77 ms Query memory: 0.026 MB Memory before query: 18.894 MB Rows returned: 1

    SELECT id, rules
    
      FROM `joom_viewlevels`
    
      WHERE id = 1

    Explain

    EXPLAIN not possible on query: SELECT id, rules FROM `joom_viewlevels` WHERE id = 1

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/contentAccess.php:172
    17	AxsContentAccess::getGroupsByViewLevels()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:43
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

34. Query Time: 0.48 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 18.903 MB Rows returned: 1

    SELECT * 
      FROM joom_splms_lessons 
      WHERE splms_lesson_id = '5'

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_lessons WHERE splms_lesson_id = '5'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/components/com_splms/models/lessons.php:270
    17	SplmsModelLessons->getNextAndPrevious()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:58
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

35. Query Time: 0.68 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 18.918 MB Rows returned: 1
    Duplicate queries: #37

    SELECT *
    
      FROM joom_splms_lessons
    
      WHERE splms_course_id = 8 
      AND enabled = 1 
      AND language = 'en-GB' 
      AND is_final_survey = 0
    
      ORDER BY ordering ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_lessons WHERE splms_course_id = 8 AND enabled = 1 AND language = 'en-GB' AND is_final_survey = 0 ORDER BY ordering ASC

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.14 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    20	JDatabaseDriver->loadObjectList()	CopyJROOT/components/com_splms/models/lessons.php:315
    19	SplmsModelLessons->getLesson()	CopyJROOT/components/com_splms/models/lessons.php:288
    18	SplmsModelLessons->getNext()	CopyJROOT/components/com_splms/models/lessons.php:274
    17	SplmsModelLessons->getNextAndPrevious()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:58
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

36. Query Time: 0.57 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 18.931 MB Rows returned: 0
    Duplicate queries: #38

    SELECT *
    
      FROM joom_splms_lessons
    
      WHERE splms_course_id = 8 
      AND enabled = 1 
      AND language = 'en-GB' 
      AND is_final_survey = 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_lessons WHERE splms_course_id = 8 AND enabled = 1 AND language = 'en-GB' AND is_final_survey = 1

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    20	JDatabaseDriver->loadObject()	CopyJROOT/components/com_splms/models/lessons.php:325
    19	SplmsModelLessons->getLesson()	CopyJROOT/components/com_splms/models/lessons.php:288
    18	SplmsModelLessons->getNext()	CopyJROOT/components/com_splms/models/lessons.php:274
    17	SplmsModelLessons->getNextAndPrevious()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:58
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

37. Query Time: 0.61 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 18.938 MB Rows returned: 1
    Duplicate queries: #35

    SELECT *
    
      FROM joom_splms_lessons
    
      WHERE splms_course_id = 8 
      AND enabled = 1 
      AND language = 'en-GB' 
      AND is_final_survey = 0
    
      ORDER BY ordering ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_lessons WHERE splms_course_id = 8 AND enabled = 1 AND language = 'en-GB' AND is_final_survey = 0 ORDER BY ordering ASC

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.10 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    20	JDatabaseDriver->loadObjectList()	CopyJROOT/components/com_splms/models/lessons.php:315
    19	SplmsModelLessons->getLesson()	CopyJROOT/components/com_splms/models/lessons.php:292
    18	SplmsModelLessons->getPrevious()	CopyJROOT/components/com_splms/models/lessons.php:277
    17	SplmsModelLessons->getNextAndPrevious()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:58
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

38. Query Time: 0.57 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 18.951 MB Rows returned: 0
    Duplicate queries: #36

    SELECT *
    
      FROM joom_splms_lessons
    
      WHERE splms_course_id = 8 
      AND enabled = 1 
      AND language = 'en-GB' 
      AND is_final_survey = 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_lessons WHERE splms_course_id = 8 AND enabled = 1 AND language = 'en-GB' AND is_final_survey = 1

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.09 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    20	JDatabaseDriver->loadObject()	CopyJROOT/components/com_splms/models/lessons.php:325
    19	SplmsModelLessons->getLesson()	CopyJROOT/components/com_splms/models/lessons.php:292
    18	SplmsModelLessons->getPrevious()	CopyJROOT/components/com_splms/models/lessons.php:277
    17	SplmsModelLessons->getNextAndPrevious()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:58
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

39. Query Time: 0.72 ms After last query: 5.95 ms Query memory: 0.026 MB Memory before query: 19.859 MB Rows returned: 0

    SELECT event_id
    
      FROM joom_splms_courses_events ce
    
      LEFT JOIN joom_eb_events e 
      ON e.id = ce.event_id
    
      WHERE ce.course_id = 8 
      AND e.published = 1
    
      ORDER BY event_date ASC

    Explain

    EXPLAIN not possible on query: SELECT event_id FROM joom_splms_courses_events ce LEFT JOIN joom_eb_events e ON e.id = ce.event_id WHERE ce.course_id = 8 AND e.published = 1 ORDER BY event_date ASC

    Profile

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1570
    20	JDatabaseDriver->loadColumn()	CopyJROOT/libraries/axslibs/events.php:227
    19	AxsEvents::getCourseEvents()	CopyJROOT/components/com_splms/models/lessons.php:295
    18	SplmsModelLessons->getPrevious()	CopyJROOT/components/com_splms/models/lessons.php:277
    17	SplmsModelLessons->getNextAndPrevious()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:58
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

40. Query Time: 1.79 ms After last query: 0.68 ms Query memory: 0.030 MB Memory before query: 19.953 MB Rows returned: 21

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM joom_modules AS m
    
      LEFT JOIN joom_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN joom_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-05 17:46:40') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-05 17:46:40') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 864 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joom_modules AS m LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-05 17:46:40') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-05 17:46:40') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 864 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') ORDER BY m.position, m.ordering

    Profile

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    executing	1.05 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    22	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/joomla/cache/controller/callback.php:169
    21	JCacheControllerCallback->get()	CopyJROOT/libraries/cms/module/helper.php:424
    20	JModuleHelper::getModuleList()	CopyJROOT/libraries/cms/module/helper.php:360
    19	JModuleHelper::load()	CopyJROOT/libraries/cms/module/helper.php:34
    18	JModuleHelper::getModule()	CopyJROOT/components/shared/controllers/comments.php:6
    17	require_once CopyJROOT/components/shared/controllers/comments.php	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:103
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

41. Query Time: 0.66 ms After last query: 1.19 ms Query memory: 0.025 MB Memory before query: 20.109 MB Rows returned: 0

    SELECT *
    
      FROM `axs_course_purchases`
    
      WHERE `user_id`=0 
      AND `course_id`=8 
      AND (status = 'PAID' OR status = 'PART' OR (status = 'REF' 
      AND access_retained = 1))

    Explain

    EXPLAIN not possible on query: SELECT * FROM `axs_course_purchases` WHERE `user_id`=0 AND `course_id`=8 AND (status = 'PAID' OR status = 'PART' OR (status = 'REF' AND access_retained = 1))

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/payment.php:285
    17	AxsPayment::hasUserPurchasedCourse()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:136
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

42. Query Time: 0.48 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 20.118 MB Rows returned: 0

    SELECT `id`
    
      FROM `axs_pay_subscriptions`
    
      WHERE `user_id`=0

    Explain

    EXPLAIN not possible on query: SELECT `id` FROM `axs_pay_subscriptions` WHERE `user_id`=0

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    18	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/axslibs/payment.php:475
    17	AxsPayment::getUserSubscriptions()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:137
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

43. Query Time: 0.60 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 20.129 MB Rows returned: 1

    SELECT *
    
      FROM `joom_splms_courses`
    
      WHERE `enabled`=1 
      AND `splms_course_id`=8 
      AND (  ( access_type = 'access' 
      AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
      AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
      AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' OR access_type IS NULL ) )
    
      ORDER BY ordering ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_courses` WHERE `enabled`=1 AND `splms_course_id`=8 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) ORDER BY ordering ASC

    Profile

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/contentAccess.php:119
    17	AxsContentAccess::checkVisibilityAccess()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:140
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

44. Query Time: 0.53 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 20.139 MB Rows returned: 1

    SELECT *
    
      FROM `joom_splms_coursescategories`
    
      WHERE `enabled`=1 
      AND `splms_coursescategory_id`=1 
      AND (  ( access_type = 'access' 
      AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
      AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
      AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' OR access_type IS NULL ) )
    
      ORDER BY ordering ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_coursescategories` WHERE `enabled`=1 AND `splms_coursescategory_id`=1 AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' OR access_type IS NULL ) ) ORDER BY ordering ASC

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/contentAccess.php:74
    17	AxsContentAccess::checkCategoryAccess()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:144
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

45. Query Time: 0.58 ms After last query: 1.49 ms Query memory: 0.025 MB Memory before query: 20.148 MB Rows returned: 0

    SELECT *
    
      FROM joom_splms_lesson_status
    
      WHERE course_id  = 8 
      AND lesson_id  = 5 
      AND user_id    = 0 
      AND language   = 'en-GB' 
      AND status     = 'completed' 
      AND archive_date IS NULL 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_lesson_status WHERE course_id = 8 AND lesson_id = 5 AND user_id = 0 AND language = 'en-GB' AND status = 'completed' AND archive_date IS NULL LIMIT 1

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/lms.php:584
    17	AxsLMS::checkLessonCompletion()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:173
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

46. Query Time: 0.63 ms After last query: 0.67 ms Query memory: 0.025 MB Memory before query: 20.233 MB Rows returned: 0
    Duplicate queries: #47

    SELECT *
    
      FROM `joom_splms_lesson_status` AS s
    
      INNER JOIN `joom_splms_lessons`AS l 
      ON l.splms_lesson_id = s.lesson_id 
    
      WHERE `course_id`=8 
      AND `lesson_id`=5 
      AND s.archive_date IS NULL 
      AND `s`.`user_id`=0 
      AND `s`.`language`='en-GB'
    
      GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id`
    
      ORDER BY `l`.`ordering`ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_lesson_status` AS s INNER JOIN `joom_splms_lessons`AS l ON l.splms_lesson_id = s.lesson_id WHERE `course_id`=8 AND `lesson_id`=5 AND s.archive_date IS NULL AND `s`.`user_id`=0 AND `s`.`language`='en-GB' GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id` ORDER BY `l`.`ordering`ASC

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    18	JDatabaseDriver->loadObjectList()	CopyJROOT/components/com_splms/models/courses.php:1149
    17	SplmsModelCourses->getProgress()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:181
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

47. Query Time: 0.57 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 20.243 MB Rows returned: 0
    Duplicate queries: #46

    SELECT *
    
      FROM `joom_splms_lesson_status` AS s
    
      INNER JOIN `joom_splms_lessons`AS l 
      ON l.splms_lesson_id = s.lesson_id 
    
      WHERE `course_id`=8 
      AND `lesson_id`=5 
      AND s.archive_date IS NULL 
      AND `s`.`user_id`=0 
      AND `s`.`language`='en-GB'
    
      GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id`
    
      ORDER BY `l`.`ordering`ASC

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_lesson_status` AS s INNER JOIN `joom_splms_lessons`AS l ON l.splms_lesson_id = s.lesson_id WHERE `course_id`=8 AND `lesson_id`=5 AND s.archive_date IS NULL AND `s`.`user_id`=0 AND `s`.`language`='en-GB' GROUP BY `s`.`user_id`,`s`.`course_id`,`s`.`lesson_id` ORDER BY `l`.`ordering`ASC

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    18	JDatabaseDriver->loadObjectList()	CopyJROOT/components/com_splms/models/courses.php:1149
    17	SplmsModelCourses->getProgress()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:208
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

48. Query Time: 0.47 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 20.248 MB Rows returned: 1

    SELECT params, slug 
      FROM joom_splms_courses 
      WHERE `splms_course_id` = 8

    Explain

    EXPLAIN not possible on query: SELECT params, slug FROM joom_splms_courses WHERE `splms_course_id` = 8

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/components/com_splms/models/courses.php:1309
    17	SplmsModelCourses::minimumStudentsMet()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:216
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

49. Query Time: 0.51 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 20.260 MB Rows returned: 0

    SELECT *
    
      FROM `joom_splms_quizquestions`
    
      WHERE `splms_lesson_id` = '5' 
      AND `splms_course_id` = '8' 
      AND `enabled` = 1
    
      ORDER BY ordering ASC 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM `joom_splms_quizquestions` WHERE `splms_lesson_id` = '5' AND `splms_course_id` = '8' AND `enabled` = 1 ORDER BY ordering ASC LIMIT 1

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    18	JDatabaseDriver->loadObject()	CopyJROOT/components/com_splms/models/quizquestions.php:104
    17	SplmsModelQuizquestions::getQuizByLesson()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:222
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

50. Query Time: 0.47 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 20.276 MB Rows returned: 1

    SELECT *
    
      FROM `ratings_post`
    
      WHERE `rating_id`='lesson_5'

    Explain

    EXPLAIN not possible on query: SELECT * FROM `ratings_post` WHERE `rating_id`='lesson_5'

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    18	JDatabaseDriver->loadObjectList()	CopyJROOT/components/shared/controllers/rating.php:29
    17	display_ratings()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:589
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

51. Query Time: 0.51 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 20.294 MB Rows returned: 1

    SELECT *
    
      FROM ic_h5p_contents
    
      WHERE id = '14' 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM ic_h5p_contents WHERE id = '14' LIMIT 1

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    19	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/lms.php:644
    18	AxsLMS::getInteractiveContentById()	CopyJROOT/components/com_splms/models/lessons.php:58
    17	SplmsModelLessons->getActivity()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:709
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

52. Query Time: 0.60 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 20.310 MB Rows returned: 0

    SELECT *
    
      FROM joom_splms_student_activities
    
      WHERE `course_id`=8 
      AND `lesson_id`=5 
      AND `user_id`=0 
      AND `activity_id` = '1644448051AiALaO'  
      AND archive_date IS NULL
    
      ORDER BY completed DESC 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_student_activities WHERE `course_id`=8 AND `lesson_id`=5 AND `user_id`=0 AND `activity_id` = '1644448051AiALaO' AND archive_date IS NULL ORDER BY completed DESC LIMIT 1

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    20	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/lms.php:5444
    19	ActivityList->buildQuery()	CopyJROOT/libraries/axslibs/lms.php:5366
    18	ActivityList->getActivities()	CopyJROOT/components/com_splms/models/lessons.php:118
    17	SplmsModelLessons->getActivity()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:709
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

53. Query Time: 0.52 ms After last query: 0.52 ms Query memory: 0.026 MB Memory before query: 20.320 MB Rows returned: 1

    SELECT c.*,l.name as content_type
    
      FROM ic_h5p_contents as c
    
      LEFT JOIN ic_h5p_libraries as l 
      ON c.library_id = l.id
    
      WHERE c.id = 14 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT c.*,l.name as content_type FROM ic_h5p_contents as c LEFT JOIN ic_h5p_libraries as l ON c.library_id = l.id WHERE c.id = 14 LIMIT 1

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    19	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/lms.php:658
    18	AxsLMS::getInteractiveLibrary()	CopyJROOT/components/com_splms/models/lessons.php:124
    17	SplmsModelLessons->getActivity()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:709
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

54. Query Time: 0.66 ms After last query: 1.63 ms Query memory: 0.026 MB Memory before query: 20.334 MB Rows returned: 0

    SELECT *
    
      FROM joom_splms_student_activities
    
      WHERE `course_id`=8 
      AND `lesson_id`=5 
      AND `user_id`=0 
      AND `activity_id` = '16565428505X1NDQ'  
      AND archive_date IS NULL
    
      ORDER BY completed DESC 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_splms_student_activities WHERE `course_id`=8 AND `lesson_id`=5 AND `user_id`=0 AND `activity_id` = '16565428505X1NDQ' AND archive_date IS NULL ORDER BY completed DESC LIMIT 1

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    20	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/lms.php:5444
    19	ActivityList->buildQuery()	CopyJROOT/libraries/axslibs/lms.php:5366
    18	ActivityList->getActivities()	CopyJROOT/components/com_splms/models/lessons.php:118
    17	SplmsModelLessons->getActivity()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:709
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

55. Query Time: 0.50 ms After last query: 1.11 ms Query memory: 0.028 MB Memory before query: 20.428 MB Rows returned: 1

    SELECT *
    
      FROM accessibility_videos
    
      WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/istockphoto-1227495919-640_adpp_is.mp4' 
      AND enabled= 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM accessibility_videos WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/istockphoto-1227495919-640_adpp_is.mp4' AND enabled= 1

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    24	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/accessibility.php:42
    23	AxsAccessibility::query()	CopyJROOT/libraries/axslibs/accessibility.php:74
    22	AxsAccessibility::video()	CopyJROOT/libraries/axslibs/media.php:130
    21	AxsMedia::getVideo()	CopyJROOT/libraries/axslibs/lms.php:2915
    20	AxsLMS::getVideo()	CopyJROOT/components/com_splms/templates/videofield_activity.php:14
    19	include CopyJROOT/components/com_splms/templates/videofield_activity.php	CopyJROOT/components/com_splms/templates/activity_container.php:8
    18	include CopyJROOT/components/com_splms/templates/activity_container.php	CopyJROOT/components/com_splms/models/lessons.php:205
    17	SplmsModelLessons->getActivity()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:709
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

56. Query Time: 0.49 ms After last query: 1.80 ms Query memory: 0.025 MB Memory before query: 20.675 MB Rows returned: 0

    SELECT parent_id
    
      FROM axs_learning_path_map
    
      WHERE item_id = 8 
      AND item_type = 'course'

    Explain

    EXPLAIN not possible on query: SELECT parent_id FROM axs_learning_path_map WHERE item_id = 8 AND item_type = 'course'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1570
    18	JDatabaseDriver->loadColumn()	CopyJROOT/libraries/axslibs/learningPaths.php:872
    17	AxsLearningPaths::getLearningPathsByCourseID()	CopyJROOT/components/com_splms/views/lesson/tmpl/default.php:1405
    16	include CopyJROOT/components/com_splms/views/lesson/tmpl/default.php	CopyJROOT/libraries/fof/view/view.php:442
    15	FOFView->loadAnyTemplate()	CopyJROOT/libraries/fof/view/view.php:843
    14	FOFView->loadTemplate()	CopyJROOT/libraries/fof/view/view.php:474
    13	FOFView->display()	CopyJROOT/libraries/fof/view/raw.php:128
    12	FOFViewRaw->display()	CopyJROOT/components/com_splms/views/lesson/view.html.php:57
    11	SplmsViewLesson->display()	CopyJROOT/libraries/fof/controller/controller.php:1128
    10	FOFController->display()	CopyJROOT/libraries/fof/controller/controller.php:1221
    9	FOFController->read()	CopyJROOT/libraries/fof/controller/controller.php:970
    8	FOFController->execute()	CopyJROOT/libraries/fof/dispatcher/dispatcher.php:328
    7	FOFDispatcher->dispatch()	CopyJROOT/components/com_splms/splms.php:35
    6	require_once CopyJROOT/components/com_splms/splms.php	CopyJROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	CopyJROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	CopyJROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

57. Query Time: 0.82 ms After last query: 1.68 ms Query memory: 0.021 MB Memory before query: 20.669 MB Rows returned: 1

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

    Explain

    EXPLAIN not possible on query: SELECT language,id FROM `joom_menu` WHERE home = 1 AND published = 1 AND client_id = 0

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.33 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    9	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/cms/language/multilang.php:106
    8	JLanguageMultilang::getSiteHomePages()	CopyJROOT/plugins/system/languagefilter/languagefilter.php:729
    7	PlgSystemLanguageFilter->onAfterDispatch()	CopyJROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	CopyJROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	CopyJROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	CopyJROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	CopyJROOT/libraries/cms/application/site.php:235
    2	JApplicationSite->doExecute()	CopyJROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

58. Query Time: 0.64 ms After last query: 2.57 ms Query memory: 0.022 MB Memory before query: 20.964 MB Rows returned: 1

    SELECT *
    
      FROM `currency`
    
      WHERE `base_currency`=1 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM `currency` WHERE `base_currency`=1 LIMIT 1

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.13 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    11	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/currency.php:84
    10	AxsCurrency->getBaseCurrency()	CopyJROOT/libraries/axslibs/currency.php:22
    9	AxsCurrency->__construct()	CopyJROOT/templates/axs/home.php:20
    8	include CopyJROOT/templates/axs/home.php	CopyJROOT/templates/axs/index.php:59
    7	require CopyJROOT/templates/axs/index.php	CopyJROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	CopyJROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	CopyJROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	CopyJROOT/libraries/cms/application/cms.php:1173
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

59. Query Time: 0.48 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 20.971 MB Rows returned: 10

    SELECT * 
      FROM axs_fonts 
      WHERE enabled = 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM axs_fonts WHERE enabled = 1

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    10	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/axslibs/fonts.php:34
    9	AxsFonts::getFonts()	CopyJROOT/templates/axs/home.php:93
    8	include CopyJROOT/templates/axs/home.php	CopyJROOT/templates/axs/index.php:59
    7	require CopyJROOT/templates/axs/index.php	CopyJROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	CopyJROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	CopyJROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	CopyJROOT/libraries/cms/application/cms.php:1173
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

60. Query Time: 0.49 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 20.985 MB Rows returned: 0

    SELECT *
    
      FROM accessibility_images
    
      WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' 
      AND enabled= 1

    Explain

    EXPLAIN not possible on query: SELECT * FROM accessibility_images WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.03 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    11	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/accessibility.php:42
    10	AxsAccessibility::query()	CopyJROOT/libraries/axslibs/accessibility.php:49
    9	AxsAccessibility::image()	CopyJROOT/templates/axs/home.php:799
    8	include CopyJROOT/templates/axs/home.php	CopyJROOT/templates/axs/index.php:59
    7	require CopyJROOT/templates/axs/index.php	CopyJROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	CopyJROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	CopyJROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	CopyJROOT/libraries/cms/application/cms.php:1173
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

61. Query Time: 0.61 ms After last query: 0.87 ms Query memory: 0.022 MB Memory before query: 21.037 MB Rows returned: 0

    SELECT * 
      FROM axs_notifications  
      WHERE enabled = 1  
      AND   DATE(start_date) <= NOW()  
      AND   ( DATE(end_date) > NOW() OR end_date = 0 )  
      AND (  ( access_type = 'access' 
      AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
      AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
      AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' ) )

    Explain

    EXPLAIN not possible on query: SELECT * FROM axs_notifications WHERE enabled = 1 AND DATE(start_date) <= NOW() AND ( DATE(end_date) > NOW() OR end_date = 0 ) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' ) )

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.03 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    10	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/axslibs/notifications.php:17
    9	AxsNotifications::loadNotifications()	CopyJROOT/templates/axs/home.php:1788
    8	include CopyJROOT/templates/axs/home.php	CopyJROOT/templates/axs/index.php:59
    7	require CopyJROOT/templates/axs/index.php	CopyJROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	CopyJROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	CopyJROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	CopyJROOT/libraries/cms/application/cms.php:1173
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

62. Query Time: 0.51 ms After last query: 3.15 ms Query memory: 0.026 MB Memory before query: 21.186 MB Rows returned: 0

    SELECT *
    
      FROM joom_easyblog_configs
    
      WHERE `name` = 'config'

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_easyblog_configs WHERE `name` = 'config'

    Profile

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.03 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1485
    21	JDatabaseDriver->loadAssoc()	CopyJROOT/libraries/joomla/table/table.php:729
    20	JTable->load()	CopyJROOT/administrator/components/com_easyblog/includes/easyblog.php:415
    19	EB::config()	CopyJROOT/components/com_easyblog/router.php:19
    18	EasyBlogBuildRoute()	CopyJROOT/libraries/cms/component/router/legacy.php:68
    17	JComponentRouterLegacy->build()	CopyJROOT/libraries/cms/router/site.php:519
    16	JRouterSite->buildSefRoute()	CopyJROOT/libraries/cms/router/site.php:489
    15	JRouterSite->_buildSefRoute()	CopyJROOT/libraries/cms/router/router.php:282
    14	JRouter->build()	CopyJROOT/libraries/cms/router/site.php:149
    13	JRouterSite->build()	CopyJROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	CopyJROOT/modules/mod_defaultmenu/helper.php:134
    11	ModDefaultHelper::getList()	CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
    10	include CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php	CopyJROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	CopyJROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	CopyJROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	CopyJROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	CopyJROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	CopyJROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	CopyJROOT/libraries/cms/application/cms.php:1190
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

63. Query Time: 1.41 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 21.239 MB Rows returned: 1

    SELECT * 
      FROM joom_extensions 
      WHERE name='com_media'

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_extensions WHERE name='com_media'

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.94 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    22	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/images.php:66
    21	AxsImages::setSession()	CopyJROOT/libraries/axslibs/images.php:15
    20	AxsImages::getImagesPath()	CopyJROOT/administrator/components/com_easyblog/includes/easyblog.php:430
    19	EB::config()	CopyJROOT/components/com_easyblog/router.php:19
    18	EasyBlogBuildRoute()	CopyJROOT/libraries/cms/component/router/legacy.php:68
    17	JComponentRouterLegacy->build()	CopyJROOT/libraries/cms/router/site.php:519
    16	JRouterSite->buildSefRoute()	CopyJROOT/libraries/cms/router/site.php:489
    15	JRouterSite->_buildSefRoute()	CopyJROOT/libraries/cms/router/router.php:282
    14	JRouter->build()	CopyJROOT/libraries/cms/router/site.php:149
    13	JRouterSite->build()	CopyJROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	CopyJROOT/modules/mod_defaultmenu/helper.php:134
    11	ModDefaultHelper::getList()	CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
    10	include CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php	CopyJROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	CopyJROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	CopyJROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	CopyJROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	CopyJROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	CopyJROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	CopyJROOT/libraries/cms/application/cms.php:1190
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

64. Query Time: 0.54 ms After last query: 1.53 ms Query memory: 0.028 MB Memory before query: 21.501 MB Rows returned: 1

    SELECT * 
      FROM joom_kunena_configuration 
      WHERE id=1

    Explain

    EXPLAIN not possible on query: SELECT * FROM joom_kunena_configuration WHERE id=1

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    28	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1485
    27	JDatabaseDriver->loadAssoc()	CopyJROOT/libraries/kunena/config.php:1306
    26	KunenaConfig->load()	CopyJROOT/libraries/kunena/config.php:1239
    25	KunenaConfig::getInstance()	CopyJROOT/libraries/kunena/factory.php:28
    24	KunenaFactory::getConfig()	CopyJROOT/libraries/kunena/route/route.php:480
    23	KunenaRoute::initialize()	CopyJROOT/libraries/kunena/route/route.php:17
    22	include CopyJROOT/libraries/kunena/route/route.php	CopyJROOT/libraries/loader.php:716
    21	JLoader::_load()	CopyJROOT/libraries/loader.php:671
    20	JLoader::_autoload()	Same as call in the line below.
    19	spl_autoload_call()	CopyJROOT/components/com_kunena/router.php:38
    18	KunenaBuildRoute()	CopyJROOT/libraries/cms/component/router/legacy.php:68
    17	JComponentRouterLegacy->build()	CopyJROOT/libraries/cms/router/site.php:519
    16	JRouterSite->buildSefRoute()	CopyJROOT/libraries/cms/router/site.php:489
    15	JRouterSite->_buildSefRoute()	CopyJROOT/libraries/cms/router/router.php:282
    14	JRouter->build()	CopyJROOT/libraries/cms/router/site.php:149
    13	JRouterSite->build()	CopyJROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	CopyJROOT/modules/mod_defaultmenu/helper.php:134
    11	ModDefaultHelper::getList()	CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
    10	include CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php	CopyJROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	CopyJROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	CopyJROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	CopyJROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	CopyJROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	CopyJROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	CopyJROOT/libraries/cms/application/cms.php:1190
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

65. Query Time: 0.57 ms After last query: 2.19 ms Query memory: 0.029 MB Memory before query: 21.721 MB Rows returned: 1

    SELECT special_characters 
      FROM joom_languages 
      WHERE sef = 'en' 
      LIMIT 1

    Explain

    EXPLAIN not possible on query: SELECT special_characters FROM joom_languages WHERE sef = 'en' LIMIT 1

    Profile

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1682
    15	JDatabaseDriver->loadObject()	CopyJROOT/libraries/axslibs/language.php:308
    14	AxsLanguage::getSpecialCharacters()	CopyJROOT/libraries/axslibs/language.php:26
    13	AxsLanguage::translate()	CopyJROOT/modules/mod_defaultmenu/tmpl/default_component.php:21
    12	require CopyJROOT/modules/mod_defaultmenu/tmpl/default_component.php	CopyJROOT/modules/mod_defaultmenu/tmpl/default.php:72
    11	require CopyJROOT/modules/mod_defaultmenu/tmpl/default.php	CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php:25
    10	include CopyJROOT/modules/mod_defaultmenu/mod_defaultmenu.php	CopyJROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	CopyJROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	CopyJROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	CopyJROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	CopyJROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	CopyJROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	CopyJROOT/libraries/cms/application/cms.php:1190
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---

66. Query Time: 0.69 ms After last query: 2.14 ms Query memory: 0.023 MB Memory before query: 21.778 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `joom_menu` AS `c`
    
      INNER JOIN `joom_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `joom_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `joom_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 864

    Explain

    EXPLAIN not possible on query: SELECT `c2`.`language`,`c2`.`id` FROM `joom_menu` AS `c` INNER JOIN `joom_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNER JOIN `joom_associations` AS `a2` ON a.key = a2.key INNER JOIN `joom_menu` AS `c2` ON a2.id = c2.`id` WHERE c.id = 864

    Profile

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	CopyJROOT/libraries/joomla/database/driver.php:1721
    14	JDatabaseDriver->loadObjectList()	CopyJROOT/libraries/cms/language/associations.php:101
    13	JLanguageAssociations::getAssociations()	CopyJROOT/administrator/components/com_menus/helpers/menus.php:313
    12	MenusHelper::getAssociations()	CopyJROOT/modules/mod_language_selector/tmpl/default.php:91
    11	require CopyJROOT/modules/mod_language_selector/tmpl/default.php	CopyJROOT/modules/mod_language_selector/mod_language_selector.php:4
    10	include CopyJROOT/modules/mod_language_selector/mod_language_selector.php	CopyJROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	CopyJROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	CopyJROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	CopyJROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	CopyJROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	CopyJROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	CopyJROOT/libraries/cms/application/cms.php:1190
    3	JApplicationCms->render()	CopyJROOT/libraries/cms/application/site.php:782
    2	JApplicationSite->render()	CopyJROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	CopyJROOT/index.php:72

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

    ---