Wrec 2018

Joomla! virheenkorjauskonsoli

Istunto

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1542409341,
                "last": 1542409341,
                "now": 1542409341
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "fi-FI"
        }
    }
}

Profiilin tiedot

Aika

Muisti

Aika: 1.52 ms / 1.52 ms Muisti: 0.506 MB / 0.87 MB Application: afterLoad

Aika: 25.13 ms / 26.65 ms Muisti: 5.546 MB / 6.42 MB Application: afterInitialise

Aika: 2.99 ms / 29.64 ms Muisti: 0.162 MB / 6.58 MB Application: afterRoute

Aika: 0.16 ms / 29.80 ms Muisti: 0.018 MB / 6.60 MB Application: beforeRenderComponent com_content

Aika: 0.87 ms / 30.67 ms Muisti: 0.134 MB / 6.73 MB Application: Before Access::preloadComponents (all components)

Aika: 0.24 ms / 30.92 ms Muisti: 0.059 MB / 6.79 MB Application: After Access::preloadComponents (all components)

Aika: 0.02 ms / 30.94 ms Muisti: 0.000 MB / 6.79 MB Application: Before Access::preloadPermissions (com_content)

Aika: 8.19 ms / 39.13 ms Muisti: 5.360 MB / 12.15 MB Application: After Access::preloadPermissions (com_content)

Aika: 0.19 ms / 39.32 ms Muisti: 0.000 MB / 11.90 MB Application: Before Access::getAssetRules (id:2158 name:com_content.article.1187)

Aika: 0.21 ms / 39.53 ms Muisti: 0.010 MB / 11.91 MB Application: After Access::getAssetRules (id:2158 name:com_content.article.1187)

Aika: 5.22 ms / 44.75 ms Muisti: 0.446 MB / 12.35 MB Application: Before Access::getAssetRules (id:11114 name:com_content.article.6409)

Aika: 0.06 ms / 44.81 ms Muisti: 0.007 MB / 12.36 MB Application: After Access::getAssetRules (id:11114 name:com_content.article.6409)

Aika: 1.93 ms / 46.74 ms Muisti: 0.104 MB / 12.46 MB Application: Before Access::getAssetRules (id:2225 name:com_content.article.1235)

Aika: 0.02 ms / 46.76 ms Muisti: 0.002 MB / 12.46 MB Application: After Access::getAssetRules (id:2225 name:com_content.article.1235)

Aika: 1.26 ms / 48.02 ms Muisti: 0.063 MB / 12.53 MB Application: Before Access::getAssetRules (id:2185 name:com_content.article.1204)

Aika: 0.02 ms / 48.04 ms Muisti: 0.002 MB / 12.53 MB Application: After Access::getAssetRules (id:2185 name:com_content.article.1204)

Aika: 3.14 ms / 51.19 ms Muisti: 0.131 MB / 12.66 MB Application: beforeRenderModule mod_articles_category (Wrec 2015 Etusivu ajankohtaista)

Aika: 1.34 ms / 52.53 ms Muisti: 0.074 MB / 12.73 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Aika: 0.04 ms / 52.57 ms Muisti: 0.007 MB / 12.74 MB Application: After Access::getAssetRules (id:8 name:com_content)

Aika: 27.12 ms / 79.69 ms Muisti: 0.243 MB / 12.98 MB Application: Before Access::getAssetRules (id:11224 name:com_content.article.6464)

Aika: 0.03 ms / 79.72 ms Muisti: 0.002 MB / 12.99 MB Application: After Access::getAssetRules (id:11224 name:com_content.article.6464)

Aika: 0.86 ms / 80.58 ms Muisti: 0.032 MB / 13.02 MB Application: Before Access::getAssetRules (id:11200 name:com_content.article.6452)

Aika: 0.02 ms / 80.60 ms Muisti: 0.002 MB / 13.02 MB Application: After Access::getAssetRules (id:11200 name:com_content.article.6452)

Aika: 0.63 ms / 81.23 ms Muisti: 0.031 MB / 13.05 MB Application: Before Access::getAssetRules (id:11186 name:com_content.article.6445)

Aika: 0.02 ms / 81.24 ms Muisti: 0.002 MB / 13.05 MB Application: After Access::getAssetRules (id:11186 name:com_content.article.6445)

Aika: 0.58 ms / 81.82 ms Muisti: 0.035 MB / 13.09 MB Application: Before Access::getAssetRules (id:11166 name:com_content.article.6435)

Aika: 0.02 ms / 81.84 ms Muisti: 0.002 MB / 13.09 MB Application: After Access::getAssetRules (id:11166 name:com_content.article.6435)

Aika: 0.58 ms / 82.42 ms Muisti: 0.035 MB / 13.12 MB Application: Before Access::getAssetRules (id:11148 name:com_content.article.6426)

Aika: 0.02 ms / 82.43 ms Muisti: 0.002 MB / 13.12 MB Application: After Access::getAssetRules (id:11148 name:com_content.article.6426)

Aika: 0.60 ms / 83.03 ms Muisti: 0.035 MB / 13.16 MB Application: Before Access::getAssetRules (id:11126 name:com_content.article.6415)

Aika: 0.02 ms / 83.05 ms Muisti: 0.002 MB / 13.16 MB Application: After Access::getAssetRules (id:11126 name:com_content.article.6415)

Aika: 3.27 ms / 86.32 ms Muisti: 0.034 MB / 13.19 MB Application: afterRenderModule mod_articles_category (Wrec 2015 Etusivu ajankohtaista)

Aika: 0.05 ms / 86.36 ms Muisti: 0.000 MB / 13.07 MB Application: beforeRenderModule mod_articles_category (Wrec2015 etusivu tulokset)

Aika: 26.09 ms / 112.46 ms Muisti: 0.198 MB / 13.27 MB Application: Before Access::getAssetRules (id:11228 name:com_content.article.6466)

Aika: 0.03 ms / 112.49 ms Muisti: 0.002 MB / 13.27 MB Application: After Access::getAssetRules (id:11228 name:com_content.article.6466)

Aika: 0.82 ms / 113.31 ms Muisti: 0.026 MB / 13.29 MB Application: Before Access::getAssetRules (id:11222 name:com_content.article.6463)

Aika: 0.02 ms / 113.33 ms Muisti: 0.002 MB / 13.30 MB Application: After Access::getAssetRules (id:11222 name:com_content.article.6463)

Aika: 0.63 ms / 113.96 ms Muisti: 0.021 MB / 13.32 MB Application: Before Access::getAssetRules (id:11216 name:com_content.article.6460)

Aika: 0.03 ms / 113.98 ms Muisti: 0.002 MB / 13.32 MB Application: After Access::getAssetRules (id:11216 name:com_content.article.6460)

Aika: 0.58 ms / 114.56 ms Muisti: 0.021 MB / 13.34 MB Application: Before Access::getAssetRules (id:11210 name:com_content.article.6457)

Aika: 0.02 ms / 114.58 ms Muisti: 0.002 MB / 13.34 MB Application: After Access::getAssetRules (id:11210 name:com_content.article.6457)

Aika: 0.75 ms / 115.33 ms Muisti: 0.022 MB / 13.36 MB Application: Before Access::getAssetRules (id:11208 name:com_content.article.6456)

Aika: 0.02 ms / 115.35 ms Muisti: 0.002 MB / 13.36 MB Application: After Access::getAssetRules (id:11208 name:com_content.article.6456)

Aika: 0.81 ms / 116.16 ms Muisti: 0.021 MB / 13.39 MB Application: Before Access::getAssetRules (id:11202 name:com_content.article.6453)

Aika: 0.02 ms / 116.18 ms Muisti: 0.002 MB / 13.39 MB Application: After Access::getAssetRules (id:11202 name:com_content.article.6453)

Aika: 2.55 ms / 118.73 ms Muisti: 0.022 MB / 13.41 MB Application: Before Access::getAssetRules (id:11196 name:com_content.article.6450)

Aika: 0.03 ms / 118.75 ms Muisti: 0.002 MB / 13.41 MB Application: After Access::getAssetRules (id:11196 name:com_content.article.6450)

Aika: 0.80 ms / 119.55 ms Muisti: 0.000 MB / 13.28 MB Application: afterRenderModule mod_articles_category (Wrec2015 etusivu tulokset)

Aika: 0.05 ms / 119.60 ms Muisti: 0.000 MB / 13.08 MB Application: afterRenderComponent com_content

Aika: 1.14 ms / 120.74 ms Muisti: 0.044 MB / 13.13 MB Application: afterDispatch

Aika: 0.87 ms / 121.60 ms Muisti: 0.030 MB / 13.16 MB Application: beforeRenderModule mod_menu (Wrec 2015 Menu)

Aika: 1.48 ms / 123.09 ms Muisti: 0.112 MB / 13.27 MB Application: afterRenderModule mod_menu (Wrec 2015 Menu)

Aika: 0.03 ms / 123.11 ms Muisti: 0.000 MB / 13.27 MB Application: beforeRenderModule mod_menu (Wrec 2015 Menu EN)

Aika: 0.17 ms / 123.29 ms Muisti: 0.004 MB / 13.27 MB Application: afterRenderModule mod_menu (Wrec 2015 Menu EN)

Aika: 0.08 ms / 123.37 ms Muisti: 0.000 MB / 13.27 MB Application: beforeRenderModule mod_languages (Language selector)

Aika: 0.65 ms / 124.02 ms Muisti: 0.016 MB / 13.28 MB Application: afterRenderModule mod_languages (Language selector)

Aika: 0.50 ms / 124.52 ms Muisti: 0.045 MB / 13.33 MB Application: afterRender

Tietokantakyselyt yhteensä: 72.01 ms

Muistin käyttö

Tietokantakyselyt

67 kyselyä kirjattu 72.01 ms

2 päällekkäisyyttä löytynyt!

2 päällekkäistä: #21 #42

Kyselyn aika: 0.20 ms

SELECT `data`

  FROM `raq76_session`

  WHERE `session_id` = '6m3u9et4is7s7q0lvfvstbqc78'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Sama kuin kutsu alla olevalla rivillä.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.11 ms Viimeisen kyselyn jälkeen: 0.24 ms

SELECT `session_id`

  FROM `raq76_session`

  WHERE `session_id` = '6m3u9et4is7s7q0lvfvstbqc78' 
  LIMIT 1

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.81 ms Viimeisen kyselyn jälkeen: 0.10 ms

INSERT INTO `raq76_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('6m3u9et4is7s7q0lvfvstbqc78', 1, 1542409341, 0, '', 0)

Selite

EXPLAIN ei mahdollinen kyselyssä: INSERT INTO `raq76_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6m3u9et4is7s7q0lvfvstbqc78', 1, 1542409341, 0, '', 0)

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

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

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.33 ms Viimeisen kyselyn jälkeen: 0.44 ms

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

  FROM `raq76_extensions`

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

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Sama kuin kutsu alla olevalla rivillä.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.06 ms Viimeisen kyselyn jälkeen: 0.36 ms

SELECT id, rules

  FROM `raq76_viewlevels`

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

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

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.04 ms Viimeisen kyselyn jälkeen: 0.08 ms

SELECT b.id

  FROM raq76_usergroups AS a

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

  WHERE a.id = 1

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

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

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.56 ms Viimeisen kyselyn jälkeen: 0.12 ms

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

  FROM raq76_extensions

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

  ORDER BY ordering

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_extensions	ref	extension	extension	82	const	105	Using index condition; Using where; Using filesort

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Sama kuin kutsu alla olevalla rivillä.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.23 ms Viimeisen kyselyn jälkeen: 2.39 ms

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

  FROM `raq76_extensions`

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

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Sama kuin kutsu alla olevalla rivillä.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_sl_piknik/classes/piknik.php:34
9	Piknik->loadParent()	JROOT/administrator/components/com_sl_piknik/classes/piknik.php:22
8	Piknik->__construct()	JROOT/plugins/system/sl_piknik/sl_piknik.php:12
7	PlgSystemSl_piknik->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.55 ms Viimeisen kyselyn jälkeen: 0.16 ms

UPDATE `raq76_extensions`

  SET `params` = '{\"mediaversion\":\"2b919ab8e50129be3f9107a1fae11027\"}'

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

Selite

EXPLAIN ei mahdollinen kyselyssä: UPDATE `raq76_extensions` SET `params` = '{\"mediaversion\":\"2b919ab8e50129be3f9107a1fae11027\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
15	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_sl_piknik/classes/piknik.php:34
9	Piknik->loadParent()	JROOT/administrator/components/com_sl_piknik/classes/piknik.php:22
8	Piknik->__construct()	JROOT/plugins/system/sl_piknik/sl_piknik.php:12
7	PlgSystemSl_piknik->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.07 ms Viimeisen kyselyn jälkeen: 0.69 ms

SELECT *

  FROM raq76_languages

  WHERE published=1

  ORDER BY ordering ASC

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using filesort

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.21 ms Viimeisen kyselyn jälkeen: 0.14 ms

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

  FROM `raq76_extensions`

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

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_extensions	ref	extension	extension	82	const	4	Using index condition; Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 6.97 ms Viimeisen kyselyn jälkeen: 2.76 ms

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

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

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	1312	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	vau.m.component_id	1	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.24 ms Viimeisen kyselyn jälkeen: 8.16 ms

SELECT catid 
  FROM raq76_content 
  WHERE id = '1187'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/sl_piknik/sl_piknik.php:67
8	PlgSystemSl_piknik->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.05 ms Viimeisen kyselyn jälkeen: 0.05 ms

SELECT value 
  FROM raq76_sl_piknik 
  WHERE name = 'override_map'

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_sl_piknik	const	PRIMARY	PRIMARY	767	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/sl_piknik/sl_piknik.php:76
8	PlgSystemSl_piknik->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.09 ms Viimeisen kyselyn jälkeen: 1.29 ms

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

  FROM `raq76_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_sl_kuntokuu','com_sl_media','com_sl_newsletter','com_sl_piknik','com_sl_sportsclubsearch','com_tags','com_templates','com_users','com_wrapper')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_assets	range	idx_asset_name	idx_asset_name	202	NULL	41	Using index condition

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
14	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:16
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 1.86 ms Viimeisen kyselyn jälkeen: 0.16 ms

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

  FROM `raq76_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	12735	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
14	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:16
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.53 ms Viimeisen kyselyn jälkeen: 6.95 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 1187 
  AND c.published > 0 
  AND a.language in ('fi-FI','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21') 
  AND (a.state = 1 OR a.state =2)

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:16
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.07 ms Viimeisen kyselyn jälkeen: 1.89 ms

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

  FROM `raq76_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1187 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	306	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	vau.t.id	47	Using index condition; Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.06 ms Viimeisen kyselyn jälkeen: 0.82 ms

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

  FROM `raq76_categories` AS `s`

  INNER JOIN `raq76_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fi-FI','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	34	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.05 ms Viimeisen kyselyn jälkeen: 0.21 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM raq76_fields AS a

  LEFT JOIN `raq76_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN raq76_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN raq76_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN raq76_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN raq76_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `raq76_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (27,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','fi-FI')

  ORDER BY a.ordering ASC

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	vau.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	vau.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	vau.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	vau.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	vau.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	vau.a.id	1	Using where; Using index

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.51 ms Viimeisen kyselyn jälkeen: 1.44 ms

Päällekkäisiä kyselyitä: #42

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6409 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
21	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
20	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
19	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
18	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
17	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:410
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.13 ms Viimeisen kyselyn jälkeen: 0.53 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '6409'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
27	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
26	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/includes/sl_helpers/sl_vau.php:413
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.05 ms Viimeisen kyselyn jälkeen: 0.11 ms

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

  FROM `raq76_categories` AS `s`

  INNER JOIN `raq76_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fi-FI','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	34	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Sama kuin kutsu alla olevalla rivillä.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/includes/sl_helpers/sl_vau.php:413
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.11 ms Viimeisen kyselyn jälkeen: 0.15 ms

SELECT alias

  FROM raq76_content

  WHERE id=6409

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
26	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
25	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
24	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
23	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/includes/sl_helpers/sl_vau.php:413
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.33 ms Viimeisen kyselyn jälkeen: 0.35 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 1235 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
21	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
20	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
19	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
18	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
17	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:410
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.11 ms Viimeisen kyselyn jälkeen: 0.29 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '1235'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
27	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
26	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/includes/sl_helpers/sl_vau.php:413
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.07 ms Viimeisen kyselyn jälkeen: 0.10 ms

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

  FROM `raq76_categories` AS `s`

  INNER JOIN `raq76_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fi-FI','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	34	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Sama kuin kutsu alla olevalla rivillä.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/includes/sl_helpers/sl_vau.php:413
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.34 ms Viimeisen kyselyn jälkeen: 0.40 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 1204 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
21	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
20	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
19	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
18	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
17	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:410
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.13 ms Viimeisen kyselyn jälkeen: 0.23 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '1204'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
27	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
26	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/includes/sl_helpers/sl_vau.php:413
16	Sl_vau::getFeaturedArticleData()	JROOT/includes/sl_helpers/sl_vau.php:429
15	Sl_vau::getFrontpageSubFeatured()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:34
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.05 ms Viimeisen kyselyn jälkeen: 0.24 ms

SELECT *

  FROM raq76_sl_piknik_media

  WHERE path = 'images/WREC2018/wrec2018ennakkoanalyysi.jpg'

  ORDER BY path ASC

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_sl_piknik_media	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7750	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/includes/sl_helpers/sl_media.php:50
17	Sl_media::_getDataFromDb()	JROOT/includes/sl_helpers/sl_media.php:34
16	Sl_media::_getSingleData()	JROOT/includes/sl_helpers/sl_media.php:19
15	Sl_media::getData()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:94
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.04 ms Viimeisen kyselyn jälkeen: 0.10 ms

SELECT *

  FROM raq76_sl_piknik_media

  WHERE path = 'images/WREC2018/turnausjarjestelmakuvai.jpg'

  ORDER BY path ASC

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_sl_piknik_media	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7750	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/includes/sl_helpers/sl_media.php:50
17	Sl_media::_getDataFromDb()	JROOT/includes/sl_helpers/sl_media.php:34
16	Sl_media::_getSingleData()	JROOT/includes/sl_helpers/sl_media.php:19
15	Sl_media::getData()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:94
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.05 ms Viimeisen kyselyn jälkeen: 0.09 ms

SELECT *

  FROM raq76_sl_piknik_media

  WHERE path = 'images/wrec2015/historianetti.jpg'

  ORDER BY path ASC

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_sl_piknik_media	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7750	Using where

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/includes/sl_helpers/sl_media.php:50
17	Sl_media::_getDataFromDb()	JROOT/includes/sl_helpers/sl_media.php:34
16	Sl_media::_getSingleData()	JROOT/includes/sl_helpers/sl_media.php:19
15	Sl_media::getData()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:94
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 1.24 ms Viimeisen kyselyn jälkeen: 0.22 ms

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

  FROM raq76_modules AS m

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

  LEFT JOIN raq76_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 <= '2018-11-16 23:02:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-11-16 23:02:21') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 570 OR mm.menuid <= 0) 
  AND m.language IN ('fi-FI','*')

  ORDER BY m.position, m.ordering

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	59	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	vau.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	vau.m.id	2	Using where; Using index

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	Sama kuin kutsu alla olevalla rivillä.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:114
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 4.38 ms Viimeisen kyselyn jälkeen: 1.81 ms

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

  FROM raq76_content AS a

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

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

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

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (10) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21') 
  AND a.language IN ('fi-FI','*')

  ORDER BY publish_up DESC 
  LIMIT 6

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	1771	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	vau.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	vau.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	vau.a.id	1	Using where
1	SIMPLE	sl	eq_ref	PRIMARY	PRIMARY	4	vau.a.id	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
21	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:223
20	ModArticlesCategoryHelper::getList()	Sama kuin kutsu alla olevalla rivillä.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 21.11 ms Viimeisen kyselyn jälkeen: 1.21 ms

SELECT distinct(c.id) 
  FROM raq76_content c
                
  LEFT JOIN raq76_contentitem_tag_map tag
                
  ON tag.content_item_id=c.id
                
  LEFT JOIN raq76_tags tags
                
  ON tag.tag_id=tags.id
                
  LEFT JOIN raq76_sl_piknik_search search
                
  ON c.id = search.content_id
                
  WHERE c.catid=10
                
  AND c.state = 1
                
  AND c.access = 1
                
  AND (c.publish_down >= '2018-11-16 23:02:21' OR c.publish_down = '0000-00-00 00:00:00')
                
  AND (c.publish_up <= '2018-11-16 23:02:21' OR c.publish_up = '0000-00-00 00:00:00')
                
  AND type_alias='com_content.article' 
  AND ( tag.tag_id in (163) OR tags.parent_id in (163) ) 
  AND c.language = 'fi-FI' 
  ORDER BY c.publish_up DESC 
  LIMIT 7 OFFSET 0

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	13845	Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	vau.tag.content_item_id	1	Using where
1	SIMPLE	tags	eq_ref	PRIMARY	PRIMARY	4	vau.tag.tag_id	1	Using where; Distinct
1	SIMPLE	search	ref	content_id	content_id	4	vau.c.id	1	Using index; Distinct

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/includes/sl_helpers/sl_vau.php:202
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.49 ms Viimeisen kyselyn jälkeen: 0.48 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6464 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
22	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
21	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
20	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
19	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:212
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.33 ms Viimeisen kyselyn jälkeen: 0.35 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6452 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
22	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
21	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
20	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
19	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:212
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.30 ms Viimeisen kyselyn jälkeen: 0.30 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6445 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
22	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
21	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
20	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
19	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:212
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.30 ms Viimeisen kyselyn jälkeen: 0.29 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6435 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
22	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
21	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
20	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
19	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:212
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.31 ms Viimeisen kyselyn jälkeen: 0.29 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6426 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
22	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
21	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
20	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
19	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:212
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.32 ms Viimeisen kyselyn jälkeen: 0.31 ms

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6415 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
22	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
21	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
20	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
19	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:212
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.07 ms Viimeisen kyselyn jälkeen: 0.15 ms

Päällekkäisiä kyselyitä: #21

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,sl.data As sl_custom

  FROM raq76_content AS a

  INNER JOIN raq76_categories AS c 
  on c.id = a.catid

  LEFT JOIN raq76_users AS u 
  on u.id = a.created_by

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

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

  LEFT JOIN raq76_sl_piknik_values sl 
  ON a.id = sl.content_id

  WHERE a.id = 6409 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 23:02:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 23:02:21')

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
22	ContentModelArticle->getItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:114
21	Sl_articlehelper->loadItem()	JROOT/includes/sl_helpers/dist/sl_articlehelper.php:59
20	Sl_articlehelper::get()	JROOT/includes/sl_helpers/dist/sl_helper.php:169
19	Sl_helper::getArticle()	JROOT/includes/sl_helpers/sl_vau.php:212
18	Sl_vau::getArticles()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:21
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.11 ms Viimeisen kyselyn jälkeen: 0.19 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '6464'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
28	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
27	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.09 ms Viimeisen kyselyn jälkeen: 0.11 ms

SELECT alias

  FROM raq76_content

  WHERE id=6464

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
26	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
25	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
24	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.10 ms Viimeisen kyselyn jälkeen: 0.15 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '6452'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
28	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
27	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.10 ms Viimeisen kyselyn jälkeen: 0.11 ms

SELECT alias

  FROM raq76_content

  WHERE id=6452

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
26	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
25	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
24	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.09 ms Viimeisen kyselyn jälkeen: 0.14 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '6445'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
28	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
27	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.11 ms Viimeisen kyselyn jälkeen: 0.09 ms

SELECT alias

  FROM raq76_content

  WHERE id=6445

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
26	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
25	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
24	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.09 ms Viimeisen kyselyn jälkeen: 0.13 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '6435'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
28	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
27	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.09 ms Viimeisen kyselyn jälkeen: 0.09 ms

SELECT alias

  FROM raq76_content

  WHERE id=6435

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
26	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
25	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
24	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.10 ms Viimeisen kyselyn jälkeen: 0.13 ms

SELECT `alias`

  FROM `raq76_content`

  WHERE id = '6426'

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
29	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
28	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
27	ContentRouter->getArticleSegment()	Sama kuin kutsu alla olevalla rivillä.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.09 ms Viimeisen kyselyn jälkeen: 0.08 ms

SELECT alias

  FROM raq76_content

  WHERE id=6426

Selite

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

Profiili

Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
26	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
25	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
24	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
18	Joomla\CMS\Router\Route::_()	JROOT/templates/wrec2015/html/mod_articles_category/news.php:29
17	require JROOT/templates/wrec2015/html/mod_articles_category/news.php	JROOT/modules/mod_articles_category/mod_articles_category.php:99
16	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/wrec2015/html/com_content/article/frontpage.php:117
14	include JROOT/templates/wrec2015/html/com_content/article/frontpage.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/plugins/system/sl_piknik/com_content/views/article/ContentViewPiknik.php:47
10	ContentViewPiknik->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Lisää xdebug.file_link_format direktiivi sinun php.ini tiedostoon saadaksesi linkit tiedostoille]

Kyselyn aika: 0.03 ms Viimeisen kyselyn jälkeen: 0.14 ms

Ajankohtaista

Tulokset

Pyörätuolirugbyn B-sarjan EM-kilpailut 2018

Joomla! virheenkorjauskonsoli

Istunto

Profiilin tiedot

Aika

Muisti

Muistin käyttö

Tietokantakyselyt

67 kyselyä kirjattu 72.01 ms

2 päällekkäisyyttä löytynyt!