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

Aika

Muisti

40 kyselyä kirjattu 47.53 ms

1. Kyselyn aika: 1.58 ms Kysely muisti: 0.055 MB Muistia ennen kyselyä: 8.045 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]

   ---

2. Kyselyn aika: 0.21 ms Viimeisen kyselyn jälkeen: 2.80 ms Kysely muisti: 0.038 MB Muistia ennen kyselyä: 8.550 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]

   ---

3. Kyselyn aika: 0.20 ms Viimeisen kyselyn jälkeen: 0.25 ms Kysely muisti: 0.041 MB Muistia ennen kyselyä: 8.593 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]

   ---

4. Kyselyn aika: 0.39 ms Viimeisen kyselyn jälkeen: 2.24 ms Kysely muisti: 0.046 MB Muistia ennen kyselyä: 8.944 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]

   ---

5. Kyselyn aika: 7.06 ms Viimeisen kyselyn jälkeen: 1.56 ms Kysely muisti: 0.036 MB Muistia ennen kyselyä: 9.087 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]

   ---

6. Kyselyn aika: 1.81 ms Viimeisen kyselyn jälkeen: 10.59 ms Kysely muisti: 0.047 MB Muistia ennen kyselyä: 10.274 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]

   ---

7. Kyselyn aika: 7.01 ms Viimeisen kyselyn jälkeen: 5.92 ms Kysely muisti: 0.030 MB Muistia ennen kyselyä: 10.632 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]

   ---

8. Kyselyn aika: 0.25 ms Viimeisen kyselyn jälkeen: 2.85 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 10.390 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]

   ---

9. Kyselyn aika: 2.14 ms Viimeisen kyselyn jälkeen: 0.36 ms Kysely muisti: 0.014 MB Muistia ennen kyselyä: 10.378 MB

   UPDATE `ajm0x_extensions`
   
     SET `params` = '{\"mediaversion\":\"f9bb66d39759e32bf2700baefde60c20\"}'
   
     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]

   ---

10. Kyselyn aika: 0.51 ms Viimeisen kyselyn jälkeen: 2.36 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]

    ---

11. Kyselyn aika: 0.70 ms Viimeisen kyselyn jälkeen: 4.14 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 11.154 MB Rivejä palautettu: 35

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ajm0x_assets`
    
      WHERE `name` IN ('root.1','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_falang','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_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_zhgooglemap')

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ajm0x_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	36	100.00	Using index condition

    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/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:55
    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:248
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    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: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]

    ---

12. Kyselyn aika: 0.57 ms Viimeisen kyselyn jälkeen: 1.58 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 11.363 MB Rivejä palautettu: 30

    SHOW FULL COLUMNS 
      FROM `ajm0x_content`

    Selite

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

    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/libraries/joomla/database/driver/mysqli.php:430
    14	JDatabaseDriverMysqli->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:250
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    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: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]

    ---

13. Kyselyn aika: 0.24 ms Viimeisen kyselyn jälkeen: 3.33 ms Kysely muisti: 0.034 MB Muistia ennen kyselyä: 11.744 MB Rivejä palautettu: 1

    SELECT *
    
      FROM ajm0x_content
    
      WHERE `id` = '254'

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ajm0x_content	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
    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()	JROOT/plugins/system/falangdriver/falang_database.php:416
    13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
    11	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    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: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]

    ---

14. Kyselyn aika: 0.30 ms Viimeisen kyselyn jälkeen: 0.46 ms Kysely muisti: 0.027 MB Muistia ennen kyselyä: 11.813 MB Rivejä palautettu: 0
    Päällekkäisiä kyselyitä: #17

    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(254)
       
      AND falang_content.reference_table='content'

    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	idxFalang1	4	const	1	5.00	Using index condition; 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()	JROOT/plugins/system/falangdriver/falang_database.php:416
    13	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    12	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:434
    11	JFalangDatabase->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    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: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]

    ---

15. Kyselyn aika: 1.93 ms Viimeisen kyselyn jälkeen: 0.29 ms Kysely muisti: 0.015 MB Muistia ennen kyselyä: 11.827 MB

    UPDATE ajm0x_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '254'

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	ajm0x_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    11	JFalangDatabase->execute()	JROOT/libraries/src/Table/Table.php:1242
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    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: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]

    ---

16. Kyselyn aika: 0.77 ms Viimeisen kyselyn jälkeen: 2.33 ms Kysely muisti: 0.033 MB Muistia ennen kyselyä: 12.094 MB Rivejä palautettu: 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
    
      FROM ajm0x_content AS a
    
      INNER JOIN ajm0x_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN ajm0x_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN ajm0x_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ajm0x_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 254 
      AND c.published > 0 
      AND a.language in ('fi-FI','*') 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-05-09 18:48:59') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-05-09 18:48:59') 
      AND (a.state = 1 OR a.state =2)

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	v	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
    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/components/com_content/models/article.php:148
    13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

17. Kyselyn aika: 0.31 ms Viimeisen kyselyn jälkeen: 0.49 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 12.135 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(254)
       
      AND falang_content.reference_table='content'

    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	idxFalang1	4	const	1	5.00	Using index condition; 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:277
    18	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    17	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    16	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    15	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    14	JFalangDatabase->loadObject()	JROOT/components/com_content/models/article.php:148
    13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

18. Kyselyn aika: 0.47 ms Viimeisen kyselyn jälkeen: 2.54 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 12.338 MB Rivejä palautettu: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `ajm0x_contentitem_tag_map` AS m 
    
      INNER JOIN `ajm0x_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 254 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	apulaine_genius.m.tag_id	1	100.00	Using where

    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/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

19. Kyselyn aika: 0.54 ms Viimeisen kyselyn jälkeen: 9.54 ms Kysely muisti: 0.038 MB Muistia ennen kyselyä: 13.577 MB Rivejä palautettu: 3

    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 `ajm0x_categories` AS `s`
    
      INNER JOIN `ajm0x_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 = 118
    
      ORDER BY c.lft

    Selite

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

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    22	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    20	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    19	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    18	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    15	PlgSystemFields->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

20. Kyselyn aika: 1.01 ms Viimeisen kyselyn jälkeen: 1.03 ms Kysely muisti: 0.036 MB Muistia ennen kyselyä: 13.688 MB Rivejä palautettu: 4

    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
    
      FROM ajm0x_fields AS a
    
      LEFT JOIN `ajm0x_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ajm0x_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ajm0x_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ajm0x_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ajm0x_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `ajm0x_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 (118,0,116)) 
      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)
    
      ORDER BY a.ordering ASC

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	idx_state,idx_access,idx_context	NO INDEX KEY COULD BE USED	NULL	NULL	7	61.22	Using where; Using temporary; Using filesort
    1	SIMPLE	l	NULL	ALL	idx_langcode	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	apulaine_genius.a.id	1	40.74	Using where; Using index

    Profiili

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

    Kutsupino

    #	Kutsufunktio	Tiedosto ja rivin numero
    23	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    22	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    15	PlgSystemFields->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

21. Kyselyn aika: 0.49 ms Viimeisen kyselyn jälkeen: 0.50 ms Kysely muisti: 0.034 MB Muistia ennen kyselyä: 13.765 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(5,3,4,7)
       
      AND falang_content.reference_table='fields'

    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
    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:277
    23	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    22	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    21	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    20	JFalangDatabase->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    15	PlgSystemFields->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

22. Kyselyn aika: 0.33 ms Viimeisen kyselyn jälkeen: 3.33 ms Kysely muisti: 0.027 MB Muistia ennen kyselyä: 14.307 MB Rivejä palautettu: 3

    SELECT `field_id`,`value`
    
      FROM `ajm0x_fields_values`
    
      WHERE `field_id` IN (5,3,4,7) 
      AND `item_id` = '254'

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ajm0x_fields_values	NULL	ref	idx_field_id,idx_item_id	idx_item_id	766	const	4	74.79	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/administrator/components/com_fields/models/field.php:701
    17	FieldsModelField->getFieldValues()	JROOT/administrator/components/com_fields/helpers/fields.php:158
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    15	PlgSystemFields->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

23. Kyselyn aika: 0.33 ms Viimeisen kyselyn jälkeen: 3.43 ms Kysely muisti: 0.034 MB Muistia ennen kyselyä: 14.489 MB Rivejä palautettu: 0

    SELECT `value`
    
      FROM ajm0x_falang_content fc
    
      WHERE fc.reference_id = '254' 
      AND fc.language_id = 2 
      AND fc.published = 1 
      AND fc.reference_field = 'com_fields' 
      AND fc.reference_table = 'content'

    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
    28	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    27	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
    26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
    25	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    24	JFalangDatabase->loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:351
    23	JFalangDatabase->_loadObject()	JROOT/plugins/system/falangdriver/falang_database.php:143
    22	JFalangDatabase->loadResult()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:505
    21	FalangManager->getRawFieldTranslations()	JROOT/plugins/system/falangdriver/falangdriver.php:718
    20	plgSystemFalangdriver->onCustomFieldsBeforePrepareField()	Sama kuin kutsu alla olevalla rivillä.
    19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/administrator/components/com_fields/helpers/fields.php:197
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
    15	PlgSystemFields->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

24. Kyselyn aika: 0.46 ms Viimeisen kyselyn jälkeen: 11.19 ms Kysely muisti: 0.060 MB Muistia ennen kyselyä: 15.557 MB Rivejä palautettu: 1

    SELECT h.*
    
      FROM ajm0x_zhgooglemaps_markers as h
    
      WHERE h.id = 247

    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

    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/components/com_zhgooglemap/helpers/map_data.php:1492
    17	comZhGoogleMapData::getMarkerCoordinatesLatLngObject()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1446
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

25. Kyselyn aika: 0.39 ms Viimeisen kyselyn jälkeen: 1.14 ms Kysely muisti: 0.032 MB Muistia ennen kyselyä: 15.745 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(247)
       
      AND falang_content.reference_table='zhgooglemaps_markers'

    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
    25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
    22	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    21	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    18	JFalangDatabase->loadObject()	JROOT/components/com_zhgooglemap/helpers/map_data.php:1492
    17	comZhGoogleMapData::getMarkerCoordinatesLatLngObject()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1446
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

26. Kyselyn aika: 0.45 ms Viimeisen kyselyn jälkeen: 0.19 ms Kysely muisti: 0.067 MB Muistia ennen kyselyä: 15.748 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=3

    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
    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/components/com_zhgooglemap/helpers/map_data.php:32
    17	comZhGoogleMapData::getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1537
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

27. Kyselyn aika: 0.29 ms Viimeisen kyselyn jälkeen: 1.24 ms Kysely muisti: 0.032 MB Muistia ennen kyselyä: 15.836 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(3)
       
      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
    25	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
    24	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
    22	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
    21	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
    20	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
    19	JFalangDatabase->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:416
    18	JFalangDatabase->loadObject()	JROOT/components/com_zhgooglemap/helpers/map_data.php:32
    17	comZhGoogleMapData::getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1537
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

28. Kyselyn aika: 1.52 ms Viimeisen kyselyn jälkeen: 0.24 ms Kysely muisti: 0.114 MB Muistia ennen kyselyä: 15.868 MB Rivejä palautettu: 15

    SELECT h.*,  c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster,  g.iconofsetx as groupiconofsetx, g.iconofsety as groupiconofsety, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished 
    
      FROM ajm0x_zhgooglemaps_markers as h
    
      LEFT JOIN ajm0x_categories as c 
      ON h.catid=c.id
    
      LEFT JOIN ajm0x_zhgooglemaps_markergroups as g 
      ON h.markergroup=g.id
    
      LEFT JOIN ajm0x_zhgooglemaps_infobubbles as bub 
      ON h.tabid=bub.id
    
      WHERE 1=1 
      and h.markergroup = 7 
      and h.published=1 
      AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2021-05-09 18:48:59') 
      AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2021-05-09 18:48:59')
    
      ORDER BY h.title

    Selite

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	h	NULL	ref	idx_markergroup	idx_markergroup	4	const	20	1.60	Using index condition; Using where; Using filesort
    1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.h.catid	1	100.00	NULL
    1	SIMPLE	g	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	bub	NULL	eq_ref	PRIMARY	PRIMARY	4	apulaine_genius.h.tabid	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/components/com_zhgooglemap/helpers/map_data.php:324
    17	comZhGoogleMapData::getMarkers()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1557
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

29. Kyselyn aika: 1.38 ms Viimeisen kyselyn jälkeen: 7.95 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.580 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(959,245,527,425,170,250,420,189,1046,419,2,247,426,249,424)
       
      AND falang_content.reference_table='zhgooglemaps_markers'

    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/components/com_zhgooglemap/helpers/map_data.php:324
    17	comZhGoogleMapData::getMarkers()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1557
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

30. Kyselyn aika: 1.30 ms Viimeisen kyselyn jälkeen: 0.31 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.610 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(959,245,527,425,170,250,420,189,1046,419,2,247,426,249,424)
       
      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
    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/components/com_zhgooglemap/helpers/map_data.php:324
    17	comZhGoogleMapData::getMarkers()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1557
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

31. Kyselyn aika: 0.34 ms Viimeisen kyselyn jälkeen: 0.21 ms Kysely muisti: 0.039 MB Muistia ennen kyselyä: 16.503 MB Rivejä palautettu: 0

    SELECT h.*, c.title as category 
    
      FROM ajm0x_zhgooglemaps_paths as h
    
      LEFT JOIN ajm0x_categories as c 
      ON h.catid=c.id
    
      WHERE h.published=1 
      and h.mapid=3

    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	25.00	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
    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/components/com_zhgooglemap/helpers/map_data.php:1309
    17	comZhGoogleMapData::getPaths()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1558
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

32. Kyselyn aika: 0.25 ms Viimeisen kyselyn jälkeen: 0.47 ms Kysely muisti: 0.033 MB Muistia ennen kyselyä: 16.392 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=3

    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
    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/components/com_zhgooglemap/helpers/map_data.php:473
    17	comZhGoogleMapData::getRouters()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1565
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

33. Kyselyn aika: 0.25 ms Viimeisen kyselyn jälkeen: 0.31 ms Kysely muisti: 0.032 MB Muistia ennen kyselyä: 16.418 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
    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/components/com_zhgooglemap/helpers/map_data.php:1327
    17	comZhGoogleMapData::getMapTypes()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1566
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

34. Kyselyn aika: 4.40 ms Viimeisen kyselyn jälkeen: 0.35 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.452 MB Rivejä palautettu: 1

    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 = 7 
      and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-05-09 18:48:59') 
      and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-09 18:48:59'))
    
      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	const	20	16.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/components/com_zhgooglemap/helpers/map_data.php:642
    17	comZhGoogleMapData::getMarkerGroups()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1570
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

35. Kyselyn aika: 0.32 ms Viimeisen kyselyn jälkeen: 0.40 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.630 MB Rivejä palautettu: 0
    Päällekkäisiä kyselyitä: #37

    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_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	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
    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/components/com_zhgooglemap/helpers/map_data.php:642
    17	comZhGoogleMapData::getMarkerGroups()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1570
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

36. Kyselyn aika: 4.64 ms Viimeisen kyselyn jälkeen: 0.24 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.532 MB Rivejä palautettu: 1

    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 = 7 
      and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-05-09 18:48:59') 
      and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-09 18:48:59'))
    
      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	const	20	16.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/components/com_zhgooglemap/helpers/map_data.php:1163
    17	comZhGoogleMapData::getMarkerGroupsManage()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1574
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

37. Kyselyn aika: 0.31 ms Viimeisen kyselyn jälkeen: 0.42 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.692 MB Rivejä palautettu: 0
    Päällekkäisiä kyselyitä: #35

    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_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	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
    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/components/com_zhgooglemap/helpers/map_data.php:1163
    17	comZhGoogleMapData::getMarkerGroupsManage()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:1574
    16	plgContentPlg_ZhGoogleMap->getMap()	JROOT/plugins/content/plg_zhgooglemap/plg_zhgooglemap.php:291
    15	plgContentPlg_ZhGoogleMap->onContentPrepare()	Sama kuin kutsu alla olevalla rivillä.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	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: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]

    ---

38. Kyselyn aika: 1.08 ms Viimeisen kyselyn jälkeen: 35.28 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 17.633 MB Rivejä palautettu: 8

    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 <= '2021-05-09 18:48:59') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-09 18:48:59') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 374 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/reitit-alasivu/index.php:15
    7	require JROOT/templates/reitit-alasivu/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]

    ---

39. Kyselyn aika: 0.97 ms Viimeisen kyselyn jälkeen: 0.42 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 17.667 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(106,16,88,103,102,1,122,125)
       
      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/reitit-alasivu/index.php:15
    7	require JROOT/templates/reitit-alasivu/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]

    ---