Vesi – kalaa ja purjealuksia

Vesi-teemassa keskipohjalainen merellisyys tuodaan esille Suomen johtavana laivanrakentajana 1600- ja 1700-luvuilla ja onnettomina haaksirikkoina. Jokien hyötykäytöstä kertovat hyvin säilyneet jauho- tai sahamyllyt ja vanhat valokuvat puutavaran uitosta. Järvien hyödyntämisestä kertoo järvimalmin nosto ja järvien kuivatukset.

Kalastus on näiden kaikkien vesielementtien luonnollinen ja ikiaikainen käyttömuoto, kuten hylkeenpyynti merialueilla. Vesistöt ovat mahdollistaneet kulkuyhteyksiä paikkoihin ja satamiin kotimaassa ja ulkomailla – eikä aina laillisin tarkoituksin, kuten viimeksi 1920-luvun kieltolain aikaiset salakuljetukset osoittavat.

Lue koko teema

Paikkakartta

Valitse näytettävät teemat listasta. Poista valinnat | Valitse kaikki

FaLang translation system by Faboba

Joomla! virheenkorjauskonsoli

Istunto

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1597421948,
                "last": 1597421948,
                "now": 1597421948
            },
            "token": "RJZy8zb1NgEqLD974FzDGOEmCH8iCGS3"
        },
        "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
        }
    }
}

Profiilin tiedot

Muistin käyttö

Tietokantakyselyt

26 kyselyä kirjattu 33.65 ms

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

2 päällekkäistä: #1 #6

2 päällekkäistä: #5 #7

2 päällekkäistä: #14 #16

2 päällekkäistä: #23 #25

Kyselyn aika: 1.69 ms Kysely muisti: 0.055 MB Muistia ennen kyselyä: 8.050 MB Rivejä palautettu: 113

Päällekkäisiä kyselyitä: #6

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

  LEFT JOIN ajm0x_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	144	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.m.component_id	1	100.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
26	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
25	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:383
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:497
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Sama kuin kutsu alla olevalla rivillä.
8	call_user_func_array()	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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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: 7.48 ms Kysely muisti: 0.038 MB Muistia ennen kyselyä: 8.556 MB Rivejä palautettu: 13

SELECT joomlatablename,tablepkID 
  FROM `ajm0x_falang_tableinfo`

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ajm0x_falang_tableinfo	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	100.00	NULL

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
28	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
27	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:383
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:497
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Sama kuin kutsu alla olevalla rivillä.
8	call_user_func_array()	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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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.36 ms Viimeisen kyselyn jälkeen: 0.52 ms Kysely muisti: 0.041 MB Muistia ennen kyselyä: 8.598 MB Rivejä palautettu: 3

SELECT * 
  FROM ajm0x_languages 
  ORDER BY ordering

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ajm0x_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using filesort

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
31	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
30	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
28	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
27	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:383
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:497
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Sama kuin kutsu alla olevalla rivillä.
8	call_user_func_array()	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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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.63 ms Viimeisen kyselyn jälkeen: 4.54 ms Kysely muisti: 0.046 MB Muistia ennen kyselyä: 8.950 MB Rivejä palautettu: 14

SHOW FULL COLUMNS 
  FROM `ajm0x_languages`

Selite

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

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
35	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
34	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
33	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
32	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
30	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
29	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
28	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
27	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
26	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
25	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:383
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:497
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Sama kuin kutsu alla olevalla rivillä.
8	call_user_func_array()	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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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: 7.17 ms Viimeisen kyselyn jälkeen: 2.52 ms Kysely muisti: 0.036 MB Muistia ennen kyselyä: 9.092 MB Rivejä palautettu: 0

Päällekkäisiä kyselyitä: #7

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM ajm0x_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(251,434,121,242,244,243,245,246,122,197,219,220,222,198,199,171,182,217,215,183,184,119,191,192,194,196,218,123,202,213,124,212,247,248,241,265,266,271,272,273,274,275,276,305,315,317,313,312,306,307,308,309,310,311,314,316,368,369,370,371,372,373,374,375,376,377,378,379,395,394,397,396,398,399,400,401,402,403,417,405,404,406,407,408,409,410,411,412,413,414,416,415,418,420,419,421,423,424,425,426,427,428,429,430,431,422,432,433,438,436,439,437,435)
   
  AND falang_content.reference_table='menu'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
29	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
28	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
27	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
26	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
25	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
24	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
23	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:383
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:497
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Sama kuin kutsu alla olevalla rivillä.
8	call_user_func_array()	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:632
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:204
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.64 ms Viimeisen kyselyn jälkeen: 20.53 ms Kysely muisti: 0.047 MB Muistia ennen kyselyä: 10.282 MB Rivejä palautettu: 113

Päällekkäisiä kyselyitä: #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 ajm0x_menu AS m

  LEFT JOIN ajm0x_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	144	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.m.component_id	1	100.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Sama kuin kutsu alla olevalla rivillä.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
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.11 ms Viimeisen kyselyn jälkeen: 2.84 ms Kysely muisti: 0.030 MB Muistia ennen kyselyä: 10.640 MB Rivejä palautettu: 0

Päällekkäisiä kyselyitä: #5

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM ajm0x_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(251,434,121,242,244,243,245,246,122,197,219,220,222,198,199,171,182,217,215,183,184,119,191,192,194,196,218,123,202,213,124,212,247,248,241,265,266,271,272,273,274,275,276,305,315,317,313,312,306,307,308,309,310,311,314,316,368,369,370,371,372,373,374,375,376,377,378,379,395,394,397,396,398,399,400,401,402,403,417,405,404,406,407,408,409,410,411,412,413,414,416,415,418,420,419,421,423,424,425,426,427,428,429,430,431,422,432,433,438,436,439,437,435)
   
  AND falang_content.reference_table='menu'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
24	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
23	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
21	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
20	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
19	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
18	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Sama kuin kutsu alla olevalla rivillä.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/plugins/system/falangdriver/falangdriver.php:366
11	plgSystemFalangdriver->parseRule()	Sama kuin kutsu alla olevalla rivillä.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:204
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.22 ms Viimeisen kyselyn jälkeen: 3.46 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 10.399 MB Rivejä palautettu: 1

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

  FROM `ajm0x_extensions`

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

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ajm0x_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
14	JFalangDatabase->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Sama kuin kutsu alla olevalla rivillä.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:204
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: 0.39 ms Kysely muisti: 0.014 MB Muistia ennen kyselyä: 10.387 MB

UPDATE `ajm0x_extensions`

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

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

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ajm0x_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
10	JFalangDatabase->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:204
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.20 ms Viimeisen kyselyn jälkeen: 7.10 ms Kysely muisti: 0.013 MB Muistia ennen kyselyä: 10.708 MB Rivejä palautettu: 12

SELECT id, home, template, s.params

  FROM ajm0x_template_styles as s

  LEFT JOIN ajm0x_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	15	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	apulaine_genius.s.template,const	1	4.63	Using index condition; Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
7	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
5	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:204
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.63 ms Viimeisen kyselyn jälkeen: 15.82 ms Kysely muisti: 0.061 MB Muistia ennen kyselyä: 12.429 MB Rivejä palautettu: 1

SELECT h.*, c.title as category

  FROM ajm0x_zhgooglemaps_maps as h

  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

  WHERE h.id=7

  ORDER BY h.title

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
15	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:187
11	ZhGoogleMapModelZhGoogleMap->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:26
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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: 1.33 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.642 MB Rivejä palautettu: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM ajm0x_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(7)
   
  AND falang_content.reference_table='zhgooglemaps_maps'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	falangContent	310	const,const,const	1	10.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
19	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
18	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
16	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
15	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
14	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
13	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
12	JFalangDatabase->loadObject()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:187
11	ZhGoogleMapModelZhGoogleMap->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:26
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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.83 ms Viimeisen kyselyn jälkeen: 0.71 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.675 MB Rivejä palautettu: 5

SELECT h.*, c.title as category 

  FROM ajm0x_zhgooglemaps_markergroups as h

  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

  WHERE  EXISTS (SELECT 1 
  FROM ajm0x_zhgooglemaps_markers as m 
  WHERE m.markergroup=h.id  
  and m.markergroup IN (6,10,16,25,47) 
  and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-08-14 16:19:08') 
  and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-08-14 16:19:08'))

  ORDER BY h.title

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	h	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	46	100.00	Using where; Using filesort
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.h.catid	1	100.00	NULL
2	DEPENDENT SUBQUERY	m	NULL	ref	idx_markergroup	idx_markergroup	4	apulaine_genius.h.id	20	16.00	Using index condition; Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:886
11	ZhGoogleMapModelZhGoogleMap->getMarkerGroups()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:56
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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.50 ms Kysely muisti: 0.025 MB Muistia ennen kyselyä: 12.581 MB Rivejä palautettu: 0

Päällekkäisiä kyselyitä: #16

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM ajm0x_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(25,10,6,47,16)
   
  AND falang_content.reference_table='zhgooglemaps_markergroups'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
15	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
14	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
13	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
12	JFalangDatabase->loadObjectList()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:886
11	ZhGoogleMapModelZhGoogleMap->getMarkerGroups()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:56
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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.30 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.603 MB Rivejä palautettu: 5

SELECT h.*, c.title as category 

  FROM ajm0x_zhgooglemaps_markergroups as h

  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

  WHERE EXISTS (SELECT 1 
  FROM ajm0x_zhgooglemaps_markers as m 
  WHERE m.markergroup=h.id  
  and m.markergroup IN (6,10,16,25,47) 
  and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-08-14 16:19:08') 
  and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-08-14 16:19:08'))

  ORDER BY h.title

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	h	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	46	100.00	Using where; Using filesort
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.h.catid	1	100.00	NULL
2	DEPENDENT SUBQUERY	m	NULL	ref	idx_markergroup	idx_markergroup	4	apulaine_genius.h.id	20	16.00	Using index condition; Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:1428
11	ZhGoogleMapModelZhGoogleMap->getMgrGroupsList()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:59
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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.61 ms Viimeisen kyselyn jälkeen: 0.44 ms Kysely muisti: 0.025 MB Muistia ennen kyselyä: 12.647 MB Rivejä palautettu: 0

Päällekkäisiä kyselyitä: #14

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM ajm0x_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(25,10,6,47,16)
   
  AND falang_content.reference_table='zhgooglemaps_markergroups'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
17	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
15	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
14	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
13	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
12	JFalangDatabase->loadObjectList()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:1428
11	ZhGoogleMapModelZhGoogleMap->getMgrGroupsList()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:59
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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.29 ms Viimeisen kyselyn jälkeen: 0.26 ms Kysely muisti: 0.027 MB Muistia ennen kyselyä: 12.666 MB Rivejä palautettu: 0

SELECT h.*, c.title as category 

  FROM ajm0x_zhgooglemaps_routers as h

  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

  WHERE h.published=1 
  and h.mapid=7

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	NULL	ref	idx_mapid	idx_mapid	4	const	1	16.67	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.h.catid	1	100.00	NULL

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:699
11	ZhGoogleMapModelZhGoogleMap->getRouters()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:66
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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.25 ms Viimeisen kyselyn jälkeen: 0.46 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.669 MB Rivejä palautettu: 1

SELECT h.*, c.title as category 

  FROM ajm0x_zhgooglemaps_maptypes as h

  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

  WHERE h.published=1

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
12	JFalangDatabase->loadObjectList()	JROOT/components/com_zhgooglemap/models/zhgooglemap.php:1613
11	ZhGoogleMapModelZhGoogleMap->getMapTypes()	JROOT/libraries/src/MVC/View/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:84
9	ZhGoogleMapViewZhGoogleMap->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zhgooglemap/zhgooglemap.php:21
6	require_once JROOT/components/com_zhgooglemap/zhgooglemap.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:204
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.93 ms Viimeisen kyselyn jälkeen: 21.45 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 13.506 MB Rivejä palautettu: 9

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

  FROM ajm0x_modules AS m

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

  LEFT JOIN ajm0x_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 <= '2020-08-14 16:19:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-08-14 16:19:08') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 122 OR mm.menuid <= 0) 
  AND m.language IN ('fi-FI','*')

  ORDER BY m.position, m.ordering

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	27	2.38	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	apulaine_genius.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	apulaine_genius.m.id	7	40.00	Using where; Using index

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
14	JFalangDatabase->loadObjectList()	Sama kuin kutsu alla olevalla rivillä.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/hurmos/index.php:15
7	require JROOT/templates/hurmos/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:1036
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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.88 ms Viimeisen kyselyn jälkeen: 1.19 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 13.561 MB Rivejä palautettu: 0

SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 

  FROM ajm0x_falang_content AS falang_content

  WHERE falang_content.language_id=2
	
  AND falang_content.published=1
   
  AND falang_content.reference_id IN(97,106,16,88,103,102,1,125,109)
   
  AND falang_content.reference_table='modules'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	falang_content	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	language_id	4	const	1	5.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
17	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
16	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
15	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
14	JFalangDatabase->loadObjectList()	Sama kuin kutsu alla olevalla rivillä.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/hurmos/index.php:15
7	require JROOT/templates/hurmos/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:1036
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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: 12.31 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 14.449 MB Rivejä palautettu: 0

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

  FROM `ajm0x_menu` AS `c`

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

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

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

  WHERE c.id = 122

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
19	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
17	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Associations.php:104
16	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
15	MenusHelper::getAssociations()	JROOT/modules/mod_falang/helper.php:66
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Sama kuin kutsu alla olevalla rivillä.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:622
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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.45 ms Viimeisen kyselyn jälkeen: 0.82 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.475 MB Rivejä palautettu: 1

SELECT fc.value

  FROM ajm0x_falang_content fc

  WHERE fc.reference_id = 122 
  AND fc.language_id = 3 
  AND fc.reference_field = 'link' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	5.20	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:540
15	modFaLangHelper::getLinkWithoutSefEnabled()	JROOT/modules/mod_falang/helper.php:413
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Sama kuin kutsu alla olevalla rivillä.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:622
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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.28 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.503 MB Rivejä palautettu: 1

Päällekkäisiä kyselyitä: #25

SELECT m.link

  FROM ajm0x_menu m

  WHERE m.id = 122

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:549
15	modFaLangHelper::getLinkWithoutSefEnabled()	JROOT/modules/mod_falang/helper.php:413
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Sama kuin kutsu alla olevalla rivillä.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:622
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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: 0.55 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.531 MB Rivejä palautettu: 1

SELECT fc.value

  FROM ajm0x_falang_content fc

  WHERE fc.reference_id = 122 
  AND fc.language_id = 1 
  AND fc.reference_field = 'link' 
  AND fc.published = 1 
  AND fc.reference_table = 'menu'

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fc	NULL	ref	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field	idxFalang1	608	const,const,const	1	5.00	Using where

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:540
15	modFaLangHelper::getLinkWithoutSefEnabled()	JROOT/modules/mod_falang/helper.php:413
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Sama kuin kutsu alla olevalla rivillä.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:622
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
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.14 ms Viimeisen kyselyn jälkeen: 0.24 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.558 MB Rivejä palautettu: 1

Päällekkäisiä kyselyitä: #23

SELECT m.link

  FROM ajm0x_menu m

  WHERE m.id = 122

Selite

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profiili

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

Kutsupino

#	Kutsufunktio	Tiedosto ja rivin numero
22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
21	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
18	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
17	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
16	JFalangDatabase->loadResult()	JROOT/modules/mod_falang/helper.php:549
15	modFaLangHelper::getLinkWithoutSefEnabled()	JROOT/modules/mod_falang/helper.php:413
14	modFaLangHelper::getList()	JROOT/modules/mod_falang/mod_falang.php:25
13	include JROOT/modules/mod_falang/mod_falang.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Sama kuin kutsu alla olevalla rivillä.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:622
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:210
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT taulut:

6 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
  FROM ajm0x_falang_content AS falang_content

2 × SELECT m.link 
  FROM ajm0x_menu m

2 × SELECT h.*, c.title as category  
  FROM ajm0x_zhgooglemaps_markergroups as h 
  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

2 × SELECT fc.value 
  FROM ajm0x_falang_content fc

2 × 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 ajm0x_menu AS m 
  LEFT JOIN ajm0x_extensions AS e 
  ON m.component_id = e.extension_id

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

1 × SELECT h.*, c.title as category  
  FROM ajm0x_zhgooglemaps_maptypes as h 
  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

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

1 × SELECT h.*, c.title as category 
  FROM ajm0x_zhgooglemaps_maps as h 
  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

1 × SELECT joomlatablename,tablepkID 
  FROM `ajm0x_falang_tableinfo

```
1 × SELECT * 
  FROM ajm0x_languages
```

1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `ajm0x_extensions`

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

1 × SELECT h.*, c.title as category  
  FROM ajm0x_zhgooglemaps_routers as h 
  LEFT JOIN ajm0x_categories as c 
  ON h.catid=c.id

OTHER taulut:

1 × UPDATE `ajm0x_extensions` 
  SET `params` = '{\"mediaversion\":\"f23e63594a0c7f73daceb38b4e75d63e\"}'

1 × SHOW FULL COLUMNS 
  FROM `ajm0x_languages

Nav view search

Navigation

Search

Vesi – kalaa ja purjealuksia

Paikkakartta

Joomla! virheenkorjauskonsoli

Istunto

Profiilin tiedot

Aika

Muisti

Muistin käyttö

Tietokantakyselyt

26 kyselyä kirjattu 33.65 ms

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

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

SELECT taulut:

OTHER taulut: