Warning: count(): Parameter must be an array or an object that implements Countable in /customers/9/8/9/footballlive.dk/httpd.www/libraries/cms/application/cms.php on line 464 Handball

Tophaandbold (Live)
S corespro
-
-
-
-

Handball.net
-
-
-
-
-

Læs mere ...

Feed ikke fundet.

Joomla! fejlsøgningskonsol

Session

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

Profilinformation

Tid

Hukommelse

Tid: 12.43 ms / 12.43 ms Hukommelse: 0.556 MB / 0.92 MB Application: afterLoad

Tid: 53.81 ms / 66.24 ms Hukommelse: 3.472 MB / 4.39 MB Application: afterInitialise

Tid: 6.06 ms / 72.30 ms Hukommelse: 0.546 MB / 4.94 MB Application: afterRoute

Tid: 5.24 ms / 77.54 ms Hukommelse: 0.205 MB / 5.14 MB Application: beforeRenderComponent com_content

Tid: 9.40 ms / 86.94 ms Hukommelse: 0.864 MB / 6.01 MB Application: Start JAccess::getAssetRules Old (1)

Tid: 0.91 ms / 87.85 ms Hukommelse: 0.035 MB / 6.04 MB Application: Finish JAccess::getAssetRules Old (1)

Tid: 0.03 ms / 87.87 ms Hukommelse: 0.000 MB / 6.04 MB Application: New JAccess Preloading Process(com_content.category)

Tid: 1.00 ms / 88.88 ms Hukommelse: 0.100 MB / 6.14 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Tid: 1.50 ms / 90.38 ms Hukommelse: 0.149 MB / 6.29 MB Application: After preloadPermissions (com_content.category)

Tid: 0.01 ms / 90.39 ms Hukommelse: 0.001 MB / 6.29 MB Application: End New JAccess Preloading Process(com_content.category)

Tid: 0.01 ms / 90.40 ms Hukommelse: 0.001 MB / 6.29 MB Application: Start JAccess::getAssetRules New (com_content.category.9)

Tid: 0.05 ms / 90.45 ms Hukommelse: 0.007 MB / 6.30 MB Application: Finish JAccess::getAssetRules New (com_content.category.9)

Tid: 4.65 ms / 95.10 ms Hukommelse: 0.259 MB / 6.56 MB Application: Start JAccess::preload(components)

Tid: 2.61 ms / 97.71 ms Hukommelse: 0.196 MB / 6.75 MB Application: Finish JAccess::preload(components)

Tid: 33.38 ms / 131.09 ms Hukommelse: 1.200 MB / 7.95 MB Application: afterRenderComponent com_content

Tid: 2.15 ms / 133.24 ms Hukommelse: 0.092 MB / 8.04 MB Application: afterDispatch

Tid: 4.17 ms / 137.40 ms Hukommelse: 0.114 MB / 8.16 MB Application: beforeRenderModule mod_search (Søg)

Tid: 2.44 ms / 139.84 ms Hukommelse: 0.322 MB / 8.48 MB Application: afterRenderModule mod_search (Søg)

Tid: 0.06 ms / 139.90 ms Hukommelse: 0.000 MB / 8.48 MB Application: beforeRenderModule mod_feed (Bold.dk)

Tid: 462.73 ms / 602.63 ms Hukommelse: 0.150 MB / 8.63 MB Application: afterRenderModule mod_feed (Bold.dk)

Tid: 0.13 ms / 602.76 ms Hukommelse: 0.000 MB / 8.63 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Tid: 1.52 ms / 604.28 ms Hukommelse: 0.020 MB / 8.65 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Tid: 0.12 ms / 604.40 ms Hukommelse: 0.001 MB / 8.65 MB Application: beforeRenderModule mod_menu (Main Menu)

Tid: 4.77 ms / 609.17 ms Hukommelse: 0.077 MB / 8.72 MB Application: afterRenderModule mod_menu (Main Menu)

Tid: 2.00 ms / 611.17 ms Hukommelse: 0.047 MB / 8.77 MB Application: afterRender

Database forespørgsler total: 21.67 ms

Hukommelsesforbrug

Database forespørgsler

27 forespørgsler logget 21.67 ms

Forespørgsels tid: 0.29 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 2.454 MB Rækker returneret: 0

SELECT `data`

  FROM `ldmjx_session`

  WHERE `session_id` = 'ee436e5fdd7e8cbba32ef198689388d6'

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ldmjx_session	const	PRIMARY	PRIMARY	602	const	1

Profil

Status	Duration
starting	0.03 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Kalder	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 kald i linjen nedenunder.
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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.36 ms Efter sidste forespørgsel: 2.54 ms Forespørgsels hukommelse: 0.003 MB hukommelse før forespørgsel: 2.589 MB

DELETE 

  FROM `ldmjx_session`

  WHERE `time` < '1547989223'

Forklar

FORKLAR ikke mulig på forespørgsel: DELETE FROM `ldmjx_session` WHERE `time` < '1547989223'

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.06 ms
updating	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 0.08 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 2.594 MB Rækker returneret: 0

SELECT `session_id`

  FROM `ldmjx_session`

  WHERE `session_id` = 'ee436e5fdd7e8cbba32ef198689388d6' 
  LIMIT 1

Forklar

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

Profil

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

Call Stack

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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.69 ms Efter sidste forespørgsel: 0.11 ms Forespørgsels hukommelse: 0.003 MB hukommelse før forespørgsel: 2.599 MB

INSERT INTO `ldmjx_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('ee436e5fdd7e8cbba32ef198689388d6', 0, 1, '1547990123', 0, '')

Forklar

FORKLAR ikke mulig på forespørgsel: INSERT INTO `ldmjx_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('ee436e5fdd7e8cbba32ef198689388d6', 0, 1, '1547990123', 0, '')

Profil

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

Call Stack

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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.83 ms Efter sidste forespørgsel: 3.11 ms Forespørgsels hukommelse: 0.028 MB hukommelse før forespørgsel: 2.760 MB Rækker returneret: 33

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ldmjx_extensions`

  WHERE `type` = 'component'

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ldmjx_extensions	ref	extension	extension	62	const	33	Using index condition

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

Call Stack

#	Kalder	Fil og linjenummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.49 ms Efter sidste forespørgsel: 2.04 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 2.880 MB Rækker returneret: 2

SELECT b.id

  FROM ldmjx_usergroups AS a

  LEFT JOIN ldmjx_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

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	3	Using where; Using index

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.07 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.03 ms
cleaning up	0.01 ms

Call Stack

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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.28 ms Efter sidste forespørgsel: 0.83 ms Forespørgsels hukommelse: 0.023 MB hukommelse før forespørgsel: 2.988 MB Rækker returneret: 4

SELECT id, rules

  FROM `ldmjx_viewlevels`

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ldmjx_viewlevels	ALL	NULL	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	4

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.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.03 ms
cleaning up	0.01 ms

Call Stack

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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.60 ms Efter sidste forespørgsel: 0.10 ms Forespørgsels hukommelse: 0.025 MB hukommelse før forespørgsel: 2.996 MB Rækker returneret: 45

SELECT folder AS type, element AS name, params

  FROM ldmjx_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ldmjx_extensions	ref	extension	extension	62	const	56	Using index condition; Using where; Anvender filesort

Profil

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

Call Stack

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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.45 ms Efter sidste forespørgsel: 12.04 ms Forespørgsels hukommelse: 0.022 MB hukommelse før forespørgsel: 4.034 MB Rækker returneret: 1

SELECT `enabled`

  FROM `ldmjx_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 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.00 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	Fil og linjenummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.73 ms Efter sidste forespørgsel: 5.71 ms Forespørgsels hukommelse: 0.032 MB hukommelse før forespørgsel: 4.532 MB Rækker returneret: 9

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 ldmjx_menu AS m

  LEFT JOIN ldmjx_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	9	Using index condition; Using where; Anvender filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	footballlive_dk.m.component_id	1	Using where

Profil

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

Call Stack

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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.51 ms Efter sidste forespørgsel: 4.32 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 4.971 MB Rækker returneret: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ldmjx_extensions`

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

Forklar

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.05 ms
optimizing	0.01 ms
statistics	0.04 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	Fil og linjenummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.79 ms Efter sidste forespørgsel: 0.12 ms Forespørgsels hukommelse: 0.005 MB hukommelse før forespørgsel: 4.961 MB

UPDATE `ldmjx_extensions`

  SET `params` = '{\"mediaversion\":\"f64415c44f8e2626ed4ddd64a1a98185\"}'

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

Forklar

FORKLAR ikke mulig på forespørgsel: UPDATE `ldmjx_extensions` SET `params` = '{\"mediaversion\":\"f64415c44f8e2626ed4ddd64a1a98185\"}' WHERE `type` = 'library' AND `element` = 'joomla'

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.04 ms
updating	0.05 ms
end	0.01 ms
query end	0.23 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	Fil og linjenummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.45 ms Efter sidste forespørgsel: 1.62 ms Forespørgsels hukommelse: 0.024 MB hukommelse før forespørgsel: 5.126 MB Rækker returneret: 1

SELECT *

  FROM ldmjx_languages

  WHERE published=1

  ORDER BY ordering ASC

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ldmjx_languages	ALL	NULL	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	1	Using where; Anvender filesort

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.02 ms
executing	0.00 ms
Sorting result	0.04 ms
Sending data	0.04 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	Fil og linjenummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.58 ms Efter sidste forespørgsel: 0.36 ms Forespørgsels hukommelse: 0.021 MB hukommelse før forespørgsel: 5.136 MB Rækker returneret: 2

SELECT id, home, template, s.params

  FROM ldmjx_template_styles as s

  LEFT JOIN ldmjx_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	62	const	4	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	4	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.08 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.05 ms
cleaning up	0.02 ms

Call Stack

#	Kalder	Fil og linjenummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 1.08 ms Efter sidste forespørgsel: 7.66 ms Forespørgsels hukommelse: 0.032 MB hukommelse før forespørgsel: 5.961 MB Rækker returneret: 8

SHOW FULL COLUMNS 
  FROM `ldmjx_assets`

Forklar

FORKLAR ikke mulig på forespørgsel: SHOW FULL COLUMNS FROM `ldmjx_assets`

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.33 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.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	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/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.37 ms Efter sidste forespørgsel: 0.50 ms Forespørgsels hukommelse: 0.029 MB hukommelse før forespørgsel: 6.001 MB Rækker returneret: 1

SELECT *

  FROM ldmjx_assets

  WHERE `id` = '1'

Forklar

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.01 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.05 ms
cleaning up	0.02 ms

Call Stack

#	Kalder	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/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.42 ms Efter sidste forespørgsel: 0.11 ms Forespørgsels hukommelse: 0.027 MB hukommelse før forespørgsel: 6.010 MB Rækker returneret: 1

SELECT a.rules

  FROM ldmjx_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,152	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.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.11 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	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/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.81 ms Efter sidste forespørgsel: 0.48 ms Forespørgsels hukommelse: 0.040 MB hukommelse før forespørgsel: 6.038 MB Rækker returneret: 171

SELECT a.id, a.parent_id

  FROM ldmjx_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	238	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.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.33 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.05 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	Fil og linjenummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
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/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.92 ms Efter sidste forespørgsel: 0.50 ms Forespørgsels hukommelse: 0.048 MB hukommelse før forespørgsel: 6.154 MB Rækker returneret: 171

SELECT a.id, a.name, a.rules

  FROM ldmjx_assets AS a

  WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	238	Using where

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.38 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	Fil og linjenummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
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/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 2.39 ms Efter sidste forespørgsel: 1.39 ms Forespørgsels hukommelse: 0.037 MB hukommelse før forespørgsel: 6.432 MB Rækker returneret: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

  FROM ldmjx_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ldmjx_categories AS cat JOIN ldmjx_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

  LEFT JOIN ldmjx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `ldmjx_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=9

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Anvender filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	25	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	footballlive_dk.c.id	5	Using where
1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	footballlive_dk.c.id	10	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Anvender filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	25	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.17 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.08 ms
statistics	0.20 ms
preparing	0.01 ms
Unlocking tables	0.07 ms
executing	0.01 ms
Creating tmp table	0.42 ms
Copying to tmp table	0.04 ms
executing	0.00 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.03 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.36 ms
Sorting result	0.03 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.12 ms
end	0.01 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.05 ms
cleaning up	0.02 ms

Call Stack

#	Kalder	Fil og linjenummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/models/category.php:354
13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.54 ms Efter sidste forespørgsel: 1.22 ms Forespørgsels hukommelse: 0.029 MB hukommelse før forespørgsel: 6.554 MB Rækker returneret: 33

SELECT element

  FROM ldmjx_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ldmjx_extensions	ref	extension	extension	62	const	33	Using index condition; Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 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.04 ms
cleaning up	0.02 ms

Call Stack

#	Kalder	Fil og linjenummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.93 ms Efter sidste forespørgsel: 0.08 ms Forespørgsels hukommelse: 0.030 MB hukommelse før forespørgsel: 6.569 MB Rækker returneret: 33

SELECT a.name, a.rules

  FROM ldmjx_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','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 INDEX NØGLE KUNNE ANVENDES	NULL	NULL	238	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.30 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Kalder	Fil og linjenummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 2.17 ms Efter sidste forespørgsel: 1.16 ms Forespørgsels hukommelse: 0.052 MB hukommelse før forespørgsel: 6.751 MB Rækker returneret: 9

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM ldmjx_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-01-20 13:15:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-01-20 13:15:23')

  ORDER BY  c.lft,  a.title,  a.created   
  LIMIT 80

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Anvender filesort
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	9	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	footballlive_dk.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	footballlive_dk.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	footballlive_dk.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Anvender filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	25	Using where; Using index; Using join buffer (flat, BNL join)

Profil

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

Call Stack

#	Kalder	Fil og linjenummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 1.09 ms Efter sidste forespørgsel: 1.44 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 7.065 MB Rækker returneret: 1

SELECT COUNT(*)

  FROM ldmjx_content AS a

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

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-01-20 13:15:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-01-20 13:15:23')

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	9	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Anvender filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	25	Using where; Using index; Using join buffer (flat, BNL join)

Profil

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

Call Stack

#	Kalder	Fil og linjenummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.60 ms Efter sidste forespørgsel: 1.30 ms Forespørgsels hukommelse: 0.035 MB hukommelse før forespørgsel: 7.180 MB Rækker returneret: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ldmjx_contentitem_tag_map` AS m 

  INNER JOIN `ldmjx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 9 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_tag	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	footballlive_dk.m.tag_id	1	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 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.09 ms
cleaning up	0.03 ms

Call Stack

#	Kalder	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 2.13 ms Efter sidste forespørgsel: 8.95 ms Forespørgsels hukommelse: 0.039 MB hukommelse før forespørgsel: 7.967 MB Rækker returneret: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM ldmjx_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ldmjx_categories AS cat JOIN ldmjx_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

  LEFT JOIN ldmjx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=9

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Forklar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Anvender filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	INGEN INDEX NØGLE KUNNE ANVENDES	NULL	NULL	25	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	footballlive_dk.c.id	5	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Anvender filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	25	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.01 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.14 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.07 ms
statistics	0.17 ms
preparing	0.01 ms
Unlocking tables	0.06 ms
executing	0.01 ms
Creating tmp table	0.37 ms
Copying to tmp table	0.04 ms
executing	0.00 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.06 ms
Sorting result	0.02 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.14 ms
Sorting result	0.03 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Kalder	Fil og linjenummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
18	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
17	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/category/tmpl/blog_item.php:59
16	include JROOT/components/com_content/views/category/tmpl/blog_item.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/components/com_content/views/category/tmpl/blog.php:86
14	include JROOT/components/com_content/views/category/tmpl/blog.php	JROOT/libraries/legacy/view/legacy.php:677
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
12	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:233
11	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:258
10	ContentViewCategory->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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

Forespørgsels tid: 0.85 ms Efter sidste forespørgsel: 19.69 ms Forespørgsels hukommelse: 0.026 MB hukommelse før forespørgsel: 8.165 MB Rækker returneret: 4

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM ldmjx_modules AS m

  LEFT JOIN ldmjx_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN ldmjx_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 <= '2019-01-20 13:15:23') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-01-20 13:15:23') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 108 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	6	Using index condition; Using where; Anvender filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	footballlive_dk.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	footballlive_dk.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.06 ms
executing	0.00 ms
Sorting result	0.09 ms
Sending data	0.11 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.04 ms
cleaning up	0.02 ms

Call Stack

#	Kalder	Fil og linjenummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/protostar/index.php:94
7	require JROOT/templates/protostar/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php: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

[Tilføj xdebug.file_link_format direktiv til din php.ini fil for at anvende link til filer.]

26 forespørgselstyper logget, sorteret efter forekomster FALDENDE

SELECT tabeller:

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

1 × SELECT `data` 
  FROM `ldmjx_session`

1 × SELECT a.id, a.parent_id 
  FROM ldmjx_assets AS a

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM ldmjx_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM ldmjx_categories AS cat JOIN ldmjx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ldmjx_contentitem_tag_map` AS m  
  INNER JOIN `ldmjx_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

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

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

1 × SELECT element 
  FROM ldmjx_extensions

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM ldmjx_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM ldmjx_categories AS cat JOIN ldmjx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.name, a.rules 
  FROM ldmjx_assets AS a

1 × SELECT a.rules 
  FROM ldmjx_assets AS a

1 × SELECT `session_id` 
  FROM `ldmjx_session`

```
1 × SELECT * 
  FROM ldmjx_assets
```

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

```
1 × SELECT * 
  FROM ldmjx_languages
```

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 ldmjx_menu AS m 
  LEFT JOIN ldmjx_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `enabled` 
  FROM `ldmjx_extensions`

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

1 × SELECT id, rules 
  FROM `ldmjx_viewlevels

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ldmjx_modules AS m 
  LEFT JOIN ldmjx_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ldmjx_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

OTHER tabeller:

```
1 × DELETE  
  FROM `ldmjx_session`
```

1 × INSERT INTO `ldmjx_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('ee436e5fdd7e8cbba32ef198689388d6', 0, 1, '1547990123', 0, ''

1 × UPDATE `ldmjx_extensions` 
  SET `params` = '{\"mediaversion\":\"f64415c44f8e2626ed4ddd64a1a98185\"}'

1 × SHOW FULL COLUMNS 
  FROM `ldmjx_assets

Denmark

Germany

Norway

Sweden

Diverse

International

Spain

Ukraine

France

Søg

Bold.dk

Joomla! fejlsøgningskonsol

Session

Profilinformation

Tid

Hukommelse

Hukommelsesforbrug

Database forespørgsler

27 forespørgsler logget 21.67 ms

26 forespørgselstyper logget, sorteret efter forekomster FALDENDE

SELECT tabeller:

OTHER tabeller: