Historia

Pyörätuolirugby kehitettiin vuonna 1977 Kanadan Winnipegissä neliraajahalvaantuneille henkilöille soveltuvaksi vaihtoehdoksi pyörätuolikoripallolle. Tänä päivänäkin pyörätuolirugby on suunnattu urheilijoille, joilla on toimintarajoituksia paitsi jaloissa myös vähintään toisessa kädessä.

Alun perin lajin nimi oli Murderball – murhapallo. Nimi kertoo paljon lajin luonteesta. Kontaktia saa ottaa surutta ja myös pelituolit on suunniteltu sen mukaisesti. Myöhemmin lajin nimeksi vaihtui pyörätuolirugby, vaikkei laji olekaan ihan suoraan rugbya pyörätuoleilla. Lajissa on paljon vaikutteita myös muista joukkuepalloilulajeista, etunenässä koripallosta.

Lähes koko 80-luvun kanadalaiset ja yhdysvaltalaiset pelasivat pyörätuolirugbya keskenään. Vuonna 1989 saatiin Torontossa järjestettyyn turnaukseen mukaan myös joukkue Iso-Britanniasta. Tämän jälkeen laji lähti leviämään tehokkaasti ja vuonna 1993 toimintaa oli jo 15 maassa.

Suomeen laji saapui vuonna 1995 ja maajoukkuetoiminta saatiin startattua melko nopeasti. Suomi esiintyi ensimmäisen kerran MM-kilpailuissa vuonna 1998 Kanadassa. Aivan lajin kärkimaiden joukkoon Suomi ei ole vielä onnistunut murtautumaan. MM-kilpailujen paras sijoitus on kymmenes kesältä 2014. EM-kisoissa Suomi on ollut parhaimmillaan kuudes.

Eurooppalaisille joukkueille yltäminen maailman kärkeen on ollut muutenkin vaikeaa pyörätuolirugbyssa. MM-kilpailuissa ja paralympialaisissa ei ole koskaan ollut eurooppalaista maata mitaleilla. Yhdysvaltain ja Kanadan lisäksi myös Australia ja Uusi-Seelanti ovat tuttuja nimiä kunniataulukon kärkipäässä.

Pyörätuolirugby on ollut mukana paralympiaohjelmassa vuodesta 1996 lähtien, jolloin se oli näytöslajina Atlantan paralympialaisissa.

Suomi on isännöinyt pyörätuolirugbyn A-sarjan EM-kilpailuja kahdesti: vuonna 2007 Espoossa ja vuonna 2015 Pajulahdessa.

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

Pyörätuolirugbyn B-sarjan EM-kilpailut pelataan 7.–15. lokakuuta 2018 Liikuntakeskus Pajulahdessa Lahden Nastolassa. Pelipäivät ovat 10.–14.10. EM-kilpailujen ottelut pelataan Pajulahden päärakennuksen palloilusalissa. Kisojen kaksi parasta joukkuetta nousee A-sarjaan ja kaksi kisojen heikointa putoaa C-sarjaan.

Joomla! virheenkorjauskonsoli

Istunto

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1542405776,
                "last": 1542405776,
                "now": 1542405776
            }
        },
        "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.84 ms / 1.84 ms Muisti: 0.507 MB / 0.87 MB Application: afterLoad

Aika: 40.40 ms / 42.23 ms Muisti: 5.546 MB / 6.42 MB Application: afterInitialise

Aika: 5.07 ms / 47.30 ms Muisti: 0.156 MB / 6.58 MB Application: afterRoute

Aika: 0.29 ms / 47.59 ms Muisti: 0.016 MB / 6.59 MB Application: beforeRenderComponent com_content

Aika: 1.17 ms / 48.76 ms Muisti: 0.115 MB / 6.71 MB Application: Before Access::preloadComponents (all components)

Aika: 0.40 ms / 49.16 ms Muisti: 0.058 MB / 6.76 MB Application: After Access::preloadComponents (all components)

Aika: 0.03 ms / 49.19 ms Muisti: 0.000 MB / 6.76 MB Application: Before Access::preloadPermissions (com_content)

Aika: 16.77 ms / 65.96 ms Muisti: 5.359 MB / 12.12 MB Application: After Access::preloadPermissions (com_content)

Aika: 0.37 ms / 66.33 ms Muisti: 0.000 MB / 11.87 MB Application: Before Access::getAssetRules (id:2185 name:com_content.article.1204)

Aika: 0.32 ms / 66.65 ms Muisti: 0.010 MB / 11.88 MB Application: After Access::getAssetRules (id:2185 name:com_content.article.1204)

Aika: 13.67 ms / 80.33 ms Muisti: 0.546 MB / 12.42 MB Application: beforeRenderModule mod_menu (Wrec2015 Sivuvalikko)

Aika: 4.42 ms / 84.74 ms Muisti: 0.210 MB / 12.63 MB Application: afterRenderModule mod_menu (Wrec2015 Sivuvalikko)

Aika: 0.90 ms / 85.64 ms Muisti: 0.000 MB / 12.60 MB Application: afterRenderComponent com_content

Aika: 1.00 ms / 86.64 ms Muisti: 0.087 MB / 12.69 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Aika: 0.07 ms / 86.71 ms Muisti: 0.007 MB / 12.69 MB Application: After Access::getAssetRules (id:8 name:com_content)

Aika: 1.30 ms / 88.01 ms Muisti: 0.016 MB / 12.71 MB Application: afterDispatch

Aika: 4.20 ms / 92.22 ms Muisti: 0.032 MB / 12.74 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Aika: 0.70 ms / 92.92 ms Muisti: 0.013 MB / 12.75 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Aika: 0.07 ms / 92.98 ms Muisti: 0.000 MB / 12.75 MB Application: beforeRenderModule mod_menu (Wrec 2015 Menu)

Aika: 0.91 ms / 93.90 ms Muisti: 0.010 MB / 12.76 MB Application: afterRenderModule mod_menu (Wrec 2015 Menu)

Aika: 0.04 ms / 93.93 ms Muisti: 0.000 MB / 12.76 MB Application: beforeRenderModule mod_menu (Wrec 2015 Menu EN)

Aika: 0.32 ms / 94.25 ms Muisti: 0.004 MB / 12.76 MB Application: afterRenderModule mod_menu (Wrec 2015 Menu EN)

Aika: 0.05 ms / 94.31 ms Muisti: 0.000 MB / 12.76 MB Application: beforeRenderModule mod_languages (Language selector)

Aika: 0.99 ms / 95.30 ms Muisti: 0.016 MB / 12.78 MB Application: afterRenderModule mod_languages (Language selector)

Aika: 0.62 ms / 95.92 ms Muisti: 0.037 MB / 12.81 MB Application: afterRender

Tietokantakyselyt yhteensä: 26.56 ms

Muistin käyttö

Tietokantakyselyt

30 kyselyä kirjattu 26.56 ms

Kyselyn aika: 0.28 ms

SELECT `data`

  FROM `raq76_session`

  WHERE `session_id` = '0aj61capor4deib595d1hcoml0'

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.15 ms Viimeisen kyselyn jälkeen: 0.38 ms

SELECT `session_id`

  FROM `raq76_session`

  WHERE `session_id` = '0aj61capor4deib595d1hcoml0' 
  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: 1.30 ms Viimeisen kyselyn jälkeen: 0.10 ms

INSERT INTO `raq76_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('0aj61capor4deib595d1hcoml0', 1, 1542405776, 0, '', 0)

Selite

EXPLAIN ei mahdollinen kyselyssä: INSERT INTO `raq76_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('0aj61capor4deib595d1hcoml0', 1, 1542405776, 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.57 ms Viimeisen kyselyn jälkeen: 0.56 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.09 ms Viimeisen kyselyn jälkeen: 0.52 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.05 ms Viimeisen kyselyn jälkeen: 0.12 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.95 ms Viimeisen kyselyn jälkeen: 0.16 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.39 ms Viimeisen kyselyn jälkeen: 3.43 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.67 ms Viimeisen kyselyn jälkeen: 0.17 ms

UPDATE `raq76_extensions`

  SET `params` = '{\"mediaversion\":\"04680593b9dca4970f8a1dea32931146\"}'

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

Selite

EXPLAIN ei mahdollinen kyselyssä: UPDATE `raq76_extensions` SET `params` = '{\"mediaversion\":\"04680593b9dca4970f8a1dea32931146\"}' 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: 1.13 ms Viimeisen kyselyn jälkeen: 0.93 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.35 ms Viimeisen kyselyn jälkeen: 0.18 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: 11.02 ms Viimeisen kyselyn jälkeen: 5.00 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.37 ms Viimeisen kyselyn jälkeen: 13.80 ms

SELECT catid 
  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
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.12 ms Viimeisen kyselyn jälkeen: 0.08 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.10 ms Viimeisen kyselyn jälkeen: 1.80 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
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
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: 3.10 ms Viimeisen kyselyn jälkeen: 0.22 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
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
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.87 ms Viimeisen kyselyn jälkeen: 14.63 ms

SHOW FULL COLUMNS 
  FROM `raq76_content`

Selite

EXPLAIN ei mahdollinen kyselyssä: SHOW FULL COLUMNS FROM `raq76_content`

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:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
14	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
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.81 ms

SELECT *

  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
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
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.99 ms Viimeisen kyselyn jälkeen: 0.14 ms

UPDATE raq76_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1204'

Selite

EXPLAIN ei mahdollinen kyselyssä: UPDATE raq76_content SET `hits` = (`hits` + 1) WHERE `id` = '1204'

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
11	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
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.68 ms Viimeisen kyselyn jälkeen: 0.68 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.language in ('fi-FI','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-11-16 22:02:56') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-11-16 22:02:56') 
  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/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->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: 2.72 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` = 1204 
  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
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->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: 1.16 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
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->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.08 ms Viimeisen kyselyn jälkeen: 0.26 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 (9,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
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->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.88 ms Viimeisen kyselyn jälkeen: 1.75 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 22:02:56') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-11-16 22:02:56') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 590 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
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	Sama kuin kutsu alla olevalla rivillä.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/wrec2015/html/com_content/article/default.php:57
13	include JROOT/templates/wrec2015/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->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.67 ms

select count(*) cnt 
  from raq76_menu 
  WHERE parent_id = 590

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_menu	index	NULL	idx_client_id_parent_id_alias_language	435	NULL	1312	Using where; Using index

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:1656
15	JDatabaseDriver->loadObject()	JROOT/includes/sl_helpers/sl_vau.php:670
14	Sl_vau::getRenderableSideModules()	JROOT/templates/wrec2015/html/com_content/article/default.php:57
13	include JROOT/templates/wrec2015/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->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: 4.82 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
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/includes/sl_helpers/sl_media.php:50
18	Sl_media::_getDataFromDb()	JROOT/includes/sl_helpers/sl_media.php:34
17	Sl_media::_getSingleData()	JROOT/includes/sl_helpers/sl_media.php:19
16	Sl_media::getData()	JROOT/includes/sl_helpers/sl_parser.php:121
15	Sl_parser::parseImageAlts()	JROOT/includes/sl_helpers/sl_parser.php:109
14	Sl_parser::parseContent()	JROOT/templates/wrec2015/html/com_content/article/default.php:109
13	include JROOT/templates/wrec2015/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->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.52 ms

SELECT language,id

  FROM `raq76_menu`

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

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	raq76_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	1312	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/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.40 ms

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

  FROM `raq76_menu` AS `c`

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

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

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

  WHERE c.id = 590

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	vau.a2.id	1

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/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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: 0.60 ms

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `raq76_content` AS `c`

  INNER JOIN `raq76_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

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

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

  INNER JOIN `raq76_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 1204 
  AND c2.access IN (1,1) 
  AND c2.language != 'fi-FI' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2018-11-16 22:02:56') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2018-11-16 22:02:56') 
  AND c2.state = 1

Selite

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.84 ms

SELECT value

  FROM raq76_sl_piknik

  WHERE name = 'global_fields_fi-FI'

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/includes/sl_helpers/dist/sl_piknik.php:35
8	Sl_piknik::getGlobalFields()	JROOT/templates/wrec2015/index.php:24
7	require JROOT/templates/wrec2015/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

27 kyselytyyppiä kirjattu, järjestetty laskevasti esiintymismäärän mukaan

SELECT taulut:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `raq76_assets`

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

2 × SELECT value 
  FROM raq76_sl_piknik

1 × 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

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

1 × SELECT language,id 
  FROM `raq76_menu`

1 × SELECT * 
  FROM raq76_sl_piknik_media

1 × select count(*) cnt 
  from raq76_menu

1 × 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

1 × 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

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `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)

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

1 × SELECT `data` 
  FROM `raq76_session`

```
1 × SELECT * 
  FROM raq76_content
```

1 × SELECT `session_id` 
  FROM `raq76_session`

1 × SELECT catid 
  FROM raq76_content

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

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

```
1 × SELECT * 
  FROM raq76_languages
```

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

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

1 × SELECT id, rules 
  FROM `raq76_viewlevels

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `raq76_content` AS `c` 
  INNER JOIN `raq76_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `raq76_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `raq76_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `raq76_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

OTHER taulut:

1 × INSERT INTO `raq76_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('0aj61capor4deib595d1hcoml0', 1, 1542405776, 0, '', 0

1 × UPDATE `raq76_extensions` 
  SET `params` = '{\"mediaversion\":\"04680593b9dca4970f8a1dea32931146\"}'

1 × SHOW FULL COLUMNS 
  FROM `raq76_content

1 × UPDATE raq76_content 
  SET `hits` = (`hits` + 1)