Kyselyn aika: 4.35 ms Kysely muisti: 0.055 MB Muistia ennen kyselyä: 8.054 MB Rivejä palautettu: 113
Päällekkäisiä kyselyitä:
#6SELECT 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
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.36 ms Viimeisen kyselyn jälkeen: 8.98 ms Kysely muisti: 0.038 MB Muistia ennen kyselyä: 8.559 MB Rivejä palautettu: 13
SELECT joomlatablename,tablepkID
FROM `ajm0x_falang_tableinfo`
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.24 ms Viimeisen kyselyn jälkeen: 0.31 ms Kysely muisti: 0.041 MB Muistia ennen kyselyä: 8.601 MB Rivejä palautettu: 3
SELECT *
FROM ajm0x_languages
ORDER BY ordering
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.41 ms Viimeisen kyselyn jälkeen: 2.76 ms Kysely muisti: 0.046 MB Muistia ennen kyselyä: 8.953 MB Rivejä palautettu: 14
SHOW FULL COLUMNS
FROM `ajm0x_languages`
EXPLAIN ei mahdollinen kyselyssä: SHOW FULL COLUMNS FROM `ajm0x_languages`
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 8.11 ms Viimeisen kyselyn jälkeen: 1.89 ms Kysely muisti: 0.036 MB Muistia ennen kyselyä: 9.096 MB Rivejä palautettu: 0
Päällekkäisiä kyselyitä:
#7SELECT 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'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 1.28 ms Viimeisen kyselyn jälkeen: 10.65 ms Kysely muisti: 0.047 MB Muistia ennen kyselyä: 10.285 MB Rivejä palautettu: 113
Päällekkäisiä kyselyitä:
#1SELECT 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
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 6.98 ms Viimeisen kyselyn jälkeen: 1.62 ms Kysely muisti: 0.030 MB Muistia ennen kyselyä: 10.644 MB Rivejä palautettu: 0
Päällekkäisiä kyselyitä:
#5SELECT 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'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.28 ms Viimeisen kyselyn jälkeen: 3.11 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 10.402 MB Rivejä palautettu: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ajm0x_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 2.11 ms Viimeisen kyselyn jälkeen: 0.40 ms Kysely muisti: 0.014 MB Muistia ennen kyselyä: 10.390 MB
UPDATE `ajm0x_extensions`
SET `params` = '{\"mediaversion\":\"269804a93037139c40f68df07282b622\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.45 ms Viimeisen kyselyn jälkeen: 2.73 ms Kysely muisti: 0.013 MB Muistia ennen kyselyä: 10.710 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
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.59 ms Viimeisen kyselyn jälkeen: 12.89 ms Kysely muisti: 0.061 MB Muistia ennen kyselyä: 12.431 MB Rivejä palautettu: 1
SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_maps as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
WHERE h.id=7
ORDER BY h.title
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
13 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
12 | JFalangDatabase->loadObject() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:187 |
11 | ZhGoogleMapModelZhGoogleMap->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:26 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.32 ms Viimeisen kyselyn jälkeen: 1.22 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.644 MB Rivejä palautettu: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM ajm0x_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(7)
AND falang_content.reference_table='zhgooglemaps_maps'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
16 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
15 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
14 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
13 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
12 | JFalangDatabase->loadObject() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:187 |
11 | ZhGoogleMapModelZhGoogleMap->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:26 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.71 ms Viimeisen kyselyn jälkeen: 0.50 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.677 MB Rivejä palautettu: 5
SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_markergroups as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM ajm0x_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.markergroup IN (6,10,16,25,47)
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-26 19:52:51')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-26 19:52:51'))
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | h | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 46 | 100.00 | Using where; Using filesort |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | apulaine_genius.h.catid | 1 | 100.00 | NULL |
2 | DEPENDENT SUBQUERY | m | NULL | ref | idx_markergroup | idx_markergroup | 4 | apulaine_genius.h.id | 20 | 16.00 | Using index condition; Using where |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:886 |
11 | ZhGoogleMapModelZhGoogleMap->getMarkerGroups() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:56 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.61 ms Viimeisen kyselyn jälkeen: 0.45 ms Kysely muisti: 0.025 MB Muistia ennen kyselyä: 12.583 MB Rivejä palautettu: 0
Päällekkäisiä kyselyitä:
#16SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM ajm0x_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(25,10,6,47,16)
AND falang_content.reference_table='zhgooglemaps_markergroups'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
15 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
14 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
13 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
12 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:886 |
11 | ZhGoogleMapModelZhGoogleMap->getMarkerGroups() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:56 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.56 ms Viimeisen kyselyn jälkeen: 0.26 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.605 MB Rivejä palautettu: 5
SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_markergroups as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM ajm0x_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.markergroup IN (6,10,16,25,47)
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-26 19:52:51')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-26 19:52:51'))
ORDER BY h.title
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | h | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 46 | 100.00 | Using where; Using filesort |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | apulaine_genius.h.catid | 1 | 100.00 | NULL |
2 | DEPENDENT SUBQUERY | m | NULL | ref | idx_markergroup | idx_markergroup | 4 | apulaine_genius.h.id | 20 | 16.00 | Using index condition; Using where |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:1428 |
11 | ZhGoogleMapModelZhGoogleMap->getMgrGroupsList() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:59 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.64 ms Viimeisen kyselyn jälkeen: 0.42 ms Kysely muisti: 0.025 MB Muistia ennen kyselyä: 12.649 MB Rivejä palautettu: 0
Päällekkäisiä kyselyitä:
#14SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM ajm0x_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(25,10,6,47,16)
AND falang_content.reference_table='zhgooglemaps_markergroups'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
15 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
14 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
13 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
12 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:1428 |
11 | ZhGoogleMapModelZhGoogleMap->getMgrGroupsList() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:59 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.24 ms Viimeisen kyselyn jälkeen: 0.27 ms Kysely muisti: 0.027 MB Muistia ennen kyselyä: 12.668 MB Rivejä palautettu: 0
SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_routers as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=7
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:699 |
11 | ZhGoogleMapModelZhGoogleMap->getRouters() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:66 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.23 ms Viimeisen kyselyn jälkeen: 0.48 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 12.672 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
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
12 | JFalangDatabase->loadObjectList() | JROOT/components/com_zhgooglemap/models/zhgooglemap.php:1613 |
11 | ZhGoogleMapModelZhGoogleMap->getMapTypes() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_zhgooglemap/views/zhgooglemap/view.html.php:84 |
9 | ZhGoogleMapViewZhGoogleMap->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_zhgooglemap/zhgooglemap.php:21 |
6 | require_once JROOT/components/com_zhgooglemap/zhgooglemap.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:204 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.89 ms Viimeisen kyselyn jälkeen: 20.59 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 13.508 MB Rivejä palautettu: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ajm0x_modules AS m
LEFT JOIN ajm0x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ajm0x_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-26 19:52:51')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-26 19:52:51')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 122 OR mm.menuid <= 0)
AND m.language IN ('fi-FI','*')
ORDER BY m.position, m.ordering
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
14 | JFalangDatabase->loadObjectList() | Sama kuin kutsu alla olevalla rivillä. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/hurmos/index.php:15 |
7 | require JROOT/templates/hurmos/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1036 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.81 ms Viimeisen kyselyn jälkeen: 0.39 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 13.563 MB Rivejä palautettu: 0
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM ajm0x_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(97,106,16,88,103,102,1,125,109)
AND falang_content.reference_table='modules'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
17 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
16 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
15 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
14 | JFalangDatabase->loadObjectList() | Sama kuin kutsu alla olevalla rivillä. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/hurmos/index.php:15 |
7 | require JROOT/templates/hurmos/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1036 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.29 ms Viimeisen kyselyn jälkeen: 12.40 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 14.452 MB Rivejä palautettu: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `ajm0x_menu` AS `c`
INNER JOIN `ajm0x_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `ajm0x_associations` AS `a2`
ON a.key = a2.key
INNER JOIN `ajm0x_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 122
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
19 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
17 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Language/Associations.php:104 |
16 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
15 | MenusHelper::getAssociations() | JROOT/modules/mod_falang/helper.php:66 |
14 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
13 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Sama kuin kutsu alla olevalla rivillä. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:622 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.47 ms Viimeisen kyselyn jälkeen: 0.99 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.478 MB Rivejä palautettu: 1
SELECT fc.value
FROM ajm0x_falang_content fc
WHERE fc.reference_id = 122
AND fc.language_id = 3
AND fc.reference_field = 'link'
AND fc.published = 1
AND fc.reference_table = 'menu'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | fc | NULL | ref | idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table,reference_field | idxFalang1 | 608 | const,const,const | 1 | 5.20 | Using where |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
19 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
18 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
17 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
16 | JFalangDatabase->loadResult() | JROOT/modules/mod_falang/helper.php:540 |
15 | modFaLangHelper::getLinkWithoutSefEnabled() | JROOT/modules/mod_falang/helper.php:413 |
14 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
13 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Sama kuin kutsu alla olevalla rivillä. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:622 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.13 ms Viimeisen kyselyn jälkeen: 0.32 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.505 MB Rivejä palautettu: 1
Päällekkäisiä kyselyitä:
#25SELECT m.link
FROM ajm0x_menu m
WHERE m.id = 122
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
19 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
18 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
17 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
16 | JFalangDatabase->loadResult() | JROOT/modules/mod_falang/helper.php:549 |
15 | modFaLangHelper::getLinkWithoutSefEnabled() | JROOT/modules/mod_falang/helper.php:413 |
14 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
13 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Sama kuin kutsu alla olevalla rivillä. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:622 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.40 ms Viimeisen kyselyn jälkeen: 0.56 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.533 MB Rivejä palautettu: 1
SELECT fc.value
FROM ajm0x_falang_content fc
WHERE fc.reference_id = 122
AND fc.language_id = 1
AND fc.reference_field = 'link'
AND fc.published = 1
AND fc.reference_table = 'menu'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
19 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
18 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
17 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
16 | JFalangDatabase->loadResult() | JROOT/modules/mod_falang/helper.php:540 |
15 | modFaLangHelper::getLinkWithoutSefEnabled() | JROOT/modules/mod_falang/helper.php:413 |
14 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
13 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Sama kuin kutsu alla olevalla rivillä. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:622 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Kyselyn aika: 0.12 ms Viimeisen kyselyn jälkeen: 0.26 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 14.560 MB Rivejä palautettu: 1
Päällekkäisiä kyselyitä:
#23SELECT m.link
FROM ajm0x_menu m
WHERE m.id = 122
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | Kutsufunktio | Tiedosto ja rivin numero |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
19 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
18 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
17 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
16 | JFalangDatabase->loadResult() | JROOT/modules/mod_falang/helper.php:549 |
15 | modFaLangHelper::getLinkWithoutSefEnabled() | JROOT/modules/mod_falang/helper.php:413 |
14 | modFaLangHelper::getList() | JROOT/modules/mod_falang/mod_falang.php:25 |
13 | include JROOT/modules/mod_falang/mod_falang.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
12 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Sama kuin kutsu alla olevalla rivillä. |
11 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
10 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:622 |
9 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:210 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |