Joomlas feilsøkingskonsoll

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1597179884,
                "last": 1597179884,
                "now": 1597179884
            },
            "token": "vN79d5fwxX75mNVt6UQIKxVdOqurX5SR"
        },
        "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
        },
        "gantry-7094897392943a1b7e0adcb306d6e466-name": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-logo-type": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-logo-custom-image": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-headerstyle": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-linkcolor": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-font-family": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-font-size-is": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-menu-type": null,
        "gantry-7094897392943a1b7e0adcb306d6e466-layout-mode": null
    }
}

Tid

Minne

58 spørring(er) logget 37.11 ms

1. Spørringstid: 0.49 ms Spørreminne: 0.018 MB Minne før spørring: 2.990 MB Rader funnet: 0

   SELECT `data`
   
     FROM `l9dks_session`
   
     WHERE `session_id` = '2gpj1pm5q4l77473u4ap9vcq75'

   Forklar

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

   Profil

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

   Call Stack

   #	Oppkaller	Fil og linjenummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Samme som oppkall i linjen nedenfor.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

2. Spørringstid: 0.29 ms Etter siste spørring: 2.64 ms Spørreminne: 0.012 MB Minne før spørring: 3.197 MB Rader funnet: 0

   SELECT `session_id`
   
     FROM `l9dks_session`
   
     WHERE `session_id` = '2gpj1pm5q4l77473u4ap9vcq75' 
     LIMIT 1

   Forklar

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

   Profil

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

   Call Stack

   #	Oppkaller	Fil og linjenummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

3. Spørringstid: 2.90 ms Etter siste spørring: 0.18 ms Spørreminne: 0.009 MB Minne før spørring: 3.213 MB

   INSERT INTO `l9dks_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('2gpj1pm5q4l77473u4ap9vcq75', 0, 1, '1597179884', 0, '')

   Forklar

   'EXPLAIN' er ikke mulig på spørringen: INSERT INTO `l9dks_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('2gpj1pm5q4l77473u4ap9vcq75', 0, 1, '1597179884', 0, '')

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   init	0.01 ms
   update	0.07 ms
   end	0.00 ms
   query end	2.58 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Oppkaller	Fil og linjenummer
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

4. Spørringstid: 0.83 ms Etter siste spørring: 2.67 ms Spørreminne: 0.027 MB Minne før spørring: 3.470 MB Rader funnet: 43

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

   Forklar

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

   Profil

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

   Call Stack

   #	Oppkaller	Fil og linjenummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Samme som oppkall i linjen nedenfor.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

5. Spørringstid: 0.53 ms Etter siste spørring: 2.39 ms Spørreminne: 0.015 MB Minne før spørring: 3.704 MB Rader funnet: 1

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

   Forklar

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

   Profil

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

   Call Stack

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

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

6. Spørringstid: 0.69 ms Etter siste spørring: 0.66 ms Spørreminne: 0.014 MB Minne før spørring: 3.780 MB Rader funnet: 3

   SELECT id, rules
   
     FROM `l9dks_viewlevels`

   Forklar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l9dks_viewlevels	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	3

   Profil

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

   Call Stack

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

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

7. Spørringstid: 0.95 ms Etter siste spørring: 0.21 ms Spørreminne: 0.015 MB Minne før spørring: 3.797 MB Rader funnet: 109

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

   Forklar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l9dks_extensions	ref	extension	extension	82	const	198	Using index condition; Using where; Bruker filsortering

   Profil

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

   Call Stack

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

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

8. Spørringstid: 0.94 ms Etter siste spørring: 6.53 ms Spørreminne: 0.016 MB Minne før spørring: 4.637 MB Rader funnet: 0

   SELECT `path`
   
     FROM l9dks_rsfirewall_ignored
   
     WHERE `type`='ignore_folder' OR `type`='ignore_file'

   Forklar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l9dks_rsfirewall_ignored	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	1	Using where

   Profil

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

   Call Stack

   #	Oppkaller	Fil og linjenummer
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

9. Spørringstid: 0.29 ms Etter siste spørring: 0.24 ms Spørreminne: 0.016 MB Minne før spørring: 4.654 MB Rader funnet: 0

   SELECT `file`
   
     FROM l9dks_rsfirewall_hashes
   
     WHERE `type`='protect'

   Forklar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l9dks_rsfirewall_hashes	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	37	Using where

   Profil

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

   Call Stack

   #	Oppkaller	Fil og linjenummer
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
   10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
   9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
   8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
   7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

   ---

10. Spørringstid: 0.30 ms Etter siste spørring: 0.14 ms Spørreminne: 0.019 MB Minne før spørring: 4.668 MB Rader funnet: 52

    SELECT *
    
      FROM l9dks_rsfirewall_configuration

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_rsfirewall_configuration	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	52

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
    10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
    9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
    8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
    7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

11. Spørringstid: 0.85 ms Etter siste spørring: 6.04 ms Spørreminne: 0.024 MB Minne før spørring: 5.250 MB Rader funnet: 10

    SHOW FULL COLUMNS 
      FROM `l9dks_rsfirewall_logs`

    Forklar

    'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `l9dks_rsfirewall_logs`

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
    11	RsfirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
    9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
    8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
    7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

12. Spørringstid: 0.39 ms Etter siste spørring: 10.27 ms Spørreminne: 0.019 MB Minne før spørring: 6.368 MB Rader funnet: 1
    Duplikat-spørringer: #13

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

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_home	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	10	Using where

    Profil

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

    Call Stack

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

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

13. Spørringstid: 0.21 ms Etter siste spørring: 0.16 ms Spørreminne: 0.020 MB Minne før spørring: 6.387 MB Rader funnet: 1
    Duplikat-spørringer: #12

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

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_home	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	10	Using where

    Profil

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

    Call Stack

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

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

14. Spørringstid: 0.29 ms Etter siste spørring: 4.29 ms Spørreminne: 0.015 MB Minne før spørring: 6.695 MB Rader funnet: 2

    SELECT extension, file, type
    
      FROM l9dks_rokcommon_configs
    
      ORDER BY priority

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_rokcommon_configs	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	2	Bruker filsortering

    Profil

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

    Call Stack

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

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

15. Spørringstid: 0.91 ms Etter siste spørring: 39.98 ms Spørreminne: 0.023 MB Minne før spørring: 10.777 MB Rader funnet: 17

    SHOW FULL COLUMNS 
      FROM `l9dks_extensions`

    Forklar

    'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `l9dks_extensions`

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
    11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    9	plgSystemRokSprocket->onAfterInitialise()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

16. Spørringstid: 0.38 ms Etter siste spørring: 0.30 ms Spørreminne: 0.016 MB Minne før spørring: 10.836 MB Rader funnet: 1

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

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
    9	plgSystemRokSprocket->onAfterInitialise()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

17. Spørringstid: 0.24 ms Etter siste spørring: 0.19 ms Spørreminne: 0.020 MB Minne før spørring: 10.854 MB Rader funnet: 1
    Duplikat-spørringer: #19

    SELECT *
    
      FROM l9dks_extensions
    
      WHERE `extension_id` = '10073'

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    9	plgSystemRokSprocket->onAfterInitialise()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

18. Spørringstid: 0.23 ms Etter siste spørring: 0.18 ms Spørreminne: 0.016 MB Minne før spørring: 10.868 MB Rader funnet: 1

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

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
    9	plgSystemRokSprocket->onAfterInitialise()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

19. Spørringstid: 0.22 ms Etter siste spørring: 0.19 ms Spørreminne: 0.020 MB Minne før spørring: 10.884 MB Rader funnet: 1
    Duplikat-spørringer: #17

    SELECT *
    
      FROM l9dks_extensions
    
      WHERE `extension_id` = '10073'

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    9	plgSystemRokSprocket->onAfterInitialise()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

20. Spørringstid: 1.20 ms Etter siste spørring: 20.38 ms Spørreminne: 0.030 MB Minne før spørring: 11.772 MB Rader funnet: 36

    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 l9dks_menu AS m
    
      LEFT JOIN l9dks_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

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	160	Using index condition; Using where; Bruker filsortering
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rederiforening.m.component_id	1	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

21. Spørringstid: 0.50 ms Etter siste spørring: 11.93 ms Spørreminne: 0.016 MB Minne før spørring: 12.917 MB Rader funnet: 4

    SELECT *
    
      FROM l9dks_rsfirewall_hashes
    
      WHERE (`type`='3.6.5' OR `type`='protect') 
      AND `flag`!='C'

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_rsfirewall_hashes	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	37	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1001
    9	plgSystemRSFirewall->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

22. Spørringstid: 0.25 ms Etter siste spørring: 0.81 ms Spørreminne: 0.016 MB Minne før spørring: 12.975 MB Rader funnet: 0

    SELECT *
    
      FROM l9dks_rsfirewall_snapshots
    
      WHERE `type`='protect'

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_rsfirewall_snapshots	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	1	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
    10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1024
    9	plgSystemRSFirewall->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

23. Spørringstid: 0.27 ms Etter siste spørring: 0.18 ms Spørreminne: 0.017 MB Minne før spørring: 12.991 MB Rader funnet: 0

    SELECT `ip`,`reason`
    
      FROM l9dks_rsfirewall_lists
    
      WHERE (`ip`='3.219.167.194' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='1' 
      AND `published`='1'

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_rsfirewall_lists	ref	published,type,ip	type	1	const	1	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:148
    10	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1060
    9	plgSystemRSFirewall->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

24. Spørringstid: 0.31 ms Etter siste spørring: 0.16 ms Spørreminne: 0.017 MB Minne før spørring: 13.007 MB Rader funnet: 0

    SELECT `ip`,`reason`
    
      FROM l9dks_rsfirewall_lists
    
      WHERE (`ip`='3.219.167.194' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
      AND `type`='0' 
      AND `published`='1'

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_rsfirewall_lists	ALL	published,type,ip	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	81	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
    11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:138
    10	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1064
    9	plgSystemRSFirewall->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

25. Spørringstid: 0.23 ms Etter siste spørring: 0.42 ms Spørreminne: 0.018 MB Minne før spørring: 13.028 MB Rader funnet: 0

    SELECT *
    
      FROM l9dks_rsfirewall_exceptions
    
      WHERE `published`='1'

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_rsfirewall_exceptions	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	1	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:669
    10	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1117
    9	plgSystemRSFirewall->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

26. Spørringstid: 0.35 ms Etter siste spørring: 3.10 ms Spørreminne: 0.024 MB Minne før spørring: 13.173 MB Rader funnet: 1

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

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	Samme som oppkall i linjen nedenfor.
    17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
    9	plgSystemK2->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

27. Spørringstid: 1.56 ms Etter siste spørring: 0.30 ms Spørreminne: 0.018 MB Minne før spørring: 13.180 MB

    UPDATE `l9dks_extensions`
    
      SET `params` = '{\"mediaversion\":\"2b7d76de5d2bfcced97850419f58ca51\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Forklar

    'EXPLAIN' er ikke mulig på spørringen: UPDATE `l9dks_extensions` SET `params` = '{\"mediaversion\":\"2b7d76de5d2bfcced97850419f58ca51\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:40
    9	plgSystemK2->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

28. Spørringstid: 0.36 ms Etter siste spørring: 3.19 ms Spørreminne: 0.022 MB Minne før spørring: 13.591 MB Rader funnet: 1

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

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_languages	ALL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	1	Using where; Bruker filsortering

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:305
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
    10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
    9	plgSystemK2->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

29. Spørringstid: 0.49 ms Etter siste spørring: 1.86 ms Spørreminne: 0.027 MB Minne før spørring: 13.782 MB Rader funnet: 5
    Duplikat-spørringer: #47

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

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	10	Using where; Using join buffer (flat, BNL join)

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
    19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
    18	JHtml::script()	Samme som oppkall i linjen nedenfor.
    17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    15	JHtml::_()	JROOT/libraries/cms/html/jquery.php:53
    14	JHtmlJquery::framework()	Samme som oppkall i linjen nedenfor.
    13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
    11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:79
    10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
    9	plgSystemK2->onAfterRoute()	Samme som oppkall i linjen nedenfor.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

30. Spørringstid: 1.00 ms Etter siste spørring: 5.35 ms Spørreminne: 0.024 MB Minne før spørring: 14.287 MB Rader funnet: 8

    SHOW FULL COLUMNS 
      FROM `l9dks_assets`

    Forklar

    'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `l9dks_assets`

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    11	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

31. Spørringstid: 0.28 ms Etter siste spørring: 0.31 ms Spørreminne: 0.018 MB Minne før spørring: 14.330 MB Rader funnet: 1

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

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    9	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

32. Spørringstid: 0.29 ms Etter siste spørring: 0.19 ms Spørreminne: 0.014 MB Minne før spørring: 14.342 MB Rader funnet: 1

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

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    8	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

33. Spørringstid: 0.38 ms Etter siste spørring: 0.83 ms Spørreminne: 0.017 MB Minne før spørring: 14.394 MB Rader funnet: 43

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

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

34. Spørringstid: 0.75 ms Etter siste spørring: 0.22 ms Spørreminne: 0.018 MB Minne før spørring: 14.419 MB Rader funnet: 42

    SELECT a.name, a.rules
    
      FROM l9dks_assets AS a
    
      WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_gantry','com_gantry','com_hikashop','com_installer','com_jce','com_jevents','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ohanah','com_plugins','com_postinstall','com_redirect','com_roksprocket','com_rsfirewall','com_search','com_tags','com_templates','com_uniterevolution','com_users','com_weblinks','com_widgetkit','com_wrapper') OR a.name = 'root.1')

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	idx_asset_name	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	232	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    11	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    10	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    9	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    8	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

35. Spørringstid: 0.50 ms Etter siste spørring: 11.35 ms Spørreminne: 0.019 MB Minne før spørring: 16.088 MB Rader funnet: 12

    SELECT id 
      FROM l9dks_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1)

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_k2_categories	range	category,published,access,trash	category	8	NULL	12	Using index condition

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
    12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/itemlist/view.html.php:29
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

36. Spørringstid: 0.79 ms Etter siste spørring: 0.97 ms Spørreminne: 0.027 MB Minne før spørring: 16.197 MB Rader funnet: 14

    SHOW FULL COLUMNS 
      FROM `l9dks_k2_categories`

    Forklar

    'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `l9dks_k2_categories`

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    14	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
    13	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:308
    12	JTable::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:41
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

37. Spørringstid: 0.25 ms Etter siste spørring: 0.24 ms Spørreminne: 0.022 MB Minne før spørring: 16.245 MB Rader funnet: 1

    SELECT * 
      FROM l9dks_k2_categories 
      WHERE id = '10'

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
    12	TableK2Category->load()	JROOT/components/com_k2/views/itemlist/view.html.php:42
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

38. Spørringstid: 0.42 ms Etter siste spørring: 6.72 ms Spørreminne: 0.022 MB Minne før spørring: 16.930 MB Rader funnet: 0

    SELECT * 
      FROM l9dks_k2_categories 
      WHERE parent=10 
      AND published=1 
      AND trash=0 
      AND access IN(1,1)  
      ORDER BY  id ASC

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_k2_categories	ref	category,parent,published,access,trash	parent	5	const	1	Using where; Bruker filsortering

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:754
    12	K2ModelItemlist->getCategoryFirstChildren()	JROOT/components/com_k2/views/itemlist/view.html.php:173
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

39. Spørringstid: 0.30 ms Etter siste spørring: 1.18 ms Spørreminne: 0.020 MB Minne før spørring: 17.023 MB Rader funnet: 0

    SELECT id
    						
      FROM l9dks_k2_categories
    						
      WHERE parent IN (10)
    						
      AND id NOT IN (10) 
    								
      AND published=1
    								
      AND trash=0 
      AND access IN(1,1)

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_k2_categories	ref	PRIMARY,category,parent,published,access,trash	parent	5	const	1	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:648
    13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:122
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:391
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

40. Spørringstid: 1.69 ms Etter siste spørring: 0.20 ms Spørreminne: 0.046 MB Minne før spørring: 17.043 MB Rader funnet: 4

    SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
      FROM l9dks_k2_items as i RIGHT JOIN l9dks_k2_categories AS c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1) 
      AND c.trash = 0 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-08-11 21:04:44' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-08-11 21:04:44' ) 
      AND c.id IN (10) 
      ORDER BY i.publish_up DESC 
      LIMIT 16, 4

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,category,published,access,trash	PRIMARY	4	const	1
    1	SIMPLE	i	range	item,catid	item	7	NULL	602	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:360
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:391
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

41. Spørringstid: 2.17 ms Etter siste spørring: 1.16 ms Spørreminne: 0.019 MB Minne før spørring: 17.177 MB Rader funnet: 1

    SELECT COUNT(*) 
      FROM l9dks_k2_items as i RIGHT JOIN l9dks_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1) 
      AND c.trash = 0 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-08-11 21:04:44' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-08-11 21:04:44' ) 
      AND c.id IN (10)

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,category,published,access,trash	PRIMARY	4	const	1
    1	SIMPLE	i	ref	item,catid	catid	4	const	280	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:598
    12	K2ModelItemlist->getTotal()	JROOT/components/com_k2/views/itemlist/view.html.php:415
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

42. Spørringstid: 0.93 ms Etter siste spørring: 5.48 ms Spørreminne: 0.036 MB Minne før spørring: 17.517 MB Rader funnet: 16

    SHOW FULL COLUMNS 
      FROM `l9dks_users`

    Forklar

    'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `l9dks_users`

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    Opening tables	0.26 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Filling schema table	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.11 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Oppkaller	Fil og linjenummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    24	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    23	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
    22	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
    21	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:583
    20	JUser::getTable()	JROOT/libraries/joomla/user/user.php:861
    19	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    18	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    17	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    16	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
    15	K2ModelItem->prepareItem()	Samme som oppkall i linjen nedenfor.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

43. Spørringstid: 0.38 ms Etter siste spørring: 0.45 ms Spørreminne: 0.031 MB Minne før spørring: 17.587 MB Rader funnet: 1

    SELECT *
    
      FROM `l9dks_users`
    
      WHERE `id` = 870

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/user.php:85
    20	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
    19	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    18	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    17	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    16	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
    15	K2ModelItem->prepareItem()	Samme som oppkall i linjen nedenfor.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

44. Spørringstid: 0.50 ms Etter siste spørring: 4.36 ms Spørreminne: 0.028 MB Minne før spørring: 18.527 MB Rader funnet: 2

    SELECT `g`.`id`,`g`.`title`
    
      FROM `l9dks_usergroups` AS g
    
      INNER JOIN `l9dks_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 870

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	rederiforening.m.group_id	1

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    21	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:110
    20	JTableUser->load()	JROOT/libraries/joomla/user/user.php:864
    19	JUser->load()	JROOT/libraries/joomla/user/user.php:243
    18	JUser->__construct()	JROOT/libraries/joomla/user/user.php:296
    17	JUser::getInstance()	JROOT/libraries/joomla/factory.php:248
    16	JFactory::getUser()	JROOT/components/com_k2/models/item.php:248
    15	K2ModelItem->prepareItem()	Samme som oppkall i linjen nedenfor.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

45. Spørringstid: 0.34 ms Etter siste spørring: 2.14 ms Spørreminne: 0.025 MB Minne før spørring: 18.550 MB Rader funnet: 1

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM l9dks_k2_users 
      WHERE userID=870

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_k2_users	ref	userID	userID	4	const	1

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1874
    16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:251
    15	K2ModelItem->prepareItem()	Samme som oppkall i linjen nedenfor.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
    12	JCacheControllerCallback->call()	JROOT/components/com_k2/views/itemlist/view.html.php:464
    11	K2ViewItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:664
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

46. Spørringstid: 0.48 ms Etter siste spørring: 47.55 ms Spørreminne: 0.021 MB Minne før spørring: 19.567 MB Rader funnet: 1

    SELECT params 
      FROM l9dks_extensions AS e 
      WHERE e.element='com_widgetkit'

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:254
    14	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
    13	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
    12	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
    11	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
    10	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    8	plgSystemWidgetkit_System->onAfterDispatch()	Samme som oppkall i linjen nedenfor.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

47. Spørringstid: 0.67 ms Etter siste spørring: 25.02 ms Spørreminne: 0.025 MB Minne før spørring: 22.766 MB Rader funnet: 5
    Duplikat-spørringer: #29

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

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	10	Using where; Using join buffer (flat, BNL join)

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
    15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
    14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/bergensrederiforening_web/lib/gantry/gantry.php:21
    8	require_once JROOT/templates/bergensrederiforening_web/lib/gantry/gantry.php	JROOT/templates/bergensrederiforening_web/index.php:15
    7	require JROOT/templates/bergensrederiforening_web/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

48. Spørringstid: 1.80 ms Etter siste spørring: 19.69 ms Spørreminne: 0.026 MB Minne før spørring: 23.822 MB Rader funnet: 32

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM l9dks_modules AS m
    
      LEFT JOIN l9dks_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN l9dks_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 <= '2020-08-11 21:04:44') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-08-11 21:04:44') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 329 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	101	Using index condition; Using where; Bruker filsortering
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	rederiforening.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	rederiforening.m.id	1	Using where; Using index

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	Samme som oppkall i linjen nedenfor.
    15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    14	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    13	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    12	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    11	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    10	JDocumentHtml->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
    9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
    8	Gantry->countModules()	JROOT/templates/bergensrederiforening_web/index.php:62
    7	require JROOT/templates/bergensrederiforening_web/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

49. Spørringstid: 0.40 ms Etter siste spørring: 12.03 ms Spørreminne: 0.024 MB Minne før spørring: 24.743 MB Rader funnet: 0

    SELECT ts.template
    
      FROM l9dks_template_styles AS ts
    
      INNER JOIN l9dks_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 329 
      AND m.template_style_id != 0

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/cms/module/helper.php:199
    12	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    11	JDocumentRendererHtmlModule->render()	JROOT/templates/bergensrederiforening_web/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/bergensrederiforening_web/index.php:78
    7	require JROOT/templates/bergensrederiforening_web/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

50. Spørringstid: 0.24 ms Etter siste spørring: 0.21 ms Spørreminne: 0.024 MB Minne før spørring: 24.765 MB Rader funnet: 1

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

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_template_styles	ALL	idx_home	INGEN INDEKSNØKKEL KUNNE BRUKES	NULL	NULL	10	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/cms/module/helper.php:199
    12	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    11	JDocumentRendererHtmlModule->render()	JROOT/templates/bergensrederiforening_web/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/bergensrederiforening_web/index.php:78
    7	require JROOT/templates/bergensrederiforening_web/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

51. Spørringstid: 0.46 ms Etter siste spørring: 29.87 ms Spørreminne: 0.020 MB Minne før spørring: 25.724 MB Rader funnet: 8

    SELECT 
    					c.id AS CID
    				
      FROM 
    					l9dks_k2_categories AS c
    				
      LEFT JOIN 
    					l9dks_k2_items AS content 
    					
      ON 
    					c.id = content.catid 	
    				 
    				
      WHERE 
    					(  c.id = 22 ) 
    					
      AND 
    					c.published = 1

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,category,published	PRIMARY	4	const	1
    1	SIMPLE	content	ref	catid	catid	4	const	7	Using index

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:76
    13	NSP_GK5_com_k2_Model::getSources()	Samme som oppkall i linjen nedenfor.
    12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:92
    11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

52. Spørringstid: 0.48 ms Etter siste spørring: 0.27 ms Spørreminne: 0.019 MB Minne før spørring: 25.746 MB Rader funnet: 5

    SELECT
    			content.id AS id				
    		
      FROM 
    			l9dks_k2_items AS content 
    			
    			
    		
      WHERE 
    			content.published = 1 
      AND content.trash = 0
                     
      AND content.access IN (1,1)    
    		 		
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2020-08-11 21:04:44' )
    				
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2020-08-11 21:04:44' )
    			 
      AND (  content.catid = 22 ) 
    			
    			 
    			
    			
    		
    			
    		
    		
      ORDER BY 
    			 content.created DESC 
    		
      LIMIT
    			0,5;

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	content	ref	item,catid	catid	4	const	7	Using where; Bruker filsortering

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:254
    13	NSP_GK5_com_k2_Model::getArticles()	Samme som oppkall i linjen nedenfor.
    12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:106
    11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

53. Spørringstid: 0.60 ms Etter siste spørring: 0.13 ms Spørreminne: 0.024 MB Minne før spørring: 25.770 MB Rader funnet: 5

    SELECT
    			content.id AS id,
    			content.alias AS alias,
    			content.title AS title, 
    			content.introtext AS text, 
    			content.created AS date, 
    			content.publish_up AS date_publish,
    			content.hits AS hits,
    			content.featured AS frontpage,
    			content.access AS access,
    			content.catid AS cid,
    			content.video AS video,
    			categories.name AS catname, 
    			categories.image AS cat_image,
    			categories.alias AS cat_alias,
    			users.email AS author_email,
    			content.created_by_alias AS author_alias,
    			users.name AS author_username,
    			content.created_by AS author_id,
    			content_rating.rating_sum AS rating_sum,
    			content_rating.rating_count AS rating_count		
    		
      FROM 
    			l9dks_k2_items AS content 
    			
      LEFT JOIN 
    				l9dks_k2_categories AS categories 
    				
      ON categories.id = content.catid 
    			
      LEFT JOIN 
    				l9dks_users AS users 
    				
      ON users.id = content.created_by 			
    			
      LEFT JOIN 
    				l9dks_k2_rating AS content_rating 
    				
      ON content_rating.itemID = content.id
    		
      WHERE 
    			1=1
    			 
      AND ( content.id = 423 OR  content.id = 389 OR  content.id = 372 OR  content.id = 337 OR  content.id = 53)
    		
      ORDER BY 
    			 content.created DESC

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	5	Using index condition; Using where; Bruker filsortering
    1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	rederiforening.content.catid	1	Using where
    1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	rederiforening.content.created_by	1
    1	SIMPLE	content_rating	eq_ref	PRIMARY	PRIMARY	4	rederiforening.content.id	1

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    14	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:312
    13	NSP_GK5_com_k2_Model::getArticles()	Samme som oppkall i linjen nedenfor.
    12	call_user_func()	JROOT/modules/mod_news_pro_gk5/helper.php:106
    11	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:32
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

54. Spørringstid: 0.35 ms Etter siste spørring: 1.52 ms Spørreminne: 0.026 MB Minne før spørring: 25.928 MB Rader funnet: 12

    SELECT id, name,  parent	
      FROM l9dks_k2_categories 
      WHERE published=1  
      AND trash=0 
      AND access IN(1,1) 
      ORDER BY parent

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l9dks_k2_categories	range	category,published,access,trash	category	8	NULL	12	Using index condition; Bruker filsortering

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1245
    17	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
    16	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:41
    15	K2HelperRoute::getItemRoute()	JROOT/templates/bergensrederiforening_web/html/mod_news_pro_gk5/com_k2/view.php:293
    14	NSP_GK5_com_k2_View::itemLink()	JROOT/templates/bergensrederiforening_web/html/mod_news_pro_gk5/com_k2/view.php:34
    13	NSP_GK5_com_k2_View::header()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:35
    12	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:159
    11	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:34
    10	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

55. Spørringstid: 1.19 ms Etter siste spørring: 9.23 ms Spørreminne: 0.028 MB Minne før spørring: 26.157 MB Rader funnet: 5

    SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
      FROM l9dks_k2_items as i RIGHT JOIN l9dks_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1)  
      AND c.trash = 0 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-08-11 21:04:44' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-08-11 21:04:44' ) 
      AND i.catid IN(10) 
      ORDER BY i.id DESC 
      LIMIT 0, 5

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,category,published,access,trash	PRIMARY	4	const	1
    1	SIMPLE	i	index	item,catid	PRIMARY	4	NULL	11	Using where

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:286
    11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
    10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

56. Spørringstid: 0.85 ms Etter siste spørring: 7.05 ms Spørreminne: 0.028 MB Minne før spørring: 26.201 MB Rader funnet: 5

    SELECT DISTINCT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams 
      FROM l9dks_k2_items as i RIGHT JOIN l9dks_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1)  
      AND c.trash = 0 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-08-11 21:04:44' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-08-11 21:04:44' ) 
      AND i.catid IN(22) 
      ORDER BY i.id DESC 
      LIMIT 0, 5

    Forklar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,category,published,access,trash	PRIMARY	4	const	1
    1	SIMPLE	i	ref	item,catid	catid	4	const	7	Using where; Bruker filsortering

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_content/helper.php:286
    11	modK2ContentHelper::getItems()	JROOT/modules/mod_k2_content/mod_k2_content.php:51
    10	include JROOT/modules/mod_k2_content/mod_k2_content.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

57. Spørringstid: 0.86 ms Etter siste spørring: 8.63 ms Spørreminne: 0.030 MB Minne før spørring: 26.395 MB Rader funnet: 6

    SHOW FULL COLUMNS 
      FROM `l9dks_template_styles`

    Forklar

    'EXPLAIN' er ikke mulig på spørringen: SHOW FULL COLUMNS FROM `l9dks_template_styles`

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    18	JTable->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    17	TemplatesTableStyle->__construct()	JROOT/libraries/joomla/table/table.php:308
    16	JTable::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Samme som oppkall i linjen nedenfor.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
    8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
    7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---

58. Spørringstid: 0.31 ms Etter siste spørring: 0.32 ms Spørreminne: 0.023 MB Minne før spørring: 26.438 MB Rader funnet: 1

    SELECT *
    
      FROM l9dks_template_styles
    
      WHERE `id` = '17'

    Forklar

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

    Profil

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

    Call Stack

    #	Oppkaller	Fil og linjenummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    15	JTable->load()	JROOT/plugins/system/gantry/gantry.php:168
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Samme som oppkall i linjen nedenfor.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
    8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
    7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Legg til xdebug.file_link_format direktivet i php.ini filen for å få koblinger til filer]

    ---