Aktuelt og nyheter

Resultatene fra Maritimt barometer 2018

I samarbeid med de maritime forumene på Vestlandet, kystrederiene og rederiforeningene, lanserte Maritime Bergen Maritim...

28-11-2018 Aktuelt og Nyheter

Samarbeid gir vinnere!

Samarbeid er den nye konkurransekraften, var budskapet til Anne Jacobsen, direktør i NCE Media da Maritime Bergen, Berge...

14-06-2018 Aktuelt og Nyheter

GDPR - Shippingens Svanemerke

Ivaretar du dine kunders rett til å bestemme over egne personopplysninger? Den 7. juni gjennomførte Maritime Bergen i sa...

07-06-2018 Aktuelt og Nyheter

Frokostmøte: Circular Cleanup

Tidlig tirsdagsmorgen holdt Maritime Bergen, i samarbeid med Æra og Norges Rederiforbund, et frokostmøte om innovasjonsp...

29-05-2018 Aktuelt og Nyheter

Bergensrederier samarbeider om cybersikkerhet

Onsdag 18. april gikk startskuddet for et helt nytt samarbeid mellom rederier i Bergensregionen om deling og felles arbe...

20-04-2018 Aktuelt og Nyheter

Rederier inviteres til Forum for Cybersikkerhet

Maritime Bergen, Odfjell SE og Kristian Gerhard Jebsen Skipsrederi og Bergens Rederiforening har gleden av å invitere re...

12-04-2018 Aktuelt og Nyheter

Stinn brakke på årets shipping konferanse

Det var fulle hus da årets NHH Shipping konferanse –LeaderShip 2018 gikk av stabelen i Terminus Hall, onsdag 4. april. ...

09-04-2018 Aktuelt og Nyheter

Trenger Norge et Havinor?

Tidlig mandags morgen holdt Maritime Bergen, i samarbeid med Bergens Rederiforening og Kystrederiene, frokostmøtet «Tren...

22-01-2018 Aktuelt og Nyheter

Ber rederier ta ansvar

Status fra Maritimt Forum for 30. november viser at alle kadettene fra Bergen har fått mønstre på i løpet av høsten. P...

04-12-2017 Aktuelt og Nyheter

Maritim Kalender

Klikk inn på Maritim Kalender og følg med hva som skjer i næringen!

Ledige stillinger

På jakt etter ny jobb i næringen? Klikk deg inn på ledige stillinger

Om oss

Bergens Rederiforening er Norges eldste rederiforening, stiftet i 1899.

Bergens Rederiforening

Bergens Rederiforening er Norges eldste rederiforening, stiftet i 1899, og foreningen fungerer som Bergenskrets av Norges Rederiforbund. Foreningen har omlag 60 medlemsbedrifter som regelmessig møtes til faglige diskusjoner og sosiale sammenkomster.

Joomlas feilsøkingskonsoll

Økt

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

Profileringinformasjon

Tid

Minne

Tid: 22.72 ms / 22.72 ms Minne: 0.722 MB / 0.94 MB Application: afterLoad

Tid: 249.28 ms / 272.00 ms Minne: 10.576 MB / 11.52 MB Application: afterInitialise

Tid: 55.26 ms / 327.26 ms Minne: 2.252 MB / 13.77 MB Application: afterRoute

Tid: 1.38 ms / 328.64 ms Minne: 0.037 MB / 13.81 MB Application: beforeRenderComponent com_content

Tid: 15.67 ms / 344.31 ms Minne: 1.048 MB / 14.85 MB Application: Start JAccess::getAssetRules Old (1)

Tid: 1.87 ms / 346.18 ms Minne: 0.065 MB / 14.92 MB Application: Finish JAccess::getAssetRules Old (1)

Tid: 0.05 ms / 346.23 ms Minne: 0.000 MB / 14.91 MB Application: Start JAccess::preload(components)

Tid: 9.77 ms / 356.01 ms Minne: 0.414 MB / 15.33 MB Application: Finish JAccess::preload(components)

Tid: 53.65 ms / 409.65 ms Minne: 3.035 MB / 18.36 MB Application: afterRenderComponent com_content

Tid: 46.79 ms / 456.44 ms Minne: 2.016 MB / 20.38 MB Application: afterDispatch

Tid: 13.49 ms / 469.93 ms Minne: 0.465 MB / 20.84 MB Application: beforeRenderModule mod_roknavmenu ()

Tid: 29.36 ms / 499.29 ms Minne: 1.078 MB / 21.92 MB Application: afterRenderModule mod_roknavmenu ()

Tid: 14.64 ms / 513.92 ms Minne: 0.027 MB / 21.95 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Tid: 6.48 ms / 520.41 ms Minne: 0.116 MB / 22.06 MB Application: afterRenderModule mod_menu (Bottom Menu)

Tid: 0.18 ms / 520.59 ms Minne: 0.000 MB / 22.06 MB Application: beforeRenderModule mod_custom (Kontakt)

Tid: 1.93 ms / 522.52 ms Minne: 0.012 MB / 22.07 MB Application: afterRenderModule mod_custom (Kontakt)

Tid: 0.37 ms / 522.89 ms Minne: 0.029 MB / 22.10 MB Application: beforeRenderModule mod_news_pro_gk5 (Arrangement)

Tid: 18.13 ms / 541.02 ms Minne: 1.104 MB / 23.20 MB Application: afterRenderModule mod_news_pro_gk5 (Arrangement)

Tid: 0.27 ms / 541.28 ms Minne: 0.000 MB / 23.08 MB Application: beforeRenderModule mod_custom (Bergens Rederiforening)

Tid: 0.27 ms / 541.55 ms Minne: 0.007 MB / 23.09 MB Application: afterRenderModule mod_custom (Bergens Rederiforening)

Tid: 0.09 ms / 541.65 ms Minne: 0.000 MB / 23.08 MB Application: beforeRenderModule mod_custom (Kalender-stillinger-omoss)

Tid: 0.20 ms / 541.85 ms Minne: 0.007 MB / 23.09 MB Application: afterRenderModule mod_custom (Kalender-stillinger-omoss)

Tid: 0.36 ms / 542.21 ms Minne: 0.033 MB / 23.12 MB Application: beforeRenderModule mod_news_pro_gk5 (Aktuelt og nyheter)

Tid: 99.35 ms / 641.55 ms Minne: 0.233 MB / 23.36 MB Application: afterRenderModule mod_news_pro_gk5 (Aktuelt og nyheter)

Tid: 0.44 ms / 642.00 ms Minne: 0.000 MB / 23.20 MB Application: beforeRenderModule mod_unite_revolution (Revolution (Fullwidth))

Tid: 22.19 ms / 664.18 ms Minne: 1.494 MB / 24.69 MB Application: afterRenderModule mod_unite_revolution (Revolution (Fullwidth))

Tid: 0.16 ms / 664.35 ms Minne: 0.000 MB / 24.69 MB Application: beforeRenderModule mod_menu (Top Menu)

Tid: 0.42 ms / 664.77 ms Minne: 0.009 MB / 24.70 MB Application: afterRenderModule mod_menu (Top Menu)

Tid: 0.07 ms / 664.84 ms Minne: 0.000 MB / 24.69 MB Application: beforeRenderModule mod_custom (Contacts (Top))

Tid: 0.25 ms / 665.08 ms Minne: 0.007 MB / 24.70 MB Application: afterRenderModule mod_custom (Contacts (Top))

Tid: 46.38 ms / 711.46 ms Minne: 0.474 MB / 25.17 MB Application: afterRender

Totalt antall database-spørringer: 46.65 ms

Minneforbruk

Database-spørringer

52 spørring(er) logget 46.65 ms

6 duplikat ble funnet.

2 duplikater: #12 #13

2 duplikater: #17 #19

2 duplikater: #29 #36

Spørringstid: 0.56 ms Spørreminne: 0.018 MB Minne før spørring: 2.986 MB Rader funnet: 0

SELECT `data`

  FROM `l9dks_session`

  WHERE `session_id` = 'epqlb2uhmqoobt87h755qfakj2'

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.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	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]

Spørringstid: 0.46 ms Etter siste spørring: 5.93 ms Spørreminne: 0.012 MB Minne før spørring: 3.194 MB Rader funnet: 0

SELECT `session_id`

  FROM `l9dks_session`

  WHERE `session_id` = 'epqlb2uhmqoobt87h755qfakj2' 
  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.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
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.02 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]

Spørringstid: 2.19 ms Etter siste spørring: 0.31 ms Spørreminne: 0.009 MB Minne før spørring: 3.209 MB

INSERT INTO `l9dks_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('epqlb2uhmqoobt87h755qfakj2', 0, 1, '1603510276', 0, '')

Forklar

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

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.02 ms
update	0.13 ms
end	0.01 ms
query end	1.77 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
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]

Spørringstid: 0.61 ms Etter siste spørring: 4.54 ms Spørreminne: 0.027 MB Minne før spørring: 3.466 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.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.19 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
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]

Spørringstid: 0.42 ms Etter siste spørring: 2.49 ms Spørreminne: 0.015 MB Minne før spørring: 3.700 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.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.00 ms
Unlocking tables	0.03 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
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]

Spørringstid: 0.27 ms Etter siste spørring: 1.04 ms Spørreminne: 0.014 MB Minne før spørring: 3.776 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.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.01 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]

Spørringstid: 1.01 ms Etter siste spørring: 0.22 ms Spørreminne: 0.015 MB Minne før spørring: 3.793 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.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.67 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
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]

Spørringstid: 0.53 ms Etter siste spørring: 15.38 ms Spørreminne: 0.016 MB Minne før spørring: 4.633 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.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 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]

Spørringstid: 0.36 ms Etter siste spørring: 0.29 ms Spørreminne: 0.016 MB Minne før spørring: 4.650 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.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: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]

Spørringstid: 0.42 ms Etter siste spørring: 0.18 ms Spørreminne: 0.019 MB Minne før spørring: 4.664 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.12 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
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]

Spørringstid: 0.96 ms Etter siste spørring: 12.94 ms Spørreminne: 0.024 MB Minne før spørring: 5.246 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.06 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.01 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.08 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.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]

Spørringstid: 0.51 ms Etter siste spørring: 26.24 ms Spørreminne: 0.019 MB Minne før spørring: 6.362 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.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 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/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]

Spørringstid: 0.33 ms Etter siste spørring: 0.23 ms Spørreminne: 0.020 MB Minne før spørring: 6.381 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 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
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]

Spørringstid: 0.42 ms Etter siste spørring: 9.10 ms Spørreminne: 0.015 MB Minne før spørring: 6.690 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 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.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
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]

Spørringstid: 0.90 ms Etter siste spørring: 88.00 ms Spørreminne: 0.023 MB Minne før spørring: 10.772 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.06 ms
checking permissions	0.01 ms
closing tables	0.00 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.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.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.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
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/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]

Spørringstid: 0.43 ms Etter siste spørring: 0.32 ms Spørreminne: 0.016 MB Minne før spørring: 10.832 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.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.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]

Spørringstid: 0.25 ms Etter siste spørring: 0.20 ms Spørreminne: 0.020 MB Minne før spørring: 10.850 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.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.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
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]

Spørringstid: 0.23 ms Etter siste spørring: 0.17 ms Spørreminne: 0.016 MB Minne før spørring: 10.864 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
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.00 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]

Spørringstid: 0.22 ms Etter siste spørring: 0.16 ms Spørreminne: 0.020 MB Minne før spørring: 10.880 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.01 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.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: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]

Spørringstid: 1.39 ms Etter siste spørring: 34.78 ms Spørreminne: 0.030 MB Minne før spørring: 11.767 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.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.79 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
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]

Spørringstid: 0.49 ms Etter siste spørring: 20.38 ms Spørreminne: 0.016 MB Minne før spørring: 12.794 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.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	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
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]

Spørringstid: 0.41 ms Etter siste spørring: 2.28 ms Spørreminne: 0.016 MB Minne før spørring: 12.852 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.06 ms
checking permissions	0.02 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.02 ms
statistics	0.02 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.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 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]

Spørringstid: 0.32 ms Etter siste spørring: 0.27 ms Spørreminne: 0.017 MB Minne før spørring: 12.868 MB Rader funnet: 0

SELECT `ip`,`reason`

  FROM l9dks_rsfirewall_lists

  WHERE (`ip`='100.24.125.162' 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.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.03 ms
executing	0.01 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
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]

Spørringstid: 0.32 ms Etter siste spørring: 0.19 ms Spørreminne: 0.017 MB Minne før spørring: 12.884 MB Rader funnet: 0

SELECT `ip`,`reason`

  FROM l9dks_rsfirewall_lists

  WHERE (`ip`='100.24.125.162' 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.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.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.09 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]

Spørringstid: 0.26 ms Etter siste spørring: 0.46 ms Spørreminne: 0.018 MB Minne før spørring: 12.905 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.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.01 ms
preparing	0.01 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]

Spørringstid: 0.51 ms Etter siste spørring: 11.53 ms Spørreminne: 0.024 MB Minne før spørring: 13.049 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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 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
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]

Spørringstid: 0.69 ms Etter siste spørring: 0.34 ms Spørreminne: 0.018 MB Minne før spørring: 13.056 MB

UPDATE `l9dks_extensions`

  SET `params` = '{\"mediaversion\":\"17cc62866563804bf70009a3e86857f5\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Forklar

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

Profil

Status	Duration
starting	0.06 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.06 ms
updating	0.06 ms
end	0.01 ms
query end	0.38 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
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]

Spørringstid: 0.45 ms Etter siste spørring: 5.54 ms Spørreminne: 0.022 MB Minne før spørring: 13.468 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.07 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.03 ms
optimizing	0.02 ms
statistics	0.02 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.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: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]

Spørringstid: 0.54 ms Etter siste spørring: 2.72 ms Spørreminne: 0.027 MB Minne før spørring: 13.660 MB Rader funnet: 5

Duplikat-spørringer: #36

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.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.00 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
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]

Spørringstid: 0.87 ms Etter siste spørring: 17.60 ms Spørreminne: 0.033 MB Minne før spørring: 14.782 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.06 ms
checking permissions	0.01 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.02 ms
executing	0.00 ms
Filling schema table	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.04 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Spørringstid: 0.38 ms Etter siste spørring: 0.36 ms Spørreminne: 0.028 MB Minne før spørring: 14.835 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.01 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Spørringstid: 0.37 ms Etter siste spørring: 0.26 ms Spørreminne: 0.024 MB Minne før spørring: 14.857 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.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.00 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.00 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Spørringstid: 5.71 ms Etter siste spørring: 1.64 ms Spørreminne: 0.027 MB Minne før spørring: 14.918 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.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Spørringstid: 0.96 ms Etter siste spørring: 0.34 ms Spørreminne: 0.027 MB Minne før spørring: 14.952 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.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.42 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Spørringstid: 11.34 ms Etter siste spørring: 6.95 ms Spørreminne: 0.021 MB Minne før spørring: 15.525 MB Rader funnet: 1

SELECT COUNT(*)

  FROM l9dks_content AS a

  LEFT JOIN l9dks_categories AS c 
  ON c.id = a.catid

  LEFT JOIN l9dks_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN l9dks_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN l9dks_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN l9dks_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM l9dks_categories AS cat JOIN l9dks_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 03:31:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 03:31:16')

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_access,idx_catid,idx_featured_catid	idx_featured_catid	1	const	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	rederiforening.a.catid	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	rederiforening.c.id	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Bruker filsortering
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	14	Using where; Using index; Using join buffer (flat, BNL join)

Profil

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

Call Stack

#	Oppkaller	Fil og linjenummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Spørringstid: 0.59 ms Etter siste spørring: 25.38 ms Spørreminne: 0.031 MB Minne før spørring: 17.987 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.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
21	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
20	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/bergensrederiforening_web/html/com_content/featured/default.php:14
13	include JROOT/templates/bergensrederiforening_web/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Spørringstid: 0.44 ms Etter siste spørring: 14.70 ms Spørreminne: 0.022 MB Minne før spørring: 18.464 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.02 ms
statistics	0.06 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
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]

Spørringstid: 1.81 ms Etter siste spørring: 51.53 ms Spørreminne: 0.026 MB Minne før spørring: 20.736 MB Rader funnet: 33

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-10-24 03:31:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-24 03:31:16') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 168 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.00 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.21 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
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]

Spørringstid: 0.47 ms Etter siste spørring: 23.48 ms Spørreminne: 0.024 MB Minne før spørring: 21.646 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 = 168 
  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.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.01 ms
executing	0.02 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.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]

Spørringstid: 0.26 ms Etter siste spørring: 0.26 ms Spørreminne: 0.024 MB Minne før spørring: 21.668 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.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.00 ms
init	0.02 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]

Spørringstid: 0.47 ms Etter siste spørring: 39.77 ms Spørreminne: 0.020 MB Minne før spørring: 22.608 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.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.08 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.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: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]

Spørringstid: 0.43 ms Etter siste spørring: 0.34 ms Spørreminne: 0.019 MB Minne før spørring: 22.630 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-10-24 03:31:16' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2020-10-24 03:31:16' )
			 
  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.07 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.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 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
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]

Spørringstid: 0.60 ms Etter siste spørring: 0.13 ms Spørreminne: 0.025 MB Minne før spørring: 22.654 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.01 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.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.19 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.01 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]

Spørringstid: 0.48 ms Etter siste spørring: 5.84 ms Spørreminne: 0.026 MB Minne før spørring: 23.183 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.08 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.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.10 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
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]

Spørringstid: 0.51 ms Etter siste spørring: 4.24 ms Spørreminne: 0.024 MB Minne før spørring: 23.217 MB Rader funnet: 290

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 = 10 ) 
					
  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	280	Using index

Profil

Status	Duration
starting	0.07 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.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.00 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
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]

Spørringstid: 0.96 ms Etter siste spørring: 0.63 ms Spørreminne: 0.019 MB Minne før spørring: 23.238 MB Rader funnet: 9

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-10-24 03:31:16' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2020-10-24 03:31:16' )
			 
  AND (  content.catid = 10 ) 
			
			 
			
			
		
			
		
		
  ORDER BY 
			 content.created DESC 
		
  LIMIT
			0,9;

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	index	item,catid	created	5	NULL	20	Using where

Profil

Status	Duration
starting	0.06 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.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.58 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
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]

Spørringstid: 0.88 ms Etter siste spørring: 0.13 ms Spørreminne: 0.025 MB Minne før spørring: 23.264 MB Rader funnet: 9

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 = 632 OR  content.id = 593 OR  content.id = 591 OR  content.id = 585 OR  content.id = 572 OR  content.id = 569 OR  content.id = 568 OR  content.id = 556 OR  content.id = 535)
		
  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	9	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.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
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.40 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.01 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]

Spørringstid: 0.53 ms Etter siste spørring: 115.06 ms Spørreminne: 0.028 MB Minne før spørring: 24.625 MB Rader funnet: 1

select * 
  from l9dks_uniterevolution_sliders 
  where id=1

Forklar

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

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.02 ms
optimizing	0.02 ms
statistics	0.21 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution/unitejoomla/db.class.php:149
18	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution/unitejoomla/db.class.php:168
17	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution/helpers/helper_operations.class.php:63
16	HelperUniteOperationsRev->getSliderRawData()	JROOT/administrator/components/com_uniterevolution/helpers/helper_operations.class.php:115
15	HelperUniteOperationsRev->getSlider()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:34
14	HelperUniteRev::getSlider()	JROOT/administrator/components/com_uniterevolution/helpers/output.class.php:107
13	UniteRevolutionOutput->initSlider()	JROOT/administrator/components/com_uniterevolution/helpers/output.class.php:973
12	UniteRevolutionOutput->outputSlider()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:25
11	HelperUniteRev::outputSlider()	JROOT/modules/mod_unite_revolution/mod_unite_revolution.php:40
10	include JROOT/modules/mod_unite_revolution/mod_unite_revolution.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]

Spørringstid: 0.23 ms Etter siste spørring: 0.37 ms Spørreminne: 0.027 MB Minne før spørring: 24.664 MB Rader funnet: 2

SELECT id,title,alias

  FROM l9dks_uniterevolution_sliders

Forklar

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

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.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.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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:49
18	HelperUniteRev::getArrSliders()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:365
17	HelperUniteRev::getArrSlidersAssoc()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:394
16	HelperUniteRev::validateSliderExists()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:404
15	HelperUniteRev::getSlidesRows()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:441
14	HelperUniteRev::getArrSlides()	JROOT/administrator/components/com_uniterevolution/helpers/output.class.php:110
13	UniteRevolutionOutput->initSlider()	JROOT/administrator/components/com_uniterevolution/helpers/output.class.php:973
12	UniteRevolutionOutput->outputSlider()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:25
11	HelperUniteRev::outputSlider()	JROOT/modules/mod_unite_revolution/mod_unite_revolution.php:40
10	include JROOT/modules/mod_unite_revolution/mod_unite_revolution.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]

Spørringstid: 0.80 ms Etter siste spørring: 0.16 ms Spørreminne: 0.026 MB Minne før spørring: 24.690 MB Rader funnet: 3

SELECT *

  FROM l9dks_uniterevolution_slides

  WHERE sliderid='1' 
  and published=1

  ORDER BY ordering asc

Forklar

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

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.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.55 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.02 ms
cleaning up	0.00 ms

Call Stack

#	Oppkaller	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:413
15	HelperUniteRev::getSlidesRows()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:441
14	HelperUniteRev::getArrSlides()	JROOT/administrator/components/com_uniterevolution/helpers/output.class.php:110
13	UniteRevolutionOutput->initSlider()	JROOT/administrator/components/com_uniterevolution/helpers/output.class.php:973
12	UniteRevolutionOutput->outputSlider()	JROOT/administrator/components/com_uniterevolution/helpers/helper.class.php:25
11	HelperUniteRev::outputSlider()	JROOT/modules/mod_unite_revolution/mod_unite_revolution.php:40
10	include JROOT/modules/mod_unite_revolution/mod_unite_revolution.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]

Spørringstid: 0.77 ms Etter siste spørring: 5.80 ms Spørreminne: 0.030 MB Minne før spørring: 24.871 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.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.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.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
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]

Spørringstid: 0.31 ms Etter siste spørring: 0.32 ms Spørreminne: 0.023 MB Minne før spørring: 24.914 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.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.05 ms
preparing	0.00 ms
Unlocking tables	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
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]

43 spørre type(r) logget, sortert etter forekomster.

VELG tabeller:

2 × SELECT template 
  FROM l9dks_template_styles as s

2 × SELECT    content.id AS id       
  FROM     l9dks_k2_items AS content

2 × SELECT `extension_id` 
  FROM `l9dks_extensions`

```
2 × SELECT * 
  FROM l9dks_extensions
```

2 × 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

2 × SELECT `ip`,`reason` 
  FROM l9dks_rsfirewall_lists

2 × 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

2 × SELECT       c.id AS CID     
  FROM       l9dks_k2_categories AS c     
  LEFT JOIN       l9dks_k2_items AS content       
  ON       c.id = content.catid

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `l9dks_extensions`

1 × SELECT params 
  FROM l9dks_extensions AS e

1 × SELECT COUNT(*) 
  FROM l9dks_content AS a 
  LEFT JOIN l9dks_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN l9dks_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN l9dks_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN l9dks_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN l9dks_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM l9dks_categories AS cat JOIN l9dks_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT * 
  FROM l9dks_template_styles

1 × SELECT a.name, a.rules 
  FROM l9dks_assets AS a

1 × 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

1 × SELECT ts.template 
  FROM l9dks_template_styles AS ts 
  INNER JOIN l9dks_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT element 
  FROM l9dks_extensions

1 × select * 
  from l9dks_uniterevolution_sliders

1 × SELECT id,title,alias 
  FROM l9dks_uniterevolution_slider

1 × SELECT * 
  FROM l9dks_uniterevolution_slides

1 × SELECT template 
  FROM l9dks_template_styles

1 × SELECT id, name,  parent 
  FROM l9dks_k2_categories

```
1 × SELECT * 
  FROM l9dks_languages
```

1 × SELECT `path` 
  FROM l9dks_rsfirewall_ignored

1 × SELECT `file` 
  FROM l9dks_rsfirewall_hashes

1 × SELECT folder AS type, element AS name, params 
  FROM l9dks_extensions

1 × SELECT id, rules 
  FROM `l9dks_viewlevels

1 × SELECT `session_id` 
  FROM `l9dks_session`

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

1 × SELECT * 
  FROM l9dks_rsfirewall_configuratio

1 × SELECT extension, file, type 
  FROM l9dks_rokcommon_configs

1 × SELECT `data` 
  FROM `l9dks_session`

```
1 × SELECT * 
  FROM l9dks_assets
```

1 × SELECT * 
  FROM l9dks_rsfirewall_exceptions

1 × SELECT * 
  FROM l9dks_rsfirewall_snapshots

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

1 × SELECT * 
  FROM l9dks_rsfirewall_hashes

1 × SELECT a.rules 
  FROM l9dks_assets AS a

ANDRE tabeller:

1 × SHOW FULL COLUMNS 
  FROM `l9dks_assets

1 × SHOW FULL COLUMNS 
  FROM `l9dks_template_styles

1 × UPDATE `l9dks_extensions` 
  SET `params` = '{\"mediaversion\":\"17cc62866563804bf70009a3e86857f5\"}'

1 × SHOW FULL COLUMNS 
  FROM `l9dks_extensions

1 × SHOW FULL COLUMNS 
  FROM `l9dks_rsfirewall_logs

1 × INSERT INTO `l9dks_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('epqlb2uhmqoobt87h755qfakj2', 0, 1, '1603510276', 0, ''

Aktuelt og nyheter

Resultatene fra Maritimt barometer 2018

Samarbeid gir vinnere!

GDPR - Shippingens Svanemerke

Frokostmøte: Circular Cleanup

Bergensrederier samarbeider om cybersikkerhet

Rederier inviteres til Forum for Cybersikkerhet

Stinn brakke på årets shipping konferanse

Trenger Norge et Havinor?

Ber rederier ta ansvar

Maritim Kalender

Ledige stillinger

Om oss

Bergens Rederiforening

Arrangement

Generalforsamling i Bergens R…

Medlemsmøte i Bergens Rederif…

Julemøte i Bergens Rederifore…

Møt Sturla Henriksen fra Norg…

Fjordtur med Statsraad Lehmku…

Kontakt

Joomlas feilsøkingskonsoll

Økt

Profileringinformasjon

Tid

Minne

Minneforbruk

Database-spørringer

52 spørring(er) logget 46.65 ms

6 duplikat ble funnet.

43 spørre type(r) logget, sortert etter forekomster.

VELG tabeller:

ANDRE tabeller: