Kyselyn aika: 1.44 ms Kysely muisti: 0.055 MB Muistia ennen kyselyä: 8.045 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.17 ms Viimeisen kyselyn jälkeen: 2.48 ms Kysely muisti: 0.038 MB Muistia ennen kyselyä: 8.550 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.21 ms Viimeisen kyselyn jälkeen: 0.27 ms Kysely muisti: 0.041 MB Muistia ennen kyselyä: 8.593 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.34 ms Viimeisen kyselyn jälkeen: 2.33 ms Kysely muisti: 0.046 MB Muistia ennen kyselyä: 8.944 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: 7.96 ms Viimeisen kyselyn jälkeen: 1.55 ms Kysely muisti: 0.036 MB Muistia ennen kyselyä: 9.087 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.98 ms Viimeisen kyselyn jälkeen: 11.69 ms Kysely muisti: 0.047 MB Muistia ennen kyselyä: 10.274 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: 7.39 ms Viimeisen kyselyn jälkeen: 5.87 ms Kysely muisti: 0.030 MB Muistia ennen kyselyä: 10.632 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.21 ms Viimeisen kyselyn jälkeen: 3.02 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'
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.07 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\":\"9b6df68403ebb62796a2c38b4158fd84\"}'
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.35 ms Viimeisen kyselyn jälkeen: 2.15 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
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: 4.24 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 11.155 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')
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 |
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/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 |
Kyselyn aika: 0.54 ms Viimeisen kyselyn jälkeen: 1.88 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 11.363 MB Rivejä palautettu: 30
SHOW FULL COLUMNS
FROM `ajm0x_content`
EXPLAIN ei mahdollinen kyselyssä: SHOW FULL COLUMNS FROM `ajm0x_content`
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/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 |
Kyselyn aika: 0.19 ms Viimeisen kyselyn jälkeen: 3.56 ms Kysely muisti: 0.033 MB Muistia ennen kyselyä: 11.745 MB Rivejä palautettu: 1
SELECT *
FROM ajm0x_content
WHERE `id` = '253'
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 |
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() | 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 |
Kyselyn aika: 0.31 ms Viimeisen kyselyn jälkeen: 0.44 ms Kysely muisti: 0.027 MB Muistia ennen kyselyä: 11.813 MB Rivejä palautettu: 0
Päällekkäisiä kyselyitä:
#17SELECT 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(253)
AND falang_content.reference_table='content'
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 |
---|
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 |
Kyselyn aika: 1.93 ms Viimeisen kyselyn jälkeen: 0.28 ms Kysely muisti: 0.015 MB Muistia ennen kyselyä: 11.827 MB
UPDATE ajm0x_content
SET `hits` = (`hits` + 1)
WHERE `id` = '253'
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.52 ms Viimeisen kyselyn jälkeen: 2.22 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 = 253
AND c.published > 0
AND a.language in ('fi-FI','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-05-26 20:40:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-05-26 20:40:11')
AND (a.state = 1 OR a.state =2)
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 |
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/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 |
Kyselyn aika: 0.31 ms Viimeisen kyselyn jälkeen: 0.49 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 12.134 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(253)
AND falang_content.reference_table='content'
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 |
---|
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 |
Kyselyn aika: 0.30 ms Viimeisen kyselyn jälkeen: 2.64 ms Kysely muisti: 0.028 MB Muistia ennen kyselyä: 12.337 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` = 253
AND `t`.`published` = 1
AND t.access IN (1,1)
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 |
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/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 |
Kyselyn aika: 0.52 ms Viimeisen kyselyn jälkeen: 10.40 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
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.88 ms Viimeisen kyselyn jälkeen: 0.99 ms Kysely muisti: 0.036 MB Muistia ennen kyselyä: 13.687 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
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 |
Ei SHOW PROFILE(Ehkä siksi, että on yli 100 kyselyä)
# | 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 |
Kyselyn aika: 0.45 ms Viimeisen kyselyn jälkeen: 0.57 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'
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 |
---|
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 |
Kyselyn aika: 0.24 ms Viimeisen kyselyn jälkeen: 3.39 ms Kysely muisti: 0.027 MB Muistia ennen kyselyä: 14.306 MB Rivejä palautettu: 3
SELECT `field_id`,`value`
FROM `ajm0x_fields_values`
WHERE `field_id` IN (5,3,4,7)
AND `item_id` = '253'
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 |
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/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 |
Kyselyn aika: 0.35 ms Viimeisen kyselyn jälkeen: 3.68 ms Kysely muisti: 0.034 MB Muistia ennen kyselyä: 14.488 MB Rivejä palautettu: 0
SELECT `value`
FROM ajm0x_falang_content fc
WHERE fc.reference_id = '253'
AND fc.language_id = 2
AND fc.published = 1
AND fc.reference_field = 'com_fields'
AND fc.reference_table = 'content'
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 |
---|
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 |
Kyselyn aika: 0.53 ms Viimeisen kyselyn jälkeen: 12.67 ms Kysely muisti: 0.092 MB Muistia ennen kyselyä: 15.556 MB Rivejä palautettu: 1
SELECT h.*
FROM ajm0x_zhgooglemaps_markers as h
WHERE h.id = 424
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 |
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/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 |
Kyselyn aika: 0.48 ms Viimeisen kyselyn jälkeen: 1.22 ms Kysely muisti: 0.032 MB Muistia ennen kyselyä: 15.809 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(424)
AND falang_content.reference_table='zhgooglemaps_markers'
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 |
---|
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 |
Kyselyn aika: 0.43 ms Viimeisen kyselyn jälkeen: 0.21 ms Kysely muisti: 0.068 MB Muistia ennen kyselyä: 15.778 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
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 |
---|
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 |
Kyselyn aika: 0.29 ms Viimeisen kyselyn jälkeen: 1.27 ms Kysely muisti: 0.032 MB Muistia ennen kyselyä: 15.866 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'
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 |
---|
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 |
Kyselyn aika: 1.46 ms Viimeisen kyselyn jälkeen: 0.24 ms Kysely muisti: 0.083 MB Muistia ennen kyselyä: 15.898 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 <= '2022-05-26 20:40:11')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2022-05-26 20:40:11')
ORDER BY h.title
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 |
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/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 |
Kyselyn aika: 1.43 ms Viimeisen kyselyn jälkeen: 2.15 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.579 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'
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/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 |
Kyselyn aika: 1.20 ms Viimeisen kyselyn jälkeen: 0.36 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.609 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'
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/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 |
Kyselyn aika: 0.30 ms Viimeisen kyselyn jälkeen: 0.22 ms Kysely muisti: 0.039 MB Muistia ennen kyselyä: 16.502 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
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 |
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/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 |
Kyselyn aika: 0.24 ms Viimeisen kyselyn jälkeen: 0.48 ms Kysely muisti: 0.033 MB Muistia ennen kyselyä: 16.390 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
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 |
---|
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 |
Kyselyn aika: 0.25 ms Viimeisen kyselyn jälkeen: 0.32 ms Kysely muisti: 0.032 MB Muistia ennen kyselyä: 16.417 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 |
---|
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 |
Kyselyn aika: 4.89 ms Viimeisen kyselyn jälkeen: 0.35 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.451 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 <= '2022-05-26 20:40:11')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-26 20:40:11'))
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 | const | 20 | 16.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/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 |
Kyselyn aika: 0.36 ms Viimeisen kyselyn jälkeen: 0.40 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.628 MB Rivejä palautettu: 0
Päällekkäisiä kyselyitä:
#37SELECT 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'
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 |
---|
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 |
Kyselyn aika: 4.55 ms Viimeisen kyselyn jälkeen: 0.23 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.531 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 <= '2022-05-26 20:40:11')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-26 20:40:11'))
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 | const | 20 | 16.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/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 |
Kyselyn aika: 0.32 ms Viimeisen kyselyn jälkeen: 0.42 ms Kysely muisti: 0.031 MB Muistia ennen kyselyä: 16.690 MB Rivejä palautettu: 0
Päällekkäisiä kyselyitä:
#35SELECT 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'
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 |
---|
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 |
Kyselyn aika: 0.90 ms Viimeisen kyselyn jälkeen: 36.88 ms Kysely muisti: 0.024 MB Muistia ennen kyselyä: 17.642 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 <= '2022-05-26 20:40:11')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-26 20:40:11')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 373 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/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 |
Kyselyn aika: 0.79 ms Viimeisen kyselyn jälkeen: 0.40 ms Kysely muisti: 0.026 MB Muistia ennen kyselyä: 17.676 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'
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/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 |
12 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM ajm0x_falang_content AS falang_content
2 × SELECT m.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
2 × SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_markergroups as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
1 × SELECT h.*
FROM ajm0x_zhgooglemaps_markers as h
1 × SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_maps as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
1 × SELECT 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
1 × SELECT `value`
FROM ajm0x_falang_content fc
1 × SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_routers as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ajm0x_modules AS m
LEFT JOIN ajm0x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ajm0x_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_maptypes as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
1 × SELECT `field_id`,`value`
FROM `ajm0x_fields_values`
1 × SELECT h.*, c.title as category
FROM ajm0x_zhgooglemaps_paths as h
LEFT JOIN ajm0x_categories as c
ON h.catid=c.id
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `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)
1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ajm0x_extensions`
1 × SELECT *
FROM ajm0x_languages
1 × SELECT joomlatablename,tablepkID
FROM `ajm0x_falang_tableinfo
1 × SELECT id, home, template, s.params
FROM ajm0x_template_styles as s
LEFT JOIN ajm0x_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ajm0x_assets`
1 × SELECT `m`.`tag_id`,`t`.*
FROM `ajm0x_contentitem_tag_map` AS m
INNER JOIN `ajm0x_tags` AS t
ON `m`.`tag_id` = `t`.`id`
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
1 × SELECT *
FROM ajm0x_content
1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
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