Sigtuna Fritidscenter

Joomlas felsökningskonsoll

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576243276,
                "last": 1576243276,
                "now": 1576243276
            },
            "client": {
                "forwarded": "3.234.214.179"
            },
            "token": "h2apCIwDOMWJGcsz3gGMosG2w0jXB3OK"
        },
        "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: 67.17 ms / 67.17 ms Minne: 1.794 MB / 2.21 MB Application: afterLoad

Tid: 235.20 ms / 302.37 ms Minne: 5.676 MB / 7.89 MB Application: afterInitialise

Tid: 83.18 ms / 385.55 ms Minne: 1.436 MB / 9.32 MB Application: afterRoute

Tid: 13.09 ms / 398.64 ms Minne: 0.314 MB / 9.64 MB Application: beforeRenderComponent com_djclassifieds

Tid: 241.20 ms / 639.85 ms Minne: 2.742 MB / 12.38 MB Application: afterRenderComponent com_djclassifieds

Tid: 31.11 ms / 670.96 ms Minne: 0.372 MB / 12.75 MB Application: afterDispatch

Tid: 48.57 ms / 719.53 ms Minne: 0.236 MB / 12.99 MB Application: beforeRenderModule mod_login (Logga in som arrangör)

Tid: 21.00 ms / 740.53 ms Minne: 0.149 MB / 13.14 MB Application: afterRenderModule mod_login (Logga in som arrangör)

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

Tid: 5.66 ms / 746.25 ms Minne: 0.007 MB / 13.14 MB Application: afterRenderModule mod_custom (FaR-Footer)

Tid: 0.10 ms / 746.35 ms Minne: 0.000 MB / 13.14 MB Application: beforeRenderModule mod_menu (Kontakt)

Tid: 16.51 ms / 762.87 ms Minne: 0.147 MB / 13.29 MB Application: afterRenderModule mod_menu (Kontakt)

Tid: 0.09 ms / 762.95 ms Minne: 0.000 MB / 13.29 MB Application: beforeRenderModule mod_menu (Utbildningar)

Tid: 10.07 ms / 773.02 ms Minne: 0.038 MB / 13.32 MB Application: afterRenderModule mod_menu (Utbildningar)

Tid: 0.10 ms / 773.12 ms Minne: 0.000 MB / 13.32 MB Application: beforeRenderModule mod_articles_latest (Aktuellt)

Tid: 10.80 ms / 783.92 ms Minne: 0.205 MB / 13.53 MB Application: Before Access::preloadComponents (all components)

Tid: 1.54 ms / 785.45 ms Minne: 0.059 MB / 13.59 MB Application: After Access::preloadComponents (all components)

Tid: 0.03 ms / 785.48 ms Minne: 0.000 MB / 13.58 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tid: 3.38 ms / 788.87 ms Minne: 0.027 MB / 13.61 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tid: 12.74 ms / 801.60 ms Minne: 0.224 MB / 13.84 MB Application: afterRenderModule mod_articles_latest (Aktuellt)

Tid: 0.16 ms / 801.77 ms Minne: 0.000 MB / 13.70 MB Application: beforeRenderModule mod_djclassifieds_search (Sökmeny - Välj själv vilka och hur många sökfält som ska fyllas i vid sökning)

Tid: 28.11 ms / 829.88 ms Minne: 0.517 MB / 14.22 MB Application: afterRenderModule mod_djclassifieds_search (Sökmeny - Välj själv vilka och hur många sökfält som ska fyllas i vid sökning)

Tid: 0.13 ms / 830.01 ms Minne: 0.000 MB / 14.15 MB Application: beforeRenderModule mod_search (Sök)

Tid: 8.83 ms / 838.84 ms Minne: 0.016 MB / 14.17 MB Application: afterRenderModule mod_search (Sök)

Tid: 1712.68 ms / 2551.53 ms Minne: 1.650 MB / 15.82 MB Application: afterRender

Databasfrågor totalt: 86.42 ms

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

#	Uppringare	Fil och radnummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Samma som samtal i raden nedan.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
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

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.18 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.01 ms
statistics	0.05 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'6465323361313461303033613433623263316266643534663637656331376533', 1, 1576243276, 0, '', 0)

Profil

Status	Duration
starting	0.07 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.00 ms
init	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.00 ms
update	0.02 ms
end	0.00 ms
query end	1.30 ms
closing tables	0.02 ms
freeing items	0.04 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.07 ms Efter sista fråga: 9.52 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.13 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.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
updating status	0.03 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.71 ms Efter sista fråga: 8.17 ms Frågeminne: 0.023 MB Minne före fråga: 4.492 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.19 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.00 ms
Sending data	0.05 ms
end	0.00 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

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.54 ms Efter sista fråga: 0.09 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.09 ms
checking permissions	0.00 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.06 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.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: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.53 ms Efter sista fråga: 1.29 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.12 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.02 ms
executing	0.00 ms
Sorting result	0.41 ms
Sending data	0.28 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
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.71 ms Efter sista fråga: 161.47 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.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.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.36 ms
Sending data	0.97 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.16 ms
updating status	0.11 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.18 ms Efter sista fråga: 50.76 ms Frågeminne: 0.048 MB Minne före fråga: 9.166 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.20 ms
checking permissions	0.02 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.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
updating status	0.01 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/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.08 ms Efter sista fråga: 23.82 ms Frågeminne: 0.025 MB Minne före fråga: 9.421 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.26 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.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
updating status	0.03 ms
cleaning up	0.00 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.19 ms Efter sista fråga: 0.14 ms Frågeminne: 0.005 MB Minne före fråga: 9.411 MB

UPDATE `gusqo_extensions`

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

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

Förklara

EXPLAIN inte möjlig i fråga: UPDATE `gusqo_extensions` SET `params` = '{\"mediaversion\":\"c68ddfdef81932e54ba70f435d9888df\"}' 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.06 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.02 ms
query end	1.45 ms
closing tables	0.03 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.00 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.88 ms Efter sista fråga: 4.71 ms Frågeminne: 0.025 MB Minne före fråga: 9.606 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.16 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.02 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.03 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.19 ms Efter sista fråga: 114.11 ms Frågeminne: 0.022 MB Minne före fråga: 11.124 MB Returnerade rader: 0

SELECT item_id 
  FROM gusqo_djcf_items_promotions 
  WHERE date_exp <= '2019-12-13 14:21:16' 
  AND updated=0 
  GROUP BY item_id

Förklara

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

Profil

Status	Duration
starting	0.17 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.01 ms
preparing	0.01 ms
executing	0.00 ms
Creating tmp table	0.03 ms
Copying to tmp table	0.03 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
updating status	0.02 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:890
7	DJClassifiedsPayment::updatePromotions()	JROOT/components/com_djclassifieds/djclassifieds.php:95
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 3.48 ms Efter sista fråga: 20.86 ms Frågeminne: 0.045 MB Minne före fråga: 11.516 MB Returnerade rader: 2

SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, c.rev_group_id, r.name as r_name, r.id as r_id, img.img_c  
  FROM gusqo_djcf_items i 
  LEFT JOIN gusqo_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN gusqo_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM gusqo_djcf_images img
								 
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  WHERE i.date_exp > '2019-12-13 14:21:17' 
  AND i.published=1 
  AND i.blocked=0  
  AND i.user_id=146  
  ORDER BY i.special DESC, i.date_start DESC 
  LIMIT 0, 20

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	i	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	898	Using where; Använder filsortering
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.i.cat_id	1
1	PRIMARY	r	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.i.region_id	1
1	PRIMARY	<derived2>	ref	key0	key0	5	4001293-farledare-joomla.i.id	10
2	DERIVED	img	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	1081	Using where; Using temporary; Använder filsortering

Profil

Status	Duration
starting	0.32 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.01 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.00 ms
After table lock	0.01 ms
init	0.14 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.75 ms
Sending data	0.11 ms
executing	0.00 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.69 ms
Sorting result	0.10 ms
Sending data	0.22 ms
removing tmp table	0.01 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.05 ms
freeing items	0.09 ms
updating status	0.05 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_djclassifieds/models/profile.php:118
10	DjclassifiedsModelProfile->getItems()	JROOT/components/com_djclassifieds/views/profile/view.html.php:66
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 4.57 ms Efter sista fråga: 0.09 ms Frågeminne: 0.026 MB Minne före fråga: 11.542 MB Returnerade rader: 6

SELECT fv.item_id, fv.field_id, fv.value, fv.value_date, fv.value_date_to,f.label, f.type 
  FROM gusqo_djcf_fields_values fv,gusqo_djcf_fields f 
  WHERE fv.item_id IN (421,420) 
  AND f.id=fv.field_id 
  AND (f.in_table>0 OR f.in_blog=1) 
  AND f.access=0 
  AND f.published=1 
  ORDER BY fv.item_id, f.label

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fv	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	6309	Using where; Using temporary; Använder filsortering
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.fv.field_id	1	Using where

Profil

Status	Duration
starting	0.13 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.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.17 ms
Copying to tmp table	3.60 ms
Sorting result	0.05 ms
Sending data	0.03 ms
end	0.00 ms
removing tmp table	0.07 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
updating status	0.03 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/components/com_djclassifieds/models/profile.php:137
10	DjclassifiedsModelProfile->getItems()	JROOT/components/com_djclassifieds/views/profile/view.html.php:66
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 0.93 ms Efter sista fråga: 0.08 ms Frågeminne: 0.026 MB Minne före fråga: 11.555 MB Returnerade rader: 2

SELECT img.* 
  FROM gusqo_djcf_images img 
  WHERE img.item_id IN (421,420) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	img	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	1081	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.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.37 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
updating status	0.02 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djimage.php:427
11	DJClassifiedsImage::getAdsImages()	JROOT/components/com_djclassifieds/models/profile.php:140
10	DjclassifiedsModelProfile->getItems()	JROOT/components/com_djclassifieds/views/profile/view.html.php:66
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 2.64 ms Efter sista fråga: 0.13 ms Frågeminne: 0.024 MB Minne före fråga: 11.562 MB Returnerade rader: 1

SELECT count(i.id) 
  FROM (SELECT i.id 
  FROM gusqo_djcf_items i 
  LEFT JOIN gusqo_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN gusqo_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM gusqo_djcf_images img
								
  WHERE img.type='item' 
  GROUP BY item_id ) img 
  ON i.id=img.item_id 
  WHERE i.date_exp > '2019-12-13 14:21:17' 
  AND i.published=1 
  AND i.blocked=0  
  AND i.user_id=146  ) as i

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	898	Using where
1	SIMPLE	<derived3>	ref	key0	key0	5	4001293-farledare-joomla.i.id	10
3	DERIVED	img	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	1081	Using where; Using temporary; Använder filsortering

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.06 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.20 ms
executing	0.00 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.67 ms
Sorting result	0.10 ms
Sending data	0.24 ms
removing tmp table	0.01 ms
Sending data	0.52 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
removing tmp table	0.04 ms
closing tables	0.02 ms
freeing items	0.14 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:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/profile.php:213
10	DjclassifiedsModelProfile->getCountItems()	JROOT/components/com_djclassifieds/views/profile/view.html.php:67
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 0.65 ms Efter sista fråga: 0.04 ms Frågeminne: 0.037 MB Minne före fråga: 11.567 MB Returnerade rader: 4

SELECT * 
  FROM gusqo_djcf_fields 
  WHERE published=1 
  AND (in_table>0 OR in_blog=1) 
  ORDER BY name

Förklara

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

Profil

Status	Duration
starting	0.09 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
After table lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.07 ms
Sending data	0.06 ms
end	0.00 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/profile.php:272
10	DjclassifiedsModelProfile->getCustomFields()	JROOT/components/com_djclassifieds/views/profile/view.html.php:68
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 0.40 ms Efter sista fråga: 0.06 ms Frågeminne: 0.023 MB Minne före fråga: 11.587 MB Returnerade rader: 1

SELECT name  
  FROM gusqo_users 
  WHERE id=146 
  LIMIT 1

Förklara

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

Profil

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

Anropsstack

#	Uppringare	Fil och radnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/profile.php:233
10	DjclassifiedsModelProfile->getProfile()	JROOT/components/com_djclassifieds/views/profile/view.html.php:69
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 0.51 ms Efter sista fråga: 0.07 ms Frågeminne: 0.026 MB Minne före fråga: 11.593 MB Returnerade rader: 1

SELECT * 
  FROM gusqo_djcf_images 
  WHERE item_id = 146 
  AND type='profile' 
  LIMIT 1

Förklara

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

Profil

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

Anropsstack

#	Uppringare	Fil och radnummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/profile.php:237
10	DjclassifiedsModelProfile->getProfile()	JROOT/components/com_djclassifieds/views/profile/view.html.php:69
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 34.45 ms Efter sista fråga: 0.04 ms Frågeminne: 0.043 MB Minne före fråga: 11.601 MB Returnerade rader: 14

SELECT f.*, v.value, v.value_date, v.value_date_to 
  FROM gusqo_djcf_fields f 
  LEFT JOIN (SELECT * 
  FROM gusqo_djcf_fields_values_profile 
  WHERE user_id=146) v 
  ON v.field_id=f.id 
  WHERE f.published=1 
  AND f.source=2 
  AND f.access=0 
  ORDER BY f.ordering

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	36	Using where; Using temporary; Använder filsortering
1	SIMPLE	gusqo_djcf_fields_values_profile	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	5131	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.00 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
After table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.21 ms
Copying to tmp table	33.21 ms
Sorting result	0.08 ms
Sending data	0.08 ms
end	0.00 ms
removing tmp table	0.09 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
updating status	0.04 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/components/com_djclassifieds/models/profile.php:244
10	DjclassifiedsModelProfile->getProfile()	JROOT/components/com_djclassifieds/views/profile/view.html.php:69
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 0.67 ms Efter sista fråga: 2.33 ms Frågeminne: 0.025 MB Minne före fråga: 11.756 MB Returnerade rader: 0

SELECT * 
  FROM gusqo_djcf_types 
  WHERE published=1

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/profile.php:258
10	DjclassifiedsModelProfile->getTypes()	JROOT/components/com_djclassifieds/views/profile/view.html.php:75
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: 5.36 ms Efter sista fråga: 6.60 ms Frågeminne: 0.095 MB Minne före fråga: 11.862 MB Returnerade rader: 109

SELECT c.*, cc.name as parent_name,IFNULL(i.items_count,0) + IFNULL(ic.items_count,0) AS items_count  
  FROM gusqo_djcf_categories c 
  LEFT JOIN gusqo_djcf_categories cc 
  ON c.parent_id=cc.id 
  LEFT JOIN (SELECT i.cat_id, count(i.id) as items_count 
  FROM gusqo_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2019-12-13 14:21:17' 
  GROUP BY i.cat_id) i 
  ON i.cat_id=c.id 
  LEFT JOIN (SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM gusqo_djcf_items_categories ic, gusqo_djcf_items i 
  WHERE ic.item_id=i.id 
  AND i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2019-12-13 14:21:17' 
  GROUP BY ic.cat_id) ic 
  ON ic.cat_id=c.id 
  WHERE c.published=1  
  AND c.access_view IN (1,1,4) 
  ORDER BY c.parent_id, c.ordering

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	77	Using where; Använder filsortering
1	PRIMARY	cc	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.c.parent_id	1
1	PRIMARY	<derived2>	ref	key0	key0	5	4001293-farledare-joomla.c.id	10
1	PRIMARY	<derived3>	ref	key0	key0	5	4001293-farledare-joomla.c.id	2
3	DERIVED	ic	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	1	Using temporary; Använder filsortering
3	DERIVED	i	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.ic.item_id	1	Using where
2	DERIVED	i	index	NULL	cat_id	4	NULL	898	Using where

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
checking permissions	0.00 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.10 ms
optimizing	0.00 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.12 ms
Sending data	0.05 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	2.77 ms
executing	0.02 ms
Creating tmp table	0.03 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.88 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
removing tmp table	0.03 ms
closing tables	0.04 ms
freeing items	0.10 ms
updating status	0.01 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:453
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:271
11	DJClassifiedsCategory::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:86
10	DJClassifiedsSEO::getCategoryRoute()	JROOT/components/com_djclassifieds/views/profile/view.html.php:111
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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.81 ms Efter sista fråga: 27.22 ms Frågeminne: 0.030 MB Minne före fråga: 12.350 MB Returnerade rader: 8

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-13 13:21:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-13 13:21:17') 
  AND m.access IN (1,1,4) 
  AND m.client_id = 0 
  AND (mm.menuid = 907 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.19 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.21 ms
Sending data	0.55 ms
end	0.01 ms
query end	0.01 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Samma som samtal i raden nedan.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_djclassifieds/views/profile/tmpl/default.php:72
12	include JROOT/components/com_djclassifieds/views/profile/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djclassifieds/views/profile/view.html.php:126
9	DJClassifiedsViewProfile->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:123
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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.32 ms Efter sista fråga: 159.30 ms Frågeminne: 0.032 MB Minne före fråga: 13.530 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	343	Using where

Profil

Status	Duration
starting	0.21 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.07 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.01 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.06 ms
updating status	0.03 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:442
15	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	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: 1.69 ms Efter sista fråga: 3.62 ms Frågeminne: 0.040 MB Minne före fråga: 13.611 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-13 13:21:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-13 13:21:17')

  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.31 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.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.12 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.11 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 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: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: 1.19 ms Efter sista fråga: 5.52 ms Frågeminne: 0.040 MB Minne före fråga: 13.812 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.24 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.03 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
updating status	0.03 ms
cleaning up	0.01 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: 2.47 ms Efter sista fråga: 10.28 ms Frågeminne: 0.090 MB Minne före fråga: 13.748 MB Returnerade rader: 109

SELECT * 
  FROM gusqo_djcf_categories 
  WHERE published=1 
  ORDER BY parent_id, ordering

Förklara

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

Profil

Status	Duration
starting	0.23 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.05 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.17 ms
Sending data	1.33 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.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:35
11	modDjClassifiedsSearch::getCats()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:55
10	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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: 5.82 ms Efter sista fråga: 0.41 ms Frågeminne: 0.095 MB Minne före fråga: 14.091 MB Returnerade rader: 109

SELECT c.*, cc.name as parent_name,IFNULL(i.items_count,0) + IFNULL(ic.items_count,0) AS items_count 
  FROM gusqo_djcf_categories c 
  LEFT JOIN gusqo_djcf_categories cc 
  ON c.parent_id=cc.id 
  LEFT JOIN (SELECT i.cat_id, count(i.id) as items_count 
  FROM gusqo_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2019-12-13 14:21:17' 
  GROUP BY i.cat_id) i 
  ON i.cat_id=c.id 
  LEFT JOIN (SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM gusqo_djcf_items_categories ic, gusqo_djcf_items i 
  WHERE ic.item_id=i.id 
  AND i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2019-12-13 14:21:17' 
  GROUP BY ic.cat_id) ic 
  ON ic.cat_id=c.id 
  WHERE c.published=1  
  AND c.access_view IN (1,1,4) 
  ORDER BY c.parent_id, c.name ASC

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	77	Using where; Använder filsortering
1	PRIMARY	cc	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.c.parent_id	1
1	PRIMARY	<derived2>	ref	key0	key0	5	4001293-farledare-joomla.c.id	10
1	PRIMARY	<derived3>	ref	key0	key0	5	4001293-farledare-joomla.c.id	2
3	DERIVED	ic	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	1	Using temporary; Använder filsortering
3	DERIVED	i	eq_ref	PRIMARY	PRIMARY	4	4001293-farledare-joomla.ic.item_id	1	Using where
2	DERIVED	i	index	NULL	cat_id	4	NULL	898	Using where

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 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.11 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.27 ms
Sending data	0.06 ms
executing	0.01 ms
Sorting result	0.00 ms
Sending data	2.90 ms
executing	0.02 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.01 ms
Sorting result	0.01 ms
Sending data	0.00 ms
removing tmp table	0.01 ms
Sending data	0.87 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
removing tmp table	0.06 ms
closing tables	0.03 ms
freeing items	0.16 ms
updating status	0.02 ms
cleaning up	0.01 ms

Anropsstack

#	Uppringare	Fil och radnummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:541
12	DJClassifiedsCategory::getCategoriesSortParent()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:137
11	DJClassifiedsCategory::getCatAllItemsCount()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:57
10	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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.70 ms Efter sista fråga: 0.86 ms Frågeminne: 0.035 MB Minne före fråga: 14.135 MB Returnerade rader: 40

SELECT r.* 
  FROM gusqo_djcf_regions r 
  WHERE r.published=1 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	ALL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	40	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.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.08 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
updating status	0.02 ms
cleaning up	0.00 ms

Anropsstack

#	Uppringare	Fil och radnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:46
11	modDjClassifiedsSearch::getRegions()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:77
10	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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.35 ms Efter sista fråga: 0.08 ms Frågeminne: 0.024 MB Minne före fråga: 14.175 MB Returnerade rader: 0

SELECT t.id as value, t.name as text, '0' as disabled 
  FROM gusqo_djcf_types t 
  WHERE t.published=1 
  ORDER BY t.ordering

Förklara

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INGEN INDEXNYCKEL KAN ANVÄNDAS	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

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

Anropsstack

#	Uppringare	Fil och radnummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djclassifieds_search/helper.php:58
11	modDjClassifiedsSearch::getTypes()	JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.php:78
10	include JROOT/modules/mod_djclassifieds_search/mod_djclassifieds_search.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.96 ms Efter sista fråga: 1720.23 ms Frågeminne: 0.022 MB Minne före fråga: 15.506 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.36 ms
checking permissions	0.02 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.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
updating status	0.03 ms
cleaning up	0.01 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]

31 Loggade frågetyper. Sorterade efter förekomst

SELECT Tabeller:

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

1 × SELECT `data` 
  FROM `gusqo_session`

1 × SELECT * 
  FROM gusqo_djcf_images

1 × SELECT t.id as value, t.name as text, '0' as disabled 
  FROM gusqo_djcf_types t

1 × SELECT r.* 
  FROM gusqo_djcf_regions r

1 × SELECT c.*, cc.name as parent_name,IFNULL(i.items_count,0) + IFNULL(ic.items_count,0) AS items_count 
  FROM gusqo_djcf_categories c 
  LEFT JOIN gusqo_djcf_categories cc 
  ON c.parent_id=cc.id 
  LEFT JOIN (SELECT i.cat_id, count(i.id) as items_count 
  FROM gusqo_djcf_items i

1 × SELECT * 
  FROM gusqo_djcf_categories

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 `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)

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 `id`,`name`,`rules`,`parent_id` 
  FROM `gusqo_assets`

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 c.*, cc.name as parent_name,IFNULL(i.items_count,0) + IFNULL(ic.items_count,0) AS items_count  
  FROM gusqo_djcf_categories c 
  LEFT JOIN gusqo_djcf_categories cc 
  ON c.parent_id=cc.id 
  LEFT JOIN (SELECT i.cat_id, count(i.id) as items_count 
  FROM gusqo_djcf_items i

```
1 × SELECT * 
  FROM gusqo_djcf_types
```

1 × SELECT f.*, v.value, v.value_date, v.value_date_to 
  FROM gusqo_djcf_fields f 
  LEFT JOIN (SELECT * 
  FROM gusqo_djcf_fields_values_profile

1 × SELECT * 
  FROM gusqo_djcf_fields

```
1 × SELECT name  
  FROM gusqo_users
```

1 × SELECT `session_id` 
  FROM `gusqo_session`

1 × SELECT count(i.id) 
  FROM (SELECT i.id 
  FROM gusqo_djcf_items i 
  LEFT JOIN gusqo_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN gusqo_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM gusqo_djcf_images img

1 × SELECT img.* 
  FROM gusqo_djcf_images img

1 × SELECT fv.item_id, fv.field_id, fv.value, fv.value_date, fv.value_date_to,f.label, f.type 
  FROM gusqo_djcf_fields_values fv,gusqo_djcf_fields f

1 × SELECT i.*, c.name AS c_name,c.alias AS c_alias, c.id as c_id, c.rev_group_id, r.name as r_name, r.id as r_id, img.img_c  
  FROM gusqo_djcf_items i 
  LEFT JOIN gusqo_djcf_categories c 
  ON i.cat_id = c.id 
  LEFT JOIN gusqo_djcf_regions r 
  ON i.region_id = r.id 
  LEFT JOIN ( SELECT COUNT(img.id) as img_c, img.item_id 
  FROM gusqo_djcf_images img

1 × SELECT item_id 
  FROM gusqo_djcf_items_promotions

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

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 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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM gusqo_extensions

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 id, rules 
  FROM `gusqo_viewlevels

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'6465323361313461303033613433623263316266643534663637656331376533', 1, 1576243276, 0, '', 0

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

Sökmeny - Välj själv vilka och hur många sökfält som ska fyllas i vid sökning