#	Käyttäjätunnus	Osumat
1	Warning: Undefined property: stdClass::$link in components/com_kunena/template/nts_kbento/layouts/statistics/general/default.php on line 34	376
2	Warning: Undefined property: stdClass::$link in components/com_kunena/template/nts_kbento/layouts/statistics/general/default.php on line 34	174
3	Warning: Undefined property: stdClass::$link in components/com_kunena/template/nts_kbento/layouts/statistics/general/default.php on line 34	167
4	Warning: Undefined property: stdClass::$link in components/com_kunena/template/nts_kbento/layouts/statistics/general/default.php on line 34	153
5	Warning: Undefined property: stdClass::$link in components/com_kunena/template/nts_kbento/layouts/statistics/general/default.php on line 34	150

Joomla! Debug-konsoli

Istunto

{
    "__default": {
        "session": {
            "counter": 7,
            "timer": {
                "start": 1782321396,
                "last": 1782321406,
                "now": 1782321408
            },
            "client": {
                "forwarded": "216.73.217.55"
            },
            "token": "p08ROnvFMitXYBiIuGlPCi9WEYke3mfO"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": ""
                        }
                    }
                }
            },
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "2": 2,
                    "3": 3
                }
            }
        },
        "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
        },
        "jomsocial_userip": "216.73.217.55",
        "application": {
            "queue": null
        }
    }
}

#	Soittaja	Tiedoston ja rivin numero
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1542
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:982
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/user/user.php:476
8	JUser->getAuthorisedGroups()	JROOT/libraries/axslibs/brands.php:491
7	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:57
6	AxsBrands::getBrand()	JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:71
5	Tovuti\Providers\FeatureFlaggingServiceProvider->getClientMetadata()	JROOT/libraries/tovuti/Providers/FeatureFlaggingServiceProvider.php:33
4	Tovuti\Providers\FeatureFlaggingServiceProvider->register()	JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:115
3	Tovuti\Helpers\AppBootstrapHelper::registerProviderWithDependencies()	JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:90
2	Tovuti\Helpers\AppBootstrapHelper::bootstrapServices()	JROOT/libraries/tovuti/Helpers/AppBootstrapHelper.php:47
1	Tovuti\Helpers\AppBootstrapHelper::bootstrap()	JROOT/index.php:70

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

#	Soittaja	Tiedoston ja rivin numero
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1498
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1065
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

EXPLAIN ei ole mahdollista kyselyssä: SELECT `folder` AS `type`,`element` AS `name`,`params` FROM joom_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	1.13 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.53 ms Viimeisen kyselyn jälkeen: 20.62 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 12.218 MB Palautetut rivit: 1

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

  FROM `joom_extensions`

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

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions` WHERE `type` = 'library' AND `element` = 'joomla'

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
16	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
15	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
13	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:850
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:224
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:717
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 3.64 ms Viimeisen kyselyn jälkeen: 0.11 ms Kyselymuisti: 0.005 MB Muisti ennen kyselyä: 12.209 MB

UPDATE `joom_extensions`

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

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

Selittää

EXPLAIN ei ole mahdollista kyselyssä: UPDATE `joom_extensions` SET `params` = '{\"mediaversion\":\"bfebfebade889030a08811c5dca947ee\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.08 ms
updating	0.16 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.11 ms
closing tables	0.01 ms
freeing items	0.01 ms
async commit	2.13 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:850
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:224
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:717
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.51 ms Viimeisen kyselyn jälkeen: 5.85 ms Kyselymuisti: 0.020 MB Muisti ennen kyselyä: 12.879 MB Palautetut rivit: 20

SELECT *

  FROM joom_languages

  WHERE published=1

  ORDER BY ordering ASC

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_languages WHERE published=1 ORDER BY ordering ASC

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.16 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:99
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:717
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.08 ms Kyselymuisti: 0.020 MB Muisti ennen kyselyä: 12.903 MB Palautetut rivit: 1

SELECT * 
  FROM axs_domains 
  WHERE domain = 'k8s.intg.tovuti.io'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM axs_domains WHERE domain = 'k8s.intg.tovuti.io'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
9	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:184
8	AxsLanguage::getSubdomainDefault()	JROOT/plugins/system/languagefilter/languagefilter.php:103
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:717
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.57 ms Viimeisen kyselyn jälkeen: 0.06 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 12.910 MB Palautetut rivit: 96

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `joom_extensions`

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

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `element`,`name`,`client_id`,`extension_id` FROM `joom_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.32 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:113
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:717
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 2.46 ms Viimeisen kyselyn jälkeen: 10.28 ms Kyselymuisti: 0.074 MB Muisti ennen kyselyä: 14.498 MB Palautetut rivit: 88

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

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

Selittää

EXPLAIN ei ole mahdollista kyselyssä: 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 joom_menu AS m LEFT JOIN joom_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

Profiili

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
executing	1.04 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
22	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
21	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
20	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
19	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
18	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
17	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:497
16	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:277
15	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
14	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
13	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:591
12	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
11	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:134
10	PlgSystemLanguageFilter->onAfterInitialise()	Sama kuin soitto alla olevalla rivillä.
9	ReflectionMethod->invokeArgs()	JROOT/libraries/tovuti/Helpers/MethodHelper.php:58
8	Tovuti\Helpers\MethodHelper::call()	JROOT/libraries/joomla/event/event.php:72
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:718
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 2.68 ms Viimeisen kyselyn jälkeen: 15.41 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 17.276 MB Palautetut rivit: 17

SHOW FULL COLUMNS 
  FROM `joom_users`

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SHOW FULL COLUMNS FROM `joom_users`

Profiili

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.51 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.10 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.23 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:435
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
15	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
14	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:599
13	JUser::getTable()	JROOT/libraries/joomla/user/user.php:783
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1178
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.24 ms Viimeisen kyselyn jälkeen: 0.29 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 17.318 MB Palautetut rivit: 1

SELECT `id`,`title`

  FROM `joom_usergroups`

  WHERE `id` = 1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id`,`title` FROM `joom_usergroups` WHERE `id` = 1

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1498
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:163
13	JTableUser->bind()	JROOT/libraries/joomla/user/user.php:785
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1178
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.28 ms Viimeisen kyselyn jälkeen: 1.99 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 17.622 MB Palautetut rivit: 1

SELECT * 
  FROM joom_kunena_configuration 
  WHERE id=1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_kunena_configuration WHERE id=1

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1306
17	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1239
16	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
15	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:480
14	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
13	include JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:716
12	JLoader::_load()	JROOT/libraries/loader.php:671
11	JLoader::_autoload()	JROOT/components/com_kunena/router.php:301
10	KunenaParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1178
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.27 ms Viimeisen kyselyn jälkeen: 1.95 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 17.786 MB Palautetut rivit: 1

SELECT * 
  FROM joom_kunena_aliases 
  WHERE alias LIKE 'statistics%'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_kunena_aliases WHERE alias LIKE 'statistics%'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:450
11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:316
10	KunenaParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1178
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.22 ms Viimeisen kyselyn jälkeen: 12.17 ms Kyselymuisti: 0.020 MB Muisti ennen kyselyä: 18.382 MB Palautetut rivit: 0

SELECT params

  FROM axs_user_settings

  WHERE id = 1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT params FROM axs_user_settings WHERE id = 1

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
8	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/user.php:802
7	AxsUser::{closure}()	JROOT/libraries/tovuti/Traits/Memoization.php:25
6	AxsUser::memoizeStatic()	JROOT/libraries/axslibs/user.php:792
5	AxsUser::getGlobalUserSettings()	JROOT/libraries/axslibs/security.php:35
4	AxsSecurity::getSettings()	JROOT/libraries/cms/application/cms.php:368
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.30 ms Viimeisen kyselyn jälkeen: 2.23 ms Kyselymuisti: 0.018 MB Muisti ennen kyselyä: 18.713 MB Palautetut rivit: 0

SELECT *

  FROM `joom_users`

  WHERE `id` = 0

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `joom_users` WHERE `id` = 0

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
5	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_users/models/user.php:992
4	UsersModelUser->getOtpConfig()	JROOT/libraries/cms/application/cms.php:372
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.51 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.019 MB Muisti ennen kyselyä: 18.719 MB Palautetut rivit: 6

SELECT id, home, template, s.params

  FROM joom_template_styles as s

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

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_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

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:490
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 2.36 ms Viimeisen kyselyn jälkeen: 3.12 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 18.938 MB Palautetut rivit: 5

SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions`

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SHOW FULL COLUMNS FROM `joom_kunena_sessions`

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.55 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.08 ms
executing	0.10 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:435
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:31
13	TableKunenaSessions->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/libraries/kunena/session.php:96
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:110
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:30
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:60
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 3.42 ms Viimeisen kyselyn jälkeen: 6.93 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 19.760 MB Palautetut rivit: 51

SHOW FULL COLUMNS 
  FROM `joom_kunena_users`

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SHOW FULL COLUMNS FROM `joom_kunena_users`

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.49 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:435
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
18	JTable->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
17	TableKunenaUsers->__construct()	JROOT/libraries/joomla/table/table.php:311
16	JTable::getInstance()	JROOT/libraries/kunena/user/user.php:252
15	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
14	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
13	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
12	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
11	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
10	JLoader::_load()	JROOT/libraries/loader.php:671
9	JLoader::_autoload()	JROOT/libraries/kunena/controller/application/display.php:215
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.38 ms Viimeisen kyselyn jälkeen: 0.68 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 19.855 MB Palautetut rivit: 0

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (0)

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`friendcount` as _friendcount, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` AS _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users` as a LEFT JOIN `joom_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `joom_session`s ON s.`userid`=a.`userid` WHERE a.`userid` IN (0)

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
14	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
13	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:63
12	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
11	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
10	JLoader::_load()	JROOT/libraries/loader.php:671
9	JLoader::_autoload()	JROOT/libraries/kunena/controller/application/display.php:215
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.44 ms Viimeisen kyselyn jälkeen: 9.81 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 20.808 MB Palautetut rivit: 0

SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role
			
  FROM joom_kunena_categories AS c
			
  INNER JOIN joom_community_groups_members AS g 
  ON c.accesstype='jomsocial' 
  AND c.access=g.groupid
			
  WHERE c.published=1 
  AND g.approved=1 
  AND g.permissions='1'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role FROM joom_kunena_categories AS c INNER JOIN joom_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1'

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/kunena/community/access.php:136
13	KunenaAccessCommunity->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.89 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 20.821 MB Palautetut rivit: 63

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

  FROM `joom_assets`

  WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets` WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Profiili

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.23 ms
preparing	0.03 ms
executing	0.39 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:430
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:533
15	JAccess::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:461
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.61 ms Viimeisen kyselyn jälkeen: 0.37 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 20.931 MB Palautetut rivit: 7

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT DISTINCT(user_id) FROM joom_usergroups as ug1 INNER JOIN joom_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN joom_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id IN (8)

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.04 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1542
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.62 ms Viimeisen kyselyn jälkeen: 0.07 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 20.938 MB Palautetut rivit: 25

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (32,20)

Selittää

Profiili

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
Creating tmp table	0.03 ms
executing	0.23 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1542
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.57 ms Viimeisen kyselyn jälkeen: 0.05 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 20.951 MB Palautetut rivit: 0

SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories 
  WHERE role IN (1,2)

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT user_id, category_id, role FROM joom_kunena_user_categories WHERE role IN (1,2)

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.96 ms Viimeisen kyselyn jälkeen: 1.14 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.078 MB Palautetut rivit: 1

SELECT COUNT(*), MAX(id) 
  FROM joom_users 
  WHERE (block=0 OR activation="")

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT COUNT(*), MAX(id) FROM joom_users WHERE (block=0 OR activation="")

Profiili

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.67 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1765
18	JDatabaseDriver->loadRow()	JROOT/libraries/kunena/user/helper.php:277
17	KunenaUserHelper::getTotalCount()	JROOT/libraries/kunena/forum/statistics.php:181
16	KunenaForumStatistics->loadMemberCount()	JROOT/libraries/kunena/forum/statistics.php:103
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.35 ms Viimeisen kyselyn jälkeen: 0.94 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 21.194 MB Palautetut rivit: 3

SELECT * 
  FROM joom_kunena_categories 
  ORDER BY ordering, name

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_kunena_categories ORDER BY ordering, name

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.11 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
19	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
18	JLoader::_load()	JROOT/libraries/loader.php:671
17	JLoader::_autoload()	JROOT/libraries/kunena/forum/statistics.php:190
16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:105
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.31 ms Viimeisen kyselyn jälkeen: 1.19 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 21.396 MB Palautetut rivit: 0

SELECT groupid

  FROM joom_community_groups_members

  WHERE approved = 1 
  AND memberid = 0

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT groupid FROM joom_community_groups_members WHERE approved = 1 AND memberid = 0

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:881
21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
19	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
18	JLoader::_load()	JROOT/libraries/loader.php:671
17	JLoader::_autoload()	JROOT/libraries/kunena/forum/statistics.php:190
16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:105
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.29 ms Viimeisen kyselyn jälkeen: 0.21 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.514 MB Palautetut rivit: 0

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='1'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='1'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
19	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
18	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
17	KunenaForumCategory->isSection()	JROOT/libraries/kunena/forum/statistics.php:199
16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:105
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.25 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.524 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #38

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='2'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
20	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
19	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:1485
18	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
17	KunenaForumCategory->isSection()	JROOT/libraries/kunena/forum/statistics.php:199
16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:105
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.18 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.533 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #37

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='2'

Profiili

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
19	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
18	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
17	KunenaForumCategory->isSection()	JROOT/libraries/kunena/forum/statistics.php:199
16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:105
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.542 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #40

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='3'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='3'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
20	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
19	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:1485
18	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
17	KunenaForumCategory->isSection()	JROOT/libraries/kunena/forum/statistics.php:199
16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:105
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.26 ms Viimeisen kyselyn jälkeen: 0.08 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.551 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #39

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='3'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM `joom_kunena_topics` WHERE `category_id`='3'

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
19	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
18	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
17	KunenaForumCategory->isSection()	JROOT/libraries/kunena/forum/statistics.php:199
16	KunenaForumStatistics->loadCategoryCount()	JROOT/libraries/kunena/forum/statistics.php:105
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.32 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 21.558 MB Palautetut rivit: 1

SELECT
				SUM(time>=1782273600 
  AND parent=0) AS todayTopicCount,
				SUM(time>=1782273600 
  AND parent>0) AS todayReplyCount,
				SUM(time>=1782187200 
  AND time<1782273600 
  AND parent=0) AS yesterdayTopicCount,
				SUM(time>=1782187200 
  AND time<1782273600 
  AND parent>0) AS yesterdayReplyCount
				
  FROM joom_kunena_messages 
  WHERE time>=1782187200 
  AND hold=0

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT SUM(time>=1782273600 AND parent=0) AS todayTopicCount, SUM(time>=1782273600 AND parent>0) AS todayReplyCount, SUM(time>=1782187200 AND time<1782273600 AND parent=0) AS yesterdayTopicCount, SUM(time>=1782187200 AND time<1782273600 AND parent>0) AS yesterdayReplyCount FROM joom_kunena_messages WHERE time>=1782187200 AND hold=0

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.03 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
17	JDatabaseDriver->loadObject()	JROOT/libraries/kunena/forum/statistics.php:227
16	KunenaForumStatistics->loadLastDays()	JROOT/libraries/kunena/forum/statistics.php:106
15	KunenaForumStatistics->loadGeneral()	JROOT/libraries/kunena/forum/statistics.php:88
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.35 ms Viimeisen kyselyn jälkeen: 1.14 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 21.624 MB Palautetut rivit: 1

SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (2,3)    
  AND tt.moved_id='0'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT COUNT(*) FROM joom_kunena_topics AS tt WHERE tt.hold IN (0) AND tt.category_id IN (2,3) AND tt.moved_id='0'

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
18	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:274
17	KunenaForumTopicHelper::getLatestTopics()	JROOT/libraries/kunena/forum/statistics.php:260
16	KunenaForumStatistics->loadTopTopics()	JROOT/libraries/kunena/forum/statistics.php:149
15	KunenaForumStatistics->loadTopicStats()	JROOT/libraries/kunena/forum/statistics.php:89
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.31 ms Viimeisen kyselyn jälkeen: 0.03 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 21.632 MB Palautetut rivit: 0

SELECT poll.threadid AS id, SUM(opt.votes) AS count
					
  FROM joom_kunena_polls_options AS opt
					
  INNER JOIN joom_kunena_polls AS poll 
  ON poll.id=opt.pollid
					
  GROUP BY pollid
					
  HAVING count > 0
					
  ORDER BY count DESC 
  LIMIT 0, 5

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT poll.threadid AS id, SUM(opt.votes) AS count FROM joom_kunena_polls_options AS opt INNER JOIN joom_kunena_polls AS poll ON poll.id=opt.pollid GROUP BY pollid HAVING count > 0 ORDER BY count DESC LIMIT 0, 5

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/statistics.php:376
16	KunenaForumStatistics->loadTopPolls()	JROOT/libraries/kunena/forum/statistics.php:159
15	KunenaForumStatistics->loadTopicStats()	JROOT/libraries/kunena/forum/statistics.php:89
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.31 ms Viimeisen kyselyn jälkeen: 0.08 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 21.642 MB Palautetut rivit: 0

SELECT `u`.`id`,`ku`.`posts` AS `count`

  FROM `joom_kunena_users` AS `ku`

  INNER JOIN `joom_users` AS `u` 
  ON `u`.`id` = `ku`.`userid`

  WHERE `ku`.`posts`>0

  ORDER BY `ku`.`posts` DESC 
  LIMIT 5

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `u`.`id`,`ku`.`posts` AS `count` FROM `joom_kunena_users` AS `ku` INNER JOIN `joom_users` AS `u` ON `u`.`id` = `ku`.`userid` WHERE `ku`.`posts`>0 ORDER BY `ku`.`posts` DESC LIMIT 5

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:317
17	KunenaUserHelper::getTopPosters()	JROOT/libraries/kunena/forum/statistics.php:296
16	KunenaForumStatistics->loadTopPosters()	JROOT/libraries/kunena/forum/statistics.php:116
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.38 ms Viimeisen kyselyn jälkeen: 0.64 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 21.675 MB Palautetut rivit: 5

SELECT cu.userid AS id, cu.view AS count
			
  FROM joom_community_users AS cu
			
  INNER JOIN joom_users AS u 
  ON u.id=cu.userid
			
  WHERE cu.view>0
			
  ORDER BY cu.view DESC 
  LIMIT 0, 5

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT cu.userid AS id, cu.view AS count FROM joom_community_users AS cu INNER JOIN joom_users AS u ON u.id=cu.userid WHERE cu.view>0 ORDER BY cu.view DESC LIMIT 0, 5

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.15 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/kunena/community/profile.php:83
18	KunenaProfileCommunity->_getTopHits()	JROOT/libraries/kunena/integration/profile.php:65
17	KunenaProfile->getTopHits()	JROOT/libraries/kunena/forum/statistics.php:331
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.32 ms Viimeisen kyselyn jälkeen: 0.18 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.696 MB Palautetut rivit: 1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 1621333

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* FROM joom_users AS u LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid WHERE u.id = 1621333

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:365
20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:280
19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:115
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.39 ms Viimeisen kyselyn jälkeen: 0.13 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 21.706 MB Palautetut rivit: 1

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (1621333)

Selittää

Profiili

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 2.33 ms Viimeisen kyselyn jälkeen: 3.22 ms Kyselymuisti: 0.028 MB Muisti ennen kyselyä: 21.981 MB Palautetut rivit: 2

SHOW FULL COLUMNS 
  FROM `joom_community_config`

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SHOW FULL COLUMNS FROM `joom_community_config`

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.52 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:435
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
25	JTable->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
24	CommunityTableConfiguration->__construct()	JROOT/libraries/joomla/table/table.php:311
23	JTable::getInstance()	JROOT/components/com_community/libraries/core.php:1056
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/user.php:132
20	CUser->init()	JROOT/components/com_community/libraries/core.php:128
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.22 ms Viimeisen kyselyn jälkeen: 0.08 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 21.998 MB Palautetut rivit: 1

SELECT *

  FROM joom_community_config

  WHERE `name` = 'config'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_community_config WHERE `name` = 'config'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
23	JTable->load()	JROOT/components/com_community/libraries/core.php:1057
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/user.php:132
20	CUser->init()	JROOT/components/com_community/libraries/core.php:128
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 2.56 ms Viimeisen kyselyn jälkeen: 2.04 ms Kyselymuisti: 0.027 MB Muisti ennen kyselyä: 22.226 MB Palautetut rivit: 15

SHOW FULL COLUMNS 
  FROM `joom_community_profiles`

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SHOW FULL COLUMNS FROM `joom_community_profiles`

Profiili

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.51 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
executing	0.10 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:435
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
24	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
23	JTable->__construct()	JROOT/components/com_community/tables/multiprofile.php:32
22	CTableMultiProfile->__construct()	JROOT/libraries/joomla/table/table.php:311
21	JTable::getInstance()	JROOT/components/com_community/libraries/user.php:732
20	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.25 ms Viimeisen kyselyn jälkeen: 1.21 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.360 MB Palautetut rivit: 1

SELECT `id` 
  FROM `joom_community_fields` 
  WHERE `fieldcode`='FIELD_GENDER'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_community_fields` WHERE `fieldcode`='FIELD_GENDER'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
24	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:792
23	CommunityModelProfile->_getgenderId()	JROOT/components/com_community/models/profile.php:766
22	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
21	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
20	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.13 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.370 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #55

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621333'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621333'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
22	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
21	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
20	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.15 ms Viimeisen kyselyn jälkeen: 0.72 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.414 MB Palautetut rivit: 1

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621333'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_users` WHERE id='1621333'

Profiili

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
21	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.40 ms Viimeisen kyselyn jälkeen: 0.06 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.425 MB Palautetut rivit: 1

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='1621333'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as _posted_on, a.`avatar` as _avatar , a.`cover` as _cover , a.`thumb` as _thumb , a.`invite` as _invite, a.`params` as _cparams, a.`view` as _view, a.`friends` as _friends, a.`groups` as _groups, a.`events` as _events, a.`friendcount` as _friendcount, a.`alias` as _alias, a.`profile_id` as _profile_id, a.`storage` as _storage, a.`watermark_hash` as _watermark_hash, a.`search_email` as _search_email, s.`userid` as _isonline, u.* FROM `joom_community_users` as a LEFT JOIN `joom_users` u ON u.`id`=a.`userid` LEFT OUTER JOIN `joom_session` s ON s.`userid`=a.`userid` AND s.`client_id` !='1' WHERE a.`userid`='1621333'

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
22	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:168
21	CUser->init()	JROOT/components/com_community/libraries/core.php:201
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.440 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #52

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621333'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621333'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
24	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
23	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
22	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
21	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:202
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.71 ms Viimeisen kyselyn jälkeen: 0.48 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.478 MB Palautetut rivit: 3

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=profile%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=profile%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.41 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1390
21	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1300
20	CRoute::_()	JROOT/plugins/kunena/community/profile.php:63
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.33 ms Viimeisen kyselyn jälkeen: 0.32 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.510 MB Palautetut rivit: 1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 1621329

Selittää

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:365
20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:280
19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:115
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.42 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.520 MB Palautetut rivit: 1

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (1621329)

Selittää

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.19 ms Viimeisen kyselyn jälkeen: 0.13 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.550 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #62

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621329'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621329'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
22	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
21	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
20	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.19 ms Viimeisen kyselyn jälkeen: 0.18 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.538 MB Palautetut rivit: 1

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621329'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_users` WHERE id='1621329'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
21	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.43 ms Viimeisen kyselyn jälkeen: 0.07 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.550 MB Palautetut rivit: 1

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='1621329'

Selittää

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
22	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:168
21	CUser->init()	JROOT/components/com_community/libraries/core.php:201
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.16 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.576 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #59

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621329'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621329'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
24	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
23	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
22	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
21	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:202
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.29 ms Viimeisen kyselyn jälkeen: 0.22 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.597 MB Palautetut rivit: 1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 1621327

Selittää

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:365
20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:280
19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:115
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.33 ms Viimeisen kyselyn jälkeen: 0.11 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.607 MB Palautetut rivit: 1

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (1621327)

Selittää

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.12 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.027 MB Muisti ennen kyselyä: 22.643 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #68

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621327'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621327'

Profiili

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
22	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
21	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
20	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.14 ms Viimeisen kyselyn jälkeen: 0.18 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.633 MB Palautetut rivit: 1

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621327'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_users` WHERE id='1621327'

Profiili

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
21	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.38 ms Viimeisen kyselyn jälkeen: 0.07 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.644 MB Palautetut rivit: 1

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='1621327'

Selittää

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
22	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:168
21	CUser->init()	JROOT/components/com_community/libraries/core.php:201
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.14 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.671 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #65

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621327'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621327'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
24	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
23	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
22	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
21	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:202
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.29 ms Viimeisen kyselyn jälkeen: 0.21 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.691 MB Palautetut rivit: 1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 1621325

Selittää

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:365
20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:280
19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:115
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.37 ms Viimeisen kyselyn jälkeen: 0.08 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.701 MB Palautetut rivit: 1

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (1621325)

Selittää

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.18 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.731 MB Palautetut rivit: 1

Päällekkäiset kyselyt: #74

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621325'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621325'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
22	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
21	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
20	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.31 ms Viimeisen kyselyn jälkeen: 0.15 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.719 MB Palautetut rivit: 1

Päällekkäiset kyselyt: #75

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621325'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_users` WHERE id='1621325'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.02 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
21	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.49 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.731 MB Palautetut rivit: 1

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='1621325'

Selittää

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
22	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:168
21	CUser->init()	JROOT/components/com_community/libraries/core.php:201
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.21 ms Viimeisen kyselyn jälkeen: 0.13 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.757 MB Palautetut rivit: 1

Päällekkäiset kyselyt: #71

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621325'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621325'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
24	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
23	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
22	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
21	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:202
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.19 ms Viimeisen kyselyn jälkeen: 0.20 ms Kyselymuisti: 0.028 MB Muisti ennen kyselyä: 22.769 MB Palautetut rivit: 1

Päällekkäiset kyselyt: #72

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621325'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_users` WHERE id='1621325'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
29	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
28	CFactory::getUser()	JROOT/components/com_community/router.php:25
27	CommunityBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
26	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
25	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
24	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
23	JRouter->build()	JROOT/libraries/cms/router/site.php:149
22	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
21	JRoute::_()	JROOT/components/com_community/libraries/core.php:1367
20	CRoute::_()	JROOT/plugins/kunena/community/profile.php:63
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.30 ms Viimeisen kyselyn jälkeen: 0.11 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.790 MB Palautetut rivit: 1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 1621328

Selittää

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:365
20	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:280
19	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
18	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:115
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.39 ms Viimeisen kyselyn jälkeen: 0.13 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.800 MB Palautetut rivit: 1

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (1621328)

Selittää

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.22 ms Viimeisen kyselyn jälkeen: 0.15 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.830 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #81

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621328'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621328'

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
23	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
22	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
21	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
20	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:130
19	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
18	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:119
17	KunenaUserHelper::get()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.20 ms Viimeisen kyselyn jälkeen: 0.17 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.818 MB Palautetut rivit: 1

SELECT `id` 
  FROM `joom_users` 
  WHERE id='1621328'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_users` WHERE id='1621328'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
21	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:190
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.49 ms Viimeisen kyselyn jälkeen: 0.06 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 22.830 MB Palautetut rivit: 1

SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1' 
  WHERE a.`userid`='1621328'

Selittää

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
22	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:168
21	CUser->init()	JROOT/components/com_community/libraries/core.php:201
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.24 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 22.856 MB Palautetut rivit: 0

Päällekkäiset kyselyt: #78

SELECT `value` 
  FROM `joom_community_fields_values` 
  WHERE `field_id` = '2' 
  AND `user_id` = '1621328'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `value` FROM `joom_community_fields_values` WHERE `field_id` = '2' AND `user_id` = '1621328'

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
24	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:775
23	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:629
22	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:767
21	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:202
20	CFactory::getUser()	JROOT/plugins/kunena/community/profile.php:58
19	KunenaProfileCommunity->getProfileURL()	JROOT/libraries/kunena/user/user.php:663
18	KunenaUser->getURL()	JROOT/libraries/kunena/user/user.php:602
17	KunenaUser->getLink()	JROOT/libraries/kunena/forum/statistics.php:347
16	KunenaForumStatistics->loadTopProfiles()	JROOT/libraries/kunena/forum/statistics.php:123
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.33 ms Viimeisen kyselyn jälkeen: 0.24 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 22.867 MB Palautetut rivit: 0

SELECT `t`.`targetuserid` AS `id`,COUNT(t.targetuserid) AS count

  FROM `joom_kunena_thankyou` AS `t`

  INNER JOIN `joom_users` AS `u` 
  ON `u`.`id` = `t`.`targetuserid`

  GROUP BY `t`.`targetuserid`

  ORDER BY `count` DESC 
  LIMIT 5

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `t`.`targetuserid` AS `id`,COUNT(t.targetuserid) AS count FROM `joom_kunena_thankyou` AS `t` INNER JOIN `joom_users` AS `u` ON `u`.`id` = `t`.`targetuserid` GROUP BY `t`.`targetuserid` ORDER BY `count` DESC LIMIT 5

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Creating tmp table	0.06 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/statistics.php:438
16	KunenaForumStatistics->loadTopThankyous()	JROOT/libraries/kunena/forum/statistics.php:132
15	KunenaForumStatistics->loadUserStats()	JROOT/libraries/kunena/forum/statistics.php:90
14	KunenaForumStatistics->loadAll()	JROOT/components/com_kunena/controller/statistics/general/display.php:46
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.77 ms Viimeisen kyselyn jälkeen: 0.12 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 22.874 MB Palautetut rivit: 0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=search%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=search%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.47 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
17	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1390
16	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1300
15	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
14	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/statistics/general/display.php:50
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.26 ms Viimeisen kyselyn jälkeen: 0.06 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 22.883 MB Palautetut rivit: 0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` = 'index.php?option=com_community&view=frontpage' 
  AND `published`='1' 
  AND `type`='component' 
  AND (`language` = 'fi-FI' )

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_menu` WHERE `link` = 'index.php?option=com_community&view=frontpage' AND `published`='1' AND `type`='component' AND (`language` = 'fi-FI' )

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
17	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1430
16	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1315
15	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
14	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/statistics/general/display.php:50
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.54 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 22.891 MB Palautetut rivit: 27

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community%' 
  AND `published`='1' 
  AND `type`='component'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community%' AND `published`='1' AND `type`='component'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.37 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
17	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1439
16	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1315
15	CRoute::_()	JROOT/plugins/kunena/community/profile.php:45
14	KunenaProfileCommunity->getUserListURL()	JROOT/components/com_kunena/controller/statistics/general/display.php:50
13	ComponentKunenaControllerStatisticsGeneralDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/statistics/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:112
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.69 ms Viimeisen kyselyn jälkeen: 3.46 ms Kyselymuisti: 0.026 MB Muisti ennen kyselyä: 23.138 MB Palautetut rivit: 0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=register%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `id` FROM `joom_menu` WHERE `link` LIKE '%option=com_community&view=register%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'

Profiili

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.37 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1732
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1390
21	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1300
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:147
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 2.70 ms Viimeisen kyselyn jälkeen: 6.60 ms Kyselymuisti: 0.029 MB Muisti ennen kyselyä: 23.744 MB Palautetut rivit: 21

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

  FROM joom_modules AS m

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

  LEFT JOIN joom_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 <= '2026-06-24 17:16:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-24 17:16:49') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 838 OR mm.menuid <= 0) 
  AND m.language IN ('fi-FI','*')

  ORDER BY m.position, m.ordering

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joom_modules AS m LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joom_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 <= '2026-06-24 17:16:49') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-24 17:16:49') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 838 OR mm.menuid <= 0) AND m.language IN ('fi-FI','*') ORDER BY m.position, m.ordering

Profiili

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.06 ms
executing	1.03 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
29	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
28	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
27	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
26	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
25	JDocumentHtml->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
24	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php:13
23	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:183
22	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
21	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
20	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/login/login/default.php:69
19	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/login/login/default.php	JROOT/libraries/kunena/layout/base.php:183
18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
16	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:147
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.22 ms Viimeisen kyselyn jälkeen: 0.40 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 23.720 MB Palautetut rivit: 1

SELECT special_characters 
  FROM joom_languages 
  WHERE sef = 'fi' 
  LIMIT 1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT special_characters FROM joom_languages WHERE sef = 'fi' LIMIT 1

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
18	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:308
17	AxsLanguage::getSpecialCharacters()	JROOT/libraries/axslibs/language.php:27
16	AxsLanguage::translate()	JROOT/libraries/axslibs/language.php:441
15	AxsLanguage::getLocalizationVariable()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:26
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:30
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:147
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.24 ms Viimeisen kyselyn jälkeen: 0.04 ms Kyselymuisti: 0.024 MB Muisti ennen kyselyä: 23.730 MB Palautetut rivit: 13

SELECT *

  FROM axs_translations

  WHERE language_tag = 'fi'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM axs_translations WHERE language_tag = 'fi'

Profiili

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1498
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/axslibs/language.php:151
17	AxsLanguage::getTranslationMap()	JROOT/libraries/axslibs/language.php:40
16	AxsLanguage::translate()	JROOT/libraries/axslibs/language.php:441
15	AxsLanguage::getLocalizationVariable()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:26
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:30
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:147
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.33 ms Viimeisen kyselyn jälkeen: 0.48 ms Kyselymuisti: 0.023 MB Muisti ennen kyselyä: 23.751 MB Palautetut rivit: 0

SELECT *

  FROM joom_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-24 17:16:49') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-24 17:16:49')

  ORDER BY id DESC 
  LIMIT 1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_kunena_announcement WHERE (published = 1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-24 17:16:49') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-24 17:16:49') ORDER BY id DESC LIMIT 1

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1498
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:131
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:40
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:35
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:147
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.86 ms Viimeisen kyselyn jälkeen: 2.72 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 23.898 MB Palautetut rivit: 1

SELECT language,id

  FROM `joom_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT language,id FROM `joom_menu` WHERE home = 1 AND published = 1 AND client_id = 0

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.51 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
10	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:729
9	PlgSystemLanguageFilter->onAfterDispatch()	Sama kuin soitto alla olevalla rivillä.
8	ReflectionMethod->invokeArgs()	JROOT/libraries/tovuti/Helpers/MethodHelper.php:58
7	Tovuti\Helpers\MethodHelper::call()	JROOT/libraries/joomla/event/event.php:72
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.38 ms Viimeisen kyselyn jälkeen: 6.78 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 24.266 MB Palautetut rivit: 10

SELECT * 
  FROM axs_fonts 
  WHERE enabled = 1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM axs_fonts WHERE enabled = 1

Profiili

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/fonts.php:34
9	AxsFonts::getFonts()	JROOT/templates/axs/home.php:138
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:72
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1132
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.27 ms Viimeisen kyselyn jälkeen: 0.29 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 24.300 MB Palautetut rivit: 0

SELECT *

  FROM accessibility_images

  WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' 
  AND enabled= 1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM accessibility_images WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' AND enabled= 1

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/accessibility.php:42
10	AxsAccessibility::query()	JROOT/libraries/axslibs/accessibility.php:49
9	AxsAccessibility::image()	JROOT/templates/axs/home.php:838
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:72
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1132
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.38 ms Viimeisen kyselyn jälkeen: 1.78 ms Kyselymuisti: 0.021 MB Muisti ennen kyselyä: 24.354 MB Palautetut rivit: 0

SELECT * 
  FROM axs_notifications  
  WHERE enabled = 1  
  AND   DATE(start_date) <= NOW()  
  AND   ( DATE(end_date) > NOW() OR end_date = 0 )  
  AND (  ( access_type = 'access' 
  AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
  AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
  AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' ) )

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM axs_notifications WHERE enabled = 1 AND DATE(start_date) <= NOW() AND ( DATE(end_date) > NOW() OR end_date = 0 ) AND ( ( access_type = 'access' AND ( ( FIND_IN_SET( 1, accesslevel ) > 0 ) OR ( FIND_IN_SET( 1, accesslevel ) > 0 ) ) ) OR ( access_type = 'user' AND ( ( FIND_IN_SET( 1, usergroup ) > 0 ) ) ) OR ( access_type = 'list' AND ( FIND_IN_SET( 0, userlist ) > 0 ) ) OR ( access_type = 'none' ) )

Profiili

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.07 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/notifications.php:19
9	AxsNotifications::loadNotifications()	JROOT/templates/axs/home.php:1827
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:72
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1132
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.31 ms Viimeisen kyselyn jälkeen: 0.73 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 24.263 MB Palautetut rivit: 1

SELECT sef 
  FROM joom_languages 
  WHERE lang_code = 'fi-FI' 
  LIMIT 1

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT sef FROM joom_languages WHERE lang_code = 'fi-FI' LIMIT 1

Profiili

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1654
13	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:285
12	AxsLanguage::getSefByLangCode()	JROOT/modules/mod_mediamodal/tmpl/default.php:8
11	require JROOT/modules/mod_mediamodal/tmpl/default.php	JROOT/modules/mod_mediamodal/mod_mediamodal.php:9
10	include JROOT/modules/mod_mediamodal/mod_mediamodal.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1148
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.24 ms Viimeisen kyselyn jälkeen: 3.65 ms Kyselymuisti: 0.025 MB Muisti ennen kyselyä: 24.508 MB Palautetut rivit: 0

SELECT *

  FROM joom_easyblog_configs

  WHERE `name` = 'config'

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT * FROM joom_easyblog_configs WHERE `name` = 'config'

Profiili

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1457
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
20	JTable->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:415
19	EB::config()	JROOT/components/com_easyblog/router.php:19
18	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_defaultmenu/helper.php:134
11	ModDefaultHelper::getList()	JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
10	include JROOT/modules/mod_defaultmenu/mod_defaultmenu.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1148
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

Kyselyaika: 1.46 ms Viimeisen kyselyn jälkeen: 3.49 ms Kyselymuisti: 0.022 MB Muisti ennen kyselyä: 24.617 MB Palautetut rivit: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `joom_menu` AS `c`

  INNER JOIN `joom_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `joom_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `joom_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 838

Selittää

EXPLAIN ei ole mahdollista kyselyssä: SELECT `c2`.`language`,`c2`.`id` FROM `joom_menu` AS `c` INNER JOIN `joom_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNER JOIN `joom_associations` AS `a2` ON a.key = a2.key INNER JOIN `joom_menu` AS `c2` ON a2.id = c2.`id` WHERE c.id = 838

Profiili

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Kutsupino

#	Soittaja	Tiedoston ja rivin numero
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1693
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:313
12	MenusHelper::getAssociations()	JROOT/modules/mod_language_selector/tmpl/default.php:98
11	require JROOT/modules/mod_language_selector/tmpl/default.php	JROOT/modules/mod_language_selector/mod_language_selector.php:4
10	include JROOT/modules/mod_language_selector/mod_language_selector.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1148
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:73

[Lisää php.ini-tiedostoon käsky xdebug.file_link_format saadaksesi linkit tiedostoihin.]

59 kyselytyyppiä kirjattu, lajiteltu tapahtumien mukaan.

VALITSE taulukot:

10 × SELECT `value` 
  FROM `joom_community_fields_values`

6 × SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid`

```
6 × SELECT `id` 
  FROM `joom_users`
```

5 × SELECT * 
  FROM `joom_kunena_topics`

5 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*    
  FROM joom_users AS u    
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid

5 × SELECT   a.`userid` as _userid ,  a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`cover` as _cover ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session` s  
  ON s.`userid`=a.`userid` 
  AND s.`client_id` !='1'

```
5 × SELECT `id` 
  FROM `joom_menu`
```
```
2 × SELECT * 
  FROM joom_languages
```

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

2 × SELECT DISTINCT(user_id) 
  FROM joom_usergroups as ug1 
  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

```
1 × SELECT * 
  FROM `axs_brands`
```

1 × SELECT * 
  FROM `axs_homepage_templates`

1 × SELECT * 
  FROM `axs_dashboard_templates`

1 × SELECT * 
  FROM axs_email_settings

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

1 × SELECT * 
  FROM axs_payment_gateways

```
1 × SELECT * 
  FROM axs_integrations
```

1 × SELECT id, rules 
  FROM `joom_viewlevels

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM joom_extensions

```
1 × SELECT * 
  FROM axs_domains
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `joom_extensions`

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

1 × SELECT `id`,`title` 
  FROM `joom_usergroups`

1 × SELECT * 
  FROM joom_kunena_configuration

1 × SELECT * 
  FROM joom_kunena_aliases

1 × SELECT params 
  FROM axs_user_settings

```
1 × SELECT * 
  FROM `joom_users`
```

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

1 × SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role    
  FROM joom_kunena_categories AS c    
  INNER JOIN joom_community_groups_members AS g 
  ON c.accesstype='jomsocial' 
  AND c.access=g.groupid

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

1 × SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories

1 × SELECT COUNT(*), MAX(id) 
  FROM joom_users

1 × SELECT * 
  FROM joom_kunena_categories

1 × SELECT groupid 
  FROM joom_community_groups_members

1 × SELECT     SUM(time>=1782273600 
  AND parent=0) AS todayTopicCount,     SUM(time>=1782273600 
  AND parent>0) AS todayReplyCount,     SUM(time>=1782187200 
  AND time<1782273600 
  AND parent=0) AS yesterdayTopicCount,     SUM(time>=1782187200 
  AND time<1782273600 
  AND parent>0) AS yesterdayReplyCount     
  FROM joom_kunena_messages

1 × SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt

1 × SELECT poll.threadid AS id, SUM(opt.votes) AS count      
  FROM joom_kunena_polls_options AS opt      
  INNER JOIN joom_kunena_polls AS poll 
  ON poll.id=opt.pollid      
  GROUP BY pollid      
  HAVING count > 0

1 × SELECT `u`.`id`,`ku`.`posts` AS `count` 
  FROM `joom_kunena_users` AS `ku` 
  INNER JOIN `joom_users` AS `u` 
  ON `u`.`id` = `ku`.`userid`

1 × SELECT cu.userid AS id, cu.view AS count    
  FROM joom_community_users AS cu    
  INNER JOIN joom_users AS u 
  ON u.id=cu.userid

1 × SELECT * 
  FROM joom_community_config

1 × SELECT `id` 
  FROM `joom_community_fields`

1 × SELECT `t`.`targetuserid` AS `id`,COUNT(t.targetuserid) AS count 
  FROM `joom_kunena_thankyou` AS `t` 
  INNER JOIN `joom_users` AS `u` 
  ON `u`.`id` = `t`.`targetuserid` 
  GROUP BY `t`.`targetuserid`

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

1 × SELECT special_characters 
  FROM joom_languages

```
1 × SELECT * 
  FROM axs_translations
```

1 × SELECT * 
  FROM joom_kunena_announcement

1 × SELECT language,id 
  FROM `joom_menu`

```
1 × SELECT * 
  FROM axs_fonts
```

1 × SELECT * 
  FROM accessibility_images

1 × SELECT * 
  FROM axs_notifications

```
1 × SELECT sef 
  FROM joom_languages
```

1 × SELECT * 
  FROM joom_easyblog_configs

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `joom_menu` AS `c` 
  INNER JOIN `joom_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `joom_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `joom_menu` AS `c2` 
  ON a2.id = c2.`id`

MUUT taulukot:

1 × UPDATE `joom_extensions` 
  SET `params` = '{\"mediaversion\":\"bfebfebade889030a08811c5dca947ee\"}'

1 × SHOW FULL COLUMNS 
  FROM `joom_users

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `joom_community_config

1 × SHOW FULL COLUMNS 
  FROM `joom_community_profiles

Tilastot

COM_KUNENA_LIB_STAT_TOP_PROFILES

Tilastot

Joomla! Debug-konsoli

Istunto

profiilin tiedot

Aika

Muisti

Muistin käyttö

Tietokantakyselyt

97 kyselyä kirjattu 143.40 ms

16 kaksoiskappale löydetty!

59 kyselytyyppiä kirjattu, lajiteltu tapahtumien mukaan.

VALITSE taulukot:

MUUT taulukot: