Alla kontakter - FaRledare.se

Nr.	Namn	Position
0	Ingbritt Ekman	Akademiskt Primärvårdscentrum (APC)
1	Eva Flygare Wallén	Akademiskt primärvårdscentrum (APC)
2	Sofia Trygg-Lycke	Akademiskt primärvårdscentrum (APC)
3	Elin Ekblom Bak	FaR-Lotsmottagning, GIH
4	Cecilia Berg	Akademiskt Primärvårdscentrum (APC)
5	Sara Petersson	Akademiskt Primärvårdscentrum (APC)
6	Cassandra Spoonberg	Akademiskt Primärvårdscentrum (APC)
7	Lena Björklund-Norrman	Akademiskt Primärvårdscentrum (APC)
8	Robert Bergkvist	Akademiskt Pimärvårdscentrum (APC)
9	Katri Harcke	Akademiskt Primärvårdscentrum (APC)
10	Jessica Bergfoth	Akademiskt Primärvårdscentrum (APC)

Joomlas felsökningskonsoll

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576323101,
                "last": 1576323101,
                "now": 1576323101
            },
            "client": {
                "forwarded": "18.207.255.49"
            },
            "token": "i8U9DraaUipJzGzvdviua5zeI8cv8XNK"
        },
        "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

Minne

Tid: 66.64 ms / 66.64 ms Minne: 1.794 MB / 2.21 MB Application: afterLoad

Tid: 239.98 ms / 306.62 ms Minne: 5.676 MB / 7.89 MB Application: afterInitialise

Tid: 60.43 ms / 367.05 ms Minne: 1.413 MB / 9.30 MB Application: afterRoute

Tid: 11.65 ms / 378.69 ms Minne: 0.292 MB / 9.59 MB Application: beforeRenderComponent com_contact

Tid: 47.33 ms / 426.02 ms Minne: 0.566 MB / 10.16 MB Application: Before Access::preloadComponents (all components)

Tid: 2.02 ms / 428.04 ms Minne: 0.060 MB / 10.22 MB Application: After Access::preloadComponents (all components)

Tid: 0.06 ms / 428.10 ms Minne: 0.000 MB / 10.22 MB Application: Before Access::getAssetRules (id:7 name:com_contact)

Tid: 3.15 ms / 431.25 ms Minne: 0.026 MB / 10.24 MB Application: After Access::getAssetRules (id:7 name:com_contact)

Tid: 69.07 ms / 500.32 ms Minne: 1.162 MB / 11.40 MB Application: afterRenderComponent com_contact

Tid: 20.61 ms / 520.94 ms Minne: 0.280 MB / 11.68 MB Application: afterDispatch

Tid: 40.07 ms / 561.00 ms Minne: 0.317 MB / 12.00 MB Application: beforeRenderModule mod_login (Logga in som arrangör)

Tid: 16.66 ms / 577.67 ms Minne: 0.148 MB / 12.15 MB Application: afterRenderModule mod_login (Logga in som arrangör)

Tid: 0.06 ms / 577.72 ms Minne: 0.000 MB / 12.15 MB Application: beforeRenderModule mod_custom (FaR-Footer)

Tid: 4.88 ms / 582.61 ms Minne: 0.006 MB / 12.15 MB Application: afterRenderModule mod_custom (FaR-Footer)

Tid: 0.08 ms / 582.68 ms Minne: 0.000 MB / 12.15 MB Application: beforeRenderModule mod_menu (Kontakt)

Tid: 17.87 ms / 600.56 ms Minne: 0.111 MB / 12.27 MB Application: afterRenderModule mod_menu (Kontakt)

Tid: 0.09 ms / 600.65 ms Minne: 0.000 MB / 12.26 MB Application: beforeRenderModule mod_menu (Utbildningar)

Tid: 11.02 ms / 611.68 ms Minne: 0.038 MB / 12.30 MB Application: afterRenderModule mod_menu (Utbildningar)

Tid: 0.10 ms / 611.78 ms Minne: 0.000 MB / 12.30 MB Application: beforeRenderModule mod_articles_latest (Aktuellt)

Tid: 7.42 ms / 619.20 ms Minne: 0.142 MB / 12.44 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tid: 0.08 ms / 619.28 ms Minne: 0.007 MB / 12.45 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tid: 6.85 ms / 626.13 ms Minne: 0.090 MB / 12.54 MB Application: afterRenderModule mod_articles_latest (Aktuellt)

Tid: 0.12 ms / 626.25 ms Minne: 0.000 MB / 12.47 MB Application: beforeRenderModule mod_search (Sök)

Tid: 8.26 ms / 634.51 ms Minne: 0.015 MB / 12.48 MB Application: afterRenderModule mod_search (Sök)

Tid: 2237.79 ms / 2872.30 ms Minne: 1.054 MB / 13.54 MB Application: afterRender

Databasfrågor totalt: 27.63 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gusqo_session	const	PRIMARY	PRIMARY	194	const	1

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

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

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

#	Uppringare	Fil och radnummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN inte möjlig i fråga: INSERT INTO `gusqo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3730613361333566393539646430383064653464313461656531663763373831', 1, 1576323101, 0, '', 0)

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.00 ms
After table lock	0.00 ms
init	0.01 ms
update	0.07 ms
Waiting for query cache lock	0.00 ms
update	0.02 ms
end	0.00 ms
query end	1.23 ms
closing tables	0.02 ms
freeing items	0.03 ms
updating status	0.02 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.12 ms Efter sista fråga: 10.49 ms Frågeminne: 0.040 MB Minne före fråga: 4.277 MB Returnerade rader: 43

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

  FROM `gusqo_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Förklara

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

Profil

Status	Duration
starting	0.15 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.00 ms
After 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.26 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
updating status	0.04 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Samma som samtal i raden nedan.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.66 ms Efter sista fråga: 8.02 ms Frågeminne: 0.023 MB Minne före fråga: 4.491 MB Returnerade rader: 4

SELECT id, rules

  FROM `gusqo_viewlevels`

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gusqo_viewlevels	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	4

Profil

Status	Duration
starting	0.15 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.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.51 ms Efter sista fråga: 0.08 ms Frågeminne: 0.023 MB Minne före fråga: 4.503 MB Returnerade rader: 1

SELECT b.id

  FROM gusqo_usergroups AS a

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

  WHERE a.id = 1

Förklara

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	Using where; Using index

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.31 ms Efter sista fråga: 1.35 ms Frågeminne: 0.034 MB Minne före fråga: 4.633 MB Returnerade rader: 95

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM gusqo_extensions

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

  ORDER BY ordering

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gusqo_extensions	ref	extension	extension	62	const	143	Using index condition; Using where; Använder filsortering

Profil

Status	Duration
starting	0.11 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.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.07 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.40 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
updating status	0.02 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Samma som samtal i raden nedan.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 2.95 ms Efter sista fråga: 160.38 ms Frågeminne: 0.126 MB Minne före fråga: 8.068 MB Returnerade rader: 84

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

  LEFT JOIN gusqo_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

Förklara

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	100	Using index condition; Using where; Använder filsortering
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.m.component_id	1	Using where

Profil

Status	Duration
starting	0.26 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.00 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.43 ms
Sending data	1.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.09 ms
updating status	0.29 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Samma som samtal i raden nedan.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.43 ms Efter sista fråga: 35.29 ms Frågeminne: 0.048 MB Minne före fråga: 9.143 MB Returnerade rader: 24

SELECT id, home, template, s.params

  FROM gusqo_template_styles as s

  LEFT JOIN gusqo_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

Förklara

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	6	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	152	4001293-farledare-joomla.e.element	3	Using index condition; Using where

Profil

Status	Duration
starting	0.26 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.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
updating status	0.02 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.07 ms Efter sista fråga: 14.84 ms Frågeminne: 0.025 MB Minne före fråga: 9.398 MB Returnerade rader: 1

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

  FROM `gusqo_extensions`

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

Förklara

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

Profil

Status	Duration
starting	0.24 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.00 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
updating status	0.04 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Samma som samtal i raden nedan.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 2.00 ms Efter sista fråga: 0.19 ms Frågeminne: 0.005 MB Minne före fråga: 9.388 MB

UPDATE `gusqo_extensions`

  SET `params` = '{\"mediaversion\":\"163d94f907f2abc7feca5208c60c2a13\"}'

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

Förklara

EXPLAIN inte möjlig i fråga: UPDATE `gusqo_extensions` SET `params` = '{\"mediaversion\":\"163d94f907f2abc7feca5208c60c2a13\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.13 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.00 ms
After table lock	0.01 ms
init	0.08 ms
Updating	0.07 ms
end	0.01 ms
Waiting for query cache lock	0.04 ms
end	0.02 ms
query end	1.27 ms
closing tables	0.04 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.86 ms Efter sista fråga: 4.64 ms Frågeminne: 0.025 MB Minne före fråga: 9.568 MB Returnerade rader: 1

SELECT *

  FROM gusqo_languages

  WHERE published=1

  ORDER BY ordering ASC

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gusqo_languages	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	1	Using where; Använder filsortering

Profil

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

Anropsstack

#	Uppringare	Fil och radnummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.69 ms Efter sista fråga: 49.25 ms Frågeminne: 0.032 MB Minne före fråga: 10.164 MB Returnerade rader: 43

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `gusqo_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforums2','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djclassifieds','com_djimageslider','com_docman','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_osmeta','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gusqo_assets	ALL	idx_asset_name	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	386	Using where

Profil

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

Anropsstack

#	Uppringare	Fil och radnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_contact/models/featured.php:238
13	ContactModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/featured/view.html.php:78
10	ContactViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.50 ms Efter sista fråga: 5.41 ms Frågeminne: 0.046 MB Minne före fråga: 10.259 MB Returnerade rader: 11

SELECT a.*,c.published as cat_published, c.published AS parents_published

  FROM `gusqo_contact_details` AS a

  INNER JOIN gusqo_categories AS c 
  ON c.id = a.catid

  WHERE a.access IN (1,1,4) 
  AND a.featured=1 
  AND c.access IN (1,1,4) 
  AND c.published = 1 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-14 11:31:41') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-14 11:31:41')

  ORDER BY ordering ASC 
  LIMIT 100

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_state	1	const	11	Using where; Använder filsortering
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	4001293-farledare-joomla.a.catid	1	Using where

Profil

Status	Duration
starting	0.23 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.00 ms
After table lock	0.01 ms
init	0.08 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.16 ms
Sending data	0.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
updating status	0.02 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_contact/models/featured.php:117
12	ContactModelFeatured->getItems()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/featured/view.html.php:79
10	ContactViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.23 ms Efter sista fråga: 3.20 ms Frågeminne: 0.025 MB Minne före fråga: 10.499 MB Returnerade rader: 1

SELECT COUNT(*)

  FROM `gusqo_contact_details` AS a

  INNER JOIN gusqo_categories AS c 
  ON c.id = a.catid

  WHERE a.access IN (1,1,4) 
  AND a.featured=1 
  AND c.access IN (1,1,4) 
  AND c.published = 1 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-14 11:31:41') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-14 11:31:41')

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_state	1	const	11	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	4001293-farledare-joomla.a.catid	1	Using where

Profil

Status	Duration
starting	0.27 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.01 ms
After table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
updating status	0.04 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_contact/views/featured/view.html.php:83
10	ContactViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.53 ms Efter sista fråga: 50.17 ms Frågeminne: 0.042 MB Minne före fråga: 11.373 MB Returnerade rader: 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 `gusqo_categories` AS `s`

  INNER JOIN `gusqo_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1,4) 
  AND c.published = 1 
  AND s.id = 125

  ORDER BY c.lft

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Använder filsortering
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	157	NULL	9	Using index condition; Using where

Profil

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

Anropsstack

#	Uppringare	Fil och radnummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/router.php:68
25	ContactRouter->getCategorySegment()	Samma som samtal i raden nedan.
24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default_items.php:107
15	include JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default_items.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default.php:22
13	include JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_contact/views/featured/view.html.php:136
10	ContactViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.38 ms Efter sista fråga: 2.56 ms Frågeminne: 0.043 MB Minne före fråga: 11.428 MB Returnerade rader: 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 `gusqo_categories` AS `s`

  INNER JOIN `gusqo_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1,4) 
  AND c.published = 1 
  AND s.id = 131

  ORDER BY c.lft

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Använder filsortering
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	157	NULL	9	Using index condition; Using where

Profil

Status	Duration
starting	0.32 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.08 ms
optimizing	0.04 ms
statistics	0.17 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.10 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
updating status	0.04 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/router.php:68
25	ContactRouter->getCategorySegment()	Samma som samtal i raden nedan.
24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default_items.php:107
15	include JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default_items.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default.php:22
13	include JROOT/plugins/system/t3/base-bs3/html/com_contact/featured/default.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_contact/views/featured/view.html.php:136
10	ContactViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contact/contact.php:29
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.84 ms Efter sista fråga: 47.29 ms Frågeminne: 0.030 MB Minne före fråga: 11.988 MB Returnerade rader: 7

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

  FROM gusqo_modules AS m

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

  LEFT JOIN gusqo_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-12-14 11:31:41') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-14 11:31:41') 
  AND m.access IN (1,1,4) 
  AND m.client_id = 0 
  AND (mm.menuid = 785 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	49	Using index condition; Using where; Använder filsortering
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	4001293-farledare-joomla.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.m.id	2	Using where; Using index

Profil

Status	Duration
starting	0.32 ms
checking permissions	0.01 ms
checking permissions	0.00 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
After table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.00 ms
Sorting result	0.22 ms
Sending data	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
updating status	0.04 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Samma som samtal i raden nedan.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:633
12	T3Template->countModules()	JROOT/templates/ja_medicare/tpls/blocks/topbar.php:10
11	include JROOT/templates/ja_medicare/tpls/blocks/topbar.php	JROOT/plugins/system/t3/includes/core/template.php:195
10	T3Template->loadBlock()	JROOT/templates/ja_medicare/tpls/malgrupp_undersida.php:36
9	include JROOT/templates/ja_medicare/tpls/malgrupp_undersida.php	JROOT/plugins/system/t3/includes/core/template.php:221
8	T3Template->loadLayout()	JROOT/templates/ja_medicare/index.php:34
7	require JROOT/templates/ja_medicare/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.52 ms Efter sista fråga: 75.35 ms Frågeminne: 0.040 MB Minne före fråga: 12.447 MB Returnerade rader: 3

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM gusqo_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,4) 
  AND c.access IN (1,1,4) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (100) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-14 11:31:41') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-14 11:31:41')

  ORDER BY a.created DESC 
  LIMIT 3

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Använder filsortering
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	8	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.a.id	1	Using where

Profil

Status	Duration
starting	0.34 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.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.10 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.07 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.07 ms
updating status	0.04 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 0.81 ms Efter sista fråga: 2.09 ms Frågeminne: 0.040 MB Minne före fråga: 12.544 MB Returnerade rader: 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 `gusqo_categories` AS `s`

  INNER JOIN `gusqo_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,4) 
  AND c.published = 1 
  AND s.id = 100

  ORDER BY c.lft

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	11	Using index condition; Using where

Profil

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

Anropsstack

#	Uppringare	Fil och radnummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Samma som samtal i raden nedan.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

Frågetid: 1.01 ms Efter sista fråga: 2239.06 ms Frågeminne: 0.022 MB Minne före fråga: 13.266 MB Returnerade rader: 1

SELECT sleep_until < NOW() 
  FROM gusqo_scheduler_metadata 
  WHERE type = 'metadata' 
  LIMIT 1

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	gusqo_scheduler_metadata	const	unique_type	unique_type	98	const	1

Profil

Status	Duration
starting	0.27 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
After table lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
updating status	0.04 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/scheduler/scheduler.php:59
8	PlgSystemScheduler->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/plugins/system/scheduler/scheduler.php:98
6	PlgSystemScheduler->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lägg till xdebug.file_link_format direktiv till din php.ini fil att ha länkar till filer]

18 Loggade frågetyper. Sorterade efter förekomst

SELECT Tabeller:

3 × 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 `gusqo_categories` AS `s` 
  INNER JOIN `gusqo_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

1 × SELECT `data` 
  FROM `gusqo_session`

1 × SELECT `session_id` 
  FROM `gusqo_session`

1 × SELECT id, rules 
  FROM `gusqo_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM gusqo_extensions

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

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

```
1 × SELECT * 
  FROM gusqo_languages
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `gusqo_assets`

1 × SELECT a.*,c.published as cat_published, c.published AS parents_published 
  FROM `gusqo_contact_details` AS a 
  INNER JOIN gusqo_categories AS c 
  ON c.id = a.catid

1 × SELECT COUNT(*) 
  FROM `gusqo_contact_details` AS a 
  INNER JOIN gusqo_categories AS c 
  ON c.id = a.catid

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

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM gusqo_content AS a 
  LEFT JOIN gusqo_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN gusqo_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN gusqo_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN gusqo_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN gusqo_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT sleep_until < NOW() 
  FROM gusqo_scheduler_metadata

OTHER Tabeller:

1 × INSERT INTO `gusqo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3730613361333566393539646430383064653464313461656531663763373831', 1, 1576323101, 0, '', 0

1 × UPDATE `gusqo_extensions` 
  SET `params` = '{\"mediaversion\":\"163d94f907f2abc7feca5208c60c2a13\"}'

Aktuellt

Utbildningar

Kontakt

Logga in som arrangör

Joomlas felsökningskonsoll

Session

Profilinformation

Tid

Minne

Minnesanvändning

Databasfrågor

21 loggade SQL-frågor 27.63 ms

18 Loggade frågetyper. Sorterade efter förekomst

SELECT Tabeller:

OTHER Tabeller: